[Oracel ebs]How to create Concurrent Program

Reference source:

https://www.youtube.com/watch?v=Qjjyraip4DM

http://www.bizinsightconsultingblog.com/2009/06/how-to-create-concurrent-program-on.html

 1. what is concurrent?

2.Concurrent Program Type

PL/SQL Store Procedure | PLSQL

Oracle Reports | SQL/PLSQLL

Host | Shell Script

SQL*Loader | SQLLoader Control File

SQL*Plus | SQL/PLSQL

Java Concurrent Program | Java

-------------------------------------------------------------------

Step:

1. Executable

2. Concurrent Program

3. Attach Concurrent Program with Request Group

-------------------------------------------------------------------

Create Executable

    Concurrent : Program : Executable

Executable

Enter all the details for Executable

Short Name

Best Practice is Short Name of Executable and concurrent program Schedule be same

Subroutine Name

For example: define executable for store procedure

Create Executable  

    Concurrent : Program : Define

  

Program

Enter the name for CP. Check the enable check box.

Short Name

Enter Name for CP Short Name should be same as short name of executable.(It's Best Practice)

Executable-Name

Select executable name from LOV.

Output-Format

Select the output format for CP.

Parameters

    1.Select the Value Set .

    2.Default Type.

    3.Default value for Set

    4.Default Value.

    

Attach Concurrent Program with Request Group  

Security : Responsibility : Request

After Saving the Concurrent Program, Attach it with required Request Set.

Choose the group where you want to attach CP

Add Concurrent program