Upload or Download Oracle Workflows using WFLOAD Command Line Utility

Requirement -  Upload wft files to database or download the latest wft file from database.

Solution -  Workflow files (with extension .wft) are being stored in database and it can be upload (to) or download (from) database .


Run Command to download !!

WFLOAD apps/apps 0 Y DOWNLOAD reqappv_final.wft REQAPPRV
WFLOAD apps/apps 0 Y DOWNLOAD poapprv_final.wft POAPPRV

Run Command to upload !!
WFLOAD apps/apps 0 Y UPLOAD reqappv_final.wft REQAPPRV
WFLOAD apps/apps 0 Y UPLOAD poapprv_final.wft POAPPRV


Run Command to upgrade !!
WFLOAD apps/apps 0 Y UPGRADE reqappv_final.wft REQAPPRV
WFLOAD apps/apps 0 Y UPGRADE poapprv_final.wft POAPPRV


This will upload the wft file - into the database - for the new instance.

Different Access Levels Used:

0 -  9	Reserved for Oracle Workflow
10 - 19	Reserved for Oracle Application Library
20 - 99	Reserved for Oracle E-Business Suite
100 - 999	Reserved for Customer Organizations
1000	Public

Different UPLOAD modes used while uploading the WFT file to the database.

UPGRADE	Honors both Customization and Protection Levels of Data.
UPLOAD	Honors only Protection. Customization Levels are not respected.
FORCE	Both Customization and Protection Levels are not honored.

Usually all the Oracle Patches run the Workflows in UPGRADE mode and access level of 20 and hence our customizations are protected if properly preserved.