I’m trying to run a Shell Script from Apps 11.5.10.2 as a “Host” type of concurrent program on Windows 2000 Platform.

Fact: Host file name: HW.sh
Fact: Installed MKS Toolkit as my emulator.
Fact: Able to run HW.sh from the prompt successfully.

Steps followed to register concurrent program:

1. Copied FNDCPESR.exe from FND_TOP and copied it to my CUSTOM_APP_TOP/bin directory and renamed it to HW.exe.

2. Registered HW as a Host executable.

3. Registered HW as a program.

4. This is how my CUSTOM_APPL_TOP/bin directory looks like:
****************************
-rwxrwxrwa 1 Administrators None 24576 Oct 29 2004 HW.exe
-rwxrwxrwa 1 Administrators None 106 Mar 25 13:08 HW.sh
****************************

5. When I submit the cuncurrent program, the following is the log:

***************************************************

Current system time is 25-MAR-2006 13:28:20

+-------------------------------------------------------------+

i:\oracle\visappl\VIS\1.0.0\bin\hw.cmd
exited with status 1
+-------------------------------------------------------------+
i:\oracle\visappl\VIS\1.0.0\bin\hw.exe
Program exited with status 3

Cause: The program terminated, returning status code 3.

Action: Check your installation manual for the meaning of this code on this operating system.
*********************************************************

Please help me resolve this issue. Links to Oracle Notes or any other info would be useful.

Regards
Arun

Hi Arun,

The shell script name should be in upper case and should not have any extension. It should be placed in module_top/bin directory and it should have read,write and execute permissions.
As MKS Toolkit is installed all unix commands work as well on 2000.
Let me know, if you need further clarifications.

Thanks,
Prakash Vangari

Prakash,
Thank you for your response.  I tried it but did not work.  I get the same log as before (see my orig post for log details).  Oracle is trying to look for .cmd or a .exe.  I’m sure that there is some config that tells oracle that if this is Win 2K, then a host program extension should either be a .cmd or a .exe.  How do I change that config? Or is there any other method that I can use?

Regards
Arun

Hi,

I checked on metalink. There needs to be some patches to be applied. We can look at it, if required. For now, have a trial and see, if the below solution works, picked from metalink.
PS: I dint test this..

The concurrent program must be called with a dummy variable.  Do this by following these steps:

1.  When defining the concurrent program from application:
Concurrent---> Program--->Define
2.  Click on the ‘Parameters’ button. 
3.  From the subsequent form, declare a dummy parameter. 
4.  Enter the next available sequence number and enter the name ‘Dummy’ as the parameter name.
5.  Navigate to the ‘Value Set’ field of this form
6.  Perform a list/query and select ‘(30 char optional)’ from the results list. 
7.  Set the ‘Default Type’ to constant and the ‘Default Value’ to DUMMY. Ensure that it is enabled.
8.  When submitting the concurrent request, you are prompted to accept the variable.  Click ‘OK’. 

The host program should now run successfully.

Thanks,
Prakash