R12 AP: Payment Validation Based On Lookups Does Not Work (Doc ID 2171713.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Funds Disbursement Core

Payment validation on format payment, based on lookups, does not work as expected.

Payment validation based on lookups must check the start_date_active and the end_date_active or the enabled_flag in fnd_lookups (which is a view on fnd_lookup_values)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
To reproduce:
- set up a lookup type with a list of countries
- set up validation on Document Payee Bank Branch Country for a payment format, linked to that value set
- make a payment for a supplier with a bank account with a country that is in that value set: payment is OK

- void the payment
- set an end date in the past in the lookup type for the country and/or uncheck the enabled flag of the country chosen above
- make the same payment as before: payment is still OK (even though it should be rejected)

- to have proof that this is the issue:
- void the payment
- delete the country chosen above from the lookup values
- make the same payment as before: payment is now rejected


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