Error When Rel Was Loading A Zero Balance Impact Cdr (Doc ID 1369471.1)

Last updated on DECEMBER 13, 2011

Applies to:

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

Symptoms


Errors when REL was loading a zero balance impact CDR into the DB.

pin_rel after loading the out file ,there is an incorrect balance  when one load lot of records .

  1)Create an account and checks the balance group for a non
  currenncy resource ( 2000001).This is initally -3600

  2)Pass around 3 usages (120 each for the above account impacting the above NCR)

  3)Discounting is involved

  Expectation is  the resource should be -3240 actual results is reso:-3340

  The out file does have the impact record file ,but not sure why rel does not
  load this.This issue does not happen for a simple scenario

  From the logs following are the calculations done (PIN_REL)


  ==


  Initially account balance was:
  RESOURCE_ID AMOUNT
  985         40,98
  2000001    -3600

  select bal.REC_ID2, bal.VALID_FROM, bal.CURRENT_BAL from BAL_GRP_SUB_BALS_T
  bal where bal.OBJ_ID0 in
  (select poid_id0 from BAL_GRP_T where ACCOUNT_OBJ_ID0=2956622);

  After rating EDRs look into rated file and try to find EDRs with balance
  impact on resource 2000001.
  Line 9:
  605 1 1 /balance_group 2956574 0 2000001
  607 2 120 1295391600 0 0 0
  Line 19:
  605 1 1 /balance_group 2956574 0 2000001
  607 2 120 1295391600 0 0 0
  Line 280:
  605 1 1 /balance_group 2956574 0 2000001
  607 2 120 1295391600 0 0 0

  So it is 120 x 3 = 360 total balance impact for resource 2000001.
  Initially account balance was -3600 for resource 2000001, so now I'm
  subtracting:  -3600+360=-3240.
  To confirm my calculations I'm checking what pin_rel loaded in
  event_bal_impacts_t table:

  POID_TYPE AMOUNT RESOURCE_ID
  /event/billing/product/fee/cycle/cycle_forward_monthly -3600 2000001
  /event/delayed/session/telco 120 2000001
  /event/delayed/session/telco 120 2000001
  /event/delayed/session/telco 120 2000001

  select e.POID_TYPE, ebi.AMOUNT, ebi.RESOURCE_ID
  from event_bal_impacts_t ebi, event_t e
  where ebi.OBJ_ID0=e.POID_ID0
  and e.ACCOUNT_OBJ_ID0=2956622
  and ebi.RESOURCE_ID=2000001;

  At the beginning account balance was -3600 for resource 2000001. After
  summing all amounts for resource 2000001 it should be -3240.
  So my calcutions are correct. Now checking balance group again (same sql
  query as in step 1):
  RESOURCE_ID AMOUNT
  985    962,6
  2000001 -3480

  "At the beginning account balance was -3600 for resource 2000001. After
  summing all amounts for resource 2000001 it should be -3240.
  So my calcutions are correct. Now checking balance group again (same sql
  query as in step 1):
  RESOURCE_ID AMOUNT
  985    962,6
  2000001 -3480

  So total amount for resource 2000001 is incorrect."

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