My Oracle Support Banner

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

Last updated on SEPTEMBER 22, 2018

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

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.