Oracle   Home  

   Home  >  Oracle Applications 11i/ R12  >  System Administration

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"

Read more about the how to Run a report/ concurrent program from the OS level  on www.in-oracle.com.

The functionality of the CONCSUB can be categorized into the following
• Controlling Concurrent Managers

• Submitting Concurrent Requests

CONCSUB is a program that allows you to submit concurrent requests from your operating system. The CONCSUB executable is located at $FND_TOP/bin/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.
 

More information about the CONCSUB you can get fom here.