In Oracle : Run a report/ concurrent program from the OS

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

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 :

 

Run a Report in Oracle Apps 11i from OS 

 

 

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

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.