[Home] [Help] [Dependency Information]
Object Name: | FND_LOG_EXCEPTIONS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_LOG_EXCEPTIONS |
Subobject Name: | |
Status: | VALID |
Here we store the extended exception information that is needed for
efficient queries. The log_sequence number serves as the primary key
for this table, and will be used as the event_key for the business event
raised for the exception.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_LOG_EXCEPTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACKNOWLEDGED |
FND_LOG_EXCEPTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SEVERITY |
FND_LOG_EXCEPTIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOG_SEQUENCE |
FND_LOG_EXCEPTIONS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UNIQUE_EXCEPTION_ID |
FND_LOG_EXCEPTIONS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_CONTEXT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_SEQUENCE | NUMBER | (22) | Yes | Primary key. Also foreign key back into fnd_log_messages |
SESSION_MODULE | VARCHAR2 | (48) | v$session.module | |
SESSION_ACTION | VARCHAR2 | (32) | v$session.action | |
ACKNOWLEDGED | VARCHAR2 | (1) | Yes | Y/N - OAM will allow the DBA to acknowledge an exception, to allow it to be filtered out of queries |
CATEGORY | VARCHAR2 | (10) | 'SYSTEM', 'PRODUCT', or null - Only used if TRANSLATED='Y' and LOG_LEVEL=6 (Unexpected). | |
SEVERITY | VARCHAR2 | (10) | 'CRITICAL', 'ERROR','WARNING', or null - Only used if TRANSLATED='Y' and LOG_LEVEL=6 (Unexpected) | |
MESSAGE_TEXT | VARCHAR2 | (2000) | Yes | Message text translated into the session language |
UNIQUE_EXCEPTION_ID | NUMBER | Foreign key into FND_LOG_UNIQUE_EXCEPTION. Associates a logged exception with its unique exception | ||
TRANSACTION_CONTEXT_ID | NUMBER | TRANSACTION_CONTEXT_ID |
Cut, paste (and edit) the following text to query this object:
SELECT LOG_SEQUENCE
, SESSION_MODULE
, SESSION_ACTION
, ACKNOWLEDGED
, CATEGORY
, SEVERITY
, MESSAGE_TEXT
, UNIQUE_EXCEPTION_ID
, TRANSACTION_CONTEXT_ID
FROM APPLSYS.FND_LOG_EXCEPTIONS;
APPLSYS.FND_LOG_EXCEPTIONS does not reference any database object
APPLSYS.FND_LOG_EXCEPTIONS is referenced by following:
|
|
|