Master Detail Form not updating the detail table (APEX)
RodiMay 12 2011 — edited Jul 26 2011Hi,
I have an EVENTS / Dates master detail form in APEX, and it worked great. I made some minor changes, and all of the sudden the updates are not taking place, and I am getting the following error message:
Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-01722: invalid number, update "RODI"."TBL_EVENT_DAYS" set "TBL_EVENT_DAY_ID" = :b1, "TBL_EVENT_ID" = :b2, "TBL_EVENT_DAY" = :b3
Unable to process update.
In the same window, I had tried to make another update that resulted in the following error message:
Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "40ED53CF82A165EE6A8C113D4D7CC520", item checksum = "62D04DB64548360577F050B3D36D2863"., update "RODI"."TBL_EVENT_DAYS" set "TBL_EVENT_DAY_ID" = :b1, "TBL_EVENT_ID" = :b2, "TBL_EVENT_DAY" = :b3
I know I could rebuild the form, but that would be a lot of work. Does anyone know if this is fixable?
Edited by: Rodi on May 12, 2011 8:49 AM
Edited by: Rodi on May 12, 2011 9:04 AM