My Oracle Support Banner

How To Use Same Serial Number In Different Organization For Same Item? (Doc ID 2718932.1)

Last updated on OCTOBER 12, 2020

Applies to:

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

Goal

We need to create new Item Instances for X Inv Org Item Instance using same serial numbers which already exists in Y, but while creating them we are getting Error:

Passed Serial Number (12345678) violates uniqueness with in Inventory items.

Some of the Item Instances we are getting the error:

Serial Number 12345678 has Inventory Material Transactions. This Item Instance's Serial Number cannot be Updated

 

Implementation:

In the system, SN uniqueness is defined as stated in the following documents:

How Installed Base Determines If A Serial Number Is Duplicated (Doc ID 387527.1)

Troubleshooting "Passed Serial Number (&SERIAL_NUMBER) violates uniqueness with..." Errors (Doc ID 1516003.1)

Within inventory model and items - A serial number is considered as a duplicated if the same serial number is used by the same item or a different item and the different items are under same model.
This enforces unique serial numbers for inventory model.

Business Case:

The requirement is to convert the IB data from Y OU to X OU. Business wants the same serial numbers in X but some are having material transactions.

Questions:

How business can use the same serial numbers in X with Item Instances?
Since the business is using the SN to track the orders, they would need same serial number in X as well.
What are the option we have to use the same SN with same item? Can we do the Inter-Org transfer if the existing Item Instance having material transactions?


 

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


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