My Oracle Support Banner

OEOIMP Trying To Update Or Delete An Existing Line But That Line Does Not Exist (Doc ID 742482.1)

Last updated on MAY 21, 2021

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
OEOIMP



Symptoms

When trying to update an existing order in Order Management via the Order Import interface, the process fails with error.
The request log file shows:

BEFORE VALIDATING LINE OPERATION CODE: UPDATE
L_HEADER_ID: 15233
P_X_LINE_TBL(I).ORIG_SYS_LINE_REF1
P_X_LINE_TBL(I).ORIG_SYS_SHIPMENT_REF G_MISS_CHAR
P_X_LINE_TBL(I).SOLD_TO_ORG_ID1020
G_IMPORT_SHIPMENTS WAS YES
INVALID OPERATION CODE. TRYING TO UPDATE OR DELETE AN EXISTING LINE BUT THAT LINE DOES NOT EXIST...

However, the following query confirms the sales order and lines do exist:

select header_id, org_id from oe_order_headers_all
where orig_sys_document_ref= &orig_sys_doc_ref
and order_source_id=&order_source;

select line_id from oe_order_lines_all
where header_id = &hdr_id;

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

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