CSI_TXN_ERROR issue
We are in 12.2.5, analyzing the CSI_TXN_ERRORS. We are testing the 'Integration Fix - IB Error Transaction' (Doc ID 1538138.1) concurrent program. It fails with "Cannot insert NULL into CSI_TRANSACTIONS.TRANSACTION_TYPE_ID. This concurrent program seem to be driven by CSI_TXN_ERRORS and this table has rows with Transaction_type_id is null seem to be causing the error.
Looking further, i see some of the rows in CSI_TXN_ERRORS dont have corresponding records in CSI_TRANSACTIONS_INTERFACE. Is this normal ?
We may some data corruption in CSI Interface tables.