This content has been marked as final. Show 5 replies
I re-created the problem on apex.oracle.com.
The application is called BUG MRU
To reproduce the problem, enter a numeric value in any of the fields. Click on the SAVE TIMESHEET button. The error will be produced.
Thank you kindly for your assistance.
You will have to get an official confirmation from Patrick, but as far as I can tell, the problem is with you using a manually created Tabular Form with the APEX_ITEM.MULTI_ROW_UPDATE procedure.
This procedure was taken out from documentation since APEX 3.2, and I believe that only now we can see the reason.
As far as I understand it, with APEX 4.1, the MRU process is using the “new” hidden column FCUD. Although the column was there in the 4.0 version, only in 4.1 it was fully utilized. Unfortunately, this column doesn’t have a matching APEX_ITEM API, so it can’t be used in a manually created Tabular Form as in your case.
Maybe I’m wrong and Patrick will come with a solution for your situation, but I believe that you will have to devise your own MRU code.
BTW, it was I who played in your workspace and created a copy of page 1. I just wanted to eliminate some other known possible reasons (for example, you have used the original schema owner name and not the one in apex.oracle.com). I left your original page 1 intact for Patrick.
♦ Please remember to mark appropriate posts as correct/helpful. For the long run, it will benefit us all.
♦ Author of Oracle Application Express 3.2 – The Essentials and More