ALL_APPLY_ERROR_MESSAGES

ALL_APPLY_ERROR_MESSAGES displays information about the individual messages in an error transaction generated by the apply processes that dequeue messages from queues accessible to the current user.

Related View

DBA_APPLY_ERROR_MESSAGES displays information about the individual messages in all of the error transactions generated by all apply processes in the database.

Note:

Messages that were spilled from memory to hard disk do not appear in this view.

Column	Datatype	Description
`MESSAGE_ID`	`RAW(16)`	Unique identifier of the message stored in the error queue
`LOCAL_TRANSACTION_ID`	`VARCHAR2(22)`	Local transaction ID for the error transaction
`TRANSACTION_MESSAGE_NUMBER`	`NUMBER`	Message number of the message that raised the error. The message number is a sequence number for the messages in the transaction, starting with 1.
`ERROR_NUMBER`	`NUMBER`	Error number of the error raised by the transaction. The error number is populated only for the LCR that raised the error. This field is NULL for the other LCRs in the transaction.
`ERROR_MESSAGE`	`VARCHAR2(4000)`	Error message of the error raised by the transaction. The error message is populated only for the LCR that raised the error. This field is NULL for the other LCRs in the transaction.