Solved

Concurrent Program to FTP file in Oracle E-Business Suite

Posted on 2008-10-07
1
4,783 Views
Last Modified: 2013-12-11
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
Comment
Question by:cjhall01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
Dr_Billy earned 500 total points
ID: 22670238
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

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup
Suggested Courses

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question