In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Run a report/ concurrent program from the OS

 Run a report/ concurrent program from the OS

If you want 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. 

This utility is found at $FND_TOP/bin

[oracle@linux1 ~]$ find /APPS -name CONCSUB
/APPS/visappl/fnd/11.5.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:

[oracle@linux1 ~]$ cd /APPS/visappl/fnd/11.5.0/bin/
[oracle@linux1 bin]$ . /APPS/visappl/APPSORA.env

[oracle@linux1 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 weather 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 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   

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> Run a report/ concurrent program from the OS