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
Solved

Concurrent Program to FTP file in Oracle E-Business Suite

Posted on 2008-10-07
1
4,539 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
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

856 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