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

Last updated on MARCH 27, 2017

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

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