My Oracle Support Banner

EAP: Supplier's Bank Account Number is Missing in ACH / EFT Payment File for Prenote if Bank Account Numbers Are Encrypted (Doc ID 2962549.1)

Last updated on AUGUST 29, 2023

Applies to:

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

Symptoms

Bank Account Numbers have been encrypted. The Supplier’s Bank Account is missing in the ACH and EFT Payment files when trying to Prenote a Supplier. This does not occur if the Bank Account Numbers are not encrypted.

STEPS
1. PeopleTools > Security > Encryption > Encryption Algorithm Keysets
    a. Setup both Algorithm ID = aes_ks256_cbc_encrypt and aes_ks256_cbc_decrypt
    b. Keyset ID = Bank_Account_Number
    c. To generate Key Value, reference Tools Document 1608091.1 - E-SEC: PET How To Create An 256 AES Encryption Profile Based On aes_ks256_cbc_encrypt and aes_ks256_cbc_decrypt Keys
    d. Save the page

2. PeopleTools > Security > Encryption > Define Encryption Profiles
    a. Setup both Encryption Profile ID = FSCM_ACCT_NUM_ENCRYPT and FSCM_ACCT_NUM_DECRYPT
    b. For the second Parameter Value, click on the magnifying glass and select Bank_Account_Number
    c. Save the page

3. PeopleTools > Security > Encryption > Test Encryption Profiles
    a. Encryption Profile ID = FSCM_ACCT_NUM_ENCRYPT
    b. Text to be Encrypted = enter any value (i.e., 12345)
    c. Click Run Encryption Profile
    d. Encrypted Text = 2j5oQtEZy1FR8GLueKRi1Q== (copy this value to be used in step 4c)

4. PeopleTools > Security > Encryption > Test Encryption Profiles
    a. Encryption Profile ID = FSCM_ACCT_NUM_DECRYPT
    b. Text to be Encrypted = 2j5oQtEZy1FR8GLueKRi1Q== (value from Step 3d)
    c. Click Run Encryption Profile
    d. Encrypted Text = 12345 (value from 3b)

5. Set Up Financials/Supply Chain > Common Definitions > Encryption Configuration > Bank Account Number Encryption
    a. Encryption Profile ID = FSCM_ACCT_NUM_ENCRYPT and Decryption Profile ID = FSCM_ACCT_NUM_DECRYPT
    b. Click Validate Profiles
    c. Profile Status = Valid
    d. Under Process Encryption, click Run

6. Suppliers > Supplier Information > Add/Update > Add/Update Supplier
    a. Setup an ACH Supplier with the following:
        - Additional Payables Options section, Payment Method = Automatic Clearing House
        - Electronic File Options section, Prenotification Required box checked with Status = New
        - Supplier Bank Accounts section, Bank Account Number populated
    b. Setup an EFT Supplier with the following:
        - Additional Payables Options section, Payment Method = Electronic Funds Transfer
        - Electronic File Options section, Prenotification Required box checked with Status = New
        - Supplier Bank Accounts section, Bank Account Number populated

7.  Accounts Payable > Vouchers > Add/Update > Regular Entry
     a. Create 1st Voucher for a Supplier with Payment Method = ACH
     b. Create a 2nd Voucher for the above ACH Supplier with Payment Method = ACH
         - Save the Voucher
         - Click OK to the following message -- This supplier has not been prenoted for EFT/ACH payment. Payment Method 'System Check' will be used (7250,357)
         - Save the Voucher
     c. Create 3rd Voucher for a Supplier with Payment Method = EFT
     d. Create 4th Voucher for the above EFT Supplier with Payment Method = EFT
         - Save the Voucher
         - Click OK to the following message -- This supplier has not been prenoted for EFT/ACH payment. Payment Method 'System Check' will be used (7250,357)
         - Save the Voucher

8. Accounts Payable > Payments > Pay Cycle Processing > Payment Selection Criteria
    a. Payment Selection Criteria > Preferences page, Process EFT/ACH Pre-Note box is checked
    b. Payment Selection Criteria > Bank / Method page, Payment Method = (1) Automatic Clearing House, (2) Electronic Funds Transfer, (3) System Check

9. On the Pay Cycle Manager page:
    a. Run Payment Selection & Creation
    b. Above 4 Vouchers should be selected for Payment
    c. Print Checks
    d. Run Electronic Payments

10. CCD File created -- Supplier Bank Account Number is missing for the Prenote for the ACH Supplier

11. PPD File created -- Supplier Bank Account Number is missing for the Prenote for the EFT Supplier

NOTE: In the Steps above, user details / customer name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Product name test environment). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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
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.