Items Created During Delayed Period Not Billed

(Doc ID 979187.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2016***

Symptoms

Problem Statement

Purchasing a deal, including a Cycle Forward product, after having introduced the config_billing_delay 10 in CM pin.conf, it created cycle forward item not associated with any bill object (bill_obj=0).

Then, billing the account that item never got billed.

Reproduction Steps

1) pin_virtual_time is:

mode 0 1260438088 Thu Dec 10 09:41:28 2009


New account created: poid_id0 = 37731

/billinfo 40803:
0 PIN_FLD_ACTG_NEXT_T TSTAMP [0] (1263081600) Sun Jan 10 00:00:00 2010



Query 1:

select
i.poid_id0,
i.poid_type,
i.service_obj_type,
i.bill_obj_id0,
i.effective_t,
bi.poid_id0 BI,
bi.next_bill_obj_id0 BI_next_bill_obj
from billinfo_t bi,
bill_t b,
item_t i
where bi.poid_id0 = b.billinfo_obj_id0
and b.poid_id0= i.bill_obj_id0
and i.account_obj_id0 = 37731 -->

POID_ID0 POID_TYPE SERVICE_OBJ_TYPE BILL_OBJ_ID0 EFFECTIVE_T BI BI_NEXT_BILL_OBJ

40163 /item/misc 37091 0 40803 0
38627 /item/cycle_forward /service/email 37091 0 40803 0
40419 /item/cycle_forward /service/ip 37091 0 40803 0



Query 2:

select * from item_t
where effective_t=0
and account_obj_id0=37731
and bill_obj_id0=0 -->

No rows


2) introduced the entry in CM pin.conf: - fm_bill config_billing_delay 10

stop/start cm

3) pvt

mode 2 1263081602 Sun Jan 10 00:00:02 2010



4) Purchase deal.

5) Query 1:

POID_ID0 POID_TYPE SERVICE_OBJ_TYPE BILL_OBJ_ID0 EFFECTIVE_T BI BI_NEXT_BILL_OBJ

40163 /item/misc 37091 0 40803 0
38627 /item/cycle_forward /service/email 37091 0 40803 0
40419 /item/cycle_forward /service/ip 37091 0 40803 0



Query 2:

POID_TYPE POID_ID0 BILLINFO_OBJ_ID0
/item/cycle_forward 43775 40803


This query, selecting items with bill_obj_id0 = 0, returns this row now.

Once this state is reached, this item won't be picked up by any bill.

Changes

 

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