EAR 9.2: Direct Debit Creation (AR_DIRDEBIT AE Program) Is Not Using Defined DD_ID Auto Numbering Value but Overriding It
(Doc ID 2792584.1)
Last updated on JULY 20, 2021
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
It has been detected that once the Direct Debit Autonumbering configuration has been set up for delivered Field DD_ID, under the desired Set ID value, and properly linked to the Record Group FS_33 (Automatic Numbering) at the TableSet Control level, when running the Create Direct Debits process (AR_DIRDEBIT AE Program), the system generates its own value for Direct Debit ID (DD ID), and overrides the previously configured settings under Record Field PS_AUTO_NUM_TBL.LAST_AUTO_NBR.
1.- Log into the FSCM Online Application EMPLOYEE Portal as a Receivables User
2.- At the TableSet Control configuration level, for Set Control Value US001, define under Record Group FS_33 (Automatic Numbering) the Set ID Value of US001
3.- Define an External Bank Account with a Collection Method of Direct Debit
4.- Define a Direct Debit Profile, linking it to the External Bank Account previously set up
5.- Set up a Customer ID, with a MICR Information, a Payment Method of Direct Debit, while linking it to the Direct Debit Profile configured
6.- Define the Auto Numbering for Field DD_ID (Direct Debit ID), under Set ID US001, with a Last Number Issued value of 555 for instance
7.- Create a new Pending Item Group for this Customer, and ensure the Item contains a Payment Method of Direct Debit
8.- Set the Pending Item Group to a Post Action of Batch Standard
9.- Launch AR Update for the Business Unit involved, and the Pending Transactions option selected
10.- Confirm that the new Customer ID has in its Customer Account the new outstanding Item
11.- Launch the Credit Direct Debits program, (AR_DIRDEBIT AE Program), to process the Item recently created
12.- ISSUE: Ensure that the new Direct Debit Worksheet is properly generated, and when reviewing the DD ID value is not the expected 556, but a different one
13.- Go back to the Auto Numbering configuration for Field DD_ID (Direct Debit ID), under Set ID US001, and confirm that there as well, the Last Number Issued value has been overridden
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
The Create Direct Debits process (AR_DIRDEBIT AE Program) is not respecting the Auto Numbering value defined for Field DD_ID, and overrides it with a system-calculated one at Record Field PS_AUTO_NUM_TBL.LAST_AUTO_NBR.
If the Company has defined the Auto Numbering functionality for delivered Field DD_ID (Direct Debit ID), then the Create Direct Debits process (AR_DIRDEBIT AE Program) should keep that as the main source to generate new DD IDs by summing +1 on the Last Number Issued in Auto Numbering.
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