CONCSUB in Oracle Apps

• CONCSUB is used to submit a concurrent program to the concurrent manager from the operating system level without having to log on to Oracle Applications.
• The Executable for CONSCUB is located at $FND_TOP/bin/CONCSUB.

The CONCSUB functionality categorized into

1. Submitting Concurrent Requests
2. Controlling Concurrent Managers

Submitting Concurrent Requests:

• We 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"

• 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.

Various printing parameters with the COCNCSUB to directly print the output of your concurrent request:

PRINTER=

NUMBER_OF_COPIES=

PRINT_STYLE=

LANGUAGE=

Also you could specify the start date and completion options along with CONCSUB by using the following parameters

START=

REPEAT_DAYS=

REPEAT_END=

Controlling Concurrent Managers:

We can shutdown concurrent managers using CONSCUB.

shutdown Command:

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.

Abort Command:

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.

If the SYSADMN user or the System Administrator responsibility is inactive, then the shutdown would fail.

To start the concurrent managers the CONCSUB is not used. We can use the startmgr executable is used.


CONSCUB Command:

CONCSUB / \

\

\

\

[WAIT=N|Y|] \

CONCURRENT \

\

\

[PROGRAM_NAME=] \

[ORG_ID=<#>] - R12 onwards only

[REPEAT_TIME=time>] \

[REPEAT_INTERVAL= ] \

[REPEAT_INTERVAL_UNIT=< resubmission unit>] \

[REPEAT_INTERVAL_TYPE=< resubmission type>] \

[REPEAT_END=date and time>] \

[START=<date>] \

[IMPLICIT=< type of concurrent request> \

[ ... ]

Description for above parameters

Example for CONSCUB:

$ 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“JUN96 23:55:00€"'

CGL

APPLSYS

ALL

CGL