Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Miscellaneous
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

An article on very basics of Concurrent Program, for beginners that follow http://getappstraining.blogspot.com.



Lets first discuss the below scenario

Being a developer, you have just developed a SQL script or a PL/SQL package procedure. The end user wants to be able to run this script ad-hoc or they wish to schedule this to run every night.

Question : How can an end-user be given control to run a script developed by a developer, given that an end user will never have access to apps password(and rightly so)?
Answer: This script can be attached to a Concurrent Program via a concurrent program executable. The user will then be given access to this Concurrent Program.

Question : But how will the end user or Oracle Apps make this script run every 10hours daily?
Answer : A concurrent program can be scheduled to run at desired intervals. The schedule is defined at the time of submission.

Question: What are the different types of scripts/programs that can be attached to concurrent programs?
Answer :
A sql script
A Sql*Loader program
Java program
Oracle Report
Pl/SQL program ( or call it a stored procedure/package procedure)
Host script, like a unix shell script
Pro*C/Spawned
Perl

Question: What are the basic steps when defining a concurrent program.
Answer: Broadly speaking there are three steps when developing a concurrent program in Oracle Apps
Step 1. Make Oracle Apps identify the executable
Step 2. Provide a handle to the executable by means of defining a concurrent program
Step 3. Make this concurrent program accesible to selected users via their responsibility.

Question: Please can you describe the above steps in detail
Answer:
Step 1. Make Oracle Apps identify the executable
In Oracle Apps we have something called as concurrent program executable. Concurrent program executable is defined to register a script or a procedure for its usage within oracle apps.

Step 2. Provide a handle to the executable by means of defining a Concurrent Program.
We need to define a concurrent program and attach that to the executable defined in above step.

Step 3. Make this concurrent program accesible to selected users via their responsibility.
We do this by adding the concurrent program to something called as request group. The request group is either associated with a responsibility or is passed in as a parameter to the function request form function. Don't worry if you do not understand this step, I will be writing a dedicated article to explain this step.


Question : Please explain the steps for defining a pl/sql concurrent program, with screenshots and with almost real life example?
Answer:
1. Create a table and a stored procedure in pl/sql
create table xx_hello_world_tab
(
 message_text VARCHAR2(
100)
,creation_date DATE
) ;

CREATE OR REPLACE PROCEDURE
xx_register_user_prc(errbuf      OUT VARCHAR2,retcode     OUT VARCHAR2) IS
BEGIN
  INSERT INTO xx_hello_world_tab VALUES (
'Hello World' ,SYSDATE);
END xx_register_user_prc;

SELECT * FROM xx_hello_world_tab ;

--Zero records will be returned here


2. Note the two parameters, namely errbuff and retcode
These parameters for used for the interaction between the concurrent program and the pl/sql Program. I suggest to the beginners not to spend much time on these parameters.

3. Define an executable attached to this procedure.
This can be done by navigating to the responsibility “Application Developer”, and selecting the menu /Concurrent/Executable

4. Define the concurrent program
This can be done by navigating to responsibility “Application Developer” and then selecting menu /Concurrent/Progra


5. Attach this program to a report group.
Go to System Administrator responsibility, and select
/Security/Responsibility/Request


Now, we can navigate to the Receivables Manager and submit the concurrent request.
Image

After the completion of the request, we check the table
Image


Anil Passi

Comments   

0 #1 venkat 2006-10-26 00:00
i have a question. is it enough if we write a
procedure xx_register_use r_prc in apps schema and compile it or should i add it to any direcotry like AR_TOP/sql and then register it as a concurrent program
Quote
0 #2 venkat 2006-10-26 00:00
i have a question. is it enough if we write a
procedure xx_register_use r_prc in apps schema and compile it or should i add it to any direcotry like AR_TOP/sql and then register it as a concurrent program
Quote
0 #3 Anil Passi 2006-11-15 00:00
Hi there,

you can schedule a concurrent request, so that you do not have to execute it manually.

If you want this done programmaticall y, then use api FND_REQUEST.SUB MIT_REQUEST

