[Spce-user] [EXTERNAL] Incorrect CDR Rating | mr12.3.1 | SipCE

[Quinten Rowland]

Hi Dario

Thanks for the pointer.

If I am correct nothing looks out of place.

If you would mind, maybe just confirm also ?

CDR
*************************** 1. row ***************************
                                  id: 7467
                         update_time: 2024-05-30 00:55:01
                      source_user_id: c5662180-5bdf-459a-beb1-66b86c11e8bf
                  source_provider_id: 1
       source_external_subscriber_id:
         source_external_contract_id: QUI001
                   source_account_id: 4
                         source_user: 27100XXXXX
                       source_domain: sip.cloudvoice.co.za
                          source_cli: 27100XXXXXX
                         source_clir: 0
                           source_ip: 169.XXXXXXXX
                   source_lnp_prefix:
                     source_user_out: 27100XXXXX
                 destination_user_id: 0
             destination_provider_id: 2
  destination_external_subscriber_id:
    destination_external_contract_id:
              destination_account_id: 0
                    destination_user: 27113221888
                  destination_domain: 105.XXXXXXX
             destination_user_dialed: 0113221888
                 destination_user_in: 27113221888
               destination_domain_in: sip.cloudXXXXXXXXXXXXX
              destination_lnp_prefix:
                destination_user_out: 27113221888
                      peer_auth_user:
                     peer_auth_realm:
                           call_type: call
                         call_status: ok
                           call_code: 200
                           init_time: 1717022346.054
                          start_time: 1717022347.119
                            duration: 4.224
                             call_id: 1_2550363646 at 192.168.0.125
                 source_carrier_cost: 0.000000
                source_reseller_cost: 0.000000
                source_customer_cost: 19.200000
            source_carrier_free_time: 0
           source_reseller_free_time: 0
           source_customer_free_time: 0
       source_carrier_billing_fee_id: 1002
      source_reseller_billing_fee_id: 1000
      source_customer_billing_fee_id: 1015
      source_carrier_billing_zone_id: 1001
     source_reseller_billing_zone_id: 1
     source_customer_billing_zone_id: 1019
            destination_carrier_cost: 0.000000
           destination_reseller_cost: 0.000000
           destination_customer_cost: 0.000000
       destination_carrier_free_time: 0
      destination_reseller_free_time: 0
      destination_customer_free_time: 0
  destination_carrier_billing_fee_id: NULL
 destination_reseller_billing_fee_id: NULL
 destination_customer_billing_fee_id: NULL
 destination_carrier_billing_zone_id: NULL
destination_reseller_billing_zone_id: NULL
destination_customer_billing_zone_id: NULL
                 frag_carrier_onpeak: NULL
                frag_reseller_onpeak: NULL
                frag_customer_onpeak: NULL
                       is_fragmented: 0
                               split: 0
                            rated_at: 2024-05-30 00:39:15
                       rating_status: ok
                         exported_at: 2024-05-30 00:55:01
                       export_status: ok
                     source_lnp_type: NULL
                destination_lnp_type: NULL

Billing Fee
*************************** 1. row ***************************
                          id: 1015
          billing_profile_id: 5
             billing_zone_id: 1020
                      source: .*
                 destination: ^278[1-9]\d{7}.*
                   direction: out
                        type: call
            onpeak_init_rate: 0.32
        onpeak_init_interval: 60
          onpeak_follow_rate: 0.32
      onpeak_follow_interval: 60
           offpeak_init_rate: 0.32
       offpeak_init_interval: 60
         offpeak_follow_rate: 0.32
     offpeak_follow_interval: 60
        onpeak_use_free_time: 0
                  match_mode: regex_longest_pattern
           onpeak_extra_rate: 0
         onpeak_extra_second: NULL
          offpeak_extra_rate: 0
        offpeak_extra_second: NULL
       offpeak_use_free_time: 0
aoc_pulse_amount_per_message: 0

On Thu, May 30, 2024 at 4:33 PM Dario Busso <dbusso at sipwise.com> wrote:

> You need to check the rated CDR record in the DB table accounting.cdr, the
> fee, and the billing profile used to rate the specific CDR.
>  Cross-check that the one applied is the one you intended to use.
> Dario
>
>
> On Thu, May 30, 2024 at 4:14 PM Quinten Rowland <quinten.rowland at gmail.com>
> wrote:
>
>> Hi All
>>
>> Would like to find out if anyone else has encountered the situation where
>> the call rating is rating the calls at a value lower than defined in the
>> billing profile fee's.
>>
>> I have a situation where the fee's defined in the billing profile is 0.32
>> but the cdr's are rated to 0.19.
>>
>> Any guidance would be much appreciated.
>>
>>
>> --
>> Kind Regards
>> Quinten Rowland
>> (+27) 62 318 2874
>> --
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
>>
>

-- 
Kind Regards
Quinten Rowland
(+27) 62 318 2874
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20240530/d6208812/attachment-0001.htm>