EBS Customizations (MOSC)

MOSC Banner

Submit Oracle Alert through plsql code

edited Apr 10, 2019 1:55PM in EBS Customizations (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center