Workflow with Approval Notification

Creating WF Local Roles:

Adhoc roles can be created through PL/SQL from database or they can be created from Applications using User Management Responsibility. If PL/SQL is used to create roles, all user names and role names in UPPER case to avoid some errors:

Script to Create an Adhoc Role:

 Script to validate WF Roles:

 Script to Add user to an already existing Adhoc Role:

 Script to Remove user from an existing Adhoc Role:

Using Adhoc roles in workflow notifications:
Once the Roles are created in the database we can load the Roles from database as discussed from Oracle Worflow Builder as below:

Navigation: File > Load Roles from Database

Select roles you want to use and then click OK.

NEW_XAOA_NF028

NEW_XAOA_NF029

Open the notification properties and then navigate to node tab, select performer as the role you just created and loaded from database.

Modified Package Code:

Sample Code to test the workflow:

 Sample scripts to test the Workflow:

Once triggered See the below Approval Notification for either Workflow –> Notifications or directly on the screen depending on the Profile Option setup:

NEW_XAOA_NF023

Open the Notification:

NEW_XAOA_NF024

Once Approved see the Activity history or Status Diagram from Status Monitor. This can be done at any stage of the workflow once kicked off. Usually while debugging this is the first place we need to check and then check in wf tables.

NEW_XAOA_NF025

NEW_XAOA_NF026

NEW_XAOA_NF027

 

Some of the workflow tables:

WF_LOOKUP_TYPES_TL
WF_MESSAGES
WF_MESSAGE_ATTRIBUTES
WF_NOTIFICATION_ATTRIBUTES
WF_ITEM_ATTRIBUTES
WF_ITEM_ACTIVITY_STATUSES

WF_ITEM_ATTRIBUTE_VALUES

Please respond if any questions.

Related posts:

Leave a Reply