FREEZE PHYSICAL INVENTORY (INCAPF) OUTPUT IS NULL BUT UPDATES ARE PERFORMED

(Doc ID 2309121.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

We are trying to performing a physical inventory, but when we take a Snapshot of inventory quantities the Freeze physical inventory output is generated empty even though there is on-hand inventory available.  Checking on the physical inventory tables after the snapshot is complete, you see:

- MTL_PHYSICAL_INVENTORIES has correct values for FREEZE_DATE and for NUMBER_OF_SKUS
- MTL_PHYSICAL_ADJUSTMENTS has the adjustments that were created and the appropriate fields are populated

Is this a setup issue, a data issue, a bug, or expected functionality?

 

 

 

 

 

 

 

Solution

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