Oracle APEX ORA-01722 when creating Interactive Report

Question

I keep getting an ORA-01722 whenever I try to save the page. This happens when I try to:

• Create a region as an Interactive Report: Tried 3 different tables, from the autmatic creation to typing the sql myself; With 1 or all columns; even doing a select 1 colX from dual;

• Change any classic report to interactive report and click save.

• If I create the interactive report from the template wizard, change to classic and try to move back, same issue.

• I've already tried only varchar columns, disables all features from the IR, gave it static id and basically turned everything off and on again.

Answer 1

When I add the second IR, it is set by default in the section Printing -> BorderWidth = .5, I changed the value to = ,5 and it can be saved without the ORA-01722 error.

Answer 2

I had a very similar issue but with Chrome. It worked for me to change to Firefox. It did however not help to dissable all chrome extensions.

Thanky you Paulo for posting solution.

Answer 3

As of jun/20 the issue is on chromium. I had to use firefox and noticed it wasn't happening, tried on chrome and opera and it was also ok.