Last updated on JUNE 01, 2016
Applies to:Oracle Payables - Version 11.5.9 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
This problem can occur on any platform.
Checked for relevance on 20-Feb-2009
Customer is trying to produce the e-mail remittance advice using the Business Event Workflow subscription oracle.apps.ap.payment, which uses the APPEWF Workflow. They have just installed 11.5.9 and there are no processes being created for this event in the WF_DEFERRED que when they follow the steps in AP to create the event.
After reviewing the setups of this event and subscription, we found the following message:
Warning - The product specified for this event is not licensed. This event will not be processed.
A Business Events Enhancement was released as the following:
-Limit the processing of events and subscriptions only to licensed products or products installed in 'Shared' Mode
-Independent of customization level
-Object definitions will be updated with the product's current license status during patching
Running the following script returned:
select name, type, status, owner_name, owner_tag, licensed_flag
and owner_name='Oracle Payables';
name type status owner_tag licensed_flag
oracle.apps.ap.payment EVENT ENABLED AP N
oracle.apps.ap.format.create EVENT ENABLED AP N
oracle.apps.ap.event.invoice.approval EVENT ENABLED AP N
oracle.apps.ap.fx.XmlPayment.advice EVENT ENABLED AP N
oracle.apps.ap.fx.XmlPayment.errors EVENT ENABLED AP N
oracle.apps.ap.processpayment.confirm EVENT ENABLED AP N
oracle.apps.ap.inv.invoice.recv EVENT ENABLED AP N
oracle.apps.ap.fx.XmlPayment.send EVENT ENABLED AP N
So you can see that all of these events are not licensed to be used and thus there are no events being created in the WF_DEFERRED que.
Running the following script to verify that Payables is a valid installed product:
select i.application_id, a.application_short_name, i.status
from FND_PRODUCT_INSTALLATIONs i, fnd_application a
where i.application_id = a.application_id
and i.application_id = 200;
APPLICATION_ID APPLICATION_SHORT_NAME STATUS
200 SQLAP I
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms