I am in the process of the implementing our own custom events, and for my initial testing I have created the custom event and a subscription on that. When I test the event from workflow administratror with the test the subscription is raising and feeding the message into custom table. If I call the same custom event from a pl/sql program then the subscription is not raising, and I think I am missing something here. Any one have any idea?
CREATE OR REPLACE PROCEDURE schl_test_event
(p_event_name IN VARCHAR2,
p_event_key IN VARCHAR2,
p_data IN CLOB DEFAULT NULL,
p_parameters IN wf_parameter_list_t DEFAULT NULL)
l_x_header_id NUMBER := 4567;
match_date VARCHAR2 (20);
--l_event := event(p_event_name);
( p_event_name => l_event,
p_event_key => p_event_key,
p_parameters => p_parameters,
p_event_data => p_data);
INSERT INTO schl.schl_event_test
While executing this I am giving the following statement.
The procedure is executing successfully but the event subscription is not raising from the schl.apps.ont.book.order event, if I perform the test from the event from the wf administrator the subscription is raising. Why it's not raising when I call it as shown in the previous post?
I would highly appreciately your help on this, Thanks again.
When you run your stored procedure manually, it inserts the record into the table correct? Is this an EBS env or standalone WF? If EBS, make sure apps and applsys have exec permissions on your sp.
If you put your subscription on a standard event, does it fire?
It inserts the records when I run my stored procedure manually and it inserts the records when I do the event test from workflow admin responsibility it inserts the records. This is EBS 11.5.10 version. Issue with when I call it in the external pl/sql the subscription is not raising.
I did the test on a seeded event 'oracle.apps.ont.oi.po_inbound_create' and it's behaving same as custom event, from wf administrator event testing the subscription is raising and when I call it in pl/sql the subscritption is not raising. I have used the following code, and the test procedure code is attached earlier post. Still couldn't find the reason for this.
exec schl_test_event ('oracle.apps.ont.oi.po_inbound.create',4567,null,null)
How are you raising the custom event? Is it from a form, trigger, workflow, or other procedure? Are you sure your calling method is raising the event and not throwing an error?
Have you tried raising the event manually from pl/sql (wf_event.raise)?