Thanks
anil
Quote
0 #4 Cherry 2006-11-15 00:00
Is there any existing APIs which can call and submit these kinds of requests or concurrent program? The purpose behind is to skip manual submission. I want to trigger some fixed procedure in the backgroud to reduce human workload.
Otherwise, any suggestion?
Quote
0 #5 Cherry 2006-11-15 00:00
Thanks for your fast response.
Then , Can I call the OFA packages such as AutoCreate PO by writting a PL/SQL as a request in this case?
Is there any existing APIs which allow to do so?
Is it ok to call OFA packages directly? Any concern?

(so rry for too much questions, I am new to Oracle and OFA)

Thanks in advanced.
Cher ry
Quote
0 #6 Anil Passi 2006-11-15 00:00
Hi there,

you can schedule a concurrent request, so that you do not have to execute it manually.

If you want this done programmaticall y, then use api FND_REQUEST.SUB MIT_REQUEST

Thanks
anil
Quote
0 #7 Cherry 2006-11-15 00:00
Is there any existing APIs which can call and submit these kinds of requests or concurrent program? The purpose behind is to skip manual submission. I want to trigger some fixed procedure in the backgroud to reduce human workload.
Otherwise, any suggestion?
Quote
0 #8 Cherry 2006-11-15 00:00
Thanks for your fast response.
Then , Can I call the OFA packages such as AutoCreate PO by writting a PL/SQL as a request in this case?
Is there any existing APIs which allow to do so?
Is it ok to call OFA packages directly? Any concern?

(so rry for too much questions, I am new to Oracle and OFA)

Thanks in advanced.
Cher ry
Quote
0 #9 Eugene 2006-11-18 00:00
Anil,
Great site. I very new to Oracle Apps and learning a whole lot from it.
I have a question about concurrent program. We outsourced an implementation team for Oracle Financials and they told me that I have to generate text files with PO, Receipts, Items, .... data it them (Prod d/b on Windows). Then generated files need to be moved to the server where Financials installed (Linux sever).
Then, they said, the concurrent program will run to load moved files into Apps.
My question is: could I just add a call (via d/b link) to the package on prod server to generate files and move them to the apps server and then proceed with loading files? It seems to me that it would be a completed task. Your thoughts?
Than k you,
Eugene
Quote
0 #10 Eugene 2006-11-18 00:00
Anil,
Great site. I very new to Oracle Apps and learning a whole lot from it.
I have a question about concurrent program. We outsourced an implementation team for Oracle Financials and they told me that I have to generate text files with PO, Receipts, Items, .... data it them (Prod d/b on Windows). Then generated files need to be moved to the server where Financials installed (Linux sever).
Then, they said, the concurrent program will run to load moved files into Apps.
My question is: could I just add a call (via d/b link) to the package on prod server to generate files and move them to the apps server and then proceed with loading files? It seems to me that it would be a completed task. Your thoughts?
Than k you,
Eugene
Quote
0 #11 Anil Passi 2006-11-19 00:00
Hi Eugene

I assume the following:-
-- --------------- ------
1. You have some concurrent program definitions to be moved from one environment to another.
2. You wish to add a DB link from Prod box to a development box, so that those definitions can be accessed.

As suming that I understood your qns correctly:-
1. I guess your outsourcing company is using FNDLOAD to download the concurrent program definitions.
F NDLOAD is described here
http://www.google.com/search?q=site:apps2fusion.com+oracle-fndload-script-examples

FNDLOAD creates text files, that can be uploaded in a new environment.

2. You usually never create DB Links frm PRD to DEV environment.
T he FNDLOAD link shows how to upload the program definitions too. You do not necessarily need to run a concurrent program, although FNDLOAD command also happens to be an executable of conc program itself.

Than ks,
Anil Passi
Quote
0 #12 Anil Passi 2006-11-19 00:00
Hi Eugene

I assume the following:-
-- --------------- ------
1. You have some concurrent program definitions to be moved from one environment to another.
2. You wish to add a DB link from Prod box to a development box, so that those definitions can be accessed.

As suming that I understood your qns correctly:-
1. I guess your outsourcing company is using FNDLOAD to download the concurrent program definitions.
F NDLOAD is described here
http://www.google.com/search?q=site:apps2fusion.com+oracle-fndload-script-examples

FNDLOAD creates text files, that can be uploaded in a new environment.

2. You usually never create DB Links frm PRD to DEV environment.
T he FNDLOAD link shows how to upload the program definitions too. You do not necessarily need to run a concurrent program, although FNDLOAD command also happens to be an executable of conc program itself.

