My Oracle Support Banner

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:

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

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

NOTE: In the Steps above, User Details/Company Name/Address/Email/Telephone Number/Account Number, represent a fictitious sample (based upon made-up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

Changes

Bank Account Number Encryption process was run against the environment 

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.