-
Respond to workflow notification from a DB procedure
The below script can be used to auto approve notifications through database procedure. Write your business logic with in the below procedure ,register it as a concurrent program and schedule it as needed to run periodically. The same script can also be used in custom forms, custom or third party applications to respond to notifications…
-
Run / start workflow from Workflow Administrator Responsibility
First of all why do we need to run a workflow from workflow administrator responsibility? Second, Who will run it? Third, When can we run it? Fourth, How can we run it? Finally, Is it recommended approach? 1) Normally we don’t run or kickoff workflow’s from workflow administrator responsibility. All seeded workflow’s are tied to…
-
Workflow migration: WFLOAD | Workflow Definitions Loader
Oracle workflow objects can be saved into database or into a file. So We can treat Oracle workflow objects as both file system objects and database objects. We save workflow object into file when working on local system either for development / enhancement or debugging. When you execute the workflow from server it will always…
-
Launch Workflow from PL/SQL
The below script will lanch or kickoff the desired workflow from PL/SQL code: declare v_itemtype VARCHAR2(50); v_itemkey VARCHAR2(50); v_process VARCHAR2(50); v_userkey VARCHAR2(50); begin v_itemtype := ‘DEMOIT’; v_itemkey := ‘1233’; v_userkey := ‘1233’; v_process := ‘DEMOPROCESS’; WF_ENGINE.Threshold := -1; WF_ENGINE.CREATEPROCESS(v_itemtype, v_itemkey, v_process); wf_engine.setitemuserkey(v_itemtype, v_itemkey, v_userkey ); wf_engine.setitemowner (v_itemtype, v_itemkey,’SYSADMIN’); WF_ENGINE.STARTPROCESS(v_itemtype, v_itemkey); commit; exception when others then…