[Home] [Help] [Dependency Information]
Object Name: | FND_LOG_MESSAGES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_LOG_MESSAGES |
Subobject Name: | |
Status: | VALID |
Programs will log debug messages to this table with the FND_LOG
package, and admins/programmers enable logging and view the data with
the FND_LOG_VIEW package, through http. Code is sprinkled with calls
that give the log level, module, and message to log.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000098862C00019$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000098862C00020$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
FND_LOG_MESSAGES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_CONTEXT_ID |
FND_LOG_MESSAGES_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOG_SEQUENCE |
FND_LOG_MESSAGES_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TIMESTAMP
TRANSACTION_CONTEXT_ID |
FND_LOG_MESSAGES_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ECID_ID
ECID_SEQ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MODULE | VARCHAR2 | (255) | Yes | Source-Code Block Identifier |
LOG_LEVEL | NUMBER | Yes | Severity of Log message (1-Lowest, 6-Highest) | |
MESSAGE_TEXT | VARCHAR2 | (4000) | Yes | Message |
SESSION_ID | NUMBER | FK to ICX_SESSIONS | ||
USER_ID | NUMBER | Yes | FK to FND_USER | |
TIMESTAMP | DATE | Yes | Time message was logged | |
LOG_SEQUENCE | NUMBER | Yes | Primary Key | |
ENCODED | VARCHAR2 | (1) | 'Y' / 'N' - Y indicates that the MESSAGE_TEXT column actually stores an encoded message from Message Dictionary. | |
NODE | VARCHAR2 | (60) | The name of the node for the current transaction | |
NODE_IP_ADDRESS | VARCHAR2 | (30) | The IP of the Node for the current transactions | |
PROCESS_ID | VARCHAR2 | (120) | The OS process Id for the current transaction | |
JVM_ID | VARCHAR2 | (120) | The unique Id for the current JVM process of the current transaction | |
THREAD_ID | VARCHAR2 | (120) | The Java thread id of the current transaction | |
AUDSID | NUMBER | This records the database AUDSID, since a single database session may be shared by multiple ICX_SESSIONS. | ||
DB_INSTANCE | NUMBER | This records the database instance number. This may be useful when looking for patterns of problems in OPS instances. | ||
TRANSACTION_CONTEXT_ID | NUMBER | Foreign key into fnd_log_transaction_context. Points to details of the transaction that logged this message. | ||
ECID_ID | VARCHAR2 | (3100) | ECID_ID | |
ECID_SEQ | NUMBER | ECID_SEQ | ||
CALLSTACK | CLOB | (4000) | CALLSTACK | |
ERRORSTACK | CLOB | (4000) | ERRORSTACK |
Cut, paste (and edit) the following text to query this object:
SELECT MODULE
, LOG_LEVEL
, MESSAGE_TEXT
, SESSION_ID
, USER_ID
, TIMESTAMP
, LOG_SEQUENCE
, ENCODED
, NODE
, NODE_IP_ADDRESS
, PROCESS_ID
, JVM_ID
, THREAD_ID
, AUDSID
, DB_INSTANCE
, TRANSACTION_CONTEXT_ID
, ECID_ID
, ECID_SEQ
, CALLSTACK
, ERRORSTACK
FROM APPLSYS.FND_LOG_MESSAGES;
APPLSYS.FND_LOG_MESSAGES does not reference any database object
APPLSYS.FND_LOG_MESSAGES is referenced by following:
|
|
|