Reconfigure CDRs

Issue:

CDRs are getting skipped because the customer has their own rating engine and they have not installed all rate plans required for rating calls.

Solution:

  1. Permanently Stop the CDRRate loop at NexOSS.

  2. Change column definition of REACDR.ARCHIVED from Timestamp to CHAR(1).

   alter table REACDR drop (Archived);
   alter table REACDR add (Archived CHAR(1) default 'N');
  1. Temporarily stop the archive_ratedcdr_table loop while making the following configuration changes

    • In unix/bin/start_RatedCDR_to_ArchivedRatedCDR.sh change input table name and specify that the records should be deleted after processing

    from

      EXTRA_PARAMS="InternalBillingTableName=RATEDCDR ExternalBillingTableName=ARCHIVEDRATEDCDR RuleTable=ARCHIVED_RATED_CDR_RULES SetFlagAfterProcessing=Archived SetFlagValueAfterProcessing=Y DeleteRecordsAfterProcessing=false"
    

    to

      EXTRA_PARAMS="InternalBillingTableName=REACDR ExternalBillingTableName=ARCHIVEDRATEDCDR RuleTable=ARCHIVED_RATED_CDR_RULES SetFlagAfterProcessing=Archived SetFlagValueAfterProcessing=Y DeleteRecordsAfterProcessing=true"
    
    • In sql/rules/rules_ratedcdr_to_archivedratedcdr.sql change (and reload the file into the database) the source for the duration values and comment out the billing amount values.

    from

      insert into ARCHIVED_RATED_CDR_RULES values('1',  'O_BillingDuration',                   'varchar_to_varchar',       'O_BillingDuration');
      insert into ARCHIVED_RATED_CDR_RULES values('1',  'O_BillingAmountFuncCurr',      'varchar_to_varchar',       'O_BillingAmountFuncCurr');
      insert into ARCHIVED_RATED_CDR_RULES values('1',  'T_BillingDuration',                   'varchar_to_varchar',       'T_BillingDuration');
      insert into ARCHIVED_RATED_CDR_RULES values('1',  'T_BillingAmountFuncCurr',       'varchar_to_varchar',       'T_BillingAmountFuncCurr');
    

    to

      insert into ARCHIVED_RATED_CDR_RULES values('1',  'RatedDuration',                    'varchar_to_varchar',       'O_BillingDuration');
      --insert into ARCHIVED_RATED_CDR_RULES values('1',  'O_BillingAmountFuncCurr',     'varchar_to_varchar',       'O_BillingAmountFuncCurr');
      insert into ARCHIVED_RATED_CDR_RULES values('1',  'RatedDuration',                    'varchar_to_varchar',       'T_BillingDuration');
      --insert into ARCHIVED_RATED_CDR_RULES values('1',  'T_BillingAmountFuncCurr',      'varchar_to_varchar',       'T_BillingAmountFuncCurr');