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 JUNE 20, 2023

Applies to:

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

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