My Oracle Support Banner

EAP: UNABLE TO CHANGE SUPPLIER BANK ACCOUNT IF A VOUCHER PYMNT_SELCT_STATUS IS E (Doc ID 2975875.1)

Last updated on AUGUST 30, 2024

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE:

Unable to change supplier bank account if a voucher is yet to be paid and payment method is ACH/EFT using existing bank account


On the Supplier > Location > Payables Options page, for a Supplier, if the Supplier has Invoices / Vouchers that were externally paid [PYMNT_SELCT_STATUS = E (Externally Paid) on PYMNT_VCHR_XREF], receive an error when trying to add a new effective dated Detail row and trying to change the Bank ID and Bank Account Number under Supplier Bank Accounts.

ERROR

At least one voucher is using this Supplier's Bank account and the EFT file is not yet created. (7025,208)

You cannot change or delete this supplier bank account as there is at least one voucher which uses this account and the EFT file is not yet created.

This Supplier has Vouchers on PYMNT_VCHR_XREF where the PYMNT_SELCT_STATUS is either E or X (Cancelled).

STEPS

1. Through SQL, find a Voucher that has the PYMNT_SELCT_STATUS = E (Externally Paid) on PYMNT_VCHR_XREF
2. Display the Voucher to find out the Supplier

    Accounts Payable >  Vouchers  > Add/Update  > Regular Entry
3. Display the Supplier from Step 2
4. On the Supplier > Location page, click the + sign to add a new effective dated Detail row

Suppliers > Supplier Information > Add/Update Supplier


5. New Detail row added has Effective Date of Today's Date
6. Click the Payables hyperlink
7. Under the Supplier Bank Accounts section, change the Bank ID and Bank Account Number
8. Click OK
9. Click Yes to the message received -- The Bank Account and/or Bank Id information was modified. (7025,246) Do you want to continue?
10. Above message is received



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.