Run a report/ concurrent program from the OS level

In special circumstance we might have to run a report/ concurrent program from the Operating System level without having to log on to Oracle Applications, you have to use CONCSUB utility for this purpose.

This utility can be found at $FND_TOP/bin

[applvis@oracle]$ find . -name CONCSUB
/u01/applvis/apps/apps_st/appl/fnd/12.0.0/bin/CONCSUB

Here are the CONCSUB Parameter Arguments:

NOTE: In green you can see the mandatory parameters.

<APPS username>/<APPS password> \
<Responsibility Application Short Name> \
<Responsibility Name> \
<User Name> \
[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=<resubmissionunit>] \
[REPEAT_INTERVAL_TYPE=<resubmissiontype>]
[REPEAT_END=<resubmission end date andtime>] \
[START=<Requested Start Date>] \
[REPEAT_DAYS=<number of days>] \
[IMPLICIT=<type of concurrent request> ] [PRINTER=<name of printer>] \
[NUMBER_OF_COPIES=<number of copies>]

Default values:

WAIT=N

REPEAT_INTERVAL_UNIT=DAYS

START = current time

IMPLICIT=NO

Example:

[applvis@oracle]$ cd $FND_TOP/bin
[applvis@oracle bin]$ Source your APPS Environment file.

[applvis@oracle bin]$ ./CONCSUB APPS/APPS SYSADMIN "System Administrator" SYSADMIN WAIT=N CONCURRENT FND FNDSCURS PROGRAM_NAME='"Active Users"'
Submitted request 2720951 for CONCURRENT FND FNDSCURS PROGRAM_NAME="Active Users"

This report is the equivalent of :

 

NOTES: 

·                    the parameters are added at the end of the command

·                    The log and out file for this program is created at the $APPLCSF/$APPLLOG and $APPLCSF/$APPLOUT 

·                    for a NULL parameter we have to use '""'

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

·                    CONCSUB utility could be used to manage the Concurrent Managers:

          Startup the ICM:

          cd $FND_TOP/bin

          startmgr.sh sysmgr=apps/apps@VIS
 

          Shutdown the ICM:

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

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