[WFLOAD]How to download and upload a Workflow?

By | May 2, 2012

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

WOW! Did you like this post? We'll send more interesting posts like [WFLOAD]How to download and upload a Workflow? to you!
Enter your Email Address: