ECM: Book To Bank Unbooked Payments Are Showing As Positive Amounts Instead Of Negative Amounts (Doc ID 2157145.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

When all bank statement lines contained positive amounts, it was necessary for the Book to Bank Reconciliation process TR_BTB_CALC to negate the lines of the bank statement code that were defined as debits.

TR_BTB_CALC.UpdMAmts.AdjSign SQL)UPDATE PS_BTB_UNBKD_TAO4 SET MONETARY_AMOUNT = - MONETARY_AMOUNT WHERE
PROCESS_INSTANCE = 69550 AND (BANK_STMT_CODE = ' ' OR EXISTS ( SELECT 'X'
FROM PS_STMT_CODE_TBL WHERE BANK_STMT_CODE = PS_BTB_UNBKD_TAO4.BANK_STMT_CODE
AND TYPE_CODE = '3' AND CR_DB= '2'))

As of PUM 10 bank statements lines which are debits are now loaded with negative transaction amounts so this TR_BTB_CALC step is no longer necessary.

STEPS:
1. Create bank statement with bank statement lines
BANK_STMT_CODE 475
RECON_TRANS_CODE CHK
RECON_TRANS_AMT -100
2. Run Automatic Reconciliation to generate NTF exception.
3. Select and run Calculate Book to Bank process
4. On Book to Bank Reconciliation details page, click on Bank Adjustments link

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.