EAP: Payment Creation populates PS_PAYMENT_TBL with wrong Remit Bank Account (Doc ID 661496.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version: 8.9 - Release: 8.9

Information in this document applies to any platform.

SPECIFIC TO:  Enterprise, Payables, AP, 8.9, 9.0

This document was previously published as Customer Connection Solution 201067067

Symptoms


When Payment Creation is run and if a Vendor Bank Account has effective dated rows (PS_VNDR_BANK_ACCT), the process is selecting the oldest effective date instead of the most current.  So, PS_PAYMENT_TBL.REMIT_BANK_ACCOUNT is not the most current value on the PS_VNDR_BANK_ACCT record.  

This is an issue after applying 8.9 Bundle 21 (Report Id 1714466000).  AP_APY2015.P_EFTBANK.Step02 SQL needs to be modified to select REMIT_BANK_ACCOUNT from the most current effective dated row on VNDR_BANK_ACCT table regardless of the order on EFFDT field.

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