My Oracle Support Banner

Customer Item Number Has Invalid Cross Reference When Attempting to Process EDI Inbound Data (Doc ID 872920.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Release Management - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:
When attempting to process EDI inbound data, the Sales order is neither
specified on schedule nor setup at the Ship From/Ship To Terms level or
Ship From/Customer Item Terms level.

Receiving Error:

Customer Item Number xxxxx has invalid cross reference.


Observation:
The above is the example. There are several Item number have invalid cross reference.
But all those cross references are showing. Some Item numbers are OK.
The error only occurs on certain part numbers.

ERROR

Customer Item Number xxxxx has invalid cross reference.

 
Steps To Reproduce:
1. Responsibility: Release management
2. Run > EDI SPSI 830, with an internal part number but no cross reference.
3. Certain parts have invalid cross reference even those cross references set up on item master.

There is currently no functionality within Order Management/RLM to obtain this feature. Consider
using MTL_CI_INTERFACE to Import Customer Item Cross Reference

Use the following WORKAROUND if user does not have the Customer Items Defined
1. First populate the MTL_INTERFACE table
    Use Manufacturing and Distribution Manager responsibility
     Special menu View -> Requests
     Submit a new request for program 'Import Customer Items'
2. Next populate the MTL_XREFS_INTERFACE table
     Use Manufacturing and Distribution Manager responsibility
     Special menu View -> Requests
     Submit a new request for program 'Import Customer Item cross references'


 
 

Changes

Upgraded from Release 11.5.9 to Release 12.0.6

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.