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

Last updated on SEPTEMBER 21, 2023

Applies to:

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

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