Issue Related to Field PARAM_THRESHOLD_VALUE of HUR Reports

(Doc ID 1639944.1)

Last updated on APRIL 11, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On : BRM  7.5.0.4.0 version, HUR Reports using BIP version 11.1.1.7.1 :

There is an issue with the field PARAM_THRESHOLD_VALUE of HUR Reports.

Details:

In the SDR field:
(…)
SUBSTR(TO_CHAR( SUM("EVENT_BAL_IMPACTS_T"."AMOUNT_ORIG"),'FM999999999.999'),1, INSTR(TO_CHAR( SUM("EVENT_BAL_IMPACTS_T"."AMOUNT_ORIG"),'FM999999999.999'),'.',1,1)-1) ||
SUBSTR(TO_CHAR( SUM("EVENT_BAL_IMPACTS_T"."AMOUNT_ORIG"),'FM999999999.999'), INSTR(TO_CHAR( SUM("EVENT_BAL_IMPACTS_T"."AMOUNT_ORIG"),'FM999999999.999'),'.',1,1)+1) SDR
(…)


                SELECT SUBSTR(TO_CHAR( SUM(51.88026),'FM999999999.999'),1, INSTR(TO_CHAR( SUM(51.88026),'FM999999999.999'),'.',1,1)-1) FROM DUAL;      -----> This results in 51
                SELECT SUBSTR(TO_CHAR( SUM(51.88026),'FM999999999.999'), INSTR(TO_CHAR( SUM(51.88026),'FM999999999.999'),'.',1,1)+1)  from dual;          -----> This results in 88

If the ("EVENT_BAL_IMPACTS_T"."AMOUNT_ORIG") = 51.88126, then the first part of statement returns 51, and the other one returns 881, producing the result 51881.

       SELECT SUBSTR(TO_CHAR( SUM(51.88126),'FM999999999.999'),1, INSTR(TO_CHAR( SUM(51.88126),'FM999999999.999'),'.',1,1)-1) FROM DUAL;     -----> This results in 51
       SELECT SUBSTR(TO_CHAR( SUM(51.88126),'FM999999999.999'), INSTR(TO_CHAR( SUM(51.88126),'FM999999999.999'),'.',1,1)+1)  from dual;         -----> This results in 881


EXPECTED BEHAVIOR:

In Case1, SDR result is 5188. Expected is 51880.


BUSINESS IMPACT:

This error leads users to  incorrect reading of the values presented in the HUR reports.

Changes

As per docs at "http://docs.oracle.com/cd/E16754_01/doc.75/e16718/rpt_tap_roaming_mgr.htm" , see below description about the SDR field of the HUR report:

"Special Drawing Right (SDR): The total Combined Roaming and SMS Interworking usage amount in SDR currency, expressed as a maximum-12-digit numeral, with the last 3 places as decimals. For example, 413021 represents 413.021.  "

  
In Case 1, as per the above design,  one would expect the output as  51880 rather than 5188.

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