My Oracle Support Banner

EAR 9.2: Users Are Able To Cancel A Reconciled Direct Debit Payment, Which Later On Cannot Be Unreconciled From Bank Statement Anymore (Doc ID 2647335.1)

Last updated on MAY 18, 2021

Applies to:

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


The Accounts Receivable Functional Team states that it is possible to cancel via the online application an already reconciled Direct Debit payment.

This causes issues at a later stage, where the Bank Statement that was reconciled against the original transaction can no longer be unreconciled, as the Source Transaction is no longer showing online, due to SQL View PS_BNK_RCN_DEBIT filtering results by PS_DD_CONTROL.DD_STATUS values of 'R' or 'C' (Remitted or Completed).


    1.- Log into the FSCM Online Application as a Receivables User
    2.- Enable a Customer for Direct Debit payments
    3.- Create a new Pending Item Group for this Customer, and set the Post Action to Batch Standard
    4.- Launch AR Update with Pending Items option selected
    5.- Confirm that the new Item is posted against the Customer's Account with a Payment Method of Direct Debit
    6.- Launch the Direct Debit Creation process
    7.- Confirm that the Direct Debit Worksheet has been created, and remitted to the Bank
    8.- Launch AR Update with the Direct Debits option selected
    9.- Confirm that the Item in question has been closed, with new Item Activity of a Direct Debit payment
    10.- Create a new Bank Statement, with a transaction equal to the Direct Debit payment
    11.- Through the Semi Manual Reconciliation page, reconcile the Bank Statement against the Receivables Direct Debit payment
    12.- Proceed to cancel the Direct Debit online
    13.- Launch the AR Update with the Direct Debits option selected
    14.- Confirm that the affected Item has been re-opened, as a new Item Activity has been added, reversing the Direct Debit payment
    15.- Go back to the Semi Manual Reconciliation page, and confirm that while the Bank Statement transaction is showing still as reconciled, the Source Transaction in Receivables for the affected Direct Debit payment is not displayed

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.

Allowing Users to cancel an already reconciled Direct Debit payment is causing problems at the Cash Management module by preventing reconciled Bank Statements to be unreconciled.

If a reconciled Direct Debit Payment should not be able to get cancelled, then the system should prevent those transactions from showing in the search results of the Cancel Direct Debits page. However, if this should be allowed, then the system should automatically unreconcile the Bank Statement, along with the Source Transaction from Receivables module for the Direct Debit payment involved.

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.




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.