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
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.
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).
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.
" EFT Layout CCD does not support Prenotes. (13950,1034) "
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).
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.
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