Download Spawned Concurrent Program
Concurrent Programs in Oracle AppsThis website has now moved toConcurrent Programs in Oracle AppsWritten by Anil PassiWednesday, 25 October 2006An article on very basics of Concurrent Program, for beginners that followLets first discuss the below scenarioBeing 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 scriptA Sql.Loader programJava programOracle ReportPl/SQL program ( or call it a stored procedure/package procedure)Host script, like a unix shell scriptPro.C/SpawnedPerlQuestion: What are the basic steps when defining a concurrent program.Answer: Broadly speaking there are three steps when developing a concurrent program in Oracle AppsStep 1. Make Oracle Apps identify the executableStep 2.
Provide a handle to the executable by means of defining a concurrent programStep 3. Make this concurrent program accesible to selected users via their responsibility.Question: Please can you describe the above steps in detailAnswer:Step 1. Make Oracle Apps identify the executableIn 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/sqlcreate table xxhelloworldtab(messagetext VARCHAR2( 100 ),creationdate DATE);CREATE OR REPLACE PROCEDURExxregisteruserprc(errbuf OUT VARCHAR2,retcode OUT VARCHAR2) ISBEGININSERT INTO xxhelloworldtab VALUES ( 'Hello World', SYSDATE);END xxregisteruserprc;SELECT. FROM xxhelloworldtab;-Zero records will be returned here2. Note the two parameters, namely errbuff and retcodeThese 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/Executable4. Define the concurrent programThis can be done by navigating to responsibility “Application Developer” and then selecting menu /Concurrent/Program5. Attach this program to a report group.Go to System Administrator responsibility, and select/Security/Responsibility/RequestNow, we can navigate to the Receivables Manager and submit the concurrent request.After the completion of the request, we check the table. 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?Thank you,Eugene. 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?Thank you,Eugene. Hi EugeneI 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.Assuming that I understood your qns correctly:-1. I guess your outsourcing company is using FNDLOAD to download the concurrent program definitions.FNDLOAD is described herecreates text files, that can be uploaded in a new environment.2. You usually never create DB Links frm PRD to DEV environment.The 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.Thanks,Anil Passi. Hi EugeneI 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.Assuming that I understood your qns correctly:-1. I guess your outsourcing company is using FNDLOAD to download the concurrent program definitions.FNDLOAD is described herecreates text files, that can be uploaded in a new environment.2. You usually never create DB Links frm PRD to DEV environment.The 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.Thanks,Anil Passi.
Hi Anil PassiI 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 thatjava.lang.ClassNotFoundException: testOracle.OracleTestProgramNewat oracle.apps.fnd.cp.request.Run.main(Run.java:117)I have set the JAVATOP and AFCLASSPATH upto that testOracle parent Directory.still I am getting the same exception.could u please sugget me to where I must palce the java class file and its further settings?Thanks in advance.HariKrishana. Hi Anil PassiI 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 thatjava.lang.ClassNotFoundException: testOracle.OracleTestProgramNewat oracle.apps.fnd.cp.request.Run.main(Run.java:117)I have set the JAVATOP and AFCLASSPATH upto that testOracle parent Directory.still I am getting the same exception.could u please sugget me to where I must palce the java class file and its further settings?Thanks in advance.HariKrishana.
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 fndrequest package routines? If yes, which ones?Pls suggest.P.S: I tried to use FndRequest.SetRepeatOptions. It creates a default release class on its own and so I am unable to specify a schedule name.Thanks,Sam.
Concurrent Program Pl/sql Stored Procedure
Attention, Internet Explorer UserAnnouncement: Oracle Community has discontinued support for Internet Explorer 7 and below.In order to provide the best platform for continued innovation, Oracle Community no longer supports Internet Explorer 7.Oracle Community will not function with this version of Internet Explorer. Please consider upgrading to a more recent version of Internet Explorer, or trying another browser such as Firefox, Safari, or Google Chrome.(Please remember to honor your company's IT policies before installing new software!).