My Oracle Support Banner

How to Prevent Duplicate Physical Inventory Tags Creation? (Doc ID 1472997.1)

Last updated on JANUARY 23, 2020

Applies to:

Oracle Inventory Management - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Goal

Physical Inventory Tag Counts are Recorded Incorrectly in Physical Adjustments

The steps are as follows:
1- Create a Physical Inventory
2- Generate Tags
3- Enter Counts

What happens is that if 2 records in the Tags Table have the same Item-lot-locator combination with 2 different Count Quantity; this will create a record in Adjustment Table with the sum of Count Quantities.
This is happening if user manually entered tags
 

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.