The Software Professionals: Creation of Concurrent Program in Oracle apps

Define a Concurrent Program Executable:

Navigation: System Administrator => Concurrent => Executable

Figure 1: Executable form navigation

Figure 2: Executable form

1. Executable –In this field we enter executable name. try to enter user friendly name which can easily remembered.

2. Short Name – In this field we enter a short name for the executable and this name is used for mapping the executable with concurrent program.

3. Application – name of application from where we want to run this executable.

4. Description: brief description about the Executable.

5. Execution Method – type of program which we want to run, Oracle stored procedures/oracle reports. We can choose one from LOVs.

6. Executable File name – This field contains the name of the file of the executable.

7. Subroutine Name – In case of spawned or immediate type of executable we use this field.

8. Execution File Path –Path of the executable which we want to execute.

9. The Stage Function Parameters- This button is only enabled when we are selecting request set stage function as our execution method. In this case it opens a window which allows us to enter parameters for request set stage function.

Define a Concurrent Program

After defining concurrent program executable next step is to define concurrent program.

Navigation: System administrator => Concurrent => Program

IF oracle stored procedure requires any input parameter. We need to define parameters

Description:

Program: name of the program which will come while submit the request.. While submitting the request this name will be displayed in Requests submission screen.

Short Name: short name to our concurrent program.

Application: name of the application to which the concurrent program belongs.

Description: description about the concurrent program.

Executable: the short name of the executable (which we have defined in the Executables screen) to which we want to attach to the concurrent program.

Method: no need to enter. It will automatically come

Options: Same as method it will be also defaulted once we enter executable’s short name.

Request Type: If we want only few concurrent managers to run our concurrent program then we can associate our concurrent program to a predefined request type.

Incrementor: Is to be used by Oracle only.

MLS Function: This feature allows developer to submit the program once but it runs the program in the multiple languages.

USE in SRS: If we want our concurrent program to be available in the Standard Request Submission through the request group then we have to check this checked box.

Allow Disable Value: This field is used to allow us to use disabled values in the value set while entering the values of the parameters in the concurrent programs.

Run Alone: This field if is checked then it indicates that the program is in compatible with all other concurrent programs and should be run alone.

Enable Trace: If this check box is checked then it will enable the SQL trace for the concurrent program and will generate the trace file when concurrent program is run.

Restart on system Failure: If this field is checked it indicates that if the system fails at any point of time and once the concurrent manager is recovered the system should start automatically.

Output Format: It can be in any form like HTML, PDF, TEXT, PS (Post Script).

Save: If this field is check then it indicates that the output of the execution will automatically get saved in the file.

Print: is checked if we want our output to be sent to the printer for printing.

Style Required: Print Style.

Printer: Is the particular printer to which output has to be send.

Assign the concurrent program to Request Group:

First search for a group name

SECURITY=> RESPONISIBILITY=> DEFINE