My Oracle Support Banner

Transactions Not Included In Generate Balance Forward Billing (Doc ID 1470119.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

Attempting to run the Generate Balance Forward billing program for Jan-12 after an upgrade to 12.1.3.

Some customers (23 customers) e.g., 32ZJOH000001, 46ZBAR000003, all the transactions during the period are not included. There were two customer accounts identified with the differences.

Example:
Customer # 46ZBAR000003 outstanding balance as per Aging report is <19,894.39>
But the outstanding balance in Consolidated Billing is <4,790.25>
The total difference is <15,104.14>

The number of credit memo transactions included in BFB invoice is 17, but actually during Jan-12 for the customer there were 23 Credit Memos created.  Six (6) credit memos are not included.

The total of the six (6) credit memos is <28,437.04>. But there are three (3) RECEIPT_ADJUST tranaction types created in the AR_CONS_INV_TRX_ALL table that amount to <13,332.90>.  
The net difference is exactly <15,104.14> (28,437.04-13,332.90)

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!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
References

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