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

Last updated on JUNE 21, 2023

Applies to:

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

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