My Oracle Support Banner

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

Last updated on JULY 08, 2020

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Physical Counting

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.

Expect the snapshot to include all qualified records.

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




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.