Call Concurrent Program through Alerts Event Based

Requirement :-  In the AP Form Payment has done (AP_CHECKS_ALL Table has trigger) call the Concurrent Program.


Steps

1) Make sure Your Concurrent Program has Ready
Assume that in your program having 1 parameter

2) Go to Alert manager => Alert => Define
    Alert Form will open

3)

Application :-  payables (because of your Concurrent program is in payables or you have to do alert on payable tables)

Name:- XXDM_AP_TEST_ALT
Application:- Payables
Table:- AP_CHECKS_ALL (this table we have to trigger Update and Insert time)
click on checks box both or any one as per requirement

In the Select statement Add Query

SELECT CHECK_NUMBER INTO &C_CHECK_NUMBER FROM AP_CHECKS_ALL
WHERE ROWID=:ROWID

Note:- You can add condition also in SQL Query

4) In the Action

Action Name :-  XXDM_AP_TEST_ALT

5) In the Action Details

Action Type :- Concurrent Program
Application:- Payables
Program Name :- DM AP Program Alert Testing   (Concurrent Program Name)
Arguments :- "&C_CHECK_NUMBER"  (this is the variable used in SQL Query for pass the data to concurrent          program parameter)

6) Save It

7) In the Action Set 

Seq:- 1
Action Set Name :- XXDM_AP_TEST_ALT
Enabled :- Checked

8) In the Action set Details 

Output and Members Tab Data Comes Automatically

9) In the Alert Details 

Output Tab Data Comes Automatically

and in Installation 

Oracle Id:- Apps
Operating_Unit:- Vision Operations (Operating Unit name)
Enabled :- Yes


Now Save It.

Now Create The AP Invoice and Make the Payment and check the CP has Called or Not.