EAP: Difference In Amount On BNK_STMT_TBL Vs BNK_RCN_TRAN After 9.2 Upgrade Has Been Completed.

(Doc ID 2348812.1)

Last updated on JANUARY 15, 2018

Applies to:

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

Goal

Within 9.1 the amounts on the bank statement table and the related system tables like BNK_RCN_TRAN, BNK_RCN_DISBRSE etc were not signed. Whether the amounts were debit or credit needed to be derived based on the bank statement code and the source record.

In 9.2 it is possible to see the amounts as actual signed amounts (-/- sign)

Within the upgrade a standard delivered Application Engine (DCTR19140309) can be executed that executed following SQL statement:

UPDATE PS_BANK_STMT_TBL
SET RECON_TRAN_AMT = %DecMult( RECON_TRAN_AMT , -1 )
WHERE BANK_STMT_CODE IN (
SELECT DISTINCT A.BANK_STMT_CODE
FROM PS_BANK_STMT_TBL A
, PS_STMT_CODE_TBL B
WHERE A.BANK_STMT_CODE = B.BANK_STMT_CODE
AND B.CR_DB = '2' )
AND RECON_TRAN_AMT > 0

This AE will sign historical transaction amounts on the BANK_STMT_TBL.

Transactions from AP are also shown as negative amounts as the view used in Semi Manual Reconciliation BNK_RCN_DISBRSE has been changed to multiply PYMNT_AMT by -1.

However external transactions (stored in BNK_RCN_TRAN) are not updated.

Solution

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