[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_CONCURRENT_REQUESTS |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: |  FND.FND_CONCURRENT_REQUESTS
|
| Subobject Name: | |
| Status: | VALID |
FND_CONCURRENT_REQUESTS stores information about individual
concurrent requests. Each row includes values that identify the
particular request and its parameters, such as who submitted it,
the request type, whether the request should run sequentially with
other requests in the same logical database (SINGLE_THREAD_FLAG),
whether the request is on hold (HOLD_FLAG), whether to display
the request in the View Requests form for the request submitter to
review, and what status and phase the concurrent request is in.
Each row also includes values that identify the concurrent program,
its execution and argument methods, and whether the program is
constrained (QUEUE_METHOD_CODE). Each row also includes flags that
indicate the
request's priority relative to other requests, as well as values
that specify how the concurrent manager should print program
output, if any. ARGUMENT1 through ARGUMENT25 contain any arguments
the application passes to the concurrent program. If the
concurrent program needs more than 25 arguments to run, the first
25 arguments are stored in this table, ARGUMENT26 through
ARGUMENT100 are stored in FND_CONC_REQUEST_ARGUMENTS. ARGUMENT_TEXT
contains the concatenation of concurrent request arguments
and COMPLETION_TEXT contains a
message about how the request completed. The row also contains
dates that the request was submitted, requested to start and
actually run. REQ_INFORMATION is used with report sets to remember
the status of the request between runs.
When the request is set to use automatic resubmission, RESUBMITTED
is a flag to indicate whether the request has been resubmitted or
not. RESUBMIT_INTERVAL_TYPE_CODE specifies whether to start interval
count down from the requested start time or the completion of the
request. RESUBMIT_INTERVAL_UNIT_CODE indicates whether interval
unit is in Days, Hours, Minutes, or Months. RESUBMIT_TIME sets the
time of the day to rerun the concurrent request. RESUBMIT_INTERVAL
indicates the number of units of time when the identical request
will be resubmitted. RESUBMIT_END_DATE is the date the request
stops resubmitting itself. IS_SUB_REQUEST is a flag that
identifies a child request and HAS_SUB_REQUEST is a flag that
identifies a parent request. Each child request also needs to have
values in PARENT_REQUEST_ID to show what parent request submitted
the child request and PRIORITY_REQUEST_ID to tell what priority the
parent request has and what priority the child request should have.
Oracle Application Object Library does not use ENFORCE_SERIALITY_FLAG
(always Y), CPU_SECONDS, LOGICAL_IOS, or PHYSICAL_IOS. You need one
row for each concurrent request. Though you should occasionally
delete from this table, you should not modify any of its data.
Oracle Application Object Library uses this information to run
concurrent requests, and automatically updates it as requests change
their status.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 20 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FND_CONCURRENT_REQUESTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REQUEST_ID
|
| FND_CONCURRENT_REQUESTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUESTED_BY
ACTUAL_COMPLETION_DATE
|
| FND_CONCURRENT_REQUESTS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CD_ID
|
| FND_CONCURRENT_REQUESTS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_DATE
|
| FND_CONCURRENT_REQUESTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STATUS_CODE
PROGRAM_APPLICATION_ID
CONCURRENT_PROGRAM_ID
|
| FND_CONCURRENT_REQUESTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_REQUEST_ID
|
| FND_CONCURRENT_REQUESTS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRIORITY_REQUEST_ID
|
| FND_CONCURRENT_REQUESTS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DESCRIPTION
|
| FND_CONCURRENT_REQUESTS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONCURRENT_PROGRAM_ID
PROGRAM_APPLICATION_ID
|
| FND_CONCURRENT_REQUESTS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PHASE_CODE
STATUS_CODE
|
| FND_CONCURRENT_REQUESTS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESPONSIBILITY_APPLICATION_ID
RESPONSIBILITY_ID
|
| FND_CONCURRENT_REQUESTS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OPS_INSTANCE
STATUS_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | (15) | Yes | Concurrent request identifier |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| REQUEST_DATE | DATE | Yes | Concurrent request submission date | |
| REQUESTED_BY | NUMBER | (15) | Yes | Username of the requestor |
| PHASE_CODE | VARCHAR2 | (1) | Yes | Code to indicate in what phase the concurrent request is |
| STATUS_CODE | VARCHAR2 | (1) | Yes | The current status of the concurrent request |
| PRIORITY_REQUEST_ID | NUMBER | (15) | Yes | Request identifier of the oldest ancestor or parent request |
| PRIORITY | NUMBER | (15) | Yes | Priority of the concurrent request |
| REQUESTED_START_DATE | DATE | Yes | The date and time when users want the request to start running | |
| HOLD_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if concurrent request is on hold |
| ENFORCE_SERIALITY_FLAG | VARCHAR2 | (1) | Yes | Not currently used |
| SINGLE_THREAD_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether to run the request sequentially with other requests in the same logical database |
| HAS_SUB_REQUEST | VARCHAR2 | (1) | Yes | Flag to identify the current request as a parent request |
| IS_SUB_REQUEST | VARCHAR2 | (1) | Yes | Flag to identify the request as a child request |
| IMPLICIT_CODE | VARCHAR2 | (1) | Yes | Code to specify whether the request appears in the View Request form for the request submitter |
| UPDATE_PROTECTED | VARCHAR2 | (1) | Yes | Flag to indicate if requestor is allowed to delete the request or update any of the request's attributes |
| QUEUE_METHOD_CODE | VARCHAR2 | (1) | Yes | Code to indicate if concurrent program is constrained |
| ARGUMENT_INPUT_METHOD_CODE | VARCHAR2 | (1) | Yes | Flag to indicate if the request uses token as argument input method |
| ORACLE_ID | NUMBER | (15) | Yes | The ORACLE account used to run the concurrent request |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Yes | Identifier of application with which that concurrent program is registered |
| CONCURRENT_PROGRAM_ID | NUMBER | (15) | Yes | Concurrent program identifier |
| RESPONSIBILITY_APPLICATION_ID | NUMBER | (15) | Yes | Identifier of the application with which the responsibility is defined |
| RESPONSIBILITY_ID | NUMBER | (15) | Yes | Responsibility identifier |
| NUMBER_OF_ARGUMENTS | NUMBER | (3) | Yes | Number of arguments |
| NUMBER_OF_COPIES | NUMBER | (15) | Yes | Number of copies to print |
| SAVE_OUTPUT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether to save output to a file |
| NLS_COMPLIANT | VARCHAR2 | (1) | Yes | Indicates if program is NLS compliant |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| NLS_LANGUAGE | VARCHAR2 | (30) | Language | |
| NLS_TERRITORY | VARCHAR2 | (30) | The territory using the language | |
| PRINTER | VARCHAR2 | (30) | Name of printer to print output | |
| PRINT_STYLE | VARCHAR2 | (30) | Output print style | |
| PRINT_GROUP | VARCHAR2 | (1) | Flag to indicate whether to print the request output together with other reports or programs in the report set | |
| REQUEST_CLASS_APPLICATION_ID | NUMBER | (15) | Identifier of application with which request type is defined | |
| CONCURRENT_REQUEST_CLASS_ID | NUMBER | (15) | Request type identifier | |
| PARENT_REQUEST_ID | NUMBER | (15) | Request identifier of the request that submits this request | |
| CONC_LOGIN_ID | NUMBER | (15) | Login session identifier | |
| LANGUAGE_ID | NUMBER | (15) | Language identifier | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| REQ_INFORMATION | VARCHAR2 | (240) | Miscellaneous information for the request to be used with the parent request of a report set | |
| RESUBMIT_INTERVAL | NUMBER | (15) | The number of units to resubmit a request | |
| RESUBMIT_INTERVAL_UNIT_CODE | VARCHAR2 | (30) | Code to indicate whether resubmit interval unit is in Days, Hours, Minutes, or Months | |
| RESUBMIT_INTERVAL_TYPE_CODE | VARCHAR2 | (30) | Code indicating whether to start interval count down from the requested start time or the completion of the request | |
| RESUBMIT_TIME | VARCHAR2 | (8) | The time of the day to regularly resubmit the request | |
| RESUBMIT_END_DATE | DATE | The end date for resubmitting the request | ||
| RESUBMITTED | VARCHAR2 | (1) | Flag to indicate whether the request has been resubmitted | |
| CONTROLLING_MANAGER | NUMBER | (15) | Identifier of concurrent manager that processed this request | |
| ACTUAL_START_DATE | DATE | The actual time and date when the request started running | ||
| ACTUAL_COMPLETION_DATE | DATE | The time and date when the request was completed | ||
| COMPLETION_TEXT | VARCHAR2 | (240) | The text message about how the request completed | |
| OUTCOME_PRODUCT | VARCHAR2 | (20) | Not currently used | |
| OUTCOME_CODE | NUMBER | (15) | Not currently used | |
| CPU_SECONDS | NUMBER | (15) | Not currently used | |
| LOGICAL_IOS | NUMBER | (15) | Not currently used | |
| PHYSICAL_IOS | NUMBER | (15) | Not currently used | |
| LOGFILE_NAME | VARCHAR2 | (255) | Logfile name | |
| LOGFILE_NODE_NAME | VARCHAR2 | (30) | The name of node or machine on which to create the log file | |
| OUTFILE_NAME | VARCHAR2 | (255) | Name of output file | |
| OUTFILE_NODE_NAME | VARCHAR2 | (30) | The name of node or machine on which to create the output file | |
| ARGUMENT_TEXT | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT1 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT2 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT3 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT4 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT5 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT6 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT7 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT8 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT9 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT10 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT11 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT12 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT13 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT14 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT15 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT16 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT17 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT18 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT19 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT20 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT21 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT22 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT23 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT24 | VARCHAR2 | (240) | Concurrent Request Argument | |
| ARGUMENT25 | VARCHAR2 | (240) | Concurrent Request Argument | |
| CRM_THRSHLD | NUMBER | (15) | Used internally by the conflict resolution manager | |
| CRM_TSTMP | DATE | Used internally by the conflict resolution manager | ||
| CRITICAL | VARCHAR2 | (1) | Is this a critical storage | |
| REQUEST_TYPE | VARCHAR2 | (1) | Specialization type | |
| ORACLE_PROCESS_ID | VARCHAR2 | (30) | Database process identifier | |
| ORACLE_SESSION_ID | NUMBER | (15) | Database session identifier | |
| OS_PROCESS_ID | VARCHAR2 | (240) | Operating system process identifier | |
| PRINT_JOB_ID | VARCHAR2 | (240) | Reserved for future use | |
| OUTPUT_FILE_TYPE | VARCHAR2 | (4) | Format of output file | |
| RELEASE_CLASS_APP_ID | NUMBER | Application identifier of the schedule | ||
| RELEASE_CLASS_ID | NUMBER | Schedule identifier | ||
| STALE_DATE | DATE | Used for advanced schedules | ||
| CANCEL_OR_HOLD | VARCHAR2 | (1) | Used for advanced schedules | |
| NOTIFY_ON_PP_ERROR | VARCHAR2 | (255) | User to notify if post processing steps fail | |
| CD_ID | NUMBER | Conflict domain identifier | ||
| REQUEST_LIMIT | VARCHAR2 | (1) | Indicates maximum number of requests a user may submit at one time | |
| CRM_RELEASE_DATE | DATE | Date at which conflicts were resolved | ||
| POST_REQUEST_STATUS | VARCHAR2 | (1) | Reserved for future use | |
| COMPLETION_CODE | VARCHAR2 | (30) | Indicates the completion status of the request, such as success | |
| INCREMENT_DATES | VARCHAR2 | (1) | Flag to increment date parameters on resubmission | |
| RESTART | VARCHAR2 | (1) | Indicates program may be restarted | |
| ENABLE_TRACE | VARCHAR2 | (1) | Turns on tracing for requests | |
| RESUB_COUNT | NUMBER | Resubmission count (for repeating requests) | ||
| NLS_CODESET | VARCHAR2 | (30) | Character set | |
| OFILE_SIZE | NUMBER | (15) | Filesize of request out in bytes | |
| LFILE_SIZE | NUMBER | (15) | Filesize of request log in bytes | |
| STALE | VARCHAR2 | (1) | Used with Scheduler to indicate requests that could not be run within the specified/required period | |
| SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
| RESOURCE_CONSUMER_GROUP | VARCHAR2 | (30) | Database Resource Manager group under which this request should be processed/run | |
| EXP_DATE | DATE | Expiration date for request | ||
| QUEUE_APP_ID | NUMBER | (15) | Not currently used (To associate request with a specific manager) | |
| QUEUE_ID | NUMBER | (15) | Not currently used (To associate request with a specific manager) | |
| OPS_INSTANCE | NUMBER | (15) | Yes | Oracle Parallel System instance identifier |
| INTERIM_STATUS_CODE | VARCHAR2 | (1) | Developer set status code for Java Concurrent Programs | |
| ROOT_REQUEST_ID | NUMBER | (15) | Root request id for a repeating requests | |
| ORIGIN | VARCHAR2 | (1) | Reserved for future use | |
| NLS_NUMERIC_CHARACTERS | VARCHAR2 | (2) | NLS Numeric character used for this request | |
| PP_START_DATE | DATE | Post Processing action start time | ||
| PP_END_DATE | DATE | Post Processing action end time | ||
| ORG_ID | NUMBER | (15) | ORG_ID | |
| RUN_NUMBER | NUMBER | (5) | number to identify how may times it is running | |
| NODE_NAME1 | VARCHAR2 | (30) | Primary target node for request | |
| NODE_NAME2 | VARCHAR2 | (30) | Secondary target node for request | |
| CONNSTR1 | VARCHAR2 | (255) | Primary connection string for request | |
| CONNSTR2 | VARCHAR2 | (255) | Secondary connection string for request | |
| EDITION_NAME | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_DATE
, REQUESTED_BY
, PHASE_CODE
, STATUS_CODE
, PRIORITY_REQUEST_ID
, PRIORITY
, REQUESTED_START_DATE
, HOLD_FLAG
, ENFORCE_SERIALITY_FLAG
, SINGLE_THREAD_FLAG
, HAS_SUB_REQUEST
, IS_SUB_REQUEST
, IMPLICIT_CODE
, UPDATE_PROTECTED
, QUEUE_METHOD_CODE
, ARGUMENT_INPUT_METHOD_CODE
, ORACLE_ID
, PROGRAM_APPLICATION_ID
, CONCURRENT_PROGRAM_ID
, RESPONSIBILITY_APPLICATION_ID
, RESPONSIBILITY_ID
, NUMBER_OF_ARGUMENTS
, NUMBER_OF_COPIES
, SAVE_OUTPUT_FLAG
, NLS_COMPLIANT
, LAST_UPDATE_LOGIN
, NLS_LANGUAGE
, NLS_TERRITORY
, PRINTER
, PRINT_STYLE
, PRINT_GROUP
, REQUEST_CLASS_APPLICATION_ID
, CONCURRENT_REQUEST_CLASS_ID
, PARENT_REQUEST_ID
, CONC_LOGIN_ID
, LANGUAGE_ID
, DESCRIPTION
, REQ_INFORMATION
, RESUBMIT_INTERVAL
, RESUBMIT_INTERVAL_UNIT_CODE
, RESUBMIT_INTERVAL_TYPE_CODE
, RESUBMIT_TIME
, RESUBMIT_END_DATE
, RESUBMITTED
, CONTROLLING_MANAGER
, ACTUAL_START_DATE
, ACTUAL_COMPLETION_DATE
, COMPLETION_TEXT
, OUTCOME_PRODUCT
, OUTCOME_CODE
, CPU_SECONDS
, LOGICAL_IOS
, PHYSICAL_IOS
, LOGFILE_NAME
, LOGFILE_NODE_NAME
, OUTFILE_NAME
, OUTFILE_NODE_NAME
, ARGUMENT_TEXT
, ARGUMENT1
, ARGUMENT2
, ARGUMENT3
, ARGUMENT4
, ARGUMENT5
, ARGUMENT6
, ARGUMENT7
, ARGUMENT8
, ARGUMENT9
, ARGUMENT10
, ARGUMENT11
, ARGUMENT12
, ARGUMENT13
, ARGUMENT14
, ARGUMENT15
, ARGUMENT16
, ARGUMENT17
, ARGUMENT18
, ARGUMENT19
, ARGUMENT20
, ARGUMENT21
, ARGUMENT22
, ARGUMENT23
, ARGUMENT24
, ARGUMENT25
, CRM_THRSHLD
, CRM_TSTMP
, CRITICAL
, REQUEST_TYPE
, ORACLE_PROCESS_ID
, ORACLE_SESSION_ID
, OS_PROCESS_ID
, PRINT_JOB_ID
, OUTPUT_FILE_TYPE
, RELEASE_CLASS_APP_ID
, RELEASE_CLASS_ID
, STALE_DATE
, CANCEL_OR_HOLD
, NOTIFY_ON_PP_ERROR
, CD_ID
, REQUEST_LIMIT
, CRM_RELEASE_DATE
, POST_REQUEST_STATUS
, COMPLETION_CODE
, INCREMENT_DATES
, RESTART
, ENABLE_TRACE
, RESUB_COUNT
, NLS_CODESET
, OFILE_SIZE
, LFILE_SIZE
, STALE
, SECURITY_GROUP_ID
, RESOURCE_CONSUMER_GROUP
, EXP_DATE
, QUEUE_APP_ID
, QUEUE_ID
, OPS_INSTANCE
, INTERIM_STATUS_CODE
, ROOT_REQUEST_ID
, ORIGIN
, NLS_NUMERIC_CHARACTERS
, PP_START_DATE
, PP_END_DATE
, ORG_ID
, RUN_NUMBER
, NODE_NAME1
, NODE_NAME2
, CONNSTR1
, CONNSTR2
, EDITION_NAME
FROM APPLSYS.FND_CONCURRENT_REQUESTS;
APPLSYS.FND_CONCURRENT_REQUESTS does not reference any database object
APPLSYS.FND_CONCURRENT_REQUESTS is referenced by following:
APPLSYS
FND_CONCURRENT_REQUESTS#
|
|
|
|