25836578: Physical Inventory Snapshot Not Creating Records For All On Hands
Last updated on MAY 23, 2017
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 our 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 we had Physical Inventory Transfer we 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: I just need to mention that we have multiple physical inventory names, each physical inventory having one or more subinventories, but one subinventory will only be in one physical count. When we 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. We 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
We 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
The issue has the following business impact:
Due to this issue, the approved adjustment value was over stated.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms