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_EXCEPTIONS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_LOG_EXCEPTIONS does not reference any database object

APPLSYS.FND_LOG_EXCEPTIONS is referenced by following:

APPLSYS: FND_LOG_EXCEPTIONS#