My Oracle Support Banner

Project Accounting Records Stuck In MMTT with ORA-01400 error. (Doc ID 309782.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Inventory Management - Version and later
Information in this document applies to any platform.
Oracle Inventory Management - Version: 11.5.10
This problem can occur on any platform.
EXECUTABLE:CSICORSY - Install Base Error Correction and Synchronization Program


Project transaction and sales orders Pick Inventory transactions are stuck in MTL_MATERIAL_TRANSACTIONS_TEMP

Error is updateMMToracle.jdbc.driver.OracleSQLException: ORA-01400: cannot insert NULL into

If you disable the trigger CSI_BLOCK_MAT_TXN_TRG and reprocess the transactions then the transactions flow through smoothly.


 In the recent past request for "Install Base Error Correction and Synchronization Program" (CSICORSY) has been submitted after new installation or upgrade.


To view full details, 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 a vibrant support community of peers and Oracle experts.