My Oracle Support Banner

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.

Symptoms

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.

STEPS:
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'.

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.