ECM: PS_PAYMENT_RCN_TBL.RECON_DIFF_AMT Is Set Incorrectly By Automatic Reconciliation Process

(Doc ID 2088980.1)

Last updated on AUGUST 28, 2017

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.


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