Long running of Workflow Background Process in EBS
All,
Greetings,
I see the recommendation as 5 minutes in one of the My oracle support doc id to schedule the Workflow Background Process for OEOL.If i change the schedule from 5 minutes to every 2 minutes, will that help? I do have OEOL scheduled to run at every 2 minutes, but i see that OEOL for deferred activity used to run longer. Whenever this happens, i do a check in apps.wf_deferred_table_m
SELECT w.user_data.itemtype "Item Type",
w.user_data.itemkey "Item Key",
DECODE(w.state, 0, '0 = Ready', 1, '1 = Delayed', 2, '2 = Retained/Processed', 3, '3 = Exception', TO_CHAR(w.state)) State,