My Oracle Support Banner

Physical Inventory Adjustment Posted But Corresponding Tag Details Are Missing (Doc ID 2347706.1)

Last updated on FEBRUARY 16, 2019

Applies to:

Oracle Inventory Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Physical Inventory Adjustment posted for tags for which no tag details exists

Physical inventory counting completed with adjustment posted. While reconciling for stock checking with Tags, there are some items found for which adjustment has been posted, but the tag counts entered for those items does not exist

This is a case of data corruption

EXPECTED BEHAVIOR
-----------------------
Expect physical inventory tags to be available in  MTL_PHYSICAL_INVENTORY_TAGS which are associated to the adjustments posted

STEPS
-----------------------
The issue can be observed with the following steps:
1. Query for specific physical inventory tags associated to adjustment ids under physical inventory
2. No records can be found for tags where the data corruption exists

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.