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 26, 2019
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
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 (x01) and
customer_item_name = their part number (x09). 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 (x09) instead of our part number (x01).
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 x09, however this behavior does not happen when they provide a customer item
name that we do not have, so x39 sets the ordered item to be our part number (x21).
Expected the system to recognize Internal Item part number x01, but instead it's setting customer item number x09.
Note: Part numbers are made up for this example.
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