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: GMF.SY_EXCP_TBL

Object Details

Object Name:	SY_EXCP_TBL
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.SY_EXCP_TBL
Subobject Name:
Status:	VALID

Contains the errors generated by the OPM Financials Data Synchronization Process for invalid data. The Exception Report for this process displays data from this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SY_EXCP_TBL_I0	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TABLE_CODE KEY_VALUE
SY_EXCP_TBL_I1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOFTWARE_CODE TABLE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
SOFTWARE_CODE	VARCHAR2	(8)	Yes	Software Code of the Financials Package that is integrated with OPM
TABLE_CODE	VARCHAR2	(16)	Yes	Indicates the data source(Table Code) that had an invalid row that could not be synchronized into OPM or to Oracle Financials( depending on the direction of synchronization.)
MESSAGE_CODE	VARCHAR2	(32)	Yes	The message token that indicates the error generated during the Synchronization process. The message token along with the parameters in columns COL1, COL2, COL3, COL4, COL5 are used by the Exception Report to compose and print the detailed error message.
EXCEPTION_DATE	DATE		Yes	The date the error ( or the exception) was generated
COL1	VARCHAR2	(64)		A parameter that provides the required information for the error that is generated during the Synchronization process. The message token MESSAGE_CODE along with this and other parameters, COLn, will be used to compose and print a detailed error message by the Exception Report.
COL2	VARCHAR2	(64)		A parameter that provides the required information for the error that is generated during the Synchronization process. The message token MESSAGE_CODE along with this and other parameters, COLn, will be used to compose and print a detailed error message by the Exception Report.
COL3	VARCHAR2	(64)		A parameter that provides the required information for the error that is generated during the Synchronization process. The message token MESSAGE_CODE along with this and other parameters, COLn, will be used to compose and print a detailed error message by the Exception Report.
COL4	VARCHAR2	(64)		A parameter that provides the required information for the error that is generated during the Synchronization process. The message token MESSAGE_CODE along with this and other parameters, COLn, will be used to compose and print a detailed error message by the Exception Report.
COL5	VARCHAR2	(64)		A parameter that provides the required information for the error that is generated during the Synchronization process. The message token MESSAGE_CODE along with this and other parameters, COLn, will be used to compose and print a detailed error message by the Exception Report.
INTERFACE_ID	NUMBER	(15)	Yes	Reference number for the Synchronization run
CO_CODE	VARCHAR2	(4)		Company for which the Synchronization is run and errors that got generated. The company field is valid only under Oracle Financials Multi-Org setup and further restricted to only those sources that are specified as Company Specific. The company specific sources are determined from the synchronization setup information( in SY_SOFT_DTL.)
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
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
KEY_VALUE	VARCHAR2	(256)	Yes	Contains the concatenated key value from the primary key columns of rows that are marked as invalid during Synchronization process. Used to manage the exceptions generated by successive runs of the Synchronization process.

Query Text

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


SELECT SOFTWARE_CODE
,      TABLE_CODE
,      MESSAGE_CODE
,      EXCEPTION_DATE
,      COL1
,      COL2
,      COL3
,      COL4
,      COL5
,      INTERFACE_ID
,      CO_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      KEY_VALUE
FROM GMF.SY_EXCP_TBL;

Dependencies

[top of page]

GMF.SY_EXCP_TBL does not reference any database object

GMF.SY_EXCP_TBL is referenced by following:

APPS: SY_EXCP_TBL