PRICING CENTER DESTROY SERVICE HIERARCHY (Doc ID 1080285.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0 and later   [Release: 7.3.1 and later ]
Information in this document applies to any platform.

Symptoms

Pricing Center reverses the Service Hierarchy uploaded into the DB.

Reproduction steps:

1. Create a subscription plan with parent "/service" having members "/service/ip" and 
"/service/email".

2. Commit with Pricing Center..

3. Using SQL alter the order of values in table "plan_services_t". The Out Of Box
order is "1, 2, 3" for array "rec_id" and physical order. Change it to 2, 3, 1.

4. stop_all, start_all.

5. Read plan with PC. Notice in the cm.log:

0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 13
1 PIN_FLD_POID POID [0] 0.0.0.1 /plan 20668224 0
1 PIN_FLD_CREATED_T TSTAMP [0] (1265146674) Tue Feb 2 18:37:54 2010
1 PIN_FLD_MOD_T TSTAMP [0] (1265146674) Tue Feb 2 18:37:54 2010
1 PIN_FLD_READ_ACCESS STR [0] "B"
1 PIN_FLD_WRITE_ACCESS STR [0] "S"
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1 0
1 PIN_FLD_DEAL_OBJ POID [0] 0.0.0.0 / 0 0
1 PIN_FLD_DESCR STR [0] "X"
1 PIN_FLD_FLAGS INT [0] 0
1 PIN_FLD_NAME STR [0] "X"
1 PIN_FLD_SERVICES ARRAY [2] allocated 20, used 5
2 PIN_FLD_BAL_INFO_INDEX INT [0] 0
2 PIN_FLD_DEAL_OBJ POID [0] 0.0.0.0 0 0
2 PIN_FLD_SERVICE_ID STR [0] ""
2 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/email -1 0
2 PIN_FLD_SUBSCRIPTION_INDEX INT [0] 1
1 PIN_FLD_SERVICES ARRAY [3] allocated 20, used 5
2 PIN_FLD_BAL_INFO_INDEX INT [0] 0
2 PIN_FLD_DEAL_OBJ POID [0] 0.0.0.0 0 0
2 PIN_FLD_SERVICE_ID STR [0] ""
2 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip -1 0
2 PIN_FLD_SUBSCRIPTION_INDEX INT [0] 1
1 PIN_FLD_SERVICES ARRAY [1] allocated 20, used 5
2 PIN_FLD_BAL_INFO_INDEX INT [0] 0
2 PIN_FLD_DEAL_OBJ POID [0] 0.0.0.0 0 0
2 PIN_FLD_SERVICE_ID STR [0] ""
2 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service -1 0
2 PIN_FLD_SUBSCRIPTION_INDEX INT [0] 1

The order is the physical order in the table. This is correct as the search
opcode does not guaranty retrieving an array in index order.

6. Notice in PC the plan has the wrong structure.

Pricing Center is assuming that the first
element on the flist is the parent of subs, instead
of using PIN_FLD_SUBSCRIPTION_INDEX.

 


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