Printable version of this Post
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
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
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
Hey, great blog…but I don’t understand how to add your site in my rss reader. Can you Help me, please