Than ks,
Anil Passi
Quote
+1 #13 Anil Passi 2006-11-26 00:00
Hi Eugene,

You can certainly do all the steps in one single concurrent program. But for doing so, you need to write a Java Concurrent Program

Than ks
Anil Passi
Quote
-1 #14 Anil Passi 2006-11-26 00:00
Hi Eugene,

You can certainly do all the steps in one single concurrent program. But for doing so, you need to write a Java Concurrent Program

Than ks
Anil Passi
Quote
0 #15 Hari 2006-11-29 00:00
Hi Anil Passi
I am trying to execute a java program through oracle apps forms. I have created a java concurrent program and I have crated a request and submitted and once its completion I am getting an exception saying that

java.lang.C lassNotFoundExc eption: testOracle.Orac leTestProgramNe w
at oracle.apps.fnd .cp.request.Run .main(Run.java: 117)

I have set the JAVA_TOP and AF_CLASSPATH upto that testOracle parent Directory.

s till I am getting the same exception.

c ould u please sugget me to where I must palce the java class file and its further settings?

Th anks in advance.
HariK rishana.
Quote
0 #16 Anil Passi 2006-11-29 00:00
Hi Hari

Try to pass the classpath in options field of the concurrent program and try to run it standalone first.

Pleas e note that, DO NOT USE $_TOP notation in classpath when specified from concurrent program options field.

Use notation as below:-

-cp /home/appsborg. zip:/home/xx/ja va/apps.zip

Put the exact paths and run again, let me know how it goes

thanks
anil passi
Quote
0 #17 Hari 2006-11-29 00:00
Hi Anil Passi
I am trying to execute a java program through oracle apps forms. I have created a java concurrent program and I have crated a request and submitted and once its completion I am getting an exception saying that

java.lang.C lassNotFoundExc eption: testOracle.Orac leTestProgramNe w
at oracle.apps.fnd .cp.request.Run .main(Run.java: 117)

I have set the JAVA_TOP and AF_CLASSPATH upto that testOracle parent Directory.

s till I am getting the same exception.

c ould u please sugget me to where I must palce the java class file and its further settings?

Th anks in advance.
HariK rishana.
Quote
0 #18 Anil Passi 2006-11-29 00:00
Hi Hari

Try to pass the classpath in options field of the concurrent program and try to run it standalone first.

Pleas e note that, DO NOT USE $_TOP notation in classpath when specified from concurrent program options field.

Use notation as below:-

-cp /home/appsborg. zip:/home/xx/ja va/apps.zip

Put the exact paths and run again, let me know how it goes

thanks
anil passi
Quote
0 #19 Anil Passi 2006-12-18 00:00
Hi Richa,

To crack the interview you first need to crack the fundamentals.

Having said that, I suggest you read all possible articles on this site and also on similar other websites. I think ittoolbox has some very nice articles.

Th e more you read and understand, the better.

I think http://getappstraining.blogspot.com/2006/10/oracle-apps-training-index.html will be a good starting point.

Thank s,
Anil Passi
Quote
0 #20 Anil Passi 2006-12-18 00:00
Hi Richa,

To crack the interview you first need to crack the fundamentals.

Having said that, I suggest you read all possible articles on this site and also on similar other websites. I think ittoolbox has some very nice articles.

Th e more you read and understand, the better.

I think http://getappstraining.blogspot.com/2006/10/oracle-apps-training-index.html will be a good starting point.

Thank s,
Anil Passi
Quote
0 #21 Anil Passi 2006-12-25 00:00
Hi Praveen

You may also have a look at the dedicated article on Request Groups http://www.google.com/search?q=site:apps2fusion.com+index.php?option=com_content&task=view&id=87&show=1&Itemid=27&show=1

Thanks,
An iL Passi
Quote
0 #22 praveen 2006-12-25 00:00
Thanks a lot Anil for the response, you are a great help...i will try to sort the issue out as per your guidance...
Quote
0 #23 Anil Passi 2006-12-25 00:00
Hi Praveen

You may also have a look at the dedicated article on Request Groups http://www.google.com/search?q=site:apps2fusion.com+index.php?option=com_content&task=view&id=87&show=1&Itemid=27&show=1

