Journal Entries Are Incorrect For Discounted CDRs (Doc ID 1142323.1)

Last updated on NOVEMBER 09, 2010

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

For a subscriber who has a discount configured, like free minutes: when we rate a CDR that is eligible for the discount, the entries in the journal table have incorrect values.

Steps to reproduce :

1) Created account with 'Standard GSM Telephony' plan. This one has 3600 free seconds every month

2) See results in journal_t , after account creation :


ITEM_OBJ_TYPE GL_ID RESOURCE_ID DB_AR_NET_AMT DB_AR_DISC_AMT CR_AR_NET_AMT CR_AR_DISC_AMT
/item/cycle_forward 102 978 45 5 0 0
/item/cycle_forward 0 1000095 0 0 3600 0

3) Now rate 7 CDRs in same file , each with 240 Seconds , amounting to 1680 seconds . Each CDR results in a charge of 0.48EUR , so total charge is 3.36EUR. There will be one single rated output file that is loaded to DB using pin_rel.

4) See results in journal_t now :


ITEM_OBJ_TYPE GL_ID RESOURCE_ID DB_AR_NET_AMT DB_AR_DISC_AMT CR_AR_NET_AMT CR_AR_DISC_AMT
/item/us/roaming/rtelo 1420 978 0.96 3.36 0.96 0
/item/us/roaming/rtelo 1420 1000095 1680 0 0 1680



Expectation : DB_AR_NET_AMT and CR_AR_NET_AMT should not get populated

Actual : DB_AR_NET_AMT and CR_AR_NET_AMT is equal to 0.96 , which is sum of charges from 2 rated CDRs.

Note: If we rate the one CDR at a time in separate files, we will see that the fields DB_AR_NET_AMT and CR_AR_NET_AMT do not get updated as expected for these discounted CDRs.  Only the field  DB_AR_DISC_AMT gets populated. So the problem is seen when we rate multiple CDRs in one file.

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