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');
   

3. 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');