My Oracle Support Banner

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 APRIL 18, 2023

Applies to:

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

Symptoms

Problem

Records in the Transaction Open Interface, MTL_TRANSACTIONS_INTERFACE table with error

The stuck transactions  will not clear by resubmission.

Changes

 1) Customer uses Installed Base and items are Installed Base trackable, trigger CSI_BLOCK_MAT_TXN_TRG got created and enabled

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.