Sunday, June 14, 2009

WFLOAD

Workflow information can be found in the wf_item_types_tl table.
It will give the long name and the short name for all workflows.

Steps:

Login to Test Instance, Set the Environment

Run Commands

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

Copy or Ftp the files created to the production database server.

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

Now Execute

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.

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.

No comments:

Post a Comment