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: APPLSYS.FND_OAM_GCS_JOBS

Object Details

Object Name:	FND_OAM_GCS_JOBS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_OAM_GCS_JOBS
Subobject Name:
Status:	VALID

Job details will be saved in this table.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000319289C00008$$	LOB	UNIQUE	APPS_TS_SEED

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_ID	NUMBER		Yes	Perl Script job ID
NODE_NAME	VARCHAR2	(80)	Yes	Node Name
PERL_SCRIPT_NAME	VARCHAR2	(80)	Yes	perl script name
GROUP_ID	NUMBER		Yes	GroupId which is a sequence generated.
USER_COMMENT	VARCHAR2	(240)		Description for this job
START_TIME	DATE			Time at which job started
END_TIME	DATE			Time at which job started
PARAMETERS	CLOB	(4000)		xml string contains parameters for the requests
PHASE	VARCHAR2	(1)		Phase of the job
STATUS	VARCHAR2	(1)		status of the job
LOG_FILE	VARCHAR2	(255)		log file name with full path
OUT_FILE	VARCHAR2	(255)		output file name with full path
REQUESTED_BY	NUMBER		Yes	Transaction requester user_id
LOGIN_ID	NUMBER		Yes	Login_id
RESPONSIBILITY_ID	NUMBER		Yes	Responsibility Id
RESP_APPLICATION_ID	NUMBER		Yes	Responsibility Application Id
SECURITY_GROUP_ID	NUMBER		Yes	Security Group Id
NLS_LANGUAGE	VARCHAR2	(30)		NLS language value
NLS_TERRITORY	VARCHAR2	(30)		NLS territory value
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
OPTIONS	VARCHAR2	(256)		Adding new column 'options'
TOKENS	VARCHAR2	(30)

Query Text

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


SELECT JOB_ID
,      NODE_NAME
,      PERL_SCRIPT_NAME
,      GROUP_ID
,      USER_COMMENT
,      START_TIME
,      END_TIME
,      PARAMETERS
,      PHASE
,      STATUS
,      LOG_FILE
,      OUT_FILE
,      REQUESTED_BY
,      LOGIN_ID
,      RESPONSIBILITY_ID
,      RESP_APPLICATION_ID
,      SECURITY_GROUP_ID
,      NLS_LANGUAGE
,      NLS_TERRITORY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OPTIONS
,      TOKENS
FROM APPLSYS.FND_OAM_GCS_JOBS;

Dependencies

[top of page]

APPLSYS.FND_OAM_GCS_JOBS does not reference any database object

APPLSYS.FND_OAM_GCS_JOBS is referenced by following:

APPS: FND_OAM_GCS_JOBS