Oracle Workflows are database applications whose definition is stored in different database tables.
We can download/upload workflow definition from different database tables to a flat file using a Oracle command line utility ‘WFLOAD‘
Following is the syntax for WFLOAD utility
WFLOAD apps/<apps_pwd> 0 Y UPLOAD <file_name>.wft WFLOAD apps/<apps_pwd> 0 Y DOWNLOAD <file_name>.wft <Item_Type> |
0, 20 and 100 are the various Access levels we have in workflow.
The access levels are defined as follows:
- 0-9: Reserved for Oracle Workflow
- 10-19: Reserved for Oracle Application Object Library
- 20-99: Reserved for Oracle E-Business Suite
- 100-999: Reserved for customer organizations
- 1000: Public
Different “Modes” applicable to WFLOAD
UPGRADE – Honors both protection and customization levels of data
UPLOAD – Honors only protection level of data [No respect of Customization Level]
FORCE – Force upload regardless of protection or customization level
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.
Where are workflow files stored in Unix?
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
Alternatively you can also download and upload the workflow through a concurrent program “Workflow Definitions Loader” from System Administrator responsibility
