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

TABLE: GL.GL_XFR_TRACKING

Object Details
Object Name: GL_XFR_TRACKING
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_XFR_TRACKING
Subobject Name:
Status: VALID


This table contains the tracking information that Golden Gate will use to launch Journal Import.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_XFR_TRACKING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnXFER_REQUEST_ID
ColumnSYSTEM_ID
Columns
Name Datatype Length Mandatory Comments
XFER_REQUEST_ID NUMBER (15) Yes Request id in EBS of this transfer run
JE_SOURCE_KEY VARCHAR2 (25) Yes Source key of the data to be transferred
GROUP_ID NUMBER (15) Yes Group id of the data to be transferred
SYSTEM_ID NUMBER (15) Yes System id data was transferred from
INTERFACE_TABLE_NAME VARCHAR2 (30) Yes Table name that the interface data is in
LEDGER_ID NUMBER (15) Yes Fusion ledger id data is being transferred in to.
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
STATUS_CODE VARCHAR2 (30) Yes Status Code
ORIGINAL_FIRST_PERIOD VARCHAR2 (15)
Original First Period
Query Text

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


SELECT XFER_REQUEST_ID
,      JE_SOURCE_KEY
,      GROUP_ID
,      SYSTEM_ID
,      INTERFACE_TABLE_NAME
,      LEDGER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      STATUS_CODE
,      ORIGINAL_FIRST_PERIOD
FROM GL.GL_XFR_TRACKING;

Dependencies

[top of page]

GL.GL_XFR_TRACKING does not reference any database object

GL.GL_XFR_TRACKING is referenced by following:

SchemaGL
ViewGL_XFR_TRACKING#