Rows Stuck in the Transaction Open Interface (mtl_transactions_interface) Table with error : Ex.. In UpdateMMToracle.jdbc.driver.OracleSQLException: ORA-01400: Cannot Insert NULL Into ("INV"."MTL_MATERIAL_TRANSACTIONS"."LAST_UPDATED_BY")
(Doc ID 2017106.1)
Last updated on JANUARY 20, 2020
Applies to:Oracle Inventory Management - Version 220.127.116.11 and later
Oracle Installed Base - Version 18.104.22.168 and later
Information in this document applies to any platform.
Records in the Transaction Open Interface, MTL_TRANSACTIONS_INTERFACE table with error
The stuck transactions will not clear by resubmission.
1) Customer uses Installed Base and items are Installed Base trackable, trigger CSI_BLOCK_MAT_TXN_TRG got created and enabled
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