Registering an UNIX host concurrent program (Oracle E-Business suite).

I wrote a UNIX shell script and executed it fine. I was asked to register the UNIX script as a concurrent program. I registered it and executed it. I couldn’t make it, Coz I dint create the symbolic link. The script was also not saved in .prog extension.

Then I learnt about registering the concurrent host program. One important to remember while registering a host concurrent program is that the first five parameters are reserved by Oracle E-Business Suite for its own use. From the sixth parameter the user –defined parameter can be defined.

The first 5 parameters are,

$0: The shell script to be executed
$1: Oracle user/password
$2: Applications user_id
$3: Application user_name
$4: Concurrent program request_id

The steps involved in registering a Unix concurrent program are,

1.       Create the shell script in the $APPLBIN directory of the specific application top. In this example, I have created the script under $XX_CUSTOM_TOP/bin and named it MY_CUSTOM.prog (the extension should be .prog).

2.       Define the concurrent executable with Execution Method ‘Host’. In the Execution File Name field, specify the name of the shell script without extension (‘MY_CUSTOM’ for this example).

3.       Define the concurrent program with parameters as required.

4.       Add the concurrent program to a request group.

5.       Make a symbolic link using the execution file name to fndcpesr, which is located in the $FND_TOP/$APPLBIN directory.  The symbolic link is created in the same directory as the shell script.

[oracle@apps bin]$ ln -s $FND_TOP/bin/fndcpesr  MY_CUSTOM

After all these steps run the concurrent program. The output of the given out file will be displayed in the log file.