Shell Script for Concurrent Program

Shell Script System Parameters

The five standard parameters do not need to be defined on the Concurrent Program Parameters Form:

$0 Name of the Concurrent Program

$1 Oracle User ID/PASSWORD

$2 User ID (numeric representation)

$3 User Name that submitted the request (character representation)

$4 Request ID for the request

Creating a Soft Link

ln -s $FND_TOP/bin/fndcpesr XXCMNLDT

Submitting a Concurrent Program from Shell 

CONCSUB username/pwd RESP_APPL_SHORT_NAME RESP_SHORT_NAME USER_NAME WAIT=N  CONCURRENT APPL_SHORT_NAME CONC_PGM_SHORT_NAME START=SYSDATE 'PARAMETER1' $PARAMETER2

CONCSUB $1 SQLAP 'W - WPC - AP' $3 WAIT=Y CONCURRENT SQLAP APXVVCF4 START='"29-Jul-2010 15:24:00"' '10000' $FILE_DIR;