ECM: Payment Dispatch Creates ACH Payment File With the Oldest Effective Dated Row for Supplier Bank Account (Doc ID 2913734.1)

Last updated on DECEMBER 06, 2022

Applies to:

Symptoms

Bank Account Numbers have been encrypted. Supplier has 1 Location with 2 Effective Dated Details where each Detail has a Supplier Bank Account. The last 4 digits of each Supplier Bank Account are the same but the preceding digits are different. Once a Voucher is paid with Payment Method = ACH and Payment Dispatch is run, the ACH Payment File is created with the Supplier’s oldest effective dated Supplier Bank Account instead of the newest effective dated one.  As a result, a large number of ACH payments are being returned from the Bank for an invalid Account Number.

STEPS
1. Navigate to 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. Associate Key Value = xxxxx
    d. Save the page

2. Navigate to 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. Navigate to 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 = yyyyy (copy this value to be used in step 4c)

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

5. Navigate to 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. Navigate to Suppliers > Supplier Information > Add/Update > Add/Update Supplier
7. On the Supplier > Location page, Supplier has one Location with 2 Effected Dated Details
    a. Click on the Payables link for each Effective Dated row
    b. For the newest Effective Dated row, Bank Account Number = 012345672
    c. For the oldest Effective Dated row, Bank Account Number = 000045672

8. Navigate to Banking > Bank Accounts > External Accounts
9. On the External Accounts > Payment Methods page
    a. Payment Method = Automated Clearing House
    b. Default box checked for Settle By = Financial Gateway / Layout = CCD

10. Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry
11. Create a Voucher for the above Supplier with today's date
      a. On the Voucher > Payments page, Method = ACH
      b. Save the Voucher

12. On the Voucher > Payments page, click the Express Payment link
13. On the Express Payment page, click Create Payment
14. On the Express Payment Manage – Pay Cycle page, click Refresh
      a. Status = Approved
      b. Click Process for Financial Gateway Electronic Payments
      c. Click Refresh
      d. Status = Completed

15. Navigate to Financial Gateway > Process Payments > Schedule Payment Dispatch
16. Run Schedule Payment Dispatch for the Transaction ID
17. ACH Payment File created with the oldest effective dated Supplier Bank Account, which is wrong

Changes

 Bank Accounts have now been encrypted.

Cause

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