R12: AP/IBY How To Have PPR Select Invoices Based On Currency AND Bank Account Country?

(Doc ID 2302992.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Payments - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

The following is a summary of the key elements that define a particular challenge that users face while processing AP payments. Is there a way to achieve the desired objective?

When creating Payment Process Profile and Payment template (or Payment Process Request), it is possible to set limitation on the currency to be considered.
Is it possible to add a new rule on the supplier bank account country ?

When invoices in EUR must be paid , if supplier bank account is in a financial establishment located in a European Country, the payment format must be SEPA format; however, if supplier is not from one of the European country, payment must follow international rules and therefore must have a different format. (the business has many countries (including China and Japanese), not just Euro-zone countries, that need to be paid in currency: EUR

We have created two different formats, and a different Payment Process Profile for each Format.

However currently, when launching a PPR on EUR currency, system is collecting all due invoices in EUR no matter their country. It means that user must then manually remove from the selected invoices all the ones not for the format linked to the PPR, before completing the processing of the batch.

For example if the user needs to pay Currency EUR invoices to suppliers outside the Euro-zone, he must launch a PPR linked to an international format and, when the PPR for then stops for user review at Status: Invoices Pending Review, the user must be careful to manually remove all invoices belonging to suppliers located in the Euro-zone. That represents a huge amount of work due for the user, due to the large number of selected invoices and due to the fact that user most of the time does not know immediately where a given supplier is located (in the Euro-zone or not).

And so, there high potential of an invoice to mistakenly remaining in a PPR, and then getting paid using the wrong format (which can have the consequence of high bank charges) and conversely, a high risk that a given invoice would get manually removed from PPR that actually uses the Format with with the invoice needs to be paid, which can result in delays in invoice payment.
 

Solution

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