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: ISC.ISC_FS_EVENTS_STG

Object Details

Object Name:	ISC_FS_EVENTS_STG
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

This table is used by the incremental load process for ISC_FS_TASKS_F, ISC_FS_TASK_ASSIGNMNTS_F and ISC_FS_CAPACITY_F.
It is initially truncated and then populated with each row from ISC_FS_EVENTS and ISC_FS_PARTY_MERGE_EVENTS.
This table is used to drive the incremental load while ISC_FS_EVENTS continues to have new rows inserted into it by the transaction application.
If the incremental load is successful, the matching (based on EVENT_ROWID) rows are deleted from ISC_FS_EVENTS and ISC_FS_PARTY_MERGE_EVENTS. If the incremental load encounters an error the rows remain in ISC_FS_EVENTS and ISC_FS_PARTY_MERGE_EVENTS and will be processed via the next incremental load. This table is always truncated at the completion of the incremental load (irrespective of the outcome).
This table does not need WHO columns as the rows exist in the table only during the execution of the incremental load.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE	NUMBER		Yes	1 - from ISC_FS_EVENTS, 2 - from ISC_FS_PARTY_MERGE_EVENTS
EVENT_ROWID	ROWID	(10)	Yes	Rowid of the corresponding row in ISC_FS_EVENTS or ISC_FS_PARTY_MERGE_EVENTS
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(60)	Yes	Source Object Type identifier - typically "SR"
SOURCE_OBJECT_ID	NUMBER		Yes	Source Object identifier
TASK_ID	NUMBER			Task identifier
TASK_ASSIGNMENT_ID	NUMBER			Task Assignment identifier if Task Assignment Created, Updated or Deleted

Query Text

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


SELECT SOURCE
,      EVENT_ROWID
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_ID
,      TASK_ID
,      TASK_ASSIGNMENT_ID
FROM ISC.ISC_FS_EVENTS_STG;

Dependencies

[top of page]

ISC.ISC_FS_EVENTS_STG does not reference any database object

ISC.ISC_FS_EVENTS_STG is referenced by following:

APPS: ISC_FS_EVENTS_STG