Friday, 25 May 2018

How to upload download workflow(.wft) file through concurrent request in oracle :Workflow Definitions Loader

How to Upload/Download Workflow (.wft) file through Concurrent Request :Workflow Definitions Loader

Usually , we download and upload the workflow file through workflow builder or through scripts. But few of them know this way by which we can also upload and download the workflow file also through concurrent request Workflow Definitions Loader.
 
Submit the Workflow Definitions Loader concurrent program to upload and download process definitions.
Rather than use the the File Save or File Open menu options in Oracle Workflow Builder, you can also use the Workflow Definitions Loader to save or load process definitions from a database or flat file.Use the Loader program when you upgrade your database to preserve your process definitions to a flat file. When the database upgrade is complete, use the Loader program again to upload the definitions back into your database. You can also use the Loader program to transfer process definitions to other databases. The Loader program lets you quickly download or upload one or more process definitions to database or flat file without having to run Oracle Workflow Builder.


First of all we need to attach the 'Workflow Definitions Loader' concurrent request to the desired responsibility in which we want to run this request./

'Workflow Definitions Loader' Parameters :-

Mode

Specify "Download" to download a process definition from the database to a flat file.

Specify "Upgrade" to apply a seed data upgrade to a database from an input file
Specify "Upload" to load a process definition from a flat file into the database. The upload mode is useful to someone who is developing a workflow process

File Specify the full path and name of the file that you want to download a process definition to, or upgrade or upload a process definition from.
Item Type If you set Mode to "Download", use the List button to choose the item type for the process definition you want to download.

Rather than use the Submit Requests form, you can also run the Workflow Definitions Loader concurrent program from the command line by entering the following commands:
To upgrade-- WFLOAD apps/pwd 0 Y UPGRADE file.wft
To upload-- WFLOAD apps/pwd 0 Y UPLOAD file.wft
To force-- WFLOAD apps/pwd 0 Y FORCE file.wft
To download-- WFLOAD apps/pwd 0 Y DOWNLOAD file.wft ITEMTYPE1 [ITEMTYPE2 ... ITEMTYPEN]

apps/pwd is the user name and password of the database.

:
 

1 comments:

Goutham Raj said...

Good Article, Alots of information provided, Thanks for sharing this information.
HR Online Training

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *