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:
Oracle Order Management - Version 11.5.10.2 and laterInformation 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 |