My Oracle Support Banner

ECM: Issue with Bank Statement Accounting Page - Wrong Accounting Entry Template for the Addendum Match (Doc ID 2041433.1)

Last updated on NOVEMBER 01, 2020

Applies to:

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


Bank Statement Accounting - Wrong Accounting Entry Template for the Addendum Match.


1. Bank External Account setup (Navigation: Banking > Bank Accounts > External Accounts)
Bank ID: 071000XXX
Set Stmt Accounting

2. Bank Statement Accounting (Navigation: Banking > Administer Reconciliation > Bank Statement Accounting)
Bank ID: 071000XXX
Activity Type: BKINE
Activity Default Template: BSP-INTEXP

Test Rules:
Sample Addenda: NNNN-NNNNNN12

- Rule ID Definition:
  Rule ID: XXXX001
  Rule Default Template: BSP-INTEXP
  Match Value: 0005-802902 ** Attention
  Match Template: BSP-INTEXP

- Rule ID: XXXX002
  Rule Default Template: BSP-INTEXP
  Match Value: 0005-80290212 ** Attention
  Match Template: BSP-INTEXP

Click on Test Rule, the message is displayed:
Match Template - Rule ID: XXXX001 - match value='NNNN-NNNNNN'
Bank Statement Accounting has assigned the template defined for this matching value. (13535,559)
This accounting template will be used to account for the external transaction per the rules defined (if any) for the bank account statement activity type."

3. Enter Bank Statements (Navigation: Banking > Bank Statements > Enter Bank Statements)
Reference Amount Tran Code Activity Type Addenda
0000000X0001 100,00 Deposits BKINE NNNN-NNNNNN
0000000X0017 150,00 Deposits BKINE NNNN-NNNNNN12

4. Run Reconciliation (Navigation: Banking > Reconcile Statements > Process Reconciliation)

5. Process Statement Accounting (Navigation: Banking > Reconcile Statements > Process Statement Accounting)

6. External transactions created:

First transaction (OK)
Match Template - Rule ID: XXXX001 - match value='NNNN-NNNNNN

Second transaction
Match Template - Rule ID: XXXX001 - match value='NNNN-NNNNNN
It should be:
Match Template - Rule ID: XXXX002 - match value='NNNN-NNNNNN12

Transactions are reconciled.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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