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

Last updated on MARCH 07, 2022

Applies to:

Symptoms

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

Some customers (23 customers), all the transactions during the period are not included. There were two customer accounts identified with the differences.

Example:
Customer # XX 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

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