Hi,
I am using Oracle APEX 24.1.0.
Problem:
When updating a record on an interactive grid, I receive a message in the ajax process:
Exception in "do_execute_dml, row 1":
Error Stack: ORA-01403: no data found
Backtrace: ORA-06512: przy "APEX_240100.WWV_FLOW_EXEC_LOCAL", linia 2818
Description of the functionality in which the error occurs:
The problem occurs when I want save the modified record on Interactive Grid.
The page has a “create human task” (apex_human_task.create_task) within the “Interactive Grid - Automatic ROW Processing (DML)”.
To reproduce the error you need to:
1. Create a Task Definition
2. Create a page of the type "Interactive Grid"
3. Create a process "Interactive Grid - Automatic ROW Processing (DML)"
Target Type: PL/SQL Code
declare
l_task_id number;
begin
l_task_id:=apex_human_task.create_task(
p_application_id => :APP_ID,
p_task_def_static_id => 'AKCEPTACJA_RACHUNKU',
p_subject => 'Test task',
p_initiator => 'xxxxxx'
);
end;