How to create Concurrent Program in Oracle Applications.

In this blog I will explain with diagrams how to create concurrent Program in Oracle Apps .
Below are simple steps to create

1. Executable
2. Concurrent program and then
3. Attach Concurrent Program with Request Group.

Login as Sysadmin or Application Developer

Create Executable:-

Application Developer -->Concurrent-->Executable and enter the details.

 





Different type of execution Method.

1. Reports - .rdf
2. SQL * Plus - .SQL
3. PL/SQL Procedures - .pkb / .pks
4. SQL * Loader file - .ctl
5. Java Structured Procedure - .java / .class
6. Host(UNIX) - .sb
7. Spawned
8. Immediate
9. Java Concurrent Program
10. Request set stage Function
11. Multi-Language Function.

Create Concurrent Program

Application Developer -->Concurrent--> Program.

• Navigate to concurrent program (CP) screen.
• Eneter Name for CP.Short Name should be same as short name of executable.(It's Best Practice).
• Check the enable check box.Select executable name from LOV.
• Select the output format for CP.

• Define Parameter. For each Parameter
  1.Select the Value Set .
  2.Default Type.
  3.Default value for Set
  4.Default Value

• After Saving the Concurrent Program, Attach it with requied Request Set.
• Choose the group where you want to attach CP
• Add Concurent program 
• Attach it with requied Request Set
 

Go to Sysadmin Responsibility.

Security --> Responsibility --> Request

Request group finding query: 

 select * from fnd_responsibility_vl where responsibility_name like '%PO%CONTROL%'

select * from fnd_responsibility where REQUEST_GROUP_ID = 1468
         
select * from fnd_request_groups where request_group_id =1468

To attach the request group through TOAD:

BEGIN
fnd_program.add_to_group ('MASPAWOHIST'
,' Custom Application Name'
,'All Project Billing Programs'
,'Projects');
COMMIT;
DBMS_OUTPUT.put_line ('Done');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line ('Object already exists' || SQLERRM);
END;