My Oracle Support Banner

12.1.3 iStore Direct Item Entry Gives Error "Duplicate cross reference part numbers found for this cross reference type" (Doc ID 2695263.1)

Last updated on JULY 11, 2022

Applies to:

Oracle iStore - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Checkout and Order Placement

Using direct Item Entry, when enter the type and cross reference number in iStore Direct Item Entry and choose Fill Details get the error -

This for items that are setup in Cross Reference and Assign page with specific organizations (Applicable To All Organizations not checked) and all the SAME entry for the Value field, then get the error.




ERROR
-----------------------
Duplicate cross reference part numbers found for this cross reference type.
Please contact your system administrator.

 

Example:

Create three entries for inventory item MY_CUSTOMER_ITEM and type MY_NEW_TYPE
If these are setup with the Value field to ALL the SAME then the error is returned -

Navigate: Inventory responsibility
Items -> Cross References

                                         Org             Value
1 MY_CUSTOMER_ITEM         D1              MY_55
2 MY_CUSTOMER_ITEM         H1              MY_55
3 MY_CUSTOMER_ITEM         D2              MY_55

 

If the Value field is setup diff for each Org, then no error




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Direct Item Entry
2. Error



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
References


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