CONCSUB Utility: Run your Concurrent Program from OS Level

CONCSUB is a utility to submit the concurrent request from operating system level to run concurrent program, without having to log on to oracle applications.

The Syntax:

CONCSUB <APPS username>/<APPS password> \
<responsibility application short name> \
<responsibility name> \
<username> \
[WAIT=N|Y|<n seconds>] \
<program application short name> \
<program name> \
[PROGRAM_NAME=<description>] \

[ORG_ID=<#>] - R12 onwards only
[REPEAT_TIME=<resubmission time>] \
[REPEAT_INTERVAL= <number>] \
[REPEAT_INTERVAL_UNIT=< resubmission unit>] \
[REPEAT_INTERVAL_TYPE=< resubmission type>] \
[REPEAT_END=<resubmission end date and time>] \
[START=<date>] \
[IMPLICIT=< type of concurrent request> \
[<parameter 1> ... <parameter n>]

The Parameters:

Parameter Name Required? Comment
<username/password> Yes The ORACLE username and password that provides access to the data that the program uses.
<responsibility application short name> Yes The application short name of the responsibility whose concurrent processing options to be used.
<responsibility name> Yes The name of the responsibility. If the name of the responsibility includes spaces, enclose that name in double quotes.
<username> Yes The uppercase username of the application user whose concurrent processing options to use.
<WAIT> No A flag that indicates whether to wait for the submitted request to complete. If one leaves this parameter out, the default value of N makes CONCSUB return to the operating system prompt without waiting for the request to complete. Set WAIT=Y to have CONCSUB check the request status every 60 seconds and returns to the operating system prompt when the request is completed.
<CONCURRENT> Yes A flag that separates the program specific parameters from the operating system parameters.
<program application short name> Yes The application short name of the concurrent program.
<program name> Yes The uppercase name of the program. It must be the short name that was enter in the Concurrent Programs window when defining a concurrent program.
<PROGRAM_NAME> No A descriptive name for your program.
<ORG_ID> No Introduced in R12, set to org id required for the report to be run with.
<REPEAT TIME> No The time of day to resubmit the request.  The format for the time is HH24:MI or HH24:MI:SS
<REPEAT_INTERVAL> No The interval between resubmission (a positive integer or real number). Use this parameter along with REPEAT_INTERVAL_UNIT to specify the time between resubmissions.
<REPEAT_INTERVAL_UNIT> No The unit of time used for the interval between resubmissions. The available units are MINUTES, HOURS, DAYS or MONTHS. Use this parameter along with REPEAT_INTERVAL to specify the time between resubmissions.
<REPEAT_INTERVAL_TYPE> No Whether to time the resubmission interval from the requested start time of the request or from its completion. Set this parameter either to START or END. The default value is START.
<REPEAT_END> No The date and time to stop resubmitting the concurrent request.
<START> No A start date and time for the program in this format:
DDMONRR HH24:MI:SS (as in 07€“APR02 18:32:05€™)
Because this date format includes a space, one must enclose the date in double quotation marks and single quotation marks.
<IMPLICIT> No Whether to show this concurrent request on the View Requests form. Specify NO, YES, ERROR or WARNING. The value IMPLICIT=NO allows the request to appear on the View Request form. The default value is NO.
<REPEAT_DAYS> No The number of days after which to repeat the concurrent request, calculated from the last requested start date.
<parameter 1> …<parameter n> No The program specific parameters. If a parameter includes spaces, enclose that parameter in double quotes, then in single quotes. If a parameter contains a double quotation mark as part of the argument, precede that mark with a backslash [\].

Here is an example of the command to run CONCSUB:

System Administrator \
PROGRAM_NAME=Register Custom Tables Weekly \
START='"08“JUN96 23:55:00€"'


1] For parameters that follow the CONCURRENT parameter and include spaces, enclose the parameter argument in double quotes, then again in single quotes. Oracle Application Object Library requires this syntax because it parses the argument string twice.

2] The above example uses the UNIX line continuation character ‘\’, not all operating systems support the use of this character.  If the line continuation character is not supported then the CONCSUB command should be submitted as one continuous line.

3] COCNSUB is also used to shutdown the concurrent managers, however to start the concurrent manager you have to use startmgr utility.



4] The CONCSUB executable is located at $FND_TOP/bin/CONCSUB.

Unix Shell Scripting Basics

Unix Shell Scripting Basics

Unix shell scripting is a very essential part of an Oracle Technical consultant’s life and here is a very basic presentation about Unix Shell Scripting. Hope this help people who want to learn the basic concepts!