25836578: Physical Inventory Snapshot Not Creating Records For All On Hands

(Doc ID 2269189.1)

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.

Symptoms

On : 12.1.3 version, Physical Counting

ACTUAL BEHAVIOR
---------------
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.


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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the approved adjustment value was over stated.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms