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

Object Details

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

History of timing information of jobs run in parallel

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_PROGRAM_RUN_TASK_JOBS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_STATUS_ID PROGRAM_RUN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_RUN_ID	NUMBER		Yes	A number that distinguishes the different runs of ad utilities, when the information is moved from in progress to history.
SESSION_ID	NUMBER		Yes	Session ID for the AD program run which ran this parallel job.
TASK_STATUS_ID	NUMBER		Yes	Id of the task to which this job corresponds. It is a foreign key to AD_PROGRAM_RUN_TASKS
JOB_NAME	VARCHAR2	(60)	Yes	Name of the file associated with this job
PRODUCT	VARCHAR2	(30)	Yes	Product that owns the file associated with this job
CURRENT_FLAG	VARCHAR2	(1)	Yes	Y for currently-running jobs; N for completed or skipped jobs
WORKER_ID	NUMBER		Yes	The worker ID for the parallel worker that ran this job
INSTALL_GROUP_NUM	NUMBER		Yes	The Installation Group Number for this job; 0 for SOA product jobs -- 1 for MOA product jobs
PROGRAM	VARCHAR2	(30)	Yes	The name of the AD program that ran this job
PHASE	NUMBER		Yes	The numeric phase for this job
ARGUMENTS	VARCHAR2	(1996)		The comand-line arguments for this job
PHASE_NAME	VARCHAR2	(30)		User-friendly name of the phase for this job
START_TIME	DATE			Time when job started
RESTART_TIME	DATE			Time when job (last) restarted
END_TIME	DATE			Time when job completed
ELAPSED_TIME	NUMBER			Total run time for the job
RESTART_COUNT	NUMBER			Number of times job failed and was restarted
SUBDIRECTORY	VARCHAR2	(256)		Subdirectory where the acted-upon file resides
COMMAND	VARCHAR2	(30)		Command code ("bin" for executables, "package" for packages, etc)
DEFER_COUNT	NUMBER			Number of times this job was deferred (after a failure)
TASK_NUMBER	NUMBER			Task number. See table description for details
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.

Query Text

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


SELECT PROGRAM_RUN_ID
,      SESSION_ID
,      TASK_STATUS_ID
,      JOB_NAME
,      PRODUCT
,      CURRENT_FLAG
,      WORKER_ID
,      INSTALL_GROUP_NUM
,      PROGRAM
,      PHASE
,      ARGUMENTS
,      PHASE_NAME
,      START_TIME
,      RESTART_TIME
,      END_TIME
,      ELAPSED_TIME
,      RESTART_COUNT
,      SUBDIRECTORY
,      COMMAND
,      DEFER_COUNT
,      TASK_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPLSYS.AD_PROGRAM_RUN_TASK_JOBS;

Dependencies

[top of page]

APPLSYS.AD_PROGRAM_RUN_TASK_JOBS does not reference any database object

APPLSYS.AD_PROGRAM_RUN_TASK_JOBS is referenced by following:

APPLSYS: AD_PROGRAM_RUN_TASK_JOBS#