There are mainly two functionalities of the CONCSUB utility:
Submit Concurrent Requests and Control Concurrent Managers.
In this article we are going to discuss how to submit a concurrent request through the Unix shell script by using the CONCSUB utility. The CONCSUB allows us to submit a concurrent program to the concurrent manager from the Operating System level without actually logging on to Oracle Applications.
CONCSUB can be used to execute both seeded and custom programs in Oracle Applications. Custom programs must be registered in Oracle Applications before we can execute them with CONCSUB.
Path for CONCSUB executable : $FND_TOP/bin/CONCSUB.
Syntax for CONCSUB :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
$CONCSUB [WAIT=N|Y| CONCURRENT [PROGRAM_NAME= [ORG_ID=<#>] – R12 onwards only [REPEAT_TIME= [REPEAT_INTERVAL= [REPEAT_INTERVAL_UNIT=< resubmission unit>] \ [REPEAT_INTERVAL_TYPE=< resubmission type>] \ [REPEAT_END= [START= [IMPLICIT=< type of concurrent request> \ [ |
Sample shell script to submit the concurrent request using CONCSUB.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
#!/bin/ksh ##################################################################### ##FILENAME: ##DESCRIPTION: ##AUTHOR: ##################################################################### ## Start of shell script DATE_TIME=`date ‘+%D %T | tr ‘a-z”A-Z’` echo “Starting to execute script at ${DATE_TIME}” submit_cc_req=`CONCSUB APPS/APPS \ SYSADMIN \ “System Administrator” \ SYSADMIN \ WAIT-N \ CONCURRENT FND \ FNDSCRUR \ PROGRAM_NAME=” Users of a Responsibility”` if[$?==0] then echo “The concurrent request $submit_cc_req submitted successfully”. else echo “Error in submitting the concurrent program” fi ## End of shell script ######################################################################## |