My Oracle Support Banner

ECM: Payment Dispatch Does Not Populate the Supplier Bank Account on the Payment File if the Bank Account is Encrypted and No Email ID is Specified (Doc ID 2922182.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

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

Symptoms

Bank Account Numbers have been encrypted. Supplier has 2 Locations. First Location has FG Remittance Advice enabled and an Email ID is specified. Second Location does not have FG Remittance Advice enabled and no Email ID is specified. First Voucher is created for the Supplier’s 1st Location. Second Voucher is created for the Supplier’s 2nd Location. Both Vouchers are paid with Payment Method = ACH. The PMT_DETAIL_TBL shows that for the 1st Voucher, PARTY_ID is appended with an _1 to the Supplier ID. When Payment Dispatch is run, the ACH file is created but the Supplier Bank Account is blank for the 1st Voucher due to the PARTY_ID being appended with an _1. As a result, ACH’s are being returned from the Bank for Invalid Account Number.

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. Associate Key Value = xxxxx  (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 = yyyyy (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 = yyyyy (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 > Location > Payables link
    a. 1st Location, Supplier Bank Accounts is setup and under Payment Notification, the box is checked for "Enable FG Remittance Advice" and the Email ID field is populated
    b. 2nd Location, Supplier Bank Accounts is setup and under Payment Notification, the box is not checked for "Enable FG Remittance Advice" and the Email ID field is not populated

7. Banking > Bank Accounts > External Accounts > Payment Methods 
    a. Payment Method = Automated Clearing House
    b. Default box checked for Settle By = Financial Gateway / Layout = CCD

8. Accounts Payable > Vouchers > Add/Update > Regular Entry
    a. Create 1st Voucher for the above Supplier for Location 1
        - On the Voucher > Payments page, Method = ACH
        - Save the Voucher
    b. Create 2nd Voucher for the above Supplier for Location 2
        - Voucher > Payments page, Method = ACH
        - Save the Voucher

9. Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager
    - Pay both Vouchers and run Financial Gateway Electronic Payments

10. Through SQL, data on PMT_DETAIL_TBL shows that for the Supplier that has an Email ID specified (which is Location 1), the PARTY_ID field has an _1 appended to the end of the Supplier ID

11. Financial Gateway > Process Payments > Schedule Payment Dispatch
      - Run Schedule Payment Dispatch for the above Pay Cycle and Pay Cycle Seq #
   
12. ACH File created but the Supplier Bank Account is blank for the 1st Voucher due to the PARTY_ID being appended with an _1

Changes

 Bank Accounts have now been encrypted.

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.