| Oracle Alert errors out when called from PL/sql [message #557723] |
Fri, 15 June 2012 02:39  |
maggy_ashee
Messages: 70
Registered: May 2007
|
Member |
|
|
Hi All,
We are facing a problem when we call Oracle Alerts from PL/SQL pkg.
It errors out with below error message:
'program was terminated by signal 11'
Our script is as below:
declare
v_alert_id NUMBER(10);
v_appl_id NUMBER(10);
order_number varchar2(30):='155';
x_conc_id number(15);
begin
MO_GLOBAL.SET_POLICY_CONTEXT('S','99');
FND_GLOBAL.APPS_INITIALIZE(0,111,2222);
SELECT alert_id,application_id
INTO v_alert_id,v_appl_id
FROM ALR_ALERTS
WHERE alert_name='Task';
x_conc_id := fnd_request.submit_request(
'ALR'
, 'ALECDC'
, 'Task' --alert name
, '' --start date
, FALSE
, v_appl_id -- appln id
, v_alert_id -- alert id
,'A'
,'Mail'
, order_number
, chr(0)
);
dbms_output.put_line(x_conc_id);
commit;
end;
|
|
|
|
|
|
| Re: Oracle Alert errors out when called from PL/sql [message #557729 is a reply to message #557724] |
Fri, 15 June 2012 04:02  |
maggy_ashee
Messages: 70
Registered: May 2007
|
Member |
|
|
After running the PL/SQL script, a request is submitted for the alert 'TASK'. The request for ALERT ends in ERROR and the log for the request shows the following message:
/aplic/d6applbr/appl/alr/12.0.0/bin/ALECDC
Program was terminated by signal 11
Please let us know why this message appears.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
