concsub

The CONCSUB is a utility which allows you to submit a concurrent program to the concurrent manager from the operating system level without having to log on to Oracle Applications.

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

CONCSUB <APPS username>/<APPS password> \

<responsibility application short name> \

<responsibility name> \

<username> \

[WAIT=N|Y|<n seconds>] \

CONCURRENT \

<program application short name> \

<program name> \

[PROGRAM_NAME=”<description>”] \

[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>]

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. For example, to pass this argument to a program:

This is an example

pass this argument through CONCSUB:

’”This is an example”’

Example

Here is an example of the command to run CONCSUB:

$ CONCSUB APPS/APPS \

SYSADMIN \

”System Administrator” \

SYSADMIN \

WAIT=N \

CONCURRENT \

FND \

FNDFMRTC \

PROGRAM_NAME=’”Register Custom Tables Weekly”’ \

REPEAT_INTERVAL=7 \

REPEAT_INTERVAL_UNIT=”DAYS” \

REPEAT_INTERVAL_TYPE=”START” \

START=’”08–JUN–96 23:55:00”’

CGL

APPLSYS

ALL

CGL

Please note that 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...

Example

$ CONCSUB APPS/APPS SYSADMIN ”System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDFMRTC PROGRAM_NAME=’”Register Custom Tables Weekly”’

REPEAT_INTERVAL=7 REPEAT_INTERVAL_UNIT=”DAYS” REPEAT_INTERVAL_TYPE=”START” START=’”08–JUN–96 23:55:00”’ CGL APPLSYS ALL CGL

The following entries explain the required and optional parameters for submitting a concurrent program with CONCSUB. Default values are listed to the right.

<username/password> Required. The ORACLE username and password that provides access to the data that your program uses.

<responsibility application short name> Required. The application short name of the responsibility whose concurrent processing options you want to use.

<responsibility name> Required. The name of your responsibility. If the name of your responsibility includes spaces, enclose that name in double quotes.

<username> Required. The uppercase username of the application user whose concurrent processing options you want to use.

<WAIT> Optional. A flag that indicates whether to wait for the submitted request to complete. If you leave this parameter out, the default value of N makes CONCSUB return you to the operating system prompt without waiting for your request to complete.

Set WAIT=Y to have CONCSUB check the request status every 60 seconds and return you to the operating system prompt when your request is completed. You can also enter an integer value for a number of seconds, as in WAIT=30, for CONCSUB to check for request completion every <number> seconds.

Attention: Using WAIT=Y or WAIT=<number> requires that your request completes before CONCSUB returns you to the operating system. If the concurrent manager is down, your CONCSUB process waits indefinitely until the concurrent manager is started and the request completes.

<CONCURRENT> Required. A flag that separates the program–specific parameters from the operating system parameters.

<program application short name> Required. The application short name of your concurrent program.

<program name> Required. The uppercase name of your program. It must be the short name that you enter in the Concurrent Programs window when defining a concurrent program.

<PROGRAM_NAME> Optional. A descriptive name for your program. The program field on the View Requests form displays this as the user–friendly program name. The concurrent program short name passed to CONCSUB is often hard for end users to understand, so the PROGRAM_NAME parameter allows you to pass a more easily remembered name for your concurrent program. If you do not specify a PROGRAM_NAME, the View Requests form displays the user–friendly program name specified in the Concurrent Programs window.

You may also use the PROGRAM_NAME parameter to indicate the batch that your request processes for programs that process a set of data, where there could be several requests for a given program that are active at the same time.

<REPEAT TIME> Optional. The time of day to resubmit the request.

The format for the time is HH24:MI or HH24:MI:SS. For example, REPEAT_TIME=14:30 resubmits your request daily at 2:30 p.m.

Attention: Do not use REPEAT_TIME with other resubmission parameters except for the optional parameters REPEAT_END and START.

<REPEAT_INTERVAL> Optional. 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> Optional. 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. For example, setting REPEAT_INTERVAL=12 and REPEAT_INTERVAL_UNIT=HOURS resubmits your request every twelve hours. The default value is DAYS.

Attention: Do not use REPEAT_INTERVAL and REPEAT_INTERVAL_UNIT with REPEAT_TIME.

<REPEAT_INTERVAL_TYPE> Optional. Whether to time the resubmission interval from the requested start time of the request or from its completion. Set this parameter either toSTART or END. The default value is START.

