Install Base and Asset Tracking - EBS (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center