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: FII.FII_SYSTEM_EVENT_LOG

Object Details

Object Name:	FII_SYSTEM_EVENT_LOG
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_SYSTEM_EVENT_LOG
Subobject Name:
Status:	VALID

This is an internal system table used for synchronization of denormalized data between Project dimension and project related facts.
Project facts (FII_PA_COST_F, FII_PA_REVENUE_F, FII_PA_BUDGET_F) have data that is
denormalized from Project dimension. Project dimension load process detects changes in the denormalized data and records log of the changes in FII_SYSTEM_EVENT_LOG. Project fact load process reads this table and updates fact tables with the most recent changes in denormalized data.
Column EVENT_TYPE is used to identify what fact table needs to be updated, EVENT_ID is a unique event identifier generated from a sequence, EVENT_OBJECT indicates a column in the project dimension that stores the original attribute value, ATTRIBUTE1 stores unique identifier
of the original record in the Project dimension, STATUS indicates processing status for the log record.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_SYSTEM_EVENT_LOG_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	EVENT_TYPE EVENT_ID

Columns

Name	Datatype	Length	Comments
EVENT_TYPE	VARCHAR2	(30)	System event type
EVENT_ID	NUMBER		Event identifier
EVENT_OBJECT	VARCHAR2	(240)	Event object
ATTRIBUTE1	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)	Descriptive flexfield segment
INSTANCE	VARCHAR2	(40)	Instance identifier
ERROR_CODE	VARCHAR2	(2000)	Event error code
STATUS	VARCHAR2	(30)	Event status
CREATION_DATE	DATE		Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.

Query Text

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


SELECT EVENT_TYPE
,      EVENT_ID
,      EVENT_OBJECT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      INSTANCE
,      ERROR_CODE
,      STATUS
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM FII.FII_SYSTEM_EVENT_LOG;

Dependencies

[top of page]

FII.FII_SYSTEM_EVENT_LOG does not reference any database object

FII.FII_SYSTEM_EVENT_LOG is referenced by following:

APPS: FII_SYSTEM_EVENT_LOG