Order Line Not Progressing To Closure, No Delivery Details ID Attached With Purged Workflow (Doc ID 2902436.1)

Last updated on APRIL 27, 2023

Applies to:

Symptoms

When attempting to process shipping transactions with Interface Trip Stop,
the following error occurs due to no delivery detail Id associated with the 
order lines and line level workflow has been purged.

ERROR
-----------------------
LEAVING OE_MSG_PUB.COUNT_AND_GET 3
local split line RET STS : U
here 12 index is 1
error in split_line User-Defined Exception
error in Ship_Confirm_Line User-Defined Exception
error in handle_nonbulk_mode User-Defined Exception
ENTER Save_API_Messages
l_errmsg User-Defined Exception
L_MSG_DATA=ORA-20002: 3100: Item 'OEOL/nnnnn848' does not exist. in Package OE_ORDER_WF_UTIL Procedure Create_LineFork
Order Number :nnnn861 Line Number :
Message :ORA-20002: 3100: Item 'OEOL/nnnnn848' does not exist. in Package OE_ORDER_WF_UTIL Procedure Create_LineFork
 
EXIT Save_API_Messages
ship_confirm_new UNEXPECTED ERROR : User-Defined Exception
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
LEAVING OE_MSG_PUB.COUNT_AND_GET 3
rollback to om_ship_confirm :
  After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 09/30/2022 11:32:42 AM
  l_return_status ==> U
  NO. OF OE MESSAGES :3
  Calling program unit OE_MSG_PUB.GET
  ORA-20002: 3100: Item 'OEOL/nnnnn848' does not exist. in Package OE_ORDER_WF_UTIL Procedure Create_LineFork
Error msg: ORA-20002: 3100: Item 'OEOL/nnnnn848' does not exist. in Package OE_


STEPS
-----------------------
1. Responsibility: Order Management Super User
2. Run Interface Trip Stop
3. Error: L_MSG_DATA=ORA-20002: 3100: Item 'nnnnn848' 
4. No Delivery details are associated
5. Order Line Workflow purged for both lines
 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.