My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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 not to 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, and it cannot be reproduced.

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


Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.