How to Create a Concurrent Program in Oracle Apps.

Now I discuss with you How to Create a Concurrent Program in Oracle Apps.

We Create a concurrent program which execution method is PL/SQL Stored Procedure.


Step 1:- First we create a stored procedure in database.
      Ex:-
                 CREATE OR REPLACE PROCEDURE XXC_HELLO_PROC
                                                                                                                   (
                                                                                                                   ERRBUFF OUT VARCHAR2
                                                                                                                , RETCODE OUT VARCHAR2
                                                                                                                  )
               IS
               BEGIN
               FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'HELLO ORACLE');
               END XXC_HELLO_PROC;

   ERRBUFF and RETCODE are the mendetory parameter.

Compile that procedure in database.

Step 2:- Now we create login Oracle Apps.

Step 3:- Select the Application Developer Responsibility.

Step 4:- Open the Executable Form

        Navigation :- Application Developer Responsibility -> Concurrent -> Executable

Step 5:-
  a)  Give the name of Executable(Which is Display for User).
  b)  Give the short name of Executable(for Back end).
  c)  Chose Application Name in which we want to register these Executable(we select "Work in Process").
  d)  Give Description(Its is not mandatory field).
  e)  Chose Execution method Name from LOV. (we select  PL/SQL Stored Procedure)
   f)  Give the procedure name in Execution File Name field.
   g) Save it.


Step 6:- Open the Concurrent Program Form
       
           Navigation :- Application Developer Responsibility -> Concurrent -> Program

Step 7:-
 a) Give the Concurrent Program Name(Which is Display for User).
 b) Give the short name of Program(for Back end).
 c) Chose Execution method Name from LOV. (we select "Work in Process")
 d) Give the Executable Short name in Executable name,which is created in above step.
 e) Save it.


Step 8:- Go to System Administrator Responsibility

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

Step 9:- Attach those Concurrent program in your request group.
 a) In name field give the concurrent program name and save it.

Step 10:- Select our responsibility which is assign on our user.

Step 11:- Now we submit our Concurrent program.
     
              Click on View from menu bar then click on request.
              Click on Submit a New Request button,select Single Request then press Ok button.
             Give Concurrent program Name, press Submit Button.Press No and find.
Now we see our concurrent program in SRS window.

Step 12:- See Output
     Click on View output button and see Output "HELLO ORACLE".