APEX 18.1, Master-detail IG by date column leads to ORA-01843: not a valid month
Master detail relationship between two grids by date column leads to ORA-01843: not a valid month error or to ORA-01858: a non-numeric character was found where a numeric was expected
LEVEL9 trace shows that APEX engine tries to bind date column using wrong format mask (YYYYMMDDHH24MISS instead of DD-MM-YYYY HH24:MI:SS)
Rewrite line to: select q.*,count(*) over () "APEX$TOTAL_ROW_COUNT"from(select "PK","TXT"from(SELECT date '2018-01-01' pk, 'Jan 2018' txt FROM dual UNION ALLSELECT date '2018-02-01' pk, 'Feb 2018' txt FROM dual)qwhere "PK"=:apex$1)qSQL Statement prepared: line count=1, first index=1, last index=1, characters=221, found binds=1bind_value p_name=>apex$1,p_data_type=>DATE,p_format_mask=>