ORACLE APPS: How To Update and Move Workflow From One Instance to Another Instance?

How To Update and Move Workflow From One Instance to Another Instance ?

Let say test is Source and PROD is target instance

1. Login to test - set the environment -

Run the following commands -

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

This will pull the workflow definition file from the database - customizations - etc...

2. Next, ftp/scp the files created - reqapprv_final.wft, etc.. to the production database server.

3. Now, login to the database server where the files now reside. Set the environment now for the production instance.

Execute the following to backup original on production: WFLOAD apps/apps 0 Y DOWNLOAD reqappv_prod.wft REQAPPRV WFLOAD apps/apps 0 Y DOWNLOAD poapprv_prod.wft POAPPRV

WFLOAD apps/apps 0 Y UPGRADE reqappv_final.wft WFLOAD apps/apps 0 Y UPGRADE poapprv_final.wft

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

4. Test the results.

Another way is to use the workflow builder. 1. Pull up the workflow from test in the workflow builder. 2. Then choose File/Save As - and enter the production database information and save. 3. You have now saved the workflow into the production database.

How to find shortname for workflows based on description?

Workflow information can be found in the wf_item_types_tl table. It will supply the long name and the short name for all workflows. That being said, the PO Create Documents workflow is CREATEPO.wft