Can't Close A Service If The Account Was Created In 7.2.1 And Upgraded To 7.4.0 (Doc ID 1107300.1)

Last updated on DECEMBER 28, 2011

Applies to:

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

Symptoms

We are working on the upgrade from  BRM 7.2.1 to BRM 7.4, we found a problem when we want to close a service for an account that was created under BRM 7.2.1.

Using Customer Center in BRM 7.4 to close the service, we see this flist for pcm_op_search:
       s_flistp of cycle event get_scale search input flist
# number of field entries allocated 20, used 11
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 83700 68
0 PIN_FLD_ARGS          ARRAY [2] allocated 20, used 1
1     PIN_FLD_CYCLE_INFO   SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_CYCLE_END_T  TSTAMP [0] (1274065200) Mon May 17 00:00:00 2010
0 PIN_FLD_ARGS          ARRAY [3] allocated 20, used 1
1     PIN_FLD_CYCLE_INFO   SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_FLAGS           INT [0] 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/cycle/cycle_forward_monthly -1 0
0 PIN_FLD_ARGS          ARRAY [5] allocated 20, used 1
1     PIN_FLD_PRODUCT      SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_OFFERING_OBJ   POID [0] 0.0.0.1 /purchased_product 445417 3
0 PIN_FLD_ARGS          ARRAY [6] allocated 20, used 1
1     PIN_FLD_PRODUCT      SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_NODE_LOCATION    STR [0] "spes_01#865/1#20090914-114820.539504:spes_01#865/1#20090914-114820.539558#4"
0 PIN_FLD_ARGS          ARRAY [7] allocated 20, used 1
1     PIN_FLD_RERATE_OBJ     POID [0] 0.0.0.0  0 0
0 PIN_FLD_TEMPLATE        STR [0] " select X from /event/billing/product/fee/cycle  where F1 = V1 and F2 > V2 and  F3 in ( 8, 16, 24, 40, 256, 272, 2056, 1032, 1280, 4104, 4120, 4352, 65792, 262400, 327936, 524544, 525568, 8388616, 8388632, 8388636, 8388864, 8389640, 8454400, 262152) and F4 = V4 and ( F5 = V5  or F6 = V6 ) and  F7 = V7 "
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 0

BRM 7.4 give us this error:
D Mon May 17 12:03:40 2010  BRM0037  cm:27248  fm_subscription_cycle_utils.c:5542 1:jsarra-ar:CustomerCenter:0:AWT-EventQueue-0:86:1274108937:0
       fm_subs_utils_get_orig_cycle_events return flist
# number of field entries allocated 20, used 2
0 PIN_FLD_POID           POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_ERR_BUF         ERR [0]
       <location=PIN_ERRLOC_DM:4 class=PIN_ERRCLASS_APPLICATION:4 errno=PIN_ERR_BAD_SEARCH_ARG:18>
       <field num=PIN_FLD_NODE_LOCATION:5,1825 recid=0 reserved=4 reserved2=0 time(sec:usec)=0:0>
       <facility=0 msg_id=0 version=0>


The problem is PIN_FLD_PRODUCT SUBSTRUCT [0] doesn’t contain: PIN_FLD_NODE_LOCATION STR. The class definition in BRM 7.4 is different against the search template.

If the account was created using BRM 7.4, in the same operation, we get this flist without node_location field:
  # number of field entries allocated 20, used 10
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 561640 16
0 PIN_FLD_ARGS          ARRAY [2] allocated 20, used 1
1     PIN_FLD_CYCLE_INFO   SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_CYCLE_END_T  TSTAMP [0] (1274065200) Mon May 17 00:00:00 2010
0 PIN_FLD_ARGS          ARRAY [3] allocated 20, used 1
1     PIN_FLD_CYCLE_INFO   SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_FLAGS           INT [0] 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/cycle/cycle_forward_monthly -1 0
0 PIN_FLD_ARGS          ARRAY [5] allocated 20, used 1
1     PIN_FLD_PRODUCT      SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_OFFERING_OBJ   POID [0] 0.0.0.1 /purchased_product 561848 5
0 PIN_FLD_ARGS          ARRAY [6] allocated 20, used 1
1     PIN_FLD_RERATE_OBJ     POID [0] 0.0.0.0  0 0
0 PIN_FLD_TEMPLATE        STR [0] " select X from /event/billing/product/fee/cycle  where F1 = V1 and F2 > V2 and  F3 in ( 8, 16, 24, 40, 256, 272, 2056, 1032, 1280, 4104, 4120, 4352, 65792, 262400, 327936, 524544, 525568, 8388616, 8388632, 8388636, 8388864, 8389640, 8454400, 262152) and F4 = V4 and ( F5 = V5  )  and F6 = V6 "
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 0

This search works fine because it does not use node_location deal.

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