Transactions Workbench Issue: Balance Forward Billing Showing Prior Period Transactions Incorrectly (Doc ID 1981826.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

Issue:
----------
Balance Forward billing for some customers showed on the first statement correctly.
After that it is still appearing on all the subsequent BFB statements for that customer.
Even though the balance for that customer in the subsequent period is zero, this transaction is appearing on all its statements.
The transaction is a Debit Memo applied to a Credit Memo.

Research/Analysis:
-------------------
From the diagnostics, observed that there are duplicate records with records with transaction_type = DELAY_CMAPP.
Before the patch patch 17659675:R12.AR.B the CONS_INV_ID_TO was not update with BFB id, so it was repeat in all the bills generated.
Now the patch resolved the issue for new records. But for the existing records, the duplicate records have to be addressed.

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