How to create and register a concurrent Programme (Oracle Apps / EBS )

1. First Develop a  PL/SQL Package (to register as a concurrent program)

2.Create Executable: Link it to PL/SQL Package created

3.Enter Parameters and link Value Sets

4.Assign the registered Concurrent Program to a request group

Now Steps to register Concurrent Programme :

Creating Executable: (This is after Pl/sql Procedure is created)

Navigation: Login into Oracle Applications –> Go to Application Developer Responsibility –> Concurrent –> Executable           (Now we will register pl/sql package or oracle report as a concurrent program)

Executable  : This is User Understandable Name
Short Name  : This is Unique and for system reference
Application : Under which application you want to register this Conc. Program
Description : Description
Execution Method: Based on this field, your file has to be placed in respective directory or database.
Execution File Name : This is the actual Report file name.

Note:
If you register a PL/SQL Procedure in a package you have to give the packagename.procedure. You don’t need to specify any parameters in procedure here.
Action: Save

Create Concurrent Program:

Navigation: Application Developer –> Concurrent –> Program


FIELDS:

Program: User Understandable Program Name
Short Name: This should be unique name and for system reference
Application: Enter the application under which you want to register this conc prog
Executable Name: Enter the User Understandable Executable Name
Method: This will be populated automatically from Executable Definition
Output Format: Select the format of the output you want
Output Style: Select A4 to print on A4 Paper
Printer: You can default any printer or you can enter while submitting concurrent program.


Assign this Concurrent Program to a request group:

Navigation: Switch to “System Administrator” Responsibility –> Security –> Responsibility –> Request

Action: Open/Double click

Action: Press F11
enter Purchasing%

Action: CTRL+F11

Action: Select the First record in the “Requests” and then File –> New

Action: Enter Your User Readable Name of your concurrent program

Action: Save

Now Your Concurrent Program is ready to use from the responsibilities having” Purchasing Reports” as Request Group.

Go to the SRS Window (View->Request->Submit) and submit request and view details(result) of the request once completed 

Steps to Register Oracle Reports in Oracle Apps / EBS

STEPS REQUIRED FOR REGISTERING A SIMPLE REPORT

1. Create a Report using Report Builder.
2. Compile and copy .RDF file in module specific directory.
3. Register the executable with System Administrator Module.
4. Define the Concurrent Program.
5. Assign the executable to Concurrent Program.
6. Assign the Concurrent Program to desired Request Group.
7. Assign the Request Group to the desired Responsibility.
8. Assign the Responsibility to the desired User.

STEPS REQUIRED REGISTERING PARAMETRIC REPORTS

1. Create a Report using Report Builder with parameters.
2. Compile and copy .RDF file in module specific directory.
3. Register the executable with System Administrator Module.
4. Define the Value set to validate the parameters.
5. Define the Concurrent Program.
6. Assign the executable to Concurrent Program.
7. Define Parameters.
8. Assign Value Set to the Parameters.
9. Assign bind parameter of yours to the TOKEN.
Note: Token is used to map bind parameters with the formal parameters of the Concurrent Program.
10. Assign the Concurrent Program to Request Group.
11. Assign the Request Group to the Responsibility.
12. Assign the Responsibility to the User.

To reference the values of Prior Parameters of a particular program into the values of other parameter is based on the Value Set.
The value of the 1st parameter is to be referenced in where clause of the 2nd Parameter.