Profiles (Serv And Act Extrating) Are Read Respectively 3 Times And 2 Times. (Doc ID 1308848.1)

Last updated on OCTOBER 05, 2015

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

During billing, profile/acct_extrating and /profile/serv_extrating read respectively 3 times and 2 times.

The solution should be to read only once each and cache.

 Here is the scenario
 
 1. PVT (pin_virtual_time) to June 1st, 2009
 2. Create account A1 with 11 deals having CF (Cycle Forward) event
 3. Create account A2 similar to A1
 4. PVT to July 6th, 2009
 5. Do billing for A1 and A2



Here is the exact input flist of the opcode:

 261054 fm_rate_get_eras_get_from_profile input flist
 261055 # number of field entries allocated 20, used 6
 261056 0 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/fee/cycle/cycle_forward_monthly -1 0
 261057 0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 39335427197 0
 261058 0 PIN_FLD_SERVICE_OBJ   POID [0] 0.0.0.1 /service/ip/gprs  39335421665 7
 261059 0 PIN_FLD_START_T            TSTAMP [0] (1243807200) Mon Jun 01 00:00:00 2009
 261060 0 PIN_FLD_END_T                TSTAMP [0] (1243807200) Mon Jun 01 00:00:00 2009
 261061 0 PIN_FLD_EFFECTIVE_T    TSTAMP [0] (1246399200) Wed Jul 01 00:00:00 2009

 And here is the content from the transaction list:

 260947 D Mon Jun 01 00:00:22 2009 sdsbico1v cm:12629
 fm_rate_get_eras.c:864 1:sdsbico1v:<no_name>:12241:1:10000:1284731080:2
 260948 Transaction flist..
 260949 # number of field entries allocated 20, used 5
 260950 0 PIN_FLD_PROFILES ARRAY [0] allocated 20, used 4
 260951 1    PIN_FLD_POID                 POID [0] 0.0.0.1 /service/ip/gprs 39335421665 6
 260952 1    PIN_FLD_EFFECTIVE_T TSTAMP [0] (1243807200) Mon Jun 01 00:00:00 2009
 260953 1    PIN_FLD_PROFILE_DATA_ARRAY ARRAY [0] allocated 20, used 3
 260954 2       PIN_FLD_PROFILE_NAME      STR [0] "CUSTCODE"
 260955 2       PIN_FLD_POID                         POID [0] 0.0.0.1 /account  39335427197 0
 260956 2       PIN_FLD_DATA_ARRAY ARRAY [0] allocated 20, used 4
 260957 3          PIN_FLD_NAME              STR [0] "CUSTCODE"
 260958 3          PIN_FLD_VALID_FROM TSTAMP [0] (1243807200) Mon Jun 01 00:00:00 2009
 260959 3          PIN_FLD_VALID_TO       TSTAMP [0] (0) <null>
 260960 3          PIN_FLD_VALUE             STR [0] "1.8040631"
 260961 1 PIN_FLD_PROFILE_DATA_ARRAY ARRAY [1] allocated 20, used 3
 260962 2    PIN_FLD_PROFILE_NAME  STR [0] "BSCS_CUST_ID"
 260963 2    PIN_FLD_POID                     POID [0] 0.0.0.1 /account  39335427197 0
 260964 2    PIN_FLD_DATA_ARRAY ARRAY [0] allocated 20, used 4
 260965 3       PIN_FLD_NAME                 STR [0] "BSCS_CUST_ID"
 260966 3       PIN_FLD_VALID_FROM    TSTAMP [0] (1243807200) Mon Jun 01 00:00:00 2009
 260967 3       PIN_FLD_VALID_TO          TSTAMP [0] (0) <null>
 260968 3       PIN_FLD_VALUE                STR [0] "BSC:BAC:8040482"



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