Delivery Against Internal Order Has Not Increased Stock in Mtl_Material_Transactions Table
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.
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.
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)
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