My Oracle Support Banner

BI Publisher - When Using a URL Link To Call a Report With Parameters, the Value With Decimal Places Shown for the Parameters Is Not Interpreted Right In URL (Doc ID 2964375.1)

Last updated on AUGUST 04, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 to 12c [Release 12.2 to 12.0]
Information in this document applies to any platform.


 When using a URL link to call a report with parameter, the number with decimal places shown for the parameter is not interpreted right in URL.


   1. Navigate to BI Publisher > Catalog and create a simple SQL Query Data Set:

        Eg: Select TEXTC TEXTC, DATED DATED, 432237,23 NUMBERN, sysdate mydate from dual

   2. Define a P_NUMBERN parameter, type float.

   3. Click View; Save As Sample Data;Save.

   4. Create a new Report from the above Data Model.

   5. Save Report: Finish.

   6. Interactive View - Edit Layout.

   7. Select NUMBERN Column data and enter below into URL field:


   8. Save report; Done.

   9. Once displaying the interactive report > Click on NUMBERN link:


Note: The decimal value 432237.23 displays as float in the parameter field after passing the report URL:432237.2299999999813735485076904296875 and it should be: 432237.23


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

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