[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_INSTALL_PROCESSES_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
SESSION_ID
WORKER_ID |
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 |
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;
APPLSYS.AD_INSTALL_PROCESSES does not reference any database object
APPLSYS.AD_INSTALL_PROCESSES is referenced by following:
|
|
|