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:

Symptoms

 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.

Steps:

   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:

        http://<host>:<port>/xmlpserver/TEST_FOLDER/TEST_REPORT.xdo?_xpt=0&_xdo=%2FTEST_FOLDER%2FTEST_REPORT.xdo&_xmode=2&P_STRING={/DATA_DS/G_1/TEXTC}&P_NUMBER={/DATA_DS/G_1/NUMBERN}&_xf=html

   8. Save report; Done.

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

       http://<host>:<port>/xmlpserver/TEST_FOLDER/TEST_REPORT.xdo?_xpt=0&_xdo=%2FTEST_FOLDER%2FTEST_REPORT.xdo&_xmode=2&P_STRING=TEXTC&P_NUMBER=432237.2299999999813735485076904296875&_xf=html

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

Cause

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