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

Last updated on MARCH 18, 2016

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.

Symptoms

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

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

EXPECTED BEHAVIOR:
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.

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