Attention: Use REPEAT_INTERVAL_TYPE only if you use REPEAT_INTERVAL.

<REPEAT_END> Optional. The date and time to stop resubmitting the concurrent request. Use one of the following for the format of the end date:

’”DD–MON–RR HH24:MI:SS”’ (as in ’”07–APR–02 18:32:05”’)

’”DD–MON–RRRR HH24:MI:SS”’ (as in ’”07–APR–2002 18:32:05”’)

Note that because this date format includes a space, you must enclose the date in double quotation marks and single quotation marks. You can also specify just the date:

’DD–MON–RR’

’DD–MON–RRRR’

<START> Optional. A start date and time for your program in this format:

’”DD–MON–RR HH24:MI:SS”’ (as in ’”07–APR–02 18:32:05”’)

Because this date format includes a space, you must enclose the date in double quotation marks and single quotation marks. If you do not specify a start time, your program submits immediately and is processed by the next available concurrent manager. The default value is the current time.

<IMPLICIT> Optional. 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.

The value IMPLICIT=YES means that only the System Administrator’s privileged View Concurrent Requests form displays this request. Use this value if the request is not interesting to the user.

Specify IMPLICIT=ERROR or IMPLICIT=WARNING, respectively, if you want the request to appear only if it fails or completes with warnings.

<REPEAT_DAYS> Optional. The number of days after which to repeat the concurrent request, calculated from the last requested start date. The number can be a positive integer or real number. For example,

REPEAT_DAYS=1.5 resubmits your request every 36 hours.

Attention: Do not use REPEAT_DAYS with other resubmission parameters except for the optional parameters REPEAT_END and START.

Suggestion: REPEAT_DAYS will become obsolete in a future release. You may therefore want to use REPEAT_INTERVAL, REPEAT_INTERVAL_TYPE and REPEAT_INTERVAL_UNIT instead of REPEAT_DAYS.

<parameter 1> ...<parameter n> Optional. Your 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 [\].

The functionality of the CONCSUB can be categorized into the following

• Submitting Concurrent Requests

• Controlling Concurrent Managers

Submitting Concurrent Requests

You can use the CONCSUB to execute both seeded and custom programs in Oracle Applications. In case of custom programs they must first be registered in Oracle Applications before you can execute them with CONCSUB.

The following can be used in Oracle Applications to run the active users report from the command line without logging in the applications

CONCSUB APPS/APPS SYSADMIN "System Administrator" SYSADMIN WAIT=N CONCURRENT FND FNDSCURS PROGRAM_NAME='"Active Users"'

Submitted request 2866136 for CONCURRENT FND FNDSCURS PROGRAM_NAME="Active Users"

The log and out file for this program is also created at the location defined by your $APPLCSF/$APPLLOG and $APPLCSF/$APPLOUT respectively.

The WAIT=Y/N is used to specify weather to wait for the first concurrent request to be completed before the second is submitted or not.

CONCSUB apps/apps_password SYSADMIN 'System Administrator' SYSADMIN WAIT=N CONCURRENT FND SHUTDOWN

Sometimes the shutdown of the concurrent managers via the CONCSUB utility using the SHUTDOWN clause hangs and you may want to terminate your concurrent managers, in such a case you can use the ABORT clause with CONCSUB to do a force shutdown of your concurrent managers.

CONCSUB apps/apps SYSADMIN 'System Administrator' SYSADMIN WAIT=N CONCURRENT FND ABORT

In this case a concurrent request to terminate the concurrent managers is fired with a -75 priority. In case of the shutdown the priority is 0 and default priority is of a concurrent request 50, by assigning a -75 priority the CONCSUB ensures abort is executed before shutdown.

Needless to say that the shutdown would fail in case the SYSADMN user or the System Administrator responsibility is inactive.

However to start the concurrent managers the CONCSUB is not used instead the startmgr executable is used.(Though possible)

This is located at $FND_TOP/bin/startmgr.

$startmgr sysmgr=apps/apps@sam

Starting icm@sam Internal Concurrent Manager

Default printer is

By default if no manager name is specified the ICM or the Internal Concurrent Manager is started. You can also start a specific manager by using the mgrname clause

To use CONCSUB to start the concurrent managers the STARTUP clause is used

$ CONCSUB apps/apps SYSADMIN 'System Administrator' SYSADMIN WAIT=N CONCURRENT FND STARTUP

Submitted request 2849496 for CONCURRENT FND STARTUP

Page updated

Google Sites

Report abuse