Raise warning when create business events subscription

Applies to:

Oracle Workflow Cartridge - Version: 11.5.9 to 12.0.6 - Release: 11.5 to 12
Information in this document applies to any platform.
Checked for relevance on 07-JAN-2011

Symptoms

When attempting to activate a business event subscription, the following error occurs: 

Warning

'The product specified for this subscription is not licensed. This subscription will not be processed.'

Cause

Value of Owner Tag field used in the Subscription creation steps (Step 2) is not a valid Application (product) Short Name that exists in  FND_APPLICATION table.

select we.name, wes.rule_function,wes.licensed_flag, wes.status, wes.owner_tag, wes.source_type, wes.phase 
from wf_event_subscriptions wes, 
wf_events we 
where wes.event_filter_guid = we.guid 
and we.name like '&event_name';

select b.application_short_name 
from FND_PRODUCT_INSTALLATIONS a, 
FND_APPLICATION b 
where b.application_id = a.application_id;

Solution

To bypass the issue follow below steps:

1. License the application into FND_PRODUCT_INSTALLATIONS table.

To license it, manually update the WF_EVENTS and WF_EVENT_SUBSCRIPTIONS tables to set the licensed_flag to 'Y'.

2. Change the Owner Tag to correspond to a valid Application_Short_Name from FND_APPLICATION table. 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10359218/viewspace-716699/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10359218/viewspace-716699/