Physical Inventory Snapshot Not Creating Records For All On Hands (Doc ID 2269189.1)

Last updated on JULY 08, 2020

Applies to:

Symptoms

On : 12.1.3 version, Physical Counting

ACTUAL BEHAVIOR
---------------
In the recent physical inventory snapshot records were not created for some on hand records. As a result the inventory adjustments were understated and only when launching the adjustments and user had Physical Inventory Transfer user saw the records in the original subinventory. Due to this the approved adjustment value was over stated.

This is occurring in a WMS-enabled org.

NOTE: Need to mention that user has multiple physical inventory names, each physical inventory having one or more subinventories, but one subinventory will only be in one physical count. When user do the snapshots and tag counts, multiple jobs will run at the same time. [ Probably not an issue, as INCAPF has a seeded incompatibility with itself, per Bug 24289458 ]

1. Do not have sales orders at all in this organization
2. There are no reservations against the 2 items in question
3. There are no move order allocations against the 2 items in question
4. Subinventory and locator is normal stock - not a staging lane

Use LPNs to move stock between different areas. This is the reason for stock on LPN. Other stock in same subinventory that are also on LPN were in the snapshot.

EXPECTED BEHAVIOR
-----------------------
Expect the snapshot to include all qualified records.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created physical Inventory for specific subinventories
2. Perform Snapshot
3. Generate Tags
4. No tags available for specific on hand records

Changes

Cause

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