My Oracle Support Banner

Cycle Arrear Items Generated Twice for the Same Period in Month DST On/Off (Doc ID 2231492.1)

Last updated on FEBRUARY 15, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


On : version, Core Billing

In month DST on/off, cycle arrear items got generated twice for the same period.

Below two major issues found in BRM which had a significant impact on the monthly bill run activity where the DST was switched off on 30th Oct 2016.

Issue 1:

The charge was prorated for the product with prorate_last "full", if the deal was cancelled in DST month.

Issue 2:

Irrespective of prorate flag, if the deal was cancelled with backdated in DST month, double charge got applied to the account,

Steps to replicate:

• On 01 Oct 2016 – Account created
• On 01 Oct 2016 – RC monthly cycle arrear deal purchased (The proration flag was set to FULL.)
• On 31 Oct 2016 – Deal got cancelled at 09:52:00 with effective from 31-Oct-2016 00.00.00 (The cycle arrear item got generated immediately, but the amount was prorated.)
• On 01 Nov 2016 – Utility pin_cycle_fees -cancel executed (A duplicate item got created.)
• On 04 Nov 2016 – Billing/ invoicing executed (The end customer got overcharged by the duplicate item created in last step, and also the items generated were prorated.)

Purchased_product object in Normal month:

1 PIN_FLD_CHARGED_FROM_T TSTAMP [0] (1472680800) Thu Sep 01 00:00:00 2016
1 PIN_FLD_CHARGED_TO_T TSTAMP [0] (1472680800) Thu Sep 01 00:00:00 2016
D Thu Sep 01 01:12:03 2016 xxxxx cm:14043
fm_subscription_apply_rate.c:5480 2:xxxxx:pin_cycle_fees:13873:5:0::0
  setting pro_last flag
  Cycle already charged.

Purchased_product object in DST Month:

0 PIN_FLD_CHARGED_FROM_T TSTAMP [0] (1475272800) Sat Oct 01 00:00:00 2016
0 PIN_FLD_CHARGED_TO_T TSTAMP [0] (1477868400) Mon Oct 31 00:00:00 2016
D Tue Nov 01 01:13:06 2016 xxxxx cm:21069
fm_subscription_apply_rate.c:5480 2:xxxxx:pin_cycle_fees:21066:4:0::0
  setting pro_last flag
  setting pro_first flag

What is the reason for the duplicate item creation?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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