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
How to pass a parameter in this concurrent program
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.
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
@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
In the above syntax instead of
to be used.
Thanks
Sravan Reddy
Hey, great blog…but I don’t understand how to add your site in my rss reader. Can you Help me, please 🙂
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 🙂
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