Wrong Proration When Backdate Purchase For Last Cycle Is Done After Partial Billing (Doc ID 1673745.1)

Last updated on FEBRUARY 07, 2024

Applies to:

Symptoms

Steps To Reproduce the Issue

Setup

1)  Create a product :
      MCF
      /service/ip
      charge = 100$
      prorate based in usage

2)  Create a discount object:
     MCF
     /service/ip
     sequential
     discount model = 100% discount on MCF (sequential)

3)  Create a deal containing both the Product and the Discount

4)  Set config_billing_delay = 2 and actg_dom = 1 in CM pin.conf

5)  Enable sequential discounting

Execution

1) Creation an Account on March 10 00:00:00

Check the events generated:

select to_char(e.poid_id0),
utl.date_t(e.created_t),ebi.amount,e.poid_type,ebi.impact_type,ebi.item_obj_id0
from event_t e, event_bal_impacts_t ebi
where ebi.obj_id0=e.poid_id0 and ebi.obj_id0 in (select poid_id0 from event_t
where account_obj_id0= 563661) order by e.created_t;

TO_CHAR(E.POID_ID0)   UTL.DATE_T(E.CREATED_T)    AMOUNT                
POID_TYPE                             IMPCAT_TYPE ITM_OBJ_ID0


2) Move the pvt to 1st April 2014:

pvt 2 040100002014

3) Run the opcode PCM_OP_BILL_MAKE_BILL to execute the partial Billing

Note as the last two events that the Customer have different amount (100, -93.333), whereas they should be equal in value (just opposite in the sign, i.e. 100, -100).

Cause

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