R12/CE: Double Credit Transferred for Bank Account Transfer, Two Rows of CE_BAT_CLEARED Events Created on Clearing (Doc ID 1388878.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR

Find that there are duplicate clearing event for bank account transfer cashflow clearing.

This can also cause the below error during reconciliation of such BAT cashflows:

APP-FND-01206: This record already exists. You entered a duplicate value or sequence of values that must be unique for every record.

EXPECTED BEHAVIOR

Expect that there should not be any duplicate clearing event.

STEPS

The issue can be reproduced at will with the following steps:
1. Create Bank Account Transfer
2. Cleared the cashflows
3. Duplicate clearing events generated.

Bank Account Transfer was performed in Cash management. However, it shows two credit against a Bank Account Transfer in GL . Thus displaying in-correct GL balances. On investigating it is found that the ce_cashflow_acct_h shows 2 rows of CE_BAT_CLEARED event for the same cashflow with no uncleared event.

 

 

 

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