Reconciliation With No System Side (Doc ID 2202919.1)

Last updated on NOVEMBER 11, 2016

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Reconciliation with no system side  

When try to reconcile an External Transaction with Bank transaction from the Semi Manual Recon page, there is a possibility that the User might go directly from this page to the External Transaction page and delete the External Transaction.
Now, when the user comes back to the Semi manual Recon page, the Deleted External Transaction is still visible, and the user can reconcile this transaction with the Bank Transaction and the system will allow it.
Then in order to check the Reconciled transactions, it can only be seen the Bank transaction, but no possibility to see the External Transaction.
Also, there is a scenario that there is only bank Side Transaction that got reconciled with No External Transaction.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1: Bank Statements are created
2: External Transactions are created
3: Both system and bank transactions appear in the Semi manual Reconciliation page as below

Case1:
Try to delete the transaction on the system side as we came to know the system transaction is no need  (for example: imagine that the user knows that the transaction should be an AR deposit that was not recognized by the system and external transaction was wrongly created)
Go to external transaction and delete the row as below
The following message appears and if user click OK : DELETE CURRENT/SELECTED ROWS FROM THIS PAGE? THE DELETE WILL OCCUR WHEN THE TRANSACTION IS SAVED
Amount on the transaction disappears. Then users click apply and OK the system brings you back to semi-manual reconciliation page and deleted external transaction still appears as un reconciled (the page is not refreshed)
 
If by mistake the user will reconcile the bank transaction with the “deleted” external transaction the system allows it.

Case2:
Now reconcile both bank transaction and system transaction.
The two transactions got reconciled and message appeared as : transaction successfully reconciled.

Cause

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