[WFLOAD]How to download and upload a Workflow?

By | May 2, 2012 | 10,541 views | Category: Workflows Tags:

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

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: