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

Last updated on FEBRUARY 21, 2022

Applies to:

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

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