How to submit concurrent program from command promot / shell

We can submit concurrent programs from OS command / shell prompt using CONCSUB utility. Following is the syntax of the same:

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>”]
[REPEAT_TIME=<resubmission time>]
[REPEAT_INTERVAL= <number>]
[REPEAT_INTERVAL_UNIT=< resubmission unit>]
[REPEAT_INTERVAL_TYPE=< resubmission type>]
[REPEAT_END=<resubmission end date and time>]
[NLS_LANGUAGE=<language of the request>]
[NLS_TERRITORY=<territory of the request>]
[START=<date>]
[IMPLICIT=< type of concurrent request>
[<parameter 1> … <parameter n>]

Examples:

Active Users
CONCSUB apps/[apps_pwd] SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDSCURS

Prints Environment Variables
CONCSUB apps/[apps_pwd] SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDPRNEV APPL_TOP

  1. Arpita
    Jul 9th, 2018 at 14:49 | #1

    How to pass a parameter in this concurrent program

  2. Dharni
    Apr 11th, 2016 at 11:41 | #2

    Hi,

    Do anyone have idea to run a concurrent program with SYS user in oracle apps or run a SQL script in concurrent program as SYS.

    Thanks in Advance.

  3. sudheer
    Dec 17th, 2014 at 16:19 | #3

    Hi…your blog is very help full thanks for share such nice script.

    i am facing a problem. can you please tell me how can i start internal manager
    on windows operating system. because from form activation button is disabled

    so any other way to activate internal manager. i have installed apps on windows. i know the script for unix but don’t know how to do on windows.

    Thanks
    sudheer

  4. Apr 30th, 2012 at 09:13 | #4

    @muthukumaran
    I have uploaded a file at following location. Right click and save it. Please note that ORA Training does not take any responsibility for this tuning, it is from our experience and what worked fine for us. Make sure to backup any files which you change before replacing.

    Click here to download the tuned scripts

    Also make sure that since our paths might be different than yours so do not replace the whole file if this is the case.

    Regards
    Tushar
    For ORA Training

  5. sravan
    Dec 20th, 2011 at 22:42 | #5

    In the above syntax instead of
    to be used.

    Thanks
    Sravan Reddy

  6. Online Stock Trading
    Sep 30th, 2009 at 11:41 | #6

    Hey, great blog…but I don’t understand how to add your site in my rss reader. Can you Help me, please 🙂

  7. Apr 25th, 2009 at 16:04 | #7

    You are right Gil. We are going to post so many useful shell scripts for Oracle Applicaions once our blog goes live.
    Thanks very much for the comment 🙂

  8. Gil
    Apr 24th, 2009 at 21:30 | #8

    Very useful post – thanks!

    If you want to run a CONCSUB report and send the output to a mailing list, you can do the following:

    . APPSserver_sid.env #setenv
    cd $APPLCSF/out/sid_server #cd to your out directory for concurrent request reports
    function ActiveUsers
    {
    CONCSUB apps/ SYSADMIN “System Administrator” SYSADMIN wait=N CONCURRENT FND FNDSCSRR | cut -f3 -d’ ‘ | sed ’s/^[ t]*//;s/[ t]*$//’
    }
    function Date
    {
    date +%B
    }
    date=$(Date)
    reportno=$(ActiveUsers)
    while [ ! -r “o”$reportno”.out” ]
    do
    sleep 10
    done
    sleep 10
    #mailx -s “$date Audit Responsibilities Monthly Report” someone@somewhere.com < “o”$reportno”.out” this works quite well for distributing say audit reports etc. to a mailing list. cheers

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>