Thanks,
An iL Passi
Quote
0 #24 praveen 2006-12-25 00:00
Thanks a lot Anil for the response, you are a great help...i will try to sort the issue out as per your guidance...
Quote
0 #25 raj 2007-01-25 00:00
Hello sunil....
Firs tof all thanking u for such valuable information for starters,,i have aquestion..
ca n u help me how a formfunction in attached to a menu..
thanks
raj
Quote
0 #26 Anil Passi 2007-01-27 00:00
.
.
.
Hi Raj

Please refer to http://getappstraining.blogspot.com/2006/10/oracle-forms-functions-menus-and-their.html

thanks
ani l
Quote
0 #27 User 2007-02-22 00:00
Hi Anil,
I just wanted to know, how to define parameters. What If my program requires 2 input parameters say empno,ename?
p lz let me know
Quote
0 #28 User 2007-02-22 00:00
If user wants to enter Input Parameter values while submitting the concurrent program( say empno, ename), how to define them. Plz let me know
Quote
0 #29 Anil Passi 2007-03-06 00:00
Hi Soham

To run a Concurrent program from Unix Shell you can use CONCSUB. A search on Metalink or google will give you the syntax.


To run a UNIX shell script as a concurrent program,you need to register this as Host Concurrent Program. Say you register an executable named XXCONC within XXPO Module.

on unix, do

1. cd $XXPO_TOP/bin
2. vi XXCONC.prog and edit and write script and save
3. ln -s $FND_TOP/bin/fn dcpesr XXCONC
4. ls -l XXCONC

Thank s
Anil Passi
Quote
0 #30 Tony 2007-04-18 00:00
Hi Anil,

Want to know the answer to

why do we attach program to a specific application only

Thanks in Advance
Quote
0 #31 Anil Passi 2007-04-18 00:00
Hi Tony

To find the answer, please see the discussion at bottom part of page
http://getappstraining.blogspot.com/2006/10/oracle-apps-training-index.html

The same question as posted by you has been discussed there.

Thank s
Anil
Quote
0 #32 Anil Passi 2007-04-20 00:00
Hi new user,

To find the answer, please see the discussion at bottom part of page
http://getappstraining.blogspot.com/2006/10/oracle-apps-training-index.html
The same question as posted by you has been discussed there.

Thank s
Anil
Quote
0 #33 Ajay 2007-05-02 00:00
Hi Anil,
Can i get anyexample of Perl Concurrent program. I am new to perl.

Regard s,
Ajay Kunde
Quote
0 #34 swati 2007-06-01 00:00
Hi Anil,

I have a requirement to enter list of values in a concurrent program parameter like comma separated values.
Is it possible?

Th anks,
Swati
Quote
0 #35 Anil Passi 2007-06-20 00:00
Hi Deb

Please do the following

1. Create a new package procedure for conc program
with two out parameters.
2. Register this as executable for conc program
3. Within this new procedure, you can execute POOL_ASSIGNMENT . The last three out variables can be displayed in log file or logged into some tables for error reporting.

T hanks,
Anil Passi
Quote
0 #36 prem 2007-06-28 00:00
Hi,

What is the differnce between the (Concurrent program) SQL Loader program which is having executable method as Host and the one which is having the executable method as SQL*Loader.
Quote
0 #37 nagender 2007-08-18 03:29
Hi Mr.Anil,
I am new to oracle apps and I would like to know about the submission of concurrent prog ufrom pl/sql.
I know that fnd_request.sub mit_request(par ameters) helps in this, but i don't know how to use it.
Can u please give the syntax of that parameters and what all should be passed for this API to call the concurrent prog.
Thanks,
N agender
Quote
0 #38 nagender 2007-08-18 03:31
Hi Mr.Anil,
I am new to oracle apps and I would like to know about the submission of concurrent prog from pl/sql.
I know that fnd_request.sub mit_request(par ameters) helps in this, but i don't know how to use it.
Can u please give the syntax of that parameters and what all should be passed for this API to call the concurrent prog.
Thanks,
N agender
Quote
0 #39 Anil Passi 2007-08-19 05:46
Hi Nagender

Pleas e refer to link
scripts4oracle.blogspot.com/2006/09/oracle-api-for-gl-interface-package_19.html

You will find an example there.

