My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.