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_SESSIONS_HISTORY

Object Details

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

Stores information on all AD sessions for an Applications System. After an AD_UTILTY session which is running concurrently has completed successfully the rows belonging to that session are copied from AD_SESSIONS table to this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SESSION_ID	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SESSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Primary Key
UTILITY_NAME	VARCHAR2	(8)	Yes	Name of AD Utility
APPL_TOP_PATH	VARCHAR2	(256)	Yes	APPL_TOP Path
INVOKDIR	VARCHAR2	(256)	Yes	Directory AD Utility was invoked from
STATUS	VARCHAR2	(30)	Yes	Active or Inactive
PRIORITY	NUMBER		Yes	Priority of Session
START_DATE	DATE		Yes	Time AD Utility was Started
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
END_DATE	DATE		Yes	Time session completed
COMPLETION_STATUS	VARCHAR2	(30)	Yes	Completion status. Valid values are ABANDONED and COMPLETED
RUN_ON_NODE	VARCHAR2	(30)	Yes	Node (machine) on which this session ran
CONTEXT_INFO	VARCHAR2	(256)		Information related to the AD Utility being executed
ANY_CHANGE_WHILE_INACTIVE_FLAG	VARCHAR2	(1)		Resources Needed by this session have changed while session was inactive
JS_TOTAL_JOBS	NUMBER			Total number of jobs in Job System
JS_COMPLETED_JOBS	NUMBER			Number of Completed Jobs
JS_REMAINING_JOBS	NUMBER			Number of Jobs Remaining in Job System
LOCKS_OVERRIDDEN_BY	NUMBER			Stores the session Id of the first session that updated the column ANY_CHANGE_WHILE_INACTIVE_FLAG to Y.
TOPDIR	VARCHAR2	(256)	Yes	Stores the directory location of the logs.

Query Text

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


SELECT SESSION_ID
,      UTILITY_NAME
,      APPL_TOP_PATH
,      INVOKDIR
,      STATUS
,      PRIORITY
,      START_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      END_DATE
,      COMPLETION_STATUS
,      RUN_ON_NODE
,      CONTEXT_INFO
,      ANY_CHANGE_WHILE_INACTIVE_FLAG
,      JS_TOTAL_JOBS
,      JS_COMPLETED_JOBS
,      JS_REMAINING_JOBS
,      LOCKS_OVERRIDDEN_BY
,      TOPDIR
FROM APPLSYS.AD_SESSIONS_HISTORY;

Dependencies

[top of page]

APPLSYS.AD_SESSIONS_HISTORY does not reference any database object

APPLSYS.AD_SESSIONS_HISTORY is referenced by following:

APPLSYS: AD_SESSIONS_HISTORY#