CREATEPO: Error at PO_REQAPPROVAL_LAUNCH.LAUNCH_CREATEPO_WF (Doc ID 465827.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Purchasing - Version 11.5.10 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 06-APR-2016***


Symptoms

Errored notifications are received after submitting requisitions for approval.

ERROR
WFENG_COMMIT_INSIDE

Error Message 3146: Commit happened in activity/function
'MAIN_REQAPPRV_PROCESS:LAUNCH_CREATE_PO_WF/PO_REQAPPROVAL_LAUNCH.LAUNCH_CREATEPO_WF'

Error Stack Wf_Engine.CreateProcess(CREATEPO, 2384628-189928)
po_autocreate_doc.start_wf_process(10: start_wf_process: Called with following parameters:ItemType
= CREATEPO/ ItemKey = 2384628-189928/ workflow_process = / req_header_id = 2384628/ po_number = /
interface_source_code = )
PO_REQAPPROVAL_LAUNCH.CreateWFInstance(PO_REQAPPROVAL_LAUNCH.CreateWFInstance:02 ItemType=CREATEPO
ItemKey=2384628-189928)
PO_REQAPPROVAL_LAUNCH.LaunchCreatePOWF(PO_REQAPPROVAL_LAUNCH.LaunchCreatePOWF:01)
PO_REQAPPROVAL_LAUNCH.Launch_CreatePO_WF(REQAPPRV, 2384628-189915)
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.LAUNCH_CREATEPO_WF, REQAPPRV, 2384628-189915,
170715, RUN)

The po_wf_debug displays the following additional information:

PO_REQAPPROVAL_INIT1.send_error_notif: ORA-06502: PL/SQL: numeric or value error
ORA-20002: 3108: Root process could not be determined for item 'CREATEPO/###-##'.
There may be a problem with the item type selector function, or you may be required to supply a starting process name.


 Steps To Reproduce:

1. Enter a Requisition and approve.
2. Expect for the Createpo workflow to pick up the Requisition and create the Purchase Order automatically.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms