5.106 DBA_APP_ERRORS_HISTORY

DBA_APP_ERRORS_HISTORY displays the history of errors raised when an application PDB synchronizes with an application in the application root.

This view displays errors raised during the last 10 synchronizations for each application.

Column Datatype NULL Description

APP_NAME

VARCHAR2(128)

Name of the application whose statement was captured

APP_STATEMENT

CLOB

Application statement

ERRORNUM

NUMBER

Error number for the statement

ERRORMSG

VARCHAR2(4000)

Error message for the statement

SYNC_TIME

TIMESTAMP(6)

NOT NULL

Sync time for the statement

SYSTEM_IGNORABLE

VARCHAR2(1)

Indicates whether the error is a system-ignorable error (Y) or not (N)

USER_IGNORABLE

VARCHAR2(1)

Indicates whether the error is a user-ignorable error (Y) or not (N)

Note:

This view is available starting with Oracle Database 21c.