How To Run Concurrent Program From Back end (Psql) and notify to USER
You can Run Concurrent program from backend by using FND_REQUEST.SUBMIT_REQUEST API. And By using FND_REQUEST.ADD_NOTIFICATION API You can send notification mail to particular User. Below given script is used for one of my client place where we want to run concurrent program from backend. First you have to initialize apps by using API fnd_global.apps_initialize. script output gives you concurrent program request id. which you can check from front end. ******************************************************** create or replace procedure XXFNDREQPROC AS v_request_id number; v_request_id1 number; v_request_id2 number; v_request_id3 number; v_request_id4 number; v_request_id5 number; v_notify_user boolean; l_user_id NUMBER:=0; l_responsibility_id NUMBER:=55550; l_resp_appl_id NUMBER:=222; P_ORG_ID NUMBER; begin fnd_global.apps_initialize(l_user_id,l_responsibility_id,l_resp_appl_id); mo_global.init ('S'); v_notify_user := FND_REQUEST.ADD_NOTIFICAT...