Submit Oracle Alert through plsql code
Hi,
i am trying to submit oracle alert through plsql code and block completed successfully. But i am not getting the results and output showing as '0'.
i am using below code. Please help me on this.
declare
v_req number(5);
Begin
v_req :=fnd_request.submit_request('ALR', -- Application Short name of the Concurrent Program/or for Alerts it is ALR
'ALECDC', -- hard coded Program Short Name for Alerts
'XXSD_NEW_USER_ALERT', -- Description of the Program.--- alert_name col from table alr_alerts for your alert name'
SYSDATE, -- Submitted date. Always give the SYSDATE.