E-Mail Payment Remittance To Supplier Does Not Work? (Doc ID 261478.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Payables - Version 11.5.9 to 11.5.10.2 [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
oracle.apps.ap.payment
oracle.apps.ap.format.create
oracle.apps.ap.event.invoice.approval
oracle.apps.ap.fx.XmlPayment.advice
oracle.apps.ap.fx.XmlPayment.errors
ORACLE.APPS.AP.PROCESSPAYMENT.CONFIRM
oracle.apps.ap.inv.invoice.recv
oracle.apps.ap.fx.XmlPayment.send

Symptoms

===========================================================================
PROBLEM DESCRIPTION
===========================================================================
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:
Licensed Flag
-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
from wf_events
where licensed_flag='N'
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms