I have a view that is taking two timestamps and giving me the days, hours and min difference. It is working in SQL Developer showing correctly. When I create an interactive or classic report off the view I get an ORA-01843: not a valid month error off the day, hour minute fields. The view columns show these columns as numbers. I even tried to TO_CHAR them and still get the same result. If I turn off those columns the report shows the other data including the timestamps correctly. Does anyone have any ideas what is happening?
SQL Developer
Oracle DB 19C
Application Express 21.1.2