Datafix: PO Receipt Not Showing In Inventory Material Transaction Table (Doc ID 2189369.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms

The Receipt is not showing in Inventory Material Transaction Table although the receipt shows in Purchasing (but there is no information's in MTL_MATERIAL_TRANSACTIONS).

Steps
1. Perform receipt.
2. Check tables:
a. -- updated in INVOICES Tabes(AP_INVOICES_ALL,AP_INVOICE_LINES_ALL,AP_INVOICES_INTERFACE etc..)
b. -- updated in Receipt Tables (RCV_SHIPMENT_HEADERS,RCV_SHIPMENT_LINES,RCV_SHIPMENT_LINES etc..)
c. but there is no information on MTL_MATERIAL_TRANSACTIONS Table.

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