My Oracle Support Banner

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 AUGUST 14, 2018

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

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
Goal
Solution
References


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.