CREATEPO: Error at PO_REQAPPROVAL_LAUNCH.LAUNCH_CREATEPO_WF
(Doc ID 465827.1)
Last updated on JANUARY 30, 2022
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.
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.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |