Physical Inventory Snapshot Not Creating Records For All On Hands
(Doc ID 2269189.1)
Last updated on MARCH 05, 2019
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