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_CONCURRENT_PROCESSES

Object Details

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

FND_CONCURRENT_PROCESSES stores information about concurrent
managers. Each row includes values that identify the ORACLE
process, the operating system process, and the concurrent
manager (QUEUE_APPLICATION_ID and CONCURRENT_QUEUE_ID).
You need one row for each instance of a running concurrent manager
(each process), as well as one row for the Internal Concurrent
Manager. Oracle Application Object Library uses this
table to keep a history of concurrent managers. You
should never update this table manually.
.
You can use the Purge Concurrent Request and/or Managers Data
program to delete history information periodically.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_CONCURRENT_PROCESSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONCURRENT_PROCESS_ID
FND_CONCURRENT_PROCESSES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUEUE_APPLICATION_ID CONCURRENT_QUEUE_ID PROCESS_STATUS_CODE
FND_CONCURRENT_PROCESSES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROCESS_STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CONCURRENT_PROCESS_ID	NUMBER	(15)	Yes	Concurrent process identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
QUEUE_APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
CONCURRENT_QUEUE_ID	NUMBER	(15)	Yes	Concurrent manager queue identifier
PROCESS_STATUS_CODE	VARCHAR2	(1)	Yes	Code to reflect the status of the process
SESSION_ID	NUMBER	(15)	Yes	Database session identifier
ORACLE_PROCESS_ID	NUMBER	(15)	Yes	Database process identifier
PROCESS_START_DATE	DATE		Yes	The date when the process starts running
OS_PROCESS_NAME	VARCHAR2	(240)		Not currently used
OS_PROCESS_ID	VARCHAR2	(240)		Operating system process identifier
MANAGER_TYPE	NUMBER	(15)		MANAGER_TYPE - Code that indicates the concurrent manager service type (0 - Internal Concurrent Manager; 1 - Concurrent managers; 2 - Transaction Manager; 3 - Internal Monitor; 4 - Conflict Resolution Manager; 5 - Scheduler)
NODE_NAME	VARCHAR2	(30)		Machine name
DB_NAME	VARCHAR2	(8)		Local database name
DB_DOMAIN	VARCHAR2	(120)		Logical location of the database
SQLNET_STRING	VARCHAR2	(255)		Not currently used
LOGFILE_NAME	VARCHAR2	(240)		Name of log file
JOB_ID	VARCHAR2	(240)		Uniquely identifies processes across nodes to control termination of a request and/or manager process on some platforms which make use of load balancing features provided by the hardware vendor for clusters
DB_INSTANCE	VARCHAR2	(16)		Used with parallel concurrent processing in an Oracle Parallel Server environment to identify (check the availability/status of) an instance of Database.
LK_HANDLE	VARCHAR2	(128)		For internal use only
PLSQL_LOG	VARCHAR2	(240)		Contains temporary PLSQL log file information
PLSQL_OUT	VARCHAR2	(240)		Contains temporary PLSQL out file information
LAST_TXN_START	DATE			Date last transaction ended
LAST_TXN_END	DATE			Date last transaction started
PLSQL_DIR	VARCHAR2	(255)		Directory for temporary log and out files
INSTANCE_NUMBER	NUMBER	(15)		OPS Instance number
PROCESS_CONTEXT	VARCHAR2	(2000)		Process Context buffer
SERVICE_PARAMETERS	VARCHAR2	(2000)		Service Parameters
GSM_INTERNAL_STATUS	VARCHAR2	(1)		gsm internal status
GSM_INTERNAL_INFO	VARCHAR2	(2000)		gsm internal status info

Query Text

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


SELECT CONCURRENT_PROCESS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      QUEUE_APPLICATION_ID
,      CONCURRENT_QUEUE_ID
,      PROCESS_STATUS_CODE
,      SESSION_ID
,      ORACLE_PROCESS_ID
,      PROCESS_START_DATE
,      OS_PROCESS_NAME
,      OS_PROCESS_ID
,      MANAGER_TYPE
,      NODE_NAME
,      DB_NAME
,      DB_DOMAIN
,      SQLNET_STRING
,      LOGFILE_NAME
,      JOB_ID
,      DB_INSTANCE
,      LK_HANDLE
,      PLSQL_LOG
,      PLSQL_OUT
,      LAST_TXN_START
,      LAST_TXN_END
,      PLSQL_DIR
,      INSTANCE_NUMBER
,      PROCESS_CONTEXT
,      SERVICE_PARAMETERS
,      GSM_INTERNAL_STATUS
,      GSM_INTERNAL_INFO
FROM APPLSYS.FND_CONCURRENT_PROCESSES;

Dependencies

[top of page]

APPLSYS.FND_CONCURRENT_PROCESSES does not reference any database object

APPLSYS.FND_CONCURRENT_PROCESSES is referenced by following:

APPS: FND_CONCURRENT_PROCESSES