EAP: Difference In Amount On BNK_STMT_TBL Vs BNK_RCN_TRAN After 9.2 Upgrade Has Been Completed.
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.
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:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms