Why does the Order Import setting populate the Customers Ordered_Item instead of the Internal_Item when it's not being a cross reference customer ? (Doc ID 1990051.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.

Goal

Why does the Order Import setting populate the Customers Ordered_Item instead of the Internal Item when it's not being a cross reference customer ?

Summary Of Issue
-----------------------------
Have an EDI customer who is providing us their part number and our part number in the 850. After running the flat file into
oracle's interface tables, when looking at oe_lines_iface_all we can see that inventory_item = our part number (50001) and
customer_item_name = their part number (103959). This customer is NOT setup as having customer items or a customer
item cross reference, however, we do have other customers that are. Once order import completes and users look at the
order in order organizer, it is setting the ordered item to their part number (103959) instead of our part number (50001).

OBSERVATION
----------------
What is very strange however, is that this only happens if we also have a part number that is the same at their part number.
So we do actually have a part number 103959, however this behavior does not happen when they provide a customer item
name that we do not have, so 141039 sets the ordered item to be our part number (119621).

EXPECTED BEHAVIOR
-----------------------
Expected the system to recognize Internal Item part number 50001, but instead it's setting customer item number 103959.
 

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