CE:R12.1: Journal Lines Duplicated When Reviewing Available Transactions In Bank Statement (Doc ID 2220460.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


Journal lines duplicated when reviewing available transactions.

Expect do not see duplicate transactions.

The issue can be reproduced at will with the following steps:

1. Responsibility: Cash Management
2. Bank Statements > Bank Statements and Reconciliation > Input bank account number and statement date > Click on 'Find' button > Click on 'Review' button > Click on 'Available' button
3. Select 'Journal' checkbox only and input relevant period name > Click on 'Find' button

Duplicate lines are displayed.

Journal lines duplicated when reviewing available transactions.
The source for both duplicated journals is 'Manual'.
They relate to payments that the user is trying to reconcile.

There are 2 separate journals that have a single debit and a single credit line but for which the credit lines are duplicated.
The problem has occurred for 2 specific journals, cannot reproduce the issue.

The table name where the user can see the duplicate lines is: CE_101_TRANSACTIONS_V

IMPORTANT: This is NOT related to a bank account transfer.
The user is looking to reconcile the statement line but the line has been duplicated.

WORKAROUND: None

The issue has the following business impact:
Due to this issue, users cannot see the correct information in the system.

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