How to Register the Concurrent Program in oracle apps

How to Register the Concurrent Program in Oracle Apps

Overview

=======

  GOTO SYSTEM ADMINISTRATOR

•    Create executable as PL/SQL Stored Procedure
•    Create Concurrent Program and attach the executable
•    Attach the Concurrent program to Request Group
•    Attach Request Group to Responsibility
•    Run the request from Responsibility

Steps to Register the Concurrent Program

===============================

Step:1

Creating Executable:

Navigation: Login into Oracle Applications –> Go to Application Developer Responsibility –> Concurrent –> Executable

Here we will register PL/SQL Procedure as a concurrent program

FIELDS:

======

Executable: This is User Understandable Name

Short Name: This is Unique and for system reference

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

Description: Description about concurrent program

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. 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

Step:2
Create Concurrent Program:
    Navigation: Application Developer –> Concurrent –> Program

If you have any parameters, you can add by clicking parameters option and enter the list of parameters and their data types and also check the box as mandatory/optional columns etc,Otherwise skip this parameters step and continue the process.

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 concurrent program

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.

Step:3

 Attach the Concurrent program to Request Group:

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

Action: Open/Double click

Action: Press F11

            Give the Request Group Corresponding to the responsibility

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 "SYSTEM ADMINISTRATOR" Responsibility having ”System Administrator Reports” as Request Group.

Step:4
Run the Request from Responsibility:
Switch to Responsibility Tab and select the responsibility where your concurrent program has been Attached and click view->Request->Submit request

Give the Concurrent Program and press tab then you can able to submit the program