Apex Version 19.2.0.00.18
I added some highlights to several columns using the Tools-Action Menu-Format-Highlight built in. 4 of the columns I'm highlighting are dates using the date picker. The value is not required.
When I exited and returned to the page I got this list of errors:
ora_sqlerrm: ORA-01840: input value not long enough for date format ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 992 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1930 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1212 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1930 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1212 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1930 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 4255 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 3460 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_API", line 197 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_API", line 423 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 1811 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 3421 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 4079 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 5907 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 6277 ORA-06512: at "APEX_190200.WWV_FLOW_REGION_NATIVE", line 2391 ORA-06512: at "APEX_190200.WWV_FLOW_PLUGIN", line 2212 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1397 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1881 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1193 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1868 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1193 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1868 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 977
As a quick test I set the server side to Never for the grid and the page displayed without error. Before adding the highlights, the page rendered as expected.
Is this a bug?
If I temporarily removed the date columns from the query in the grid, saved it and put them back the error went away - as did the highlight on those columns (which made sense).