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 MARCH 09, 2020
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.
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