How to Create Concurrent Program in Oracle Apps |Oracle E-Business Suite

Create and register a concurrent program in oracle apps

Oracle applications is all about the concurrent program, most of the activities are performed by concurrent programs, so let’s see how to create a concurrent program in oracle apps

Here the question arises what is the concurrent program?

A concurrent program is an executable file, if you want to perform an activity such as generating a report, creating invoices, posting a journal and etc. these all tasks can be done by creating an executable file, an executable file can be anything such as PLSQL code, oracle reports, HOST, Java program and etc.

Here are the steps to create an executable and register that executable file as a concurrent program.

 Create a sample table as shown below

      

  Create a package specification as shown below

Note: Make sure to give two mandatory parameters ERRBUF and RETCODE, Otherwise your program will complete in error.

                ERRBUF is used to store the standard oracle errors

                RETCODE gives the program status; there are three values for RETCODE.

                                0: Program completed successfully without any error.

                                1: Program completed with warning.

                                2: Program completed with error.

  Create a package body as shown below

  Now you are ready with your PLSQL executable file, Now login to the oracle application and follow the below steps.

Navigation

                 System Administrator

                                Concurrent  

                                             Program

                                                             Executable.

You will get the below screen; input all the below details.

Executable: give the executable and remember it, you have entered an executable name in DEFINE stage.

Short Name: give the short name the same as the executable name.

Application: Your custom application name.

Execution Method: if you are registering a PLSQL program then select PLSQL Procedure from the drop-down list else select the appropriate value.

Execution File Name: Give the executable file (Refer Screen Shot)  name which is created above.

After entering the entire details click on the save icon, now you have successfully created the executable.

 Now you have to define the concurrent program, follow the below steps.

  Navigation

                System Administrator

Concurrent 

 Program 

 Executable.

You will get the below screen; Enter all the details are shown below. 

Note: The executable name should be the same as the executable name given in the executable section.

 Now attach the concurrent program to Request Group as shown below.

    Navigation:

                 Security 

                             Responsibility 

 Request.

  Now run the program and check the output

    

Data Inserted in the below table.

 That's it guys 

Click here for Adding concurrent program to a request group