Some Items Are Being Filtered During Pin_bill_accts Making Them Stuck At Bill-in-progress (Doc ID 2549272.1)

Last updated on AUGUST 16, 2024

Applies to:

Symptoms

Item filtering that was evident in make_bill_now. Also, persists in make_bill. Start_date filters items created earlier than the date, but supposedly posted on the bill. Usually occurs on items created before account enters collections.

This issue is related to issue which was fixed in Doc ID 2477656.1 -Bills Generated by BILL_NOW Process are Not Including All Items. 

In this case, the similar error is occurring while execute pin_bill_accts, where an old event is not being considered when a bill is generated, remaining in bill-in-progress. 

Based on the user's business rules, after 16 days of a due date of a bill without a payment, the services are suspended, and the billing is suppressed. After a period of time, this suppression is removed.

From cm.pinlog, see that prune filter starting at 1587783600 (Apr 25), the user is expecting the start to include the event on Feb 17. 

Observation: 
Feb-17 - Occurs the billing suppression and product inactivation which generates the cycle event reversal, referring to a future period of the cycle that was not used by the customer.
On 24-jun the billing suppression is canceled, turning the customer able to have new bills.
On 18-Jul, when the pin_bill_accts have processed the account it used the prune filter start_t=25-Apr (1587783600), which makes the system ignore the event created on Feb-17.

 
EXPECTED BEHAVIOR
-----------------------
Bill to include event on created on Feb-17.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create account with date of month (DOM) 1 and purchase product on 01/01
2. Run Bill now
3. Move to next month 02/17, account enters collection, billing is suppressed.
4. Accounts is in collection every month until 06/25, billing suppression is canceled to allow new bill generated for account.
5. Move to July DOM +17 days (Jul 18), execute pin_bill_accts

Cause

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