Tuesday, February 7, 2012

Creating Soft link or Symbolic link for Concurrent Manager program files

Soft Link or Symbolic Link is required to read a shell script (.prog file) through a concurrent program.

We can create soft links or symbolic links for Concurrent Manager program files as follows:

Step 1:Go to the custom top as below:

>cd $xxtest_TOP/bin
testapp01(APPDEV) /product/appl/apps/apps_st/appl/xxtest/12.0.0/bin

Step 2: Use 'fndcpesr' command to create soft link

Lets say we have to create two symbolic links for two .prog files xxtest_techtest_ets_loader.prog and xxtest_techtest_points_loader.prog respectively,than we can proceed as follows:

testapp01(APPDEV) /product/appl/apps/apps_st/appl/xxtest/12.0.0/bin
$ln -s $FND_TOP/bin/fndcpesr xxtest_techtest_ets_loader

$ln -s $FND_TOP/bin/fndcpesr xxtest_techtest_points_loader

Note:prog_name should be without .prog extension while creating symbolic link for .prog files.

Step 3:Verify the two created symbolic links:

$ls -altr xxtest_techtest*
lrwxrwxrwx 1 applmgr oinstall 55 Feb 7 14:29 xxtest_techtest_ets_loader -> /product/appl/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr
lrwxrwxrwx 1 applmgr oinstall 55 Feb 7 14:29 xxtest_techtest_points_loader -> /product/appl/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr
As we see above,after creating symbolic link the new attribute 'l' is added that is nothing but symbolic link.

1)'fndcpesr' is a standard utility available in $FND_TOP/bin directory.
2) Its mainly used by the application to parse arguments for shell scripts.
3)It is located in $FND_TOP/bin path along with other FND Utilities.
4)'fndcpesr' is an executable and read only file.

Hope it helps.

Happy Apps DBA learning...


  1. just curious to know... What happens if i do not relink every time i update a program file.
    there is program called test.prg staged on Jan 1st and relinked
    but if i update test.prg on Jan 2nd and i do not relink what happens, as the relink still time stamp on Jan 1st but the program is Jan 2nd.

  2. A smallish campaign with a homemade list would not be likely to yield much of a result. To achieve anything worthwhile, a much more aggressive effort is needed. Then, the age-old value analysis applies: projected earnings = margin on total projected sales - cost of campaign.