Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Alert errors out when called from PL/sql
Oracle Alert errors out when called from PL/sql [message #557723] Fri, 15 June 2012 02:39 Go to next message
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 #557724 is a reply to message #557723] Fri, 15 June 2012 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 59984
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
'program was terminated by signal 11'


This is NOT an Oracle message.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: Oracle Alert errors out when called from PL/sql [message #557729 is a reply to message #557724] Fri, 15 June 2012 04:02 Go to previous messageGo to next message
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.
Is it able to pass parameters for submitting oracle alert [message #557755 is a reply to message #557723] Fri, 15 June 2012 08:53 Go to previous messageGo to next message
rponmani
Messages: 13
Registered: April 2012
Location: Chennai
Junior Member
In PL/SQL procedure I am submitting an alert through FND_REQUEST.SUBMIT_REQUEST. I am passing a value to the alert.
But the request for alert ends in error. The log shows the error message as "Program was terminated by signal 11".

If I submit the alert without passing parameter the alert ends successfully.
The requirement is I have to pass the parameter to the alert.
My doubt is whether we can able to pass parameter to an alert in FND_REQUEST.SUBMIT_REQUEST from PL/SQL procedure.
Re: Is it able to pass parameters for submitting oracle alert [message #557790 is a reply to message #557755] Fri, 15 June 2012 14:52 Go to previous messageGo to next message
Littlefoot
Messages: 19884
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's no much use in creating a clone.

The question remains the same, but the answer ... well, you'll have to wait until someone who understands Oracle Apps. sees your question. Therefore, be patient.
Re: Oracle Alert errors out when called from PL/sql [message #559095 is a reply to message #557723] Thu, 28 June 2012 13:35 Go to previous message
Oraclekay
Messages: 2
Registered: June 2012
Junior Member
Did anyone find a solution for this? I am getting the exact same error
Program was terminated by signal 11

Previous Topic: HTML page select problem
Next Topic: How to link Sales Order to AP
Goto Forum:
  


Current Time: Thu Dec 18 13:58:53 CST 2014

Total time taken to generate the page: 0.10599 seconds