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_INSTALL_PROCESSES

Object Details

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

AD_INSTALL_PROCESSES holds information about the jobs assigned to each worker for all the parallely (concurrently) running sessions . This table is used for communication between the manager and the worker.The managerof a session (identified by session_id) loads the job information in this table and the workers belonging to that session (identified by session_id) reads the job information and executes it.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_INSTALL_PROCESSES_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	SESSION_ID WORKER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Foreign Key to AD_SESSIONS.SESSION_ID
OS_PROCESS_ID	NUMBER		Yes	OS Process Id
OS_USER_NAME	VARCHAR2	(30)	Yes	OS User Name
WORKER_ID	NUMBER		Yes	AD Worker ID
INSTALL_GROUP_NUM	NUMBER		Yes	INSTALL_GROUP_NUMBER
PDI_USERNAME	VARCHAR2	(32)	Yes	PDI_USERNAME
STATUS	VARCHAR2	(1)	Yes	Worker Status
CONTROL_CODE	VARCHAR2	(1)	Yes	Worker Control Code
PDI_PRODUCT	VARCHAR2	(10)	Yes	Product Executing Command
PHASE	NUMBER		Yes	Phase
FILE_PRODUCT	VARCHAR2	(10)	Yes	File Product Owner
CONTEXT	VARCHAR2	(256)	Yes	CONTEXT
COMMAND	VARCHAR2	(30)	Yes	Action Code
SUBDIRECTORY	VARCHAR2	(256)	Yes	Directory Containing File Being Executed
FILENAME	VARCHAR2	(256)	Yes	Name of File Being Executed
ARGUMENTS	VARCHAR2	(1996)		Arguments Passed to File
PHASE_NAME	VARCHAR2	(30)		Phase Name
ELAPSED_TIME	NUMBER			Run Time Including Restarts
START_TIME	DATE			Start Time of Job
END_TIME	DATE			Completion Time of Job
RESTART_TIME	DATE			Time Job Restarted
RESTART_COUNT	NUMBER			Number of Times Job Restarted
SKIP_FLAG	VARCHAR2	(1)		Flag if Job Skipped
SYMBOLIC_ARGUMENTS	VARCHAR2	(1996)		SYMBOLIC_ARGUMENTS
DEFER_COUNT	NUMBER			Number of times the job is deferred

Query Text

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


SELECT SESSION_ID
,      OS_PROCESS_ID
,      OS_USER_NAME
,      WORKER_ID
,      INSTALL_GROUP_NUM
,      PDI_USERNAME
,      STATUS
,      CONTROL_CODE
,      PDI_PRODUCT
,      PHASE
,      FILE_PRODUCT
,      CONTEXT
,      COMMAND
,      SUBDIRECTORY
,      FILENAME
,      ARGUMENTS
,      PHASE_NAME
,      ELAPSED_TIME
,      START_TIME
,      END_TIME
,      RESTART_TIME
,      RESTART_COUNT
,      SKIP_FLAG
,      SYMBOLIC_ARGUMENTS
,      DEFER_COUNT
FROM APPLSYS.AD_INSTALL_PROCESSES;

Dependencies

[top of page]

APPLSYS.AD_INSTALL_PROCESSES does not reference any database object

APPLSYS.AD_INSTALL_PROCESSES is referenced by following:

APPLSYS: AD_INSTALL_PROCESSES#