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.GL_UPDT_MSG

Object Details

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

OPM GL Update Process Error Messages table. Only used when OPM is integrated with Oracle Financials.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_UPDT_MSG_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GUPROC_ID LINE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
GUPROC_ID	NUMBER	(10)	Yes	OPM GL Update process reference number
LINE_NO	NUMBER	(10)	Yes	Sequential line number to order the messages
MESSAGE_COMMENT	VARCHAR2	(240)	Yes	Actual error message composed and generated during the process
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard delete mark
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column

Query Text

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


SELECT GUPROC_ID
,      LINE_NO
,      MESSAGE_COMMENT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DELETE_MARK
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM GMF.GL_UPDT_MSG;

Dependencies

[top of page]

GMF.GL_UPDT_MSG does not reference any database object

GMF.GL_UPDT_MSG is referenced by following:

APPS: GL_UPDT_MSG