, , ,

CONCSUB Utility – Run Oracle Apps Concurrent Program from OS Level

The concurrent request can be submitted via shell script. This can be done by a standard utility named CONSUB. It can be used to schedule a request too.
The syntax for CONCSUB is given below:
CONCSUB <APPS username>/<APPS password>
<responsibility application short name>
<responsibility name>
<username>
[WAIT=N|Y|<n seconds>]
CONCURRENT
<program application short name>
<program name>
[PROGRAM_NAME=<description>]
 
[ORG_ID=<#>] – R12 onwards only
[REPEAT_TIME=<resubmission time>]
[REPEAT_INTERVAL= <number>]
[REPEAT_INTERVAL_UNIT=< resubmission unit>]
[REPEAT_INTERVAL_TYPE=< resubmission type>]
[REPEAT_END=<resubmission end date and time>]
[START=<date>]
[IMPLICIT=< type of concurrent request>
[<parameter 1> … <parameter n>]
These are the compulsory Parameters:
PARAMETER
DESCRIPTION
ORACLE ID
Username and Password of the ORACLE ID for Applications, separated by a slash (“/”). This would be apps/appspass
Responsibility Application Short Name
Enter the short name of the application for your responsibility. This name, along with your responsibility name, will be used to select a responsibility for your request to run in. eg : SYSADMIN
Responsibility Name
This name, along with your responsibility application short name, will be used to select a responsibility for your concurrent request to run in.
eg : ”System Administrator”
User name
Enter the name of your Application Object Library user. This name will be used to update the Who information for any data your concurrent manager changes.
eg : SYSADMIN
CONCURRENT
A flag that separates the program–specific parameters from the operating system parameters.
Program application short name
The application short name of your concurrent program. 
eg : FND
Program name
The uppercase name of your program. It must be the short name that you enter in the Concurrent Programs window when defining a concurrent program.

Here is an example of the command to run CONCSUB:

$ 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
Notes:
1] For parameters that follow the CONCURRENT parameter and include spaces, enclose the parameter argument in double quotes, then again in single quotes. Oracle Application Object Library requires this syntax because it parses the argument string twice.
2] The above example uses the UNIX line continuation character ”, not all operating systems support the use of this character.  If the line continuation character is not supported then the CONCSUB command should be submitted as one continuous line.
3] COCNSUB is also used to shutdown the concurrent managers, however to start the concurrent manager you have to use startmgr utility.
CONCSUB apps/apps SYSADMIN ‘System Administrator’ SYSADMIN WAIT=N CONCURRENT FND SHUTDOWN
CONCSUB apps/apps SYSADMIN ‘System Administrator’ SYSADMIN WAIT=N CONCURRENT FND ABORT
4] The CONCSUB executable is located at $FND_TOP/bin/CONCSUB.

1 reply
  1. Nirabhra Das
    Nirabhra Das says:

    Hi, I am trying to make a script which I will use for submitting a concurrent request for a scheduled concurrent program. This script will also be used in future. So the parameter START='”DD-MON-YYYY HH24:MM:SS”‘ needs to be input through a variable. I cannot find any way to input that.

    I have saved the current date in the above format in a variable and appended the time 20:00:00 to it. When I pass it in CONCSUB, I get the below error
    “-bash: 27-NOV-2018\ 20:00:00: command not found

    You have entered an invalid request start date and time: 1. Could not submit your concurrent request or report.

    Verify that the value for the profile option “Concurrent:Request Start Time” is in the correct date and time format of DD-MON-Y
    Cannot submit your concurrent request

    Review the previous error messages”

    The Program I am trying to run is below:
    {
    #! /bin/bash

    datenow=`date +’%d-%b-%Y’ | tr ‘[a-z]’ ‘[A-Z]’`

    datetimenow= “$datenow\ 20:00:00”

    echo $datetimenow

    CONCSUB APPS/$APPS_PASS SYSADMIN ‘System Administrator’ SYSADMIN WAIT=N CONCURRENT SLCUST1 SLC_AD_SNAPSHOT_RUN START=$datetimenow REPEAT_DAYS=1
    }

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply