EAP: Payment Creation populates PS_PAYMENT_TBL with wrong Remit Bank Account
Last updated on JANUARY 12, 2018
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
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.
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