Order Import creates order with errors (Doc ID 2461523.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

On : 11.5.10.2 version, Transaction Entry

When attempting to import an order,
the following error occurs.
But order was imported in spite of error

ERROR
-----------------------
Msg-1 for Src: 9, Hdr: WEB-G8604693-W38642589083-69762990, Line: OE_ORDER_LINES_ALL47757598: Process Order failed with errors.
BEFORE DELETING OLD MESSAGES FROM THE DATABASE TABLE
DELETE MESSAGES RETURN STATUS: S
BEFORE SAVING MESSAGES IN THE DATABASE TABLE
ENTER SAVE_MESSAGES
L_MSG_DATA=Process Order failed with errors.
Process Order failed with errors.
EXIT SAVE_MESSAGES
LEAVING OE_MSG_PUB.INITIALIZE
RETURN_STATUS: E
ORDER FAILED WITH ERROR ( S )
ENTERING RAISE_EVENT_XMLINT
LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: 9
after order_import for docref=WEB-G8604693-W38642589083-69762990 and request_id 396732352
parent request_id:396732351
In handled no data found exception
No more records to process
NO. OF ORDERS FOUND: 1
NO. OF ORDERS IMPORTED: 0
NO. OF ORDERS FAILED: 1

ORDER NUMBER : 10035713


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management responsibility
2. Run Order Import
3. See issue

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot determine why order was import even though there are errors.

Cause

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