Bills Generated by BILL_NOW Process are Not Including All Items (Doc ID 2477656.1)

Last updated on AUGUST 07, 2024

Applies to:

Symptoms

There is an argument used by OOB bill now to filter the items linked to the bill which is by date range of CREATED_T of the item.
In the problematical scenario, bill_now collects items with created_t between Feb 14 01:00:00 2017 and May 30 00:00:00 2017. However, the missing items have created_t = Feb 3 11:05:42 PM and created_t = Feb 7 8:38:08 PM, which are not included on the filtering of the OOB logic.

The bill’s due should match with the ‘Amount due for all bills’.


STEPS
-----------------------
An account is in Collections, current billing cycle 28/02/2017 - 07/03/2017
Date to submit payment, 15/04/2017
Payment allocated on the open bills
Account exits Collections and bill now scheduled, current billing cycle 14/04/2017 - 29/04/2017
Bill Now executed, 16/04/2017

Changes

Cause

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