After an Upgrade from APEX4.2 to APEX5, we are experiencing a Dataload issue on the Dataload results page of error : ORA-01403: no data found
Looking at previous discussions the solution was to Update collection PARSE_COL_HEAD and set USE_APPLICATION_DATE_FORMAT.
I created a process to do this
Process Name : Update USE_APPLICATION_DATE_FORMAT
select max(seq_id) into L_seq_id from apex_collections where collection_name = 'PARSE_COL_HEAD';
L_c00_last := 'C00'||to_char(L_seq_id);
(p_collection_name => 'PARSE_COL_HEAD'
,p_seq => L_seq_id
,p_c001 => L_c00_last
,p_c002 => 'USE_APPLICATION_DATE_FORMAT'
,p_c003 => NULL
,p_c004 => 'Y'
Unfortunately this did not work. Can any body help setting this attribute?
this is why you
DO NOT USE UNDOCUMENTED FEATURES/TABLES/CODE!
posting the URL to the article you mentioned might help us know exactly what you are referring to (and the precise problem that your HACK-THAT-BROKE was trying to solve)