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_EVENTS

Object Details

Object Name:	FND_EVENTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_EVENTS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_EVENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_ID
FND_EVENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_APPLICATION_ID SOURCE_ID SOURCE_TYPE
FND_EVENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID SOURCE_TYPE
FND_EVENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TYPE PROCESSED
FND_EVENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEST_TYPE PROCESSED
FND_EVENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEVERITY

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER		Yes
SOURCE_APPLICATION_ID	NUMBER		Yes
SOURCE_ID	NUMBER		Yes
SOURCE_TYPE	VARCHAR2	(1)	Yes
DEST_TYPE	VARCHAR2	(1)	Yes
MESSAGE_APPL_SHORT_NAME	VARCHAR2	(50)	Yes
MESSAGE_NAME	VARCHAR2	(30)	Yes
TIME	DATE		Yes
SEVERITY	VARCHAR2	(30)	Yes
PROCESSED	VARCHAR2	(1)	Yes
TOKENS	VARCHAR2	(1)	Yes
MODULE	VARCHAR2	(255)		Exception Source Module
USER_ID	NUMBER			User that posted event
RESP_APPL_ID	NUMBER			Application ID of User's Responsibility
RESPONSIBILITY_ID	NUMBER			User's Responsibility Id
SEC_GROUP_ID	NUMBER			Users's Security Group ID
SESSION_ID	NUMBER			User's session ID
NODE	VARCHAR2	(30)		Node event was posted from
DB_INSTANCE	VARCHAR2	(16)		Database Instance event was posted from
AUDSID	NUMBER			Oracle Session ID
SECURITY_GROUP_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_ID
,      SOURCE_APPLICATION_ID
,      SOURCE_ID
,      SOURCE_TYPE
,      DEST_TYPE
,      MESSAGE_APPL_SHORT_NAME
,      MESSAGE_NAME
,      TIME
,      SEVERITY
,      PROCESSED
,      TOKENS
,      MODULE
,      USER_ID
,      RESP_APPL_ID
,      RESPONSIBILITY_ID
,      SEC_GROUP_ID
,      SESSION_ID
,      NODE
,      DB_INSTANCE
,      AUDSID
,      SECURITY_GROUP_ID
FROM APPLSYS.FND_EVENTS;

Dependencies

[top of page]

APPLSYS.FND_EVENTS does not reference any database object

APPLSYS.FND_EVENTS is referenced by following:

APPLSYS: FND_EVENTS#