This content has been marked as final. Show 8 replies
Any validations? Processes? conditions?
Yes. A "Loc not null" - Validation on Column Loc in TabularForm. And a "After Header" Process to load the items in region "Form on EMP".
the reason for that error is that the tabular form doesn't have a MRU process, but the meta information of that process is required for re-displaying the tabular in case of an error.
I have added the missing MRU process with a condition of type "Never" which will give APEX all the necessary information for re-displaying the invalid tabular form data, but because of the "Never" condition it will not fire in case of a successful submit.
I will inform the developer in charge if it's possible to improve the error message for 4.2 if the MRU is missing.
My Blog: http://www.inside-oracle-apex.com
APEX Plug-Ins: http://apex.oracle.com/plugins
what could be causing this if your MRU process is not missing. How can you make sure that the tabular form still displays after a validation fails?
do you have an example on apex.oracle.com where I can have a look at?
Too bad, I wasn't able to reproduce it on apex.oracle.com
No idea what could be causing this error, and the entire tabular form disappears when the user-defined exception is displayed.
I even tried deleting the tabular form and created it again, but still getting that error.
I have been battling the same or similar problem for past 3 weeks. In my case it triggers if you add say 5 extra rows and on the 5th entry you leave the row incomplete (hence fails validation) and I get a report error. if you click submit again then it I get the User Defined Exception
Report Error when tabular form fails validation
Did you see error entry with this code in your debug?
Execute Statement: begin begin select lov_disp_value, lov_return_value bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from wwv_flow_list_of_values_data_v where lov_id = 74036122111933119 and (required_patch is null or (required_patch > 0 and (wwv_flow_item.fetch_g_build_options_excluded is null or instr(wwv_flow_item.fetch_g_build_options_excluded,':'||required_patch||':') = 0) ) or (required_patch < 0 and (wwv_flow_item.fetch_g_build_options_included is null or instr(wwv_flow_item.fetch_g_build_options_included,':'||(0-required_patch)||':') = 0) ) ) and exists (select 1 from wwv_flow_lists_of_values$_v where id = 74036122111933119) order by LOV_DISP_SEQUENCE, upper(lov_disp_value) ; end; end;
And then if I hit submit, again then get the user defined exception
I get something like this in the debug right before the user-defined exception
Execute Statement: begin begin select /*+ cardinality(t 10) */ disp, val bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from table(wwv_flow_utilities.get_temp_lov_data(3)) t order by insert_order, disp; end; end;
But in my case it's not the adding of extra rows, that's causing this because I don't use that for my tabular form.
I wish I could help, don't know what's up with this error.