This content has been marked as final. Show 4 replies
Can you try giving schema name
Documentation (Not sure what value to be given for these. I went with the below values.)
Owner: Company Name
Owner Tag: Custom Schema
Owner Tag: APPS
It should be Application name as mentioned by Alejandro
Edited by: appsjit on May 8, 2013 11:43 AM
Ensure OWNER_TAG represents an actual licensed application, like 'FND' no quotes. The business event system will dispatch subscriptions for licensed products.
Also, to detect any other possible errors please add an error type subscription. This way the BES will catch the error and will notify SYSADMIN of such failure, it won't go silent. You can use this link to see how: https://blogs.oracle.com/oracleworkflow/entry/defining_business_events_with_synchronous
Thanks Alejandro. Now this is working.
Changes i made:
1. Added the WFERROR workflow as a subscription to this event. So i could see that the function i am calling from the event did not have proper signature.
2. Changed the function signature to have standard parameters like:
CREATE OR REPLACE PACKAGE BODY XX_GL_APPROVE_BE_PKG
function subscription(p_subscription_guid in raw,
p_event in out nocopy wf_event_t) return varchar2 is
insert into xxvtv.xxvtv_test_table values ('From BE');
when others then
wf_core.context('XX_GL_APPROVE_BE_PKG','function subscription', p_event.getEventName(), p_event.getEventKey());
3. Changed the owner name and owner tag both to the custom schema name (XX)