Usage of 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 <apps/pwd> 0 Y {UPLOAD | DOWNLOAD | UPGRADE | FORCE} [@<appl-shortname>:]<filepath> [<item type>]
WFLOAD <apps/pwd>@<connect_string> 0 Y {UPLOAD | UPGRADE | FORCE} <filepath>[<file_name.wft>]

Example:-

 WFLOAD apps/pwd@<connect_string> 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 <apps/pwd> 0 Y {UPLOAD | DOWNLOAD | UPGRADE | FORCE} [@<appl-shortname>:]<filepath> [<item type>]

WFLOAD <apps_user_name>/<password>@db 0 Y DOWNLOAD file_name.wft <Item_Type>

Example:-

WFLOAD <apps_user_name>/<password>@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
$<PRODUCT_TOP>/patch/115/import/<LANG> directory.
For example, .wft files related to order management can be located in the following directory:-

 $ONT_TOP/patch/115/import/US

Example:

-------

[usxxxxx:oracle:]$ WFLOAD apps/simple4u 0 Y FORCE $LDMF_TOP/install/sql/LOGI_STANDARD_PRICING_WF.wft
Log filename    : L7883028.log

Report filename : O7883028.out
Oracle Workflow Definition Loader 2.6.4.0.

Access level: 100, Mode: FORCE

Uploaded 2 ITEM_TYPE record(s) to database.
Uploaded 53 LOOKUP_TYPE record(s) to database.
Uploaded 23 MESSAGE record(s) to database.
Uploaded 101 ACTIVITY record(s) to database.
Uploaded 0 ROLE record(s) to database.