[Home] [Help] [Dependency Information]
Object Name: | FND_LOG_UNIQUE_EXCEPTIONS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_LOG_UNIQUE_EXCEPTIONS |
Subobject Name: | |
Status: | VALID |
This table tracks all details related to unique exceptions that are logged. Exceptions with the same encoded message (i.e. message name and token values) will be considered to be duplicates
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_LOG_UNIQUE_EXCEPTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIQUE_EXCEPTION_ID |
FND_LOG_UNIQUE_EXCEPTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ENCODED_MESSAGE
STATUS |
FND_LOG_UNIQUE_EXCEPTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ENGLISH_MESSAGE
STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIQUE_EXCEPTION_ID | NUMBER | Yes | Primary key, generated from theFND_LOG_UNIQUE_EXCEPTIONS_S sequence | |
ENCODED_MESSAGE | VARCHAR2 | (2000) | Encoded message dictionary message | |
ENGLISH_MESSAGE | VARCHAR2 | (2000) | English translation from message dictionary | |
STATUS | VARCHAR2 | (1) | "N" New "O" Open "C" Closed | |
COUNT | NUMBER | Count of child exceptions that were logged under this unique exception | ||
SEVERITY | VARCHAR2 | (10) | Severity of Exception 'CRITICAL', ERROR', 'WARNING' | |
CATEGORY | VARCHAR2 | (10) | Category of Exception 'SYSTEM', 'PRODUCT' | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT UNIQUE_EXCEPTION_ID
, ENCODED_MESSAGE
, ENGLISH_MESSAGE
, STATUS
, COUNT
, SEVERITY
, CATEGORY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPLSYS.FND_LOG_UNIQUE_EXCEPTIONS;
APPLSYS.FND_LOG_UNIQUE_EXCEPTIONS does not reference any database object
APPLSYS.FND_LOG_UNIQUE_EXCEPTIONS is referenced by following:
|
|
|