Oracle submit concurrent Request from shell script

Oracle submit concurrent Request from shell script

In this Post , We will be discussing about the oracle submit concurrent request from shell script. We have the possibility in oracle apps to submit the concurrent request from shell script. We have particular syntax provided in the System Administration User Guide to submit the concurrent requests from shell scripting. To execute the shell script from oracle application , we need to create the prog file and then register in as a host type in concurrent program executable. Here below I will share detail standard script for concurrent request and the working example to submit the concurrent request from shell script.

Standard syntax of concurrent request from shell script.

$ 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}]/
[START={date}] /
[IMPLICIT={ type of concurrent request} /
[{parameter 1} ... {parameter n}]

 Real Time Example of Oracle submit concurrent Request from shell script

For Example :- Here below is the standard Program , which we will call from shell script.

This Program has four Parameters as below :

#!/bin/ksh

#####################################################################

##FILENAME:

##DESCRIPTION:

##AUTHOR:

#####################################################################

## Start of shell script

DATE_TIME=`date '+%D %T | tr 'a-z''A-Z'`

echo "Calling Employee Update Program ${DATE_TIME}"

submit_cc_req=`CONCSUB APPS/APPS \

               SYSADMIN \

               "System Administrator" \

               SYSADMIN \

               WAIT-N \

    CONCURRENT AP \

               APXHRUPD \

               [PROGRAM_NAME=" Employee Update Program"] \

               [33444,2001,2334,5666]

              

if[$?==0]

then

  echo "Concurrent request $submit_cc_req submitted successfully".

else

  echo "There is an error in concurrent program submission"

fi

## End of shell script

#####################################################################

Registration of Prog file of Oracle submit concurrent Request from shell script

We need to register this prog file as a host file for concurrent programs in oracle apps.