Tutorials
Oracle Apps
Oracle Apps Concurrent Processing
Oracle Apps Concurrent Processing - Page 2
Oracle Apps Concurrent Processing - Page 3
Oracle Apps Concurrent Processing - Page 4Oracle Apps 11i Free Training : Concurrent Processing : This document talks about the concurrent processing in oracle applications. It will give the step-by-step procedure of creating concurrent programs in oracle applications. All types of concurrent programs are described in detail. Concurrent programs can be scheduled to run or manually run in oracle applications. In Oracle Applications, concurrent processing simultaneously executes programs running in the background with online operations to fully utilize your hardware capacity, hence the name ‘Concurrent Processing’. You can write a program (called a ”concurrent program”) that runs as a concurrent process. Typically, you create concurrent programs for long–running, data–intensive tasks, such as posting a journal or generating a report.
A concurrent program is an instance of an execution file, along with parameter definitions and incompatibilities. Concurrent programs use concurrent program executables to locate the correct execution file. Several concurrent programs may use the same execution file to perform their specific tasks, each having different parameter defaults and incompatibilities.
A concurrent program executable links an execution file or and the method used to execute it with a defined concurrent program. Under Concurrent Processing, an execution method may be a program written in a standard language, a reporting tool, or an operating system language.
An execution method can be a PL/SQL Stored Procedure, an Oracle Tool such as Oracle Reports or SQL*Plus, a spawned process, or an operating system host language.
A concurrent program execution file is an operating system file or database stored procedure which contains your application logic and can be executed by either invoking it directly on the command line or by invoking a program which acts upon it. For example, you run a Pro*C program by invoking it on the command line. You run a SQL script by running SQL*Plus and passing the name of the SQL script without the .sql extension.
The first step in creating a concurrent program in oracle applications is to create the concurrent program executable. To do this, navigate to Application Developer responsibility after you login to Oracle Applications. To login, you can take the help of the ‘Topic11 - Oracle Applications Login Document’.
To open the Executable form follow the below mentioned navigation path.
Application Developer à Concurrent à Executable.

Figure 1. Executable Form Navigation
You will see the form as shown in figure 2 below.

Figure 2. Executable Form
i) Executable - Enter executable name here. Enter any user friendly name.
ii) Short Name - Enter short name for your executable. This is used for mapping the executable with the concurrent program. Usually executable name are of 8 characters.
iii) Application - Give the application to which the executable belongs to. E.g. you want some program to run from oracle payables then account payables should be entered as application name.
iv) Description - Give the brief description of the executable in this field.
v) Execution Method - Here you need to choose the appropriate execution method for your executable. Following are the possible execution methods which are commonly used in oracle applications.
PL/SQL Stored Procedure, Oracle Reports, Host, SQL*loader, SQL*Plus are the most commonly used executable types.
vi) Executable File name – This should contain the name of the executable file. In case of PL/SQL Stored procedure or Java Stored Procedure it should be the fully defined name of the stored procedure.
vii) Subroutine Name – This field is only used when executable type is spawned or immediate.
viii) Execution File Path -
ix) The Stage Function Parameters button opens a window that allows you to enter parameters for the Request Set Stage Function. This button is only enabled when you select Request Set Stage Function as your Execution Method.
Next Page: Oracle Apps Concurrent Processing - Page 2
| Nice one |

| Good One |
| Very Informative.... Keep up the good work..... |
| A very good article for oracle developers those who work on development environment |
| your are excellent..... ;) |
| Very neatly explained step by step |
| Excellent Article very Good |
|
This material is gud, But give detailed description of each field Its better to learn more for beginners |
| Very Good site. Well laid out with good examples. Much easier to use than the official documentation. |
| Way the explanation is given, really useful for beginners and whoever wants to refresh their knowledge. |
| Good information. If will be even better if it includes how to set email notification should the concurrent process fails. |
| u can add the complete slide shots upto the report or forms execution in apps . thank you |
| Good informationm,can u give some more information like if a concurrent program is running from a long time,what may be the problem.Actually it has to complete the same in the minutes.So please can u clear me what may be the issue,and where we can have a look ... |
|
Hi, I am using java concurrent Program to call shell script. In Shell Scrip i want APPS user name and Password,to exucute SQLLoader Command. IF we use Host Conncurrent program, we getUSer name and password directly. any idea how i can get this in java concureent program. Thanks, Prashant |