Hello!
I am using below code to raise a business event.
declare
l_parameters wf_parameter_list_t := wf_parameter_list_t();
begin
--Optional:
--execute immediate 'truncate table applsys.fnd_log_messages';
--Add your parameters here
wf_log_pkg.init(1, null, 1, 'wf%');
wf_event.addparametertolist(p_name => 'SHIPMENT_HEADER_ID',
p_value => '123',
p_parameterlist => l_parameters);
wf_event.raise(p_event_name => 'apps.xx.cust.event',
p_event_key => 'thisisthekey',
p_event_data => NULL,
p_parameters => l_parameters,
p_send_date => sysdate);
dbms_output.put_line(l_parameters);
commit;
end;
After raising the event i check wf_deferred table and there is newly created record for this event. Now i want MSGID of this row or any other value which can identify this event uniquely. How can i do this?
-Thanks