Item Available In Inventory But In Item Supply/Demand Form Current Onhand Is Showing As Zero

(Doc ID 2133144.1)

Last updated on MAY 21, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Inventory Transactions

Items have on hand quantity available in Organization and Subinventory but in View Supply Demand Form the Current On hand quantity is showing as zero '0'.

This issue with ALL items that have lot control enabled.

Issue did not occur until Patch 21236633 - Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 4 [RPC4]

STEPS
-----------------------
1. Navigate to Inventory > Onhand > Supply/Demand.
2. Query item.
3. See zero (0) available.

Changes

Applied RPC4 Patch in Production Environment

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