My Oracle Support Banner

Miscellaneous Receipt Fails With "Passed Serial Number (XXXX) Violates Uniqueness With In Inventory Items". (Doc ID 1601315.1)

Last updated on AUGUST 07, 2020

Applies to:

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


Miscellaneous Receipt transaction is failing to update Install Base with following error message for lot controlled items:


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

The issue can be reproduced with the following steps:
1. create new item, EAM rebuildable type, serialized, lot controlled
2. create Misc receipt: Item A, Lot L1, Serial Number SN1
3. do any of these:
a) Issue item A, lot L1, serial number SN1 to EAM work order
b) Issue item A, lot L1, serial number SN1 as Inventory Misc Issue
4. create Misc Receipt for Item A, Lot L1-X, serial number SN1.
5. Check Oracle Installed Base Admin > Transaction Error Processing for item A
=> above error is displayed




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

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