My Oracle Support Banner

EBS WMS: Data Cleanup Script For Zero Quantity Records In MTL_ONHAND_QUANTITIES_DETAIL Table (Doc ID 1577990.1)

Last updated on JANUARY 04, 2021

Applies to:

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

Symptoms

Generate reports on the quantity on hand details of the items from MTL_ONHAND_QUANTITIES_DETAIL table showing items with zero quantity. 

When you query the MTL_ONHAND_QUANTITIES_DETAIL table it has 2 records for that item whose sum of Primary transaction Quantity is equating to zero.

Concurrent request "Consolidate Inventory Onhand Quantities" is not going to work in WMS enabled organization

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.