Below are information to register shell scripts as host programs in Oracle Applications.
1. Create a shell script ( say example) and move to the appropriate BIN directory in Oracle Application.
2. The parameters in the shell scripts should start with $5 , $6 Onwards.
3. Rename the shell script to *.prog ( example.prog).
4. Change Permissions to 755 for the *.prog file.
5. Create Link to the shell Script ( ln -s $FND_TOP/bin/fndcpesrexample.prog).
6. Step 5 Creates example file. Register this executable in the application as a host executable (Using System Administratorprivilege ).

Please Note : The first parameter in the concurrent program is passed as the Fifth parameter in the shell scripts
since the first four parameters are allocated to userid,request_id .. etc.
If for some reason the Concurrent program fails then check to see the privileges of the shell script ( example.prog) . It might have to be registered using applmgr logon .

Return to : Oracle Database, SQL, Application, Programming Tips