Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5159
  • Last Modified:

Concurrent Program to FTP file in Oracle E-Business Suite

Hi,

I am new to both E-Busniess Suite and Unix and am trying to set up a concurrent program which will ftp a file I have created on my database server to a remote ftp server.

I created my shell script in vi and have saved it with .prog suffix in $XBOL_TOP/bin, I gave it 775 permission and then created a soft link to it with the fndcpesr command.

From herein the app I defined it as an executable as a Business Onine application, I then defined it as a program and added it to the Application Administrator request group.

When I try to submit it I am getting an error message that the program cannot be executed and that I should "verify the execu" I can't read what it syas fully.

Can anyone advise if I have gone wrong somewhere, or point me in the direction of some docs or examples of this working?

Many thanks in advance,
0
cjhall01
Asked:
cjhall01
1 Solution
 
Dr_BillyCommented:
Hi There ,

The error Message you are getting is "concurrent program cannot be executed , verify that the execution path to the executable" ,Check the following and see if that helps :

For example, if your unix script is.. filename.sh , you need to register it as a host program with executable file = filename.
This way the standard parameters are automatically passed. If you have external parameters for the script, then use the below method:
--------------
These are the few steps which is required to make a host based Concurrent Program.

Step1
Create a script and save as .prog extension and put into your application top bin folder.

If your custom application is XX then the scripts should goes to $XX_TOP/bin For example, call the script CUSTOM.prog and place it under your application Top Folder

Step 2
Now,you have understood , the execution of unix program is bit different in oracle application. The only things you have to notice is you need to pass 4 mandatory parameter to execute host program.

The other way around is ,you can use fndcpesr and link with your host program.It means the fndcpesr will take care of your 4 mandatory parameter. You have to simply create a soft link with $XX_TOP/bin folder.

ln -s $FND_TOP/bin/fndcpesr <script>

This link should be named the same as your script without the .prog extension.

Step 3
Next you have to make into system administrator responsibly follow 3 steps from these menu

- sysadmin -> concurrent-> program -> executable
- sysadmin -> concurrent-> program -> define
- sysadmin ->security -> responsibility -> request

Register the concurrent program, using an execution method of 'Host'. Use the name of your script without the .prog extension as the name of the executable.

Step 4
Your script will be passed at least 4 parameters, between $1 and $4. These are:

- orauser/pwd,
- userid,
- username,
- request_id

Any other parameters you define will be passed in $5 and higher. Make sure your script returns an exit status also.
*What additional piece need to incorporate in code
*you need to simply

ORA_USER_PASS=$1
USERID=$2
USERNAME=$3
REQUESTID=$4
customparameter1=$5
customparameter2=$6 etc etc

hope that Helps .

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now