Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Concurrent Program to FTP file in Oracle E-Business Suite

Posted on 2008-10-07
1
Medium Priority
?
4,974 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 2000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses

824 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