Delivery Against Internal Order Has Not Increased Stock in Mtl_Material_Transactions Table (Doc ID 1279944.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

A DELIVER transaction against an Internal Requisition or Internal Sales Order has not increased the On Hand Quantity .
The intransit shipment receipt for Internal Requisition is not showing in inventory, even though the receipt is delivered.

A transaction of type DELIVER exists in the table RCV_TRANSACTIONS, but a row in MTL_MATERIAL_TRANSACTIONS_TEMP was not created nor in MTL_MATERIAL_TRANSACTIONS so consequently there is no row in the MTL_ONHAND_QUANTITIES tables.  
   
Steps
1. Navigate to  View Receiving Transactions
2. Enter search criteria and click Find
3. Both a Receive and Deliver transaction exist

In RCV_TRANSACTIONS table (example)

 

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