24 January 2013

How to use WFLOAD command for UPLOAD,DOWNLOAD


We use the Workflow Definitions Loader to save or load process definitions from a database or flat file. We can also define as it is a utility that moves workflow data between a file and a database and it is also used to upgrade, upload and download the workflow data.Following is the syntax and the parameter details of WFLOAD
WFLOAD @ 0 Y {UPLOAD | UPGRADE | FORCE} []Example:- WFLOAD apps/pwd@ 0 Y UPLOAD POREQAPPRV.wft



Different “Upload Modes” applicable to WFLOADUPGRADE – Honors both protection and customization levels of dataUPLOAD - Honors only protection level of data [No respect of Customization Level]FORCE - Force upload regardless of protection or customization level Use the following command to download workflow definition
WFLOAD /@db 0 Y DOWNLOAD file_name.wft
Example:-
WFLOAD /@db 0 Y DOWNLOAD header.wft OEOH
DOWNLOAD - Parameter to WFLOAD to download workflow definition
As a standard practice, Oracle’s upgrade patches mostly run in UPGRADE mode, hence your customizations can protected if best practices for development are followed.
One can find the seeded workflow definition files under$/patch/115/import/ directory.
For example, .wft files related to order management can be located in the following directory:-

$ONT_TOP/patch/115/import/US For example, .wft files related to order management can be located in the following directory:-
$ONT_TOP/patch/115/import/US

21 January 2013

Subinventory Conversion



Is there an API/Interface to convert Subinventories in Oracle Apps?


Three Options,


1) You can safely Insert into MTL_SECONDARY_INVENTORIES table after completing data validations.


2) Use the Subinventory Table handler to the insert, MTL_SECONDARY_INVENTORIES_PKG


3) If you don't want to create addition API, then validate the data and complete the data cleansing in a excel. then insert into MTL_SECONDARY_INVENTORIES table using Toad.