Import Orders Using Items With Cross References (Doc ID 1425666.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Entry

When attempting to import order lines with CUSTOMER_ITEM_NAME
and CUSTOMER_ITEM_ID_TYPE = CUST,
the following error occurs.

ERROR
-----------------------
CALLED TO THE INV API CI_ATTR_VAL RETURNED ERROR:No Customer Item found in the MTL_CUSTOMER_ITEMS table with the specified criteria.
Msg-1 for Src: 0, Hdr: OE_ORDER_HEADERS_ALL62002, Line: 000001: Inventory Api Return with APP-43037 :- No Customer Item found in the MTL_CUSTOMER_ITEMS table with the specified criteria.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate Interface tables (oe_headers_iface_all + oe_lines_iface_all)
2. CUSTOMER_ITEM_ID_TYPE = CUST
OPERATION_CODE = INSERT
CUSTOMER_ITEM_NAME= 1550-33630
3. Run OEOIMP module: Order Import concurrent request

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import order lines using the customer item name only.

Cause

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