5 Replies Latest reply: May 30, 2012 2:32 AM by 892563 RSS

    No data found error : Error processing Multi Row Update process APEX4.1

    699839
      Good Day all

      We upgraded to APEX 4.1 last night, and since then a manually created tabular form cannot be updated anymore.

      The query used to create the tabular form is:

      select apex_item.hidden(1,PK_TIMESHEET_LINE)||
      apex_item.md5_checksum(DAY_01,DAY_02,DAY_03,DAY_04,DAY_05,DAY_06,DAY_07)||
      decode(task_type,'Logging', apex_item.text(2,DAY_01,7), apex_item.hidden(2,DAY_01,7)) DAY_01,
      decode(task_type,'Logging', apex_item.text(3,DAY_02,7), apex_item.hidden(3,DAY_02,7)) DAY_02,
      decode(task_type,'Logging', apex_item.text(4,DAY_03,7), apex_item.hidden(4,DAY_03,7)) DAY_03,
      decode(task_type,'Logging', apex_item.text(5,DAY_04,7), apex_item.hidden(5,DAY_04,7)) DAY_04,
      decode(task_type,'Logging', apex_item.text(6,DAY_05,7), apex_item.hidden(6,DAY_05,7)) DAY_05,
      decode(task_type,'Logging', apex_item.text(7,DAY_06,7), apex_item.hidden(7,DAY_06,7)) DAY_06,
      decode(task_type,'Logging', apex_item.text(8,DAY_07,7), apex_item.hidden(8,DAY_07,7)) DAY_07,
      decode(task_type,'Logging', NULL,'<b>')
      ||replace(lpad('.',(task_level*5)-5,'.'),'.','&nbsp')
      ||qts_get_task_name(fk_task)
      ||decode(task_type,'Logging', NULL,'</b>') task_name,
      decode(nvl(DAY_01,0)+nvl(DAY_02,0)+nvl(DAY_03,0)+nvl(DAY_04,0)+nvl(DAY_05,0)+nvl(DAY_06,0)+nvl(DAY_07,0),
      0,null,
      to_char(nvl(DAY_01,0)+nvl(DAY_02,0)+nvl(DAY_03,0)+nvl(DAY_04,0)+nvl(DAY_05,0)+nvl(DAY_06,0)+nvl(DAY_07,0),'99.00')) total
      from qts_timesheet_lines
      where FK_TIMESHEET = :P7_PK_TIMESHEET
      and fk_task in (select pk_project_tasks
      from qts_project_tasks
      where fk_agreement_project = nvl(:P7_PK_PROJECT,fk_agreement_project))
      order by pk_timesheet_line


      The table is displayed, and when the apply changes button is pressed, a PL/SQL anonymous block executes, with the following code:

      APEX_ITEM.MULTI_ROW_UPDATE('Q2_FIN_DEV:QTS_TIMESHEET_LINES:PK_TIMESHEET_LINE,1:|DAY_01,2:DAY_02,3:DAY_03,4:DAY_04,5:DAY_05,6:DAY_06,7:DAY_07,8');


      The error received is:

      No Data Found
      Error processing Multi Row Update


      This worked fine in APEX 4.0, and was still in use yesterday, before the upgrade.


      I expect this might have something to do with a change in column order, as a result of the new feature with primary keys in tabular forms. I however cannot find any guidance on how the syntax should look now.


      Any help will be appreciated.


      Kind Regards
      Marissa Stander