Thanks,
Anil Passi
Quote
0 #40 navin 2007-09-05 13:51
Hi Anil,
It is very good initiative from your end. needs more on XML publishers.
Quote
0 #41 Sandhyakashyap 2007-09-17 10:31
I am unable to see any of the pictures on your site, especially the screen-shots. Any particular reason?
Quote
0 #42 Anil Passi 2007-09-17 11:13
Hi Sandhya

Are you able to visit http://docs.google.com

Possibly your company URL filters off that URL

Cheers
Ani l
Quote
0 #43 Udayabhaskar Emani 2007-10-25 09:58
Hi Anil,
Your Article is too Good and its very useful.
Regards
Madhuri
Quote
0 #44 sai d 2007-10-29 14:41
hi anil,

great post first of all. but i have a question

is it possible for one seeded concurrent program to be the trigger of another custom one without disturbing the seeded program? if yes how? im really confused as to how to do this!
Quote
0 #45 Anil Passi 2007-10-29 14:45
Sai

Not possible, unless the seeded program calls a user hook API or calls a business event.

Thanks,
Anil Passi
Quote
0 #46 Shakil Ahmed 2007-11-13 17:15
Hi Anil,

In oracle apps => concurrent requests window we have the option to schedule a request and save the schedule also.
I have a requirement. By using a plsql script I have to create a schedule, attach it to a concurrent request so that it runs periodically. Also I should be able to update and cancel an existing schedule.
I have to create around 4 functions (create schedule, submit request, update schedule and cancel schedule). Can I use fnd_request package routines ? If yes, which ones ?

Pls suggest.

P.S : I tried to use Fnd_Request.Set _Repeat_Options . It creates a default release class on its own and so I am unable to specify a schedule name.

Thanks,
Sam
Quote
0 #47 hari Kishan 2007-12-04 10:18
While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions
Quote
0 #48 Sten Vesterli 2008-01-15 12:59
Under Windows (with MKS Toolkit), you would create the link with
ln %FND_TOP%in nd cpesr.exe XXCONC.exe

NTF S under Windows 2003 server does not support symbolic links
to individual files - that's why it's a hard link. Also remember
to call the link .exe - otherwise, Windows will refuse to
execute it.
Quote
0 #49 anonymous 2008-01-16 10:12
Hi anil,
I was new to oracle apps.how can i see where all the records are get saved when we save them.plz help me.
Quote
0 #50 vasavi 2008-01-17 02:37
hi anil,

I was new to oracle apps.how can i see where all the records are get saved when we save them.plz help me.And also plz can u tell me the books which i can refer to make my basics strong in apps.
Quote
0 #51 Manish Sharad 2008-01-22 15:29
Hi Anil:

Its a good effort from your side, appriciated.
I just want help regarding what is the best documentation or the braindump test questions for the the OCP expert exams, i am planning to appear exam code 1ZO-232 system Admin, for Oracle Business Suite.

Thanks
Quote
0 #52 Shekar Suman 2008-01-23 14:35
This is the best way to learn new things about subject.
Quote
0 #53 Shekar Suman 2008-01-23 14:39
How to call shell script concurrent program (having one parameter) in another concurrent program
Quote
0 #54 sreekanth munagala 2008-03-17 06:41
Hai Anil,
I have some queries regarding this article.
In the screen we get while defining executable,
the re is one option called SHORTNAME.
Why do we need this SHORTNAME?
what is the difference between executable and execution file name?
Quote
0 #55 Anil Passi- 2008-04-26 18:42
Hi Sree

Shortname is the identifier of the concurrent executable, lets say a tag.

The actual executable could be a java file or pl/sql etc.
Name of that actual physiscal executable may or may not be the same as tag of the program, i.e. short name

Thanks
An il
Quote
0 #56 Valeria 2008-05-19 15:06
Hello Anil,
What happen if we define the printer name, print style, print type ect in our PROCEDURE? Will it over write the printer information in the concurrent program submitt form?
Quote
0 #57 Anil Passi 2008-05-19 15:23
Hi Tuan,

Indeed, pl/sql API set print option will override concurent program definition

Tha nks
Anil
Quote
0 #58 Santosh Sharma 2008-05-27 02:20
Hi Everyone,

We have a workflow which we want to schedule to execute on the last friday of every month.

