My Oracle Support Banner

ECM: PS_PAYMENT_RCN_TBL.RECON_DIFF_AMT Is Set Incorrectly By Automatic Reconciliation Process (Doc ID 2088980.1)

Last updated on JULY 21, 2020

Applies to:

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


After the FSCM Image 10 Enhancement to Bank Statement Load which signs all disbursement line amounts as negative, when a Payables Payment is reconciled to a Bank Statement line, the PS_PAYMENT_RCN_TBL.RECON_DIFF_AMT is incorrectly set

1) Load a Bank statement with a Disbursement/debit transaction in it
2) Run Automatic Reconciliation (FSPRECON) Process for the bank statement
The statement is reconciled to a Payables Payment. A row is inserted into PS_PAYMENT_RCN_TBL, however the RECON_DIFF_AMT is incorrectly calculated by subtracting the PS_BANK_STMT_TBL.RECON_TRAN_AMT from PS_PAYMENT_TBL.PYMNT_AMT. The result will be non-zero.

PS_PAYMENT_RCN_TBL.RECON_DIFF_AMT should give an idea of the difference between the Bank Statement line amount and the system transaction amount, which should be 0 when the amounts are equal on both the system and the bank side.




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.