Order Import Fail When Using Inventory Item, error Please enter required information - Inventory Item
Last updated on DECEMBER 30, 2017
Applies to:Oracle Order Management - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Sep-2013***
On : 12.0.4 version, Transaction Entry
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.
L_MSG_DATA=Please enter required information - Inventory Item
Error in Procedure insert_message ORA-01403: no data found
The issue can be reproduced at will with the following steps:
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
Applied EGO Patch 9430881
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms