My Oracle Support Banner

EAR 9.2: 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 (Doc ID 2380962.1)

Last updated on MARCH 30, 2018

Applies to:

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

Symptoms

ISSUE:

The Functional Team has detected a problem when defining a new Direct Debit Profile ID in the system. An Error Message is being triggered by the system when the Prenote Required flag is being selected, and the configuration is being saved.

This seems to take place when the Set ID under which the new Direct Debit Profile ID is being entered, has at the TableSet Control level, different Set ID values defined for the following Record Groups:

     - FS_39 (Banks)
     - AR_27 (Direct Debits)

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 saving the Direct Debit Profile ID, the system is not taking the correct Set ID to make the validation of the Prenote Required flag, and instead of taking the Set ID from the Bank details (FS_39), it is erroneously taking it from the Direct Debit (AR_27).

REPLICATION STEPS:

     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 US001
     4.- Ensure that the following settings are enabled:
          - Record Group AR_27 (Direct Debits) points to Set ID US001
          - Record Group FS_39 (Banks) points to Set ID SHARE
     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 = US001
          - Profile ID = OSSDD
          - Effective Date = January 1st 1900
          - Status = Active
          - Description = OSS Direct Debit Profile
          - Short Desc = OSS DD
          - 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.- The system throws an Error Message

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.

ERROR MESSAGE:

      " EFT Layout CCD does not support Prenotes. (13950,1034) "

ACTUAL RESULT:

The Direct Debit Profile ID configuration cannot be properly stored in the system if Prenote functionality is needed to be required. This prevents outstanding Items to be properly generated in Direct Debit Worksheets by the Create Direct Debits AE Program (AR_DIR_DEBIT).

EXPECTED BEHAVIOR:

The validation for the Prenote Required flag should be done against the Set ID value used for the Bank Account details defined in the Remit section, and not the Direct Debit Profile one.

 

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.