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 220.127.116.11 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!