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
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.