My Oracle Support Banner

Issues With Decimal Values In Preview Section For An APP Built Through APEX App Builder (Doc ID 2988085.1)

Last updated on NOVEMBER 23, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Goal

Issues with decimal values in preview section for an APP built through APEX App builder

For columns having up to 2 decimal places, it has been displaying as 10-15 decimals (eg: 72.74 it is displaying as 72.73999999999999) in the preview section for the data loading template Application, and it is showing as expected after loading the data into the target table.

We are using apex_data_parser.parse() for the preview section. And also, we have tried the ROUND() and other possible methods for the SQL query but getting the errror "ORA-01722: invalid number".

Solution

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
Goal
Solution


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