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: GMA.GMA_MIGRATION_LOG

Object Details

Object Name:	GMA_MIGRATION_LOG
Object Type:	TABLE
Owner:	GMA
FND Design Data:	GMA.GMA_MIGRATION_LOG
Subobject Name:
Status:	VALID

TO TRACK MIGRATION ERRORS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMA_MIGRATION_LOG_I1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RUN_ID TABLE_NAME
GMA_MIGRATION_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MESSAGE_TYPE
GMA_MIGRATION_LOG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TABLE_NAME
GMA_MIGRATION_LOG_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTEXT

Columns

Name	Datatype	Length	Mandatory	Comments
TABLE_NAME	VARCHAR2	(80)		The name of the table the message is for
LINE_NO	NUMBER			Line number that caused the error
RUN_ID	NUMBER		Yes	ID to track each run of migration scripts
MESSAGE_TOKEN	VARCHAR2	(80)	Yes	Message being entered
MESSAGE_TYPE	VARCHAR2	(2)	Yes	Either I, E, D, P
PARAM1	VARCHAR2	(2000)		OPTIONAL PARAM1
PARAM2	VARCHAR2	(2000)		OPTIONAL PARAM2
PARAM3	VARCHAR2	(2000)		OPTIONAL PARAM3
PARAM4	VARCHAR2	(2000)		OPTIONAL PARAM4
PARAM5	VARCHAR2	(2000)		OPTIONAL PARAM5
DB_ERROR	VARCHAR2	(2000)		TRACK DB ERROR
POSITION	NUMBER			Position in function where the error occurred
TIMESTAMP	DATE			Time of table entry
BASE_MESSAGE	VARCHAR2	(2000)		Message for the programmer to bypass fnd_message reference
MSG_APP_SHORT_NAME	VARCHAR2	(3)		Application short name for the message text
CONTEXT	VARCHAR2	(80)		Migration context in which the message was logged
TOKEN1	VARCHAR2	(80)		Token for substituting values in the message
TOKEN2	VARCHAR2	(80)		Token for substituting values in the message
TOKEN3	VARCHAR2	(80)		Token for substituting values in
TOKEN4	VARCHAR2	(80)		Token for substituting values in
TOKEN5	VARCHAR2	(80)		Token for substituting values in
TOKEN6	VARCHAR2	(80)		Token for substituting values in
PARAM6	VARCHAR2	(2000)		Value to substitute for token6

Query Text

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


SELECT TABLE_NAME
,      LINE_NO
,      RUN_ID
,      MESSAGE_TOKEN
,      MESSAGE_TYPE
,      PARAM1
,      PARAM2
,      PARAM3
,      PARAM4
,      PARAM5
,      DB_ERROR
,      POSITION
,      TIMESTAMP
,      BASE_MESSAGE
,      MSG_APP_SHORT_NAME
,      CONTEXT
,      TOKEN1
,      TOKEN2
,      TOKEN3
,      TOKEN4
,      TOKEN5
,      TOKEN6
,      PARAM6
FROM GMA.GMA_MIGRATION_LOG;

Dependencies

[top of page]

GMA.GMA_MIGRATION_LOG does not reference any database object

GMA.GMA_MIGRATION_LOG is referenced by following:

APPS: GMA_MIGRATION_LOG