Order Import Error In IR-ISO scenario - Reason Passed Is Not Active Or Not Present
(Doc ID 2802125.1)
Last updated on SEPTEMBER 20, 2021
Applies to:
Oracle Order Management - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
Order Import request is ending with following error while importing an Internal Sales Order for Internal Requisition - Internal Sales Order flow (IR-ISO flow)
ERROR
Reason passed is not active or not present
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
exe error Process_Request_Pvt
ENTER SET RECURSION MODE
ENTITY CODE-11
ENTRY-EXIT MODE -0
RECURSION MODE AT ENTRY -N
RECURSION MODE WITHOUT EXP AT ENTRY -N
RECURSION MODE AT EXIT -N
RECURSION MODE WITHOUT EXP AT EXIT -N
execution error
ENTER SET RECURSION MODE
ENTITY CODE-9
ENTRY-EXIT MODE -0
RECURSION MODE AT ENTRY -N
RECURSION MODE WITHOUT EXP AT ENTRY -N
RECURSION MODE AT EXIT -N
RECURSION MODE WITHOUT EXP AT EXIT -N
OEXVORDB: COMPLETED PROCESS_DELAYED_REQUESTS WITH RETURN STATUSE
PO: EXITING PROCESS ORDER WITH ERROR
...
Msg-1 for Src: 10, Hdr: 1788943, Line: 1: Process Order failed with errors.
BEFORE DELETING OLD MESSAGES FROM THE DATABASE TABLE
DELETE MESSAGES RETURN STATUS: S
BEFORE SAVING MESSAGES IN THE DATABASE TABLE
ENTER SAVE_MESSAGES
L_MSG_DATA=Process Order failed with errors.
Error in Procedure insert_message ORA-01403: no data found
Order number not found
Order Number : Line Number :
Message :Process Order failed with errors.
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
exe error Process_Request_Pvt
ENTER SET RECURSION MODE
ENTITY CODE-11
ENTRY-EXIT MODE -0
RECURSION MODE AT ENTRY -N
RECURSION MODE WITHOUT EXP AT ENTRY -N
RECURSION MODE AT EXIT -N
RECURSION MODE WITHOUT EXP AT EXIT -N
execution error
ENTER SET RECURSION MODE
ENTITY CODE-9
ENTRY-EXIT MODE -0
RECURSION MODE AT ENTRY -N
RECURSION MODE WITHOUT EXP AT ENTRY -N
RECURSION MODE AT EXIT -N
RECURSION MODE WITHOUT EXP AT EXIT -N
OEXVORDB: COMPLETED PROCESS_DELAYED_REQUESTS WITH RETURN STATUSE
PO: EXITING PROCESS ORDER WITH ERROR
...
Msg-1 for Src: 10, Hdr: 1788943, Line: 1: Process Order failed with errors.
BEFORE DELETING OLD MESSAGES FROM THE DATABASE TABLE
DELETE MESSAGES RETURN STATUS: S
BEFORE SAVING MESSAGES IN THE DATABASE TABLE
ENTER SAVE_MESSAGES
L_MSG_DATA=Process Order failed with errors.
Error in Procedure insert_message ORA-01403: no data found
Order number not found
Order Number : Line Number :
Message :Process Order failed with errors.
STEPS TO REPRODUCE:
1. The Create Internal Orders process runs and inserts the data into the Order Management iface tables for Order Import to Order Management
2. Upon submitting the Order Management request the lines are not created into the internal sales orders.
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 |
Cause |
Solution |
References |