Interactive Grid (IG) ORA-01403 Error in Oracle APEX 5.1.2

0
votes

How can I overcome this {Ajax call returned server error ORA-01403: no data found for} problem? Problem arises ,When I want to set Order_Status_Field value 2 in IG where query was Order_Status_Id=1.

My IG query was :

SELECT P.ORDER_ID, P.ORDER_STATUS_ID FROM ORDER_DETAILS P WHERE P.ORDER_STATUS_ID=1;

My Workspace Name: ZISHAN

User: ZISHANIIUC@GMAIL.COM

Pass: 123

Problem Page No: 3 (Order Report)

1. Before Updating Order Status: enter image description here

2. After Updating Order Status: enter image description here

1
oracle-apexoracle-apex-5oracle-apex-5.1

1 Answers

2
votes

I saw your are using standard "Interactive Grid - Automatic Row Processing (DML)" process, which is an AJAX approach. this apex behaviour is a call ajax using json format for data. so you have a filter on your sql query 

SELECT T.ORDER_ID,
       T.TABLE_ID,
       T.TAKEN_BY,
       T.ORDER_STATUS_ID,
       T.TOTAL_COST
FROM ORDER_DETAILS T
 WHERE T.ORDER_STATUS_ID=2

and you want to update your filter column (data has change) it's seem like apex do not find the prevouis data filter and return no_data_found (not really sure what happen ) but for solution : .

  1. put your filter in interactive grid --> action button ---> filter or
  2. write your own custom process