EAP: Adding Location Effective Date Defaults Supplier Bank Account With Incorrect Account Number When Bank Account Number Encryption Process Has Run (Doc ID 2988896.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

The Bank Account Number Encryption process has been run for the environment. When a Supplier Location Effective Date is added along with a Supplier Bank Account, the information is saved successfully to PS_VNDR_BANK_ACCT.

When a new Location Effective Date is added, the Supplier Bank Account defaults with the prior Location Effective Date Bank Account Number which is correct. Change the Account Number for this new Effective Date. Add a third Location Effective Date. The Supplier Bank Account defaults with the incorrect Account Number. This number is coming from the first Effective Date instead of the prior date. Users have no idea the wrong Supplier Bank Account Number has defaulted.

STEPS:

1. Bank Account Number Encryption process run against environment: Banking > Bank Accounts > External Accounts > USBNK/CHCK > Account # is encrypted

2. Suppliers > Supplier Information > Add/Update > Add/Update Supplier > USA0000007 > Location
    a. Current Effective Date = 01/01/1900
    b. Add new Effective Date = 10/05/2022
    c. Add Supplier Bank Acct = 1234954533
    d. Save
    e. Encrypted Acct = 00XXXXXXXXXX4533

3. Suppliers > Supplier Information > Add/Update > Add/Update Supplier > USA0000007 > Location
    a. Add Effective Date = 11/07/2022
    b. Supplier Bank Acct defaults with prior Effective Date value = 1234954533 (correct)
    c. Change Description, Bank Name, and Bank Account Number 1234954533, change 9 to 8 = 1234854533
    d. Save
    e. Encrypted Acct = 00XXXXXXXXXX4533

4. Suppliers > Supplier Information > Add/Update > Add/Update Supplier > USA0000007 > Location
    a. Add one more Effective Date = 12/05/2022
    b. Notice the default Bank Account Number 1234954533 (incorrect)
        - This Account Number is from the first Effective Date, 10/05/2022
        - Bank Account should have defaulted with 1234854533, from Effective Date 11/07/2023
    c. Change Description, Bank Name, Bank Account Number 1234954533, change 9 to 7 = 1234754533
    d. Save
    e. Encrypted Acct = 00XXXXXXXXXX45233 

5. Confirm Supplier Bank Account Numbers for each Location Effective Date by unmasking the numbers: Suppliers > Supplier Information > Add/Update > Add/Update Supplier > USA0000007 > Location
    a. 10/5/2022 = 1234954533
    b. 11/07/2022 = 1234854533
    c. 12/05/2022 = 1234754533

Changes

Bank Account Number Encryption process was run against the environment 

Cause

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