R12:IBY:End Dated Supplier Bank Accounts Does Not Update Outstanding Invoices With New Bank Account (Doc ID 1078576.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

On : 12.0.6 / 12.1.x version,

Find that end dating a supplier bank account does not update the invoice headers associated to that bank account to an active one based on the bank account priority.

EXPECTED BEHAVIOR
Expect the application to update all outstanding invoices with an active supplier bank account based on the bank priority.

STEPS
The issue can be reproduced at will with the following steps:

(R) Oracle Payables Responsibility

1. Navigate to: Invoices / Entry / Invoices

2. Create a new invoice for a given supplier, the supplier is setup with a default bank account for electronic payments. Notice the application defaults that bank account to the Invoice header in the 'Remit-To Bank Account Name' and 'Remit-To Bank Account Number' fields.

3. Navigate to: Suppliers / Entry

4. Query up the supplier and Click Go

5. Click on Payment Details on the left menu

6. Search the Account Assignment Level at the appropriate level to get the Bank Account assigned to that supplier, click Go

7. Click on End Date for the bank account attached to the invoice entered in step 3.

==> The system shows a warning message: "This bank account is attached to 1 number of payable documents. Would you like to replace existing bank account with other available bank account as per the priority available in document payables".

Choose Yes

Note: For that supplier there is another bank account already setup with priority 2.

8. Navigate to: Invoices / Entry / Invoices

9. Query the invoice entered in step number 3

10. Navigate to the Payment Schedule tab

==> Notice the application did not change the bank account fields, the Invoice cannot be paid as is because the bank account is end dated.

The user can manually change the payment schedule to use the active bank account. But this is not a feasible solution as there might be hundreds of invoices with the old bank account.

Cause

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