ECM: Bank Statement Reconciliation Process Does Not Reconcile CM Transaction With Bank Transactions
(Doc ID 2102459.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
The Reconciliation SQL on the online page for PS_BNK_RCN_DEALS is not in sync with the SQL in the PS_RCN_EVENT_TBL record.
1) Navigate to Main Menu> Banking > Administer Reconciliation> Reconciliation Rules
2) Open PS_BNK_RCN_DEALS, open Insert rule, and see the SQL.
3) Query RCN_EVENT_TBL for the rule and compare the SQLs which shows online and in the Descr of the said record.
4) The Descr field has '«s(Amount)', while the SQL on online page has just 'Amount'.
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