My Oracle Support Banner

EAR 9.2: AR_DIRDEBIT AE Program Not Processing NEW Prenotes If TableSet Control Configuration For SetID On Record Group FS_23 (Customers) Is Not Equal To That Of Record Group FS_39 (Banks) (Doc ID 2403490.1)

Last updated on APRIL 10, 2019

Applies to:

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



After the implementation of the solution provided by the fix on <Bug 27555338> (AR: Error Message (13950,1034) At Direct Debit Profile Setup Level If Prenote Required, Due To FS_39 (Banks) And AR_27 (Direct Debit) Using Different Set ID Values), further testing revealed that at the Create Direct Debits AE Program (AR_DIRDEBIT) is unable to handle Prenote worksheet creation if the Set IDs of the below Record Groups differ:

     - FS_39 (Banks)
     - AR_27 (Direct Debits)
     - FS_23 (Customers)

Even if at the Bank External Account level, the Collection Method Direct Debit has been configured with the proper EFT Layout, and the Bank Integration Layout options state that it supports Prenote functionality, at the time of running the Create Direct Debits AE Program (AR_DIRDEBIT), the process is not taking the correct Set ID when Customers are defined under a different Set ID value to make the validation of the Prenote functionality. As such, no Prenote related Direct Debit Worksheets are created for Customers whose Prenote Status is NEW.


     1.- Log into the FSCM Online Application as User ID VP1
     2.- Navigate to: PeopleTools > Utilities > Administration > TableSet Control
     3.- Open the configuration under Set Control Value US002
     4.- Ensure that the following settings are enabled:
          - Record Group AR_27 (Direct Debits) points to Set ID US002
          - Record Group FS_39 (Banks) points to Set ID SHARE
          - Record Group FS_23 (Customers) points to Set ID US002
     5.- Navigate to: Banking > Bank Accounts > External Accounts
     6.- Open the configuration under Bank Set ID SHARE, Bank Code USBNK, and Bank Account CHCK
     7.- At the External Accounts tab, ensure that the AR flag is selected, and the 'DD/AR Draft Cash Ctrl' option is checked
     8.- Go to the Collection Methods tab, and define the below configuration:
          - Payment Method = Direct Debit
          - Prenote Required = Y
          - Direct Debit Lead Time Days = blank
          - EFT Layout Code = CCD
          - Default = Y
          - Send to Financial Gateway = Y
          - Click on 'Define Layout Properties' icon, and enter a value in COMPANYID row (Such as: Property Value = OSSTEST001)
     9.- Save the changes
     10.- Navigate to: Banking > Administer Bank Integration > Bank Integration Layouts
     11.- Open existing definition for Bank Set ID SHARE, and Bank Code USBNK
     12.- Scroll through the different Supported Layouts until finding Layout Code CCD
     13.- Confirm that the 'Supports Prenotes' flag is selected
     14.- Navigate to: Set Up Financials/Supply Chain > Product Related > Receivables > Payments > Direct Debit Profile
     15.- Click to add a new value with the below settings:
          - Set ID = US002
          - Profile ID = DD001
          - Effective Date = January 1st 1900
          - Status = Active
          - Description = Direct Debit Profile for US002
          - Short Desc = DD US002
          - Currency Code = USD
          - Rate Type = CRRNT
          - Prenote Required = Y
          - Bank Code = USBNK
          - Bank Account = CHCK
          - EFT ayout = CCD
     16.- Save the new Direct Debit Profile configuration
     17.- Navigate to: Customers > Customer Information > General Information

     18.- Create a brand new Customer ID (CUST-01) under Set ID US002
     19.- Navigate to: Customers > Customer Information > MICR Information
     20.- Create under Set ID US002, a new MICR Information for Remit Customer CUST-01 under Set ID US002
     21.- Navigate to: Customers > Customer Information > General Information
     22.- Open Customer ID CUST-01 under Set ID US002, and go to the Bill To Options page, and ensure the below values:
          - Payment Method = DD
          - Direct Debit Group = Group A
          - Bank Account = MICR-CUST-01
          - Direct Debit Profile ID = DD001
          - Payment Terms ID = IMMED
          - Prenote Required = Y
          - Prenote Status = NEW
          - Confirm After = 3 Days
     23.- Navigate to: Accounts Receivable > Pending Items > Online Items > Group Entry
     24.- Create a brand new Pending Item Group under Business Unit US002, for Customer ID CUST-01, for 500 USD
     25.- Place the Pending Item Group into Post Action Batch Standard
     26.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
     27.- Launch the AR_UPDATE AE Program for Business Unit US002, and Pending Items flag selected
     28.- Navigate to: Accounts Receivable > Direct Debits > Administer Direct Debits > Create Direct Debits
     29.- Launch the AR_DIRDEBIT AE Program for Business Unit US002, Direct Debit Profile ID DD001, and the combination of Bank Code USBNK, Bank Account CHCK, and EFT Layout Code CCD
     30.- While the process completes into Success, there is a Message stating Prenotes is no valid, and no Direct debit Worksheet is being created

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.


     " EFT Layout CCD is not valid for Prenotes. Prenotes not processed for Run Control OSS Sequence Number 1.
       1 Item(s) not processed because Prenotes are not confirmed for Run Control OSS.
       0 Items Selected for Collection by Direct debit for Run Control OSS.
       0 Direct Debit(s) Prenote(s) were created for Run Control OSS Sequence Number 1. "


The Create Direct Debit AE Program (AR_DIRDEBIT) is unable to properly generate the Prenote related Direct Debit Worksheet for those Customers whose Prenote Status is NEW, so no Direct Debit electronic file is generated to be sent to the Bank, so that the Prenote Status can be confirmed. As long as Prenote Status remains in NEW, no Items can be paid by the Customer via Direct debit method.


The Create Direct Debits AE Program (AR_DIR_DEBIT) should be able to handle any Set ID configuration regarding Banks, Customers, Direct Debit Profile, and MICR Information, to generate the Prenote related Direct Debit Worksheet when needed.


NOTE: In the  attached document, user details / company name / address / email / telephone 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.




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

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