Monday, July 22, 2013

Shell script in Oracle Applications

How to create Shell Scripts in Oracle Applications


This shell scripts has default first 4 parameters are

1) Logon 
2) Requester ID
3) Requester
4) Request_id

From the 5th parameters on words we read the real parameters we pass from concurrent program

Write a shell script and save as XXXXX.prog file and give 777 permissions

Ex:
#!/bin/ksh
## Call from fndcpesr
## Env info
 logon=$1
 requestor_id=$2
 requestor=$3
 req_id=$4
# These are the parameter we read from concurrent program 
 param1=$5
 param2=$6
## Custom mode parameter (Overwrites everytime)
echo "Logon            = $logon"
echo "Requestor ID     = $requestor_id"
echo "Requestor        = $requestor"
echo "Request ID       = $req_id"
echo "param1           = $param1"
echo "param2           = $param2"
echo "Completed successfully"


Then Move this file to Custom to Bin Directory

Then create simbolic for that shell script

cd $XXXX_TOP
ln -s $FND_TOP/bin/fndcpesr XXXXX

 Then create Executable with host as executable
Then create Concurrent program 
Then assign this concurrent program to Request group and run the program

No comments:

Post a Comment