Wednesday 28 September 2016

Workflow Notes

Download Workflow Builder:

Download workflow builder from Metalink - Patch Number 6970344.

Workflow builder works on both 32 bit machine and 64 bit machine. But if you are using 64 bit machine you need to have Admin Access on your 64 bit system from where you are launching the Workflow builder.

Refer note Recommended Set Up for Client/Server Products with Oracle E-Business Suite 11i and R12 (Doc ID 277535.1) for getting appropriate Workflow builder patch.

Workflow Access Levels:

   0-9           Reserved for Oracle Workflow
   10-19       Resereved for Oracle Application Object Library
   20-99       Resereved for Oracle Applications Development

   100-999   Reserved for Customer Organization
    1000       Public

When developing custom workflow or modifying a seeded workflow you need to set the access level to 100. Setting any other access level and modifying seeded workflow objects may corrupt the workflow and you might see abnormal functionality.

If any activity/object is locked by Oracle Applications Development the protection level will be 20 and you will not be able to modify with access level 100. If it is not locked the protection level will be 1000 and you will be able to modify with access level 100.

After you modify, you need to check the preserve customiztions and lock at this access level to protect the customizations from upgrade/patching. With this Customization value will be 100 and Protection will also be 100. However by checking Allow modifications to customized objects Oracle App development will also be able to modify.

Set the access level from workflow bulider Help (Menu) --> About Workflow Builder

WFLOAD Commands:

Download workflow from the instance:
WFLOAD apps/<apps pwd> 0 Y DOWNLOAD XXCUST.wft <ITEMTYPE>

Upload workflow to database - Upgrade mode:
WFLOAD apps/<apps pwd>0 Y UPGRADE XXR2REXT820B.wft

Upgrade mode honours both protection and customiztion levels of data

Upload workflow to database - Upload mode:
WFLOAD apps/<apps pwd>0 Y UPLOAD XXR2REXT820B.wft

Upload mode honours only protection levels of data.

Upload workflow to database - Force mode:
WFLOAD apps/<apps pwd> 0 Y FORCE XXR2REXT820B.wft
Force upload  does not honor both protection and customiztion levels of data

Below are some useful metalink notes on workflow:
How To Use WFLOAD To Download, Upload, Upgrade, Force Upload A Workflow To Database? (Doc ID 1569004.1)
How to Ensure Workflow File Customizations/Changes Are Not OverWritten By Upgrades/Patches (Doc ID 1343956.1)
WFLOAD Fails On Customizations (Doc ID 1015861.102)



No comments:

Post a Comment