My Oracle Support Banner

Discrepancy In Mtl Material Table Transact Qty And Mtl Txn Request Headers Table Delivered Qty (Doc ID 2518204.1)

Last updated on JULY 02, 2021

Applies to:

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

Symptoms

There is a discrepancy between  MTL_MATERIAL_TRANSACTIONS.transaction_quantity and the 
and MTL_TXN_REQUEST_LINES.quantity_delivered value. In these cases, the
MTL_MATERIAL_TRANSACTIONS.transaction_quantity is <0.

The following identification script can be run to detect the discrepancy. 
When prompted, run for a specific organization_id enter nothing to run for all organizations.

Changes

 

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
Changes
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.