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_CTL

Object Details

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

The control table for the OPM GL Update Process. This is 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_CTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GUPROC_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GUPROC_ID	NUMBER	(10)	Yes	OPM GL Update process reference number. Is also the surrogate for the row
CO_CODE	VARCHAR2	(4)	Yes	Company for which the process is run
OF_SOB_ID	NUMBER	(15)	Yes	Oracle GL Sets of Books Identifier
FISCAL_YEAR	NUMBER	(5)	Yes	GL Fiscal Year
PERIOD	NUMBER	(5)	Yes	GL Period
PERIOD_START_DATE	DATE		Yes	Period Start Date
PERIOD_END_DATE	DATE		Yes	Period End Date
ALL_SOURCE	VARCHAR2	(2)		Indicates if the Process is to be run for all OPM Subsystem Sources
ONE_SOURCE	VARCHAR2	(4)		Indicates the single Subsystem for which the process needs to be run
FROM_SOURCE	VARCHAR2	(4)		Specifies the from range of Subsystem when a range is specified
TO_SOURCE	VARCHAR2	(4)		Specifies the to range when a Subsystem range is specified
ALL_EVENT	VARCHAR2	(2)		Set when process is to be run for All Events
ONE_EVENT	VARCHAR2	(4)		Indicates the single event for which the process is to be run
FROM_EVENT	VARCHAR2	(4)		Specifies the from range when event range is specified
TO_EVENT	VARCHAR2	(4)		Specifies the to range when an event range is specified
ALL_SUB_EVENT	VARCHAR2	(2)		Indicates if the process is to be run for all Sub-events
ONE_SUB_EVENT	VARCHAR2	(4)		Indicates the single sub-event for which the process is run
FROM_SUB_EVENT	VARCHAR2	(4)		Specifies the from range when a sub-event range is specified.
TO_SUB_EVENT	VARCHAR2	(4)		Specifies the to range when a sub-event range is specified
OF_USER_ID	NUMBER	(15)	Yes	The User identifier of the OPM User.
RUNNING_IND	NUMBER	(5)	Yes	Indicates if the process is currently running or not. 0 = Not yet started; 1 = running; 2 = completed
SCHEDULED_ON	VARCHAR2	(32)	Yes	Date and time process is scheduled
STARTED_BY	NUMBER	(15)	Yes	User who started the process
STARTED_ON	DATE			Date and time when process starts
ENDED_ON	DATE			Date and time when process ends
ERRORS_FOUND	NUMBER	(10)		Number of errors found. Includes duplicates.
ERRORS_POSTED	NUMBER	(10)		Number of unique errors posted to error messages table (GL_UPDT_MSG)
ROWS_POSTED	NUMBER	(10)		Number of rows successfully posted to Oracle GL Interface
ABORT_IND	NUMBER	(5)		Indicates if process has to be aborted: 0 - Continue processing; 1 - Abort the process
ABORT_BY	NUMBER	(15)		User who aborted the process
ABORT_REASON	VARCHAR2	(70)		Reason for aborting the process
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
IN_USE	NUMBER	(5)		Not currently used
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
,      CO_CODE
,      OF_SOB_ID
,      FISCAL_YEAR
,      PERIOD
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      ALL_SOURCE
,      ONE_SOURCE
,      FROM_SOURCE
,      TO_SOURCE
,      ALL_EVENT
,      ONE_EVENT
,      FROM_EVENT
,      TO_EVENT
,      ALL_SUB_EVENT
,      ONE_SUB_EVENT
,      FROM_SUB_EVENT
,      TO_SUB_EVENT
,      OF_USER_ID
,      RUNNING_IND
,      SCHEDULED_ON
,      STARTED_BY
,      STARTED_ON
,      ENDED_ON
,      ERRORS_FOUND
,      ERRORS_POSTED
,      ROWS_POSTED
,      ABORT_IND
,      ABORT_BY
,      ABORT_REASON
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      IN_USE
,      DELETE_MARK
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM GMF.GL_UPDT_CTL;

Dependencies

[top of page]

GMF.GL_UPDT_CTL does not reference any database object

GMF.GL_UPDT_CTL is referenced by following:

GMF: GL_UPDT_CTL#