Order Import Fail When Using Inventory Item, error Please enter required information - Inventory Item
(Doc ID 1350280.1)
Last updated on FEBRUARY 01, 2022
Applies to:
Oracle Order Management - Version 12.0.4 and laterInformation in this document applies to any platform.
OEOIMP
Symptoms
When attempting to do order import
if specify inventory_item it failed ,
if use inventory_item_id , it works fine.
The problem occur after applying <Patch 9430881>
the following error occurs.
ERROR
L_MSG_DATA=Please enter required information - Inventory Item Error in Procedure insert_message ORA-01403: no data found
STEPS TO REPRODUCE
1. Insert data into table OE_HEADERS_IFACE_ALL with booked_flag=Y and use INVENTORY_ITEM instead of INVENTORY_ITEM_ID in OE_LINES_IFACE_ALL
2. Login as Order management responsibility
3. (N) Orders , Returns -> Import Orders-> Order Import request
Changes
Applied EGO <Patch 9430881>
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 |