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_CONC_PROG_ONSITE_INFO

Object Details

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

The Fnd_Conc_Prog_OnSite_Info table stores information about Concurrent Programs on site runtime information. Each row includes an identifier for Concurrent Program and when the program last run, requests outcome and its request id. Application Object Library uses this information to pro-actively inform System Administrator about some of the maintenance activities that are critical to Apps Performance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_CONC_PROG_ONSITE_INFO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROGRAM_APPLICATION_ID CONCURRENT_PROGRAM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_APPLICATION_ID	NUMBER		Yes	Concurrent Program Application Id
CONCURRENT_PROGRAM_ID	NUMBER		Yes	Concurrent Program Id
LAST_RUN_DATE	DATE			Date when this program was last run
LAST_RUN_REQUEST_ID	NUMBER			Request Id of the last run Request
OUTCOME	VARCHAR2	(1)		Status code of the request
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)	Yes	Standard Who Column
MONITOR_ENABLED	VARCHAR2	(1)		Enable Monitor critical activity in OAM or not
REQUEST_SCH_INTERVAL	NUMBER			System Admin set schedule repeat interval value in days.
SUCCESSFUL_COMPLETION	NUMBER			Number of completed with success requests from reset_date
WARNING_COMPLETION	NUMBER			Number of completed with warning requests from reset_date
ERROR_COMPLETION	NUMBER			Number of completed with error requests from reset_date
RESET_DATE	DATE			Date from which successful_completion,warning_completion error_completion counting started
MIN_RUN_TIME	NUMBER			Minimum amount of time in seconds it took to run request for this program.
MAX_RUN_TIME	NUMBER			Maximum amount of time in seconds it took to run request for this program.
AVG_RUN_TIME	NUMBER			Average time of Request run for this program.
ON_FAILURE_LOG_LEVEL	VARCHAR2	(30)		System Exception log level to log an event when a Request for this program completes with error status. Null value means does not log event.
SHELF_LIFE	NUMBER			Number of more days to retain the request
ALERT_LONG_RUNNING_ENABLED	VARCHAR2	(1)		Y/N flag to determine if program is selected for specific alerting for long running requests
ALERT_LONG_RUNNING_THRESHOLD	NUMBER			User specified threshold for the program run time in seconds
ALERT_LONG_RUNNING_TOLERANCE	NUMBER			User specified tolerance for the program run time (%)
ALERT_LONG_PENDING_ENABLED	VARCHAR2	(1)		Y/N flag to determine if program is selected for specific alerting for long pending requests
ALERT_LONG_PENDING_TOLERANCE	NUMBER			User specified tolerance for the program wait time in seconds
NODE_NAME1	VARCHAR2	(240)		Primary target node for program
NODE_NAME2	VARCHAR2	(30)		Secondary target node for program
CONNSTR1	VARCHAR2	(255)		Primary connection string for program
CONNSTR2	VARCHAR2	(255)		Secondary connection string for program
BUSINESS_EVENT_MAP	VARCHAR2	(50)		Business Event Map

Query Text

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


SELECT PROGRAM_APPLICATION_ID
,      CONCURRENT_PROGRAM_ID
,      LAST_RUN_DATE
,      LAST_RUN_REQUEST_ID
,      OUTCOME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      MONITOR_ENABLED
,      REQUEST_SCH_INTERVAL
,      SUCCESSFUL_COMPLETION
,      WARNING_COMPLETION
,      ERROR_COMPLETION
,      RESET_DATE
,      MIN_RUN_TIME
,      MAX_RUN_TIME
,      AVG_RUN_TIME
,      ON_FAILURE_LOG_LEVEL
,      SHELF_LIFE
,      ALERT_LONG_RUNNING_ENABLED
,      ALERT_LONG_RUNNING_THRESHOLD
,      ALERT_LONG_RUNNING_TOLERANCE
,      ALERT_LONG_PENDING_ENABLED
,      ALERT_LONG_PENDING_TOLERANCE
,      NODE_NAME1
,      NODE_NAME2
,      CONNSTR1
,      CONNSTR2
,      BUSINESS_EVENT_MAP
FROM APPLSYS.FND_CONC_PROG_ONSITE_INFO;

Dependencies

[top of page]

APPLSYS.FND_CONC_PROG_ONSITE_INFO does not reference any database object

APPLSYS.FND_CONC_PROG_ONSITE_INFO is referenced by following:

APPS: FND_CONC_PROG_ONSITE_INFO