1 Reply Latest reply on May 19, 2017 5:15 PM by Mike Kutz

    Data load Upgrade from 4.2 to 5 ORA-01403: no data found issue

    ade_adekoya

      Hello

       

      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

       

      DECLARE

         L_seq_id NUMBER;

         L_c00_last VARCHAR2(100);

      BEGIN

         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);

        

         APEX_COLLECTION.UPDATE_MEMBER

            (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'

               );

      END;

       

      Unfortunately this did not work. Can any body help setting this attribute?

       

      Regards

      Ade Adekoya