Interface Trip Stop Error With ORA-20002: 3100: Item 'OEOL/xxxxxx' does not exist in Package OE_ORDER_WF_UTIL Procedure Create_LineFork
(Doc ID 1406315.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Order Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]Oracle Shipping Execution - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS
Symptoms
When attempting to interface the order, Interface Trip Stop ends with the following error:
no. of OE messages :3
Error msg: ORA-20002: 3100: Item 'OEOL/1101451' does not exist. in Package OE_ORDER_WF_UTIL Procedure Create_LineFork
Error msg: User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure CreateStart_LineFork
Error msg: User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure CreateStart_LineProcess
Failed to interface Batch 872597 to Order Management because API interface_header_to_OM failed
InterfaceTripStop: total stops processed: 1
Stops processed for ORDER MANAGEMENT with status NORMAL: 0
Stops processed for ORDER MANAGEMENT with status WARNING: 1
Stops interfaced for ORDER MANAGEMENT: 0
Error msg: ORA-20002: 3100: Item 'OEOL/1101451' does not exist. in Package OE_ORDER_WF_UTIL Procedure Create_LineFork
Error msg: User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure CreateStart_LineFork
Error msg: User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure CreateStart_LineProcess
Failed to interface Batch 872597 to Order Management because API interface_header_to_OM failed
InterfaceTripStop: total stops processed: 1
Stops processed for ORDER MANAGEMENT with status NORMAL: 0
Stops processed for ORDER MANAGEMENT with status WARNING: 1
Stops interfaced for ORDER MANAGEMENT: 0
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. OM Superuser
2. Run Requests
3. Interface Trip Stop SRs
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 |