Solved

Concurrent Program to FTP file in Oracle E-Business Suite

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

770 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