Inventory Interface Table Trigger Example To Track Material Processing (Debugging Sales Orders Interface)

(Doc ID 1547197.1)

Last updated on NOVEMBER 28, 2017

Applies to:

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

Goal

Could you please provide a way to track values created, inserted or deleted from the transaction interface table?

GOAL
Want to track data inserted into the interface tables that are not correctly processed by the trip stop.

OTHER OPTIONS
The normal way to debug shipping transactions is to enable WSH (<Note 290432.1>) and INV Debug (<Note 148651.1>).

BUSINESS IMPACT
Concerned that the data is not correctly processing from Shipping thru to Inventory.

Solution

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