Create Host/Shell Script Concurrent Program in R12
Below is the step by step process of registering shell script as a host program or concurrent program in Oracle Applications R12
Step 1 : Create the executable name HOST_TEST_PROGRAM and Executable File Name demo_sh
Step 2 : Register the concurrent program Demo Shell Script Concurrent Program
Options : encrypt it will avoid displaying apps password in unix command prompt
wont get the password using unix command ps -ef | grep "apps"
Step 3 : Adding two parameter in the concurrent program
Parameter1 Parameter2
Step 4: Add the concurrent program in to the request group & Add that request group into the Responsibility.
Step 5:
1.Create a shell script ( say demo.prog) in appropriate $CUSTOM_TOP/bin directory
Script name : demo.prog
#! /bin/ksh
param1="$5"
param2="$6"
echo "Parameter1 : $param1"
echo "Parameter2 : $param2"
2.Change Permissions to 755 for the demo.prog file. ($chmod 755 $CUSTOM_TOP/bin/demo.prog)
3.Create soft Link to the shell Script ( ln -s $FND_TOP/bin/fndcpesr $CUSTOM_TOP/bin/demo_sh) to create demo_sh file.
4. First 5 params are reserved for Application, user defined params starts from 5th param
ORA_USER_PASS=$1
USERID=$2
USERNAME=$3
REQUESTID=$4
5. fndcpesr is a standard utility available in $FND_TOP directory. Its mainly used by the application to parse arguments for shell scripts.
Step 6:
Submit the concurrent program Demo Shell Script Concurrent Program
from Added responsibility
Program should be completed in normal and out put parameter values are displayed in log file.
Note : The above method should allow spaces in the user defined parameters
