eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_LOG_MESSAGES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_LOG_MESSAGES does not reference any database object

APPLSYS.FND_LOG_MESSAGES is referenced by following:

APPLSYS: FND_LOG_MESSAGES#