My Oracle Support Banner

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.

Symptoms


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.

REPLICATION STEPS:

  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.

NOTE: In the images/screenshots/examples mentioned and/or 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.

Changes

 

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
Changes
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.