Script to RETRY workflow BEGIN wf_engine.handleerror ( itemtype => ‘OEOL’, itemkey => 2705276, activity => ‘SHIP_LINE’, command => ‘RETRY’, RESULT => NULL ); END; /… Read More »How to RETRY/SKIP a workflow from backend
DECLARE lc_role_name apps.wf_roles.name%TYPE := ‘XX_TEST_ROLE’; BEGIN wf_directory.setadhocroleexpiration(lc_role_name, sysdate -1 ); COMMIT; wf_directory.setadhocrolestatus( lc_role_name, ‘INACTIVE’); COMMIT; wf_directory.deleterole(lc_role_name , ‘WF_LOCAL_ROLES’ , 0); COMMIT; END; /DECLARE lc_role_name apps.wf_roles.name%type… Read More »PL/SQL Script to Inactive and Delete Adhoc Role
Before reading this article, read about Roles in Workflow if you are not aware of what a role is about. A role can be created… Read More »Adhoc Roles in Oracle Workflow
DECLARE ln_role_users_count NUMBER; lc_role_name apps.wf_roles.NAME%TYPE := ‘XX_TEST_ROLE’; BEGIN —————————— –Checking if Adhoc Role Exits —————————— SELECT COUNT (1) INTO ln_role_users_count FROM apps.wf_user_roles WHERE NAME =… Read More »PL/SQL Script to Remove and Add Users to Adhoc Role
DECLARE ln_role_count NUMBER; lc_role_name apps.wf_roles.NAME%TYPE := ‘XX_TEST_ROLE’; lc_role_display_name apps.wf_roles.description%TYPE := ‘XX Test Role’; BEGIN —————————— –Checking if Adhoc Role Exits —————————— SELECT COUNT (1) INTO… Read More »PL/SQL Script to Create Adhoc Role
A Role in Oracle EBS is a a categorization of set of users who share same responsibilities. A role will have one or more users… Read More »What is a Role in Oracle Workflow
This article explains how to attach a concurrent program output as a Workflow email notification. Prerequisites DBA Directory should be created with Concurrent Program output… Read More »Attaching Concurrent Program Output as Workflow Email Notification Attachment
By default Event/Subscription button is visible only through SYSADMIN login. This is due to a setup in ‘Administration‘ tab of Workflow Administrator, where only ‘SYSADMIN’… Read More »Create Event/Subscription button is Missing, How to Enable?
Table Name Description WF_ITEMS WF_ITEMS is the runtime table for workflow processes. Each row defines one work item within the system. WF_ITEM_TYPES The WF_ITEM_TYPES table… Read More »Important Tables of Oracle Workflow and their Description
Earlier we have seen how to close FYI based notification. Here in this article lets see how to close Approval/Response based notification from backend. Since… Read More »How to Close Approval or Response Required based Notifications from backend?