Change In Rerate_Rebill Behavior After Applying Patch 8431843 (Doc ID 942485.1)

Last updated on OCTOBER 30, 2009

Applies to:

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

Goal

After applying the <<Patch 8431843>> , the rerating behavior is changing.


The following is the difference in the search template to retrieve events to be rerated :

Before applying the patch :

op_subscription_pol_spec_rerate return flist
# number of field entries allocated 20, used 13
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 4836398 25
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_END_T TSTAMP [0] (1230850801) Fri Jan 02 00:00:01 2009
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/fee/purchase -1 0
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/fee/purchase/% -1 0
0 PIN_FLD_ARGS ARRAY [5] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/adjustment/event -1 0
0 PIN_FLD_ARGS ARRAY [6] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [*] allocated 20, used 1
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 764848 0
0 PIN_FLD_ARGS ARRAY [7] allocated 20, used 1
1 PIN_FLD_END_T TSTAMP [0] (0) <null>
0 PIN_FLD_ARGS ARRAY [8] allocated 20, used 1
1 PIN_FLD_CREATED_T TSTAMP [0] (0) <null>
0 PIN_FLD_TEMPLATE STR [0] "select X from /event where ( F1 = V1 and F2 >= V2 ) and ( F3
= V3 or F4 like V4 or F5 = V5 ) and ( F6 = V6 ) and event_no is null and ( provider_descr is null
or provider_descr not like 'HIDDEN%' ) order by F8 asc, F7 asc "
0 PIN_FLD_RESULTS ARRAY [10000] NULL array ptr
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 4836398 25

After applying the patch :

op_subscription_pol_spec_rerate return flist
# number of field entries allocated 20, used 15
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 182798 25
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_END_T TSTAMP [0] (1230850801) Fri Jan 02 00:00:01 2009
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_CREATED_T TSTAMP [0] (1230850801) Fri Jan 02 00:00:01 2009
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_CREATED_T TSTAMP [0] (1234652400) Sun Feb 15 00:00:00 2009
0 PIN_FLD_ARGS ARRAY [5] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/fee/purchase -1 0
0 PIN_FLD_ARGS ARRAY [6] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/fee/purchase/% -1 0
0 PIN_FLD_ARGS ARRAY [7] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/adjustment/event -1 0
0 PIN_FLD_ARGS ARRAY [8] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [*] allocated 20, used 1
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 48984 0
0 PIN_FLD_ARGS ARRAY [9] allocated 20, used 1
1 PIN_FLD_END_T TSTAMP [0] (0) <null>
0 PIN_FLD_ARGS ARRAY [10] allocated 20, used 1
1 PIN_FLD_CREATED_T TSTAMP [0] (0) <null>
0 PIN_FLD_TEMPLATE STR [0] "select X from /event where ( F1 = V1 and ( F2 >= V2 and F3
>= V3 and F4 <= V4 ) ) and ( F5 = V5 or F6 like V6 or F7 = V7 ) and ( F8 = V8 ) and
event_no is null and ( provider_descr is null or provider_descr not like 'HIDDEN%' ) order by F10
asc, F9 asc "
0 PIN_FLD_RESULTS ARRAY [10000] NULL array ptr
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 182798 25

 

Q1) In the input flist to rerating if we pass the flag value as 2 (PIN_FLD_RERATE_BY_CREATED_T 0x02) , rerating should search and rerate events based on CREATED_T, but in the search above(after patch), it has END_T and CREATED_T.

Q2) What is the significance of the change in the search query template ?

Solution

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