Rerating Is Not Happning Correctly (Doc ID 1321076.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Symptoms

Rerating is not happening correctly. The cycle fee for the period Feb 01- Feb 10 is applied at the rate of 5000 instead of the old 4000.

0) Current Real Date : March. 2nd, 2011
1) Change pin_virtual_time to Feb. 11st, 2011 by:
pin_virtual_time -m 021110002011
2) Order(2011030258343) registerd and opened as done on Feb.1st, 2011 (Service creation log is m20110302.log and service number D300055836)
3) Change pin virtual time to March 1st. (pin_virtual_time -m 2 030110002011)
4) partial bill done with: xop PCM_OP_BILL_MAKE_BILL 0 1
5) Change order(2011030258344) registed and opened as done on Feb 10th. (Pricing factor SNI_FLD_FEE_GB has been changed from 01 to 02)
6) rerated:

expected result is:-

F 0009 - B & A monthly basic telephone call February 1, 2011 ~ February 9, 2011 unit price= 4000, quantity=2 sum = 4000*2 *9/28 = 2571.4285
2011/02/10 ~ 2011/02/28 unit price= 5000, quantity=2 sum = 5000*2 *19/28 = 6785.7142
total sum = 9357.1427

actual result is:-

F 0009 - B & A monthly basic telephone call February 1, 2011 ~ February 14, 2011 unit price= 5000, quantity=2 sum = 5000*2 *9/28 = 3214.285714
<== Canculated with the factor(SNI_FLD_FEE_GB = 02). error.
2011/02/10 ~ 2011/02/28 unit price = 5000, quantity=2 sum = 5000*2 *19/28 = 6785.714286
total sum = 10000

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.