Workflow Job Fails with ORA-20003 and WFENG_COMMIT_INSIDE (Doc ID 1604634.1)

Last updated on AUGUST 15, 2017

Applies to:

Symptoms

Define a Workflow with one PLSQL sub-program.  Within the Workflow, set up Parameter value propagation
so that Parameters contained in the PLSQL sub-program can receive its values automatically from the Workflow.
Submit the workflow job using Message-Triggered Submission.

The Workflow job fails with the following error message in the job log:

Error Code: ORA-20003:: Error Description:  : Error occured during
workflow(1799) Execution. Please check Workflow Monitor for more Details.
DEBUG MESSAGE FROM OWB/CDR DB Server-WF Operator: User defined program
returned Failure...
Execution Status : Failed :: Job Status: Failure :: 08-23-2013 09:32:11

Error Code: ORA-20003:: Error Description:  : Error occured during
workflow(1799) Execution. Please check Workflow Monitor for more Details.

Workflow Monitor shows the following error:

Error Activity ID: 290324
Error Activity Label: 1799:183640001_6
Error Item Type:  1799
Error Item Key: WB_IK_20130813_135536_18005810_1799
Error Message  3146: Commit happened in activity/function
'1799:183640001_6/WB_RT_WORKFLOW_UTIL_11G.EXECUTE_TASK'

Error Name:  WFENG_COMMIT_INSIDE

Error Stack  WB_RT_WORKFLOW_UTIL_11G.Execute_Any_Task(3716,
WB_IK_20130813_135536_18005810_1799, 290324, RUN)
WB_RT_WORKFLOW_UTIL_11G.Execute_Task(1799,
WB_IK_20130813_135536_18005810_1799, 290324, RUN)
Wf_Engine_Util.Function_Call(WB_RT_WORKFLOW_UTIL_11G.EXECUTE_TASK, 1799,
WB_IK_20130813_135536_18005810_1799, 290324, RUN)
 

Cause