How To Pass ORDERED_ITEM instead of INVENTORY_ITEM_ID in the P_LINE_TBL_ITEM? (Doc ID 2246754.1)

Last updated on MARCH 22, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

Qn1:Is there a way to pass ORDERED_ITEM instead of INVENTORY_ITEM_ID in the P_LINE_TBL_ITEM?
Currently if we pass ORDERED_ITEM only and no value in INVENTORY_ITEM_ID, it gives following error

"X_MESSAGES": {"X_MESSAGES_ITEM": [
{"MESSAGE_TEXT": "Please enter required information - Inventory Item"},
{"MESSAGE_TEXT": "Debug File: /finshared/common/admin/l2010950.dbg"}
]},

Since Oracle CPQ or middleware will be invoking OE_INBOUND_INT, the invoking application may not have INVENTORY_ITEM_ID, which is an Oracle internal ID.
 
Qn2:"Ok, that aligns with my finding and i have already tested using the correct sequence and this works.

Could you also help me with the below question?

Is there a way to pass ORDERED_ITEM instead of INVENTORY_ITEM_ID in the P_LINE_TBL_ITEM
Currently if we pass ORDERED_ITEM only and no value in INVENTORY_ITEM_ID, it gives following error

"X_MESSAGES": {"X_MESSAGES_ITEM": [
{"MESSAGE_TEXT": "Please enter required information - Inventory Item"},
{"MESSAGE_TEXT": "Debug File: /finshared/common/admin/l2010950.dbg"}
]},

Since Oracle CPQ or middleware will be invoking OE_INBOUND_INT, the invoking application may not have INVENTORY_ITEM_ID, which is an Oracle internal ID."
 

Solution

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