We've tried all the permutations and combinations in the Schedule Request form, in the periodic section, if we select last day and Friday, the request is scheduled for each friday and also on the last day.... On clicking the Apply saved schedules button we get
a LOV of some saved schedules. This list has an entry which says "Last working day on or before 15th of every month". This is similar to our requirement. But on selecting this option, we can't determine how this schedule has been defined.

Want your help in getting this request scheduled. Thanks in advance.

Regar ds,
Santosh
Quote
0 #59 Erick T 2008-07-28 09:45
Hello everybody, I need some help, Is it possible to transfer text files from the client (I mean the end user) using a concurrent program, If so, how can I do this?

Thanks in advance
Quote
0 #60 Erick T 2008-07-28 09:55
I almost forgot, Is it possible to do the same but viceversa, the latter question is becouse I need to process a csv file, but also I need to do a store procedure which produces a list of files

Best Regards
Quote
0 #61 koppulasandhya 2008-08-21 08:15
Hi Anil,
Is it possible to access the out_chr_err_buf and out_num_ret_cod e parameters after the concurrent request is completed?
To be more clear, suppose if I submit the request using fnd_request.sub mit_request and assign some value to out_chr_err_buf will I be Able to use that value after the concurrent request is completed?

Tha nks & Regards,
Sandhy a
Quote
0 #62 PreethiS 2009-06-29 11:41
Hi,

I have a request set, which has 2 concurrent programs, one of them is a report and the other is unix script to email the report generated in 1st request.

The report takes the first and last dates of the previous month as its parameters.

I scheduled to run this request set on the first of every month and to increment its date parameters, but unfortunately its not incrementing the date parameters of the 1st request in this set and it is taking the parameters when it was first scheduled.

The set was first scheduled to run on 1st May, so it would take 1st April and 30th April as its parameters for the 1st request. Then again when it ran on the 1st of June, it again took the same params as 1st and 30th April even though the Increment date parameters check box is selected when scheduled.

Tha nks,
Preethi.
Quote
0 #63 venki R 2009-11-19 05:34
hi

i have written an even alert which will trigger my concurrent program.here i want to pass a the output parameter of the alert as input to the concurrent program and inturn the same parameter to my pl/sql stored procedure.

ple ase help me out in this regard.

thanks
R.Venki
Quote
0 #64 Sravana 2010-09-27 02:49
Hi Anil,

My requirement is to pick up multiple files from one unix server and process them using a concurrent program. For one file it is working fine. When I run the concurrent program, it is successfully picking up the data from the specified Unix location and processing it successfully. Now I need to pick up multiple files from the same location based on the starting 4 letters. Could you please let me know how to do it? Thanks in advance.
This concurrent program picks up inpun file and passes this as input to a control file. So, please help me on how to read multiple input files and send these as input to the control file.

Thanks
S ravani
Quote
0 #65 Vikrant 2011-04-07 00:31
Hi,
can anyone please help me in writing a plsql procedure for submitting a concurrent program.
Quote
0 #66 MUDS 2011-09-19 07:19
Hi Vikrant,
You can execute a PL/SQL procedure using concurrent program but you cannot write a PL/SQL procedure to execute a concurrent program
Quote
0 #67 Saiprasad Khisti 2014-11-16 13:16
Hi Anil,

I have a concurrent program scheduled with Advanced option set .I want to cancel this schedule and set a new schedule. But I am not getting the pending request in the list so that I can cancel the request.

As per my knowledge we get Advanced option set in "Run As Job" , when we apply a saved schedule . Can you please tell me how to cancel such a schedule ?

Thanks&Regards,
Saiprasad
Quote
0 #68 Simvu 2015-02-03 12:13
Hi
We use an ftp script to fetch a flat .txt file from an external server to an EBS application server by means of running a concurrent program using two input parameters (server path and file name). The challenge is that, the file name is different for each file and the scheduled concurrent program should always run the latest file from the application server. How should we command the program to always execute the latest file?
Quote
0 #69 puneeth 2015-02-20 16:18
hi, venkat oracle apps is three-tier architecture
1.front-end (end user)
2.application tier(middle tier)
3.database tier (back end)

when u compile a procedure it stores in database tier as a schema object u can access it in front-end .so,there is no need to transfer the procedure to application tier .but if u write any script.sql it need to transfer to application tier (sql folder)
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner