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

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

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

STEPS

1. Bank External Account setup (Navigation: Banking > Bank Accounts > External Accounts)
Bank: TRBNK
Bank ID: 071000288
Account#: 0005-802902
Set Stmt Accounting

2. Bank Statement Accounting (Navigation: Banking > Administer Reconciliation > Bank Statement Accounting)
Bank ID: 071000288
Account #:0005-802902
Activity Type: BKINE
Activity Default Template: BSP-INTEXP

Test Rules:
Sample Addenda: 0005-80290212

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

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

Click on Test Rule, the message is displayed:
"Template=BSP-INTEXP
Match Template - Rule ID: AMEX001 - match value='0005-802902'
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
000000020001 100,00 Deposits BKINE 0005-802902
000000020017 150,00 Deposits BKINE 0005-80290212

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: AMEX001 - match value='0005-802902

Second transaction
Match Template - Rule ID: AMEX001 - match value='0005-802902
It should be:
Match Template - Rule ID: AMEX002 - match value='0005-80290212

Transactions are reconciled.


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