[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_CONCURRENT_PROGRAMS |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: |  FND.FND_CONCURRENT_PROGRAMS
|
| Subobject Name: | |
| Status: | VALID |
FND_CONCURRENT_PROGRAMS stores information about concurrent
programs. Each row includes a name and description of the
concurrent program. Each row also includes the execution methods
for the program (EXECUTION_METHOD_CODE), the argument method
(ARGUMENT_METHOD_CODE), and whether the program is constrained
(QUEUE_METHOD_CODE). If the program is a special concurrent
program that controls the concurrent managers, QUEUE_CONTROL_FLAG
is set to Y. Each row also includes flags that indicate whether
the program is enabled and defined as run-alone, as well as values
that specify the print style the concurrent manager should use to
print program output, if any. There are also values that identify
the executable associated with the concurrent program and the
application with which the executable is defined, and flags that
specify whether the concurrent program is a parent of a report
set, whether to save the output file, and whether a print style is
required. Information such as printer name and number of rows and
columns on each page of the output
file for the concurrent program is also included in the table.
You need one row for each concurrent program in each application.
Oracle Application Object Library uses this information to run
concurrent programs.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 20 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FND_CONCURRENT_PROGRAMS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 APPLICATION_ID
CONCURRENT_PROGRAM_ID
|
| FND_CONCURRENT_PROGRAMS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
APPLICATION_ID
CONCURRENT_PROGRAM_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| APPLICATION_ID | NUMBER | (15) | Yes | Application identifier |
| CONCURRENT_PROGRAM_ID | NUMBER | (15) | Yes | Concurrent program identifier |
| CONCURRENT_PROGRAM_NAME | VARCHAR2 | (30) | Yes | Internal name of the concurrent program |
| 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 |
| EXECUTABLE_APPLICATION_ID | NUMBER | (15) | Yes | Identifier of the application with which the executable is registered |
| EXECUTABLE_ID | NUMBER | (15) | Yes | Concurrent program executable identifier |
| EXECUTION_METHOD_CODE | VARCHAR2 | (1) | Yes | Execution method for the concurrent program |
| ARGUMENT_METHOD_CODE | VARCHAR2 | (1) | Yes | Code to indicate how program arguments are passed to the concurrent program |
| QUEUE_CONTROL_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the concurrent program controls concurrent managers |
| QUEUE_METHOD_CODE | VARCHAR2 | (1) | Yes | Code to indicate whether the concurrent program is constrained |
| REQUEST_SET_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the concurrent program is a parent of a report set |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | Enabled flag |
| PRINT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the concurrent manager should print output of the concurrent program |
| RUN_ALONE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this is a run alone concurrent program |
| SRS_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if a request can be submitted for this concurrent program from Standard Report Submission |
| CLASS_APPLICATION_ID | NUMBER | (15) | Identifier of application for with which the request type of this program is identified | |
| CONCURRENT_CLASS_ID | NUMBER | (15) | Request type identifier | |
| EXECUTION_OPTIONS | VARCHAR2 | (250) | SQL*Report or Oracle Report program running options | |
| SAVE_OUTPUT_FLAG | VARCHAR2 | (1) | Flag to indicate whether to save output file for the concurrent program | |
| REQUIRED_STYLE | VARCHAR2 | (1) | Yes | Flag to indicate if the print style associated with the concurrent program is mandatory |
| OUTPUT_PRINT_STYLE | VARCHAR2 | (30) | The print style for the concurrent program output | |
| PRINTER_NAME | VARCHAR2 | (30) | Name of printer for printing the concurrent program output | |
| MINIMUM_WIDTH | NUMBER | (4) | Minimum number of columns | |
| MINIMUM_LENGTH | NUMBER | (4) | Minimum number of rows | |
| REQUEST_PRIORITY | NUMBER | (15) | Program level priority assigned by the System Administrator to guarantee that programs run at the same level regardless of who submits them (REQUEST_PRIORITY assigned to concurrent programs overrides the user profile value) | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| IPROG_ID | NUMBER | (4) | Conflict resolution manager internal information | |
| OUTPUT_FILE_TYPE | VARCHAR2 | (4) | Format of output file | |
| ENABLE_TRACE | VARCHAR2 | (1) | Yes | Turns on tracing for requests |
| RESTART | VARCHAR2 | (1) | Yes | Indicates program may be re-started |
| NLS_COMPLIANT | VARCHAR2 | (1) | Yes | Indicates if the program is NLS compliant. In particular, indicates if the program accepts date and number parameters in canonical format |
| ICON_NAME | VARCHAR2 | (30) | Reserved for future use | |
| CD_PARAMETER | VARCHAR2 | (240) | Parameter used to identify conflict domains | |
| INCREMENT_PROC | VARCHAR2 | (61) | Procedure name used to increment program parameters | |
| MLS_EXECUTABLE_APP_ID | NUMBER | (15) | Application identifier for MLS language function | |
| MLS_EXECUTABLE_ID | NUMBER | (15) | Identifier for MLS language function | |
| ENABLE_TIME_STATISTICS | VARCHAR2 | (1) | Yes | Y or N. Timed statistics collection is turned on for the program's session when set to Y |
| SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
| STAT_COLLECT | VARCHAR2 | (1) | Reserved for future use | |
| RESOURCE_CONSUMER_GROUP | VARCHAR2 | (30) | Resource consumer group | |
| ROLLBACK_SEGMENT | VARCHAR2 | (30) | Rollback segment for a transaction | |
| OPTIMIZER_MODE | VARCHAR2 | (30) | Optimization mode, such as RULE, FIRST_ROW, etc. | |
| INSTANCE_ID | NUMBER | (15) | OPS Instance number | |
| REFRESH_PORTLET | VARCHAR2 | (1) | refresh portlet based on program outcome. Possible values 'N'ever/'S'uccess/'A'lways/'W'arning.(lookup type CONC_REFRESH_PORTLET) | |
| PROGRAM_TYPE | VARCHAR2 | (1) | Concurrent Program Type. Possible values( 'O'(ther), 'P'(urge) ) Lookup type CONC_PROGRAM_TYPE | |
| ACTIVITY_SUMMARIZER | VARCHAR2 | (51) | PLSQL procedure that developers can register to provide summary information what the programcan do. | |
| REQUEST_SCH_INTERVAL | NUMBER | Oracle suggested request schedule repeat interval value in days | ||
| ALLOW_MULTIPLE_PENDING_REQUEST | VARCHAR2 | (1) | If set to N if there is one pending request then it will not submit another request | |
| DELETE_LOG_FILE | VARCHAR2 | (1) | If set to Y Concurrent Manager will delete Request Log file | |
| TEMPLATE_APPL_SHORT_NAME | VARCHAR2 | (50) | XML Publisher default template appl short name | |
| TEMPLATE_CODE | VARCHAR2 | (80) | default template code | |
| MULTI_ORG_CATEGORY | VARCHAR2 | (1) | multi_org_category |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, CONCURRENT_PROGRAM_ID
, CONCURRENT_PROGRAM_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, EXECUTABLE_APPLICATION_ID
, EXECUTABLE_ID
, EXECUTION_METHOD_CODE
, ARGUMENT_METHOD_CODE
, QUEUE_CONTROL_FLAG
, QUEUE_METHOD_CODE
, REQUEST_SET_FLAG
, ENABLED_FLAG
, PRINT_FLAG
, RUN_ALONE_FLAG
, SRS_FLAG
, CLASS_APPLICATION_ID
, CONCURRENT_CLASS_ID
, EXECUTION_OPTIONS
, SAVE_OUTPUT_FLAG
, REQUIRED_STYLE
, OUTPUT_PRINT_STYLE
, PRINTER_NAME
, MINIMUM_WIDTH
, MINIMUM_LENGTH
, REQUEST_PRIORITY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, IPROG_ID
, OUTPUT_FILE_TYPE
, ENABLE_TRACE
, RESTART
, NLS_COMPLIANT
, ICON_NAME
, CD_PARAMETER
, INCREMENT_PROC
, MLS_EXECUTABLE_APP_ID
, MLS_EXECUTABLE_ID
, ENABLE_TIME_STATISTICS
, SECURITY_GROUP_ID
, STAT_COLLECT
, RESOURCE_CONSUMER_GROUP
, ROLLBACK_SEGMENT
, OPTIMIZER_MODE
, INSTANCE_ID
, REFRESH_PORTLET
, PROGRAM_TYPE
, ACTIVITY_SUMMARIZER
, REQUEST_SCH_INTERVAL
, ALLOW_MULTIPLE_PENDING_REQUEST
, DELETE_LOG_FILE
, TEMPLATE_APPL_SHORT_NAME
, TEMPLATE_CODE
, MULTI_ORG_CATEGORY
FROM APPLSYS.FND_CONCURRENT_PROGRAMS;
APPLSYS.FND_CONCURRENT_PROGRAMS does not reference any database object
APPLSYS.FND_CONCURRENT_PROGRAMS is referenced by following:
APPS
FND_CONCURRENT_PROGRAMS
FND_PROG_ONSITE_DELETE
FND_PROG_ONSITE_INSERT
|
|
|
|