How to register a concurrent program in Oracle apps

In this post, we will learn to register a concurrent program in oracle apps. We are going to register a report as a concurrent program.

Steps in brief-

1. Develop a report to register as a concurrent program
2. Define Executable: Link it to Report file(.rdf) created
3. Define Concurrent Program: Link to it executable defined in previous step
4. Enter Parameters and link Value Sets
5. Assign the registered Concurrent Program to a request group

1. Develop a report to register as a concurrent program

Firstly develop a report and move/copy it on Application server.

Please refer below link will show you how to develop oracle report and move it on Application server. 

    Oracle reports tutorials

2. Defining Executable:

   Navigation: Login into Oracle Applications

            -> Go to System Administrator/Application Developer Responsibility

               –> Concurrent

                 –> Program

                    -> Executable

Fields-

Executable: User Understandable Name

Short Name: Unique name or system reference

Application: Under which application you want to register this Concurrent Program

Description: Description for executable

Execution Method: Your file has to be placed in respective directory or database based on this field.

Execution File Name: This is the actual executable file name. If you register a PL/SQL Procedure you have to give the packagename.procedure. You don’t need to specify any parameters in procedure here.

   

Action: Save the changes

3. Define Concurrent Program:

    Navigation: System Administrator –> Concurrent –> Program -> Define

Fields:

Program: User Understandable Program/Report Name

Short Name: Unique name for system reference

Application: Enter the application under which you want to register this concurrent program

Executable Name: Search for the executable created above.

Method: This will be populated automatically from Executable Definition

Output Format: Select the format for the output

Output Style: Select A4 to print on A4 Paper

4. Define Parameters :

Note- In my previous Oracle Report development post there were not any parameters for the report so this step is not applied to the program which doesn’t have parameters. We have to use this step when we want to take parameters from user while running concurrent program. Let’s say if user wants to have sales order number parameter so that he can get those particular sales orders details. To do so we have to define parameter as below.

Fields:

Seq: It is always better to enter sequences in multiple of 5 or 10. So that you can insert any additional parameters if you want later in middle.

Parameter: Name the Parameter Field and it's for system reference.

Description: You can see this description while submitting the concurrent program.

Value set: '10/Numbers' is the standard value set for Number input parameters

                Default Type: If you want to default any particular value while submitting the concurrent program.

                Current Date : Used to pass the Sysdate as default value

                Current Time : Used to pass the Systime as default value

                Constant     : Used to pass the constant number or date or string as default value

                Segment      : Used to get the Previous parameter value as default to the next parameter

                SQL Statement: We can pass the SELECT statement result as default value

                Profile : used to pass the user profile value as default like userid ,username,respid, respname and so on.

Required CheckBox : Used to make the parameter as mandatory or optional

Enabled  CheckBox: Used to enable or disable the parameter

Display  CheckBox: Used to hide or display the parameter

Prompt: This is the actual message displayed while submitting the concurrent programs.

Token: Used to link this parameter to the parameter defined in actual report file(.rdf)

Action :Save

5. Assign the registered Concurrent Program to a request group

Find the request group name for which we are going to attach out program

Query the responsibility and application

Navigation: System Administrator -> Security –> Responsibility –> Define

Navigation: System Administrator -> Security –> Responsibility –> Request

Query the Request Group name - 

Add records with the type Program and enter our program name.

Action : Save

Now we can run the program from Order Management Super User responsibility.

You can view the output for this program by clicking on View Output button.

Output for this report is - 

Posted in: r12