<p>
Hi all,
</p>
<p>
Got a good one here. Client is receiving the error above in the standard eBusiness Suite Req Approval Workflow. The problem has been narrowed down to the responsibility level. When the final approver is logged is as one Responsibility, the error does not occur. When the final approval is done through logging in as another Responsibility, the error halts the workflow.
</p>
<p>
All profile options are the same for both responsibilities. Both responsibilities use the same function 'Advanced Worklist' to display the Workflow Notifications. This started happening after an upgrade to 11.5.10.2.
</p>
<p>
There is one hit on Metalink but this didn't work (note: 603475.1).
</p>
<p>
I have been through the PL/SQL code and found that there is infact a commit statement in there. The PO Requisition Approval Workflow is calling the Create PO workflow and the error occurs when the wf_engine.StartProcess call is hit. Code flow below.
</p>
<p>
I was always under the impression that commit statements were a big 'no no' in Workflow? I could always take it out but this is standard 11.5.10.2 code so I assume it is there for a reason. Ultimately there must be something wrong with the Responsibility but I cannot for the life of me see it. I suspect that this is tied in with the way Workflow uses the responsibility.
</p>
<p>
<u>Code Flow</u>
<sup>PO_REQAPPROVAL_LAUNCH.LAUNCH_CREATEPO_WF - called from Workflow function.
PO_REQAPPROVAL_LAUNCH.LaunchCreatePOWF
PO_REQAPPROVAL_LAUNCH.CreateWFInstance
PO_AUTOCREATE_DOC.start_WF_process
commit;
wf_engine.CreateProcess - (item type - CREATEPO)
wf_engine.StartProcess - exception!
</sup>
</p>
<p>
Any help or comments appreciated.
</p>
<p>
Cheers,
</p>
<p>
Jon.
</p>