[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_CONC_PROG_ONSITE_INFO_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROGRAM_APPLICATION_ID
CONCURRENT_PROGRAM_ID |
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 |
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;
APPLSYS.FND_CONC_PROG_ONSITE_INFO does not reference any database object
APPLSYS.FND_CONC_PROG_ONSITE_INFO is referenced by following:
|
|
|