AR_DIRDEBIT Process Updates Wrong EFT_LAYOUT_CD When If There Are Multiple Sequences In The Run Control

(Doc ID 2340049.1)

Last updated on DECEMBER 15, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When the run control for AR_DIRDEBIT has more than 1 sequence, the process updates the wrong EFT_LAYOUT_CD if different bank accounts and direct debit profiles are used for the different sequences. The process takes the last direct debit profile and updates the EFT_LAYOUT_CD in the DD_CONTROL table for all the direct debit transactions processed by that run control. This causes the wrong EFT layout being selected for the direct debit and sent to Cash Management for processing.

All the different bank account and direct deposit profiles should be used for their respective transactions.


The issue can be reproduced at will with the following steps:

  1. Navigate to Accounts Receivable > Direct Debits > Administer Direct Debits > Create Direct Debits
  2. Create a new run control with 5 different sequences, each having a direct debit profiles and different deposit bank accounts with different EFT layout codes.
  3. Run AR_DIRDEBIT
  4. Run AR_UPDATE
  5. Review the rows in PS_DD_CONTROL and note how all the newly created rows have the same EFT_LAYOUT_CD that was entered for only the 5th run control sequence created in step 2.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms