I'm getting this error following an update or delete ?
ORA-20001: Error in DML: p_rowid=21, p_alt_rowid=ID, p_rowid2=, p_alt_rowid2=. ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "1FFA33DC4A60C98933B2BE9961D15CDA" application checksum = "0"
sounds like either:
1) someone else is editing the same thing you are editing; or more likely
2) your browser's cache settings are causing you to look at an old version of an edit page.
The message you're seeing is preventing you from saving old data over new data. Check to see if your browser checks for updated pages every time rather than "automatically"
Yep just tried that, but this time trying to delete the record.
"Current version of data in database has changed since user initiated update process."
However if this helps we have a sperate schema / user that has been granted select,insert,update and delete to the actual owner schema / user of the table.
Thank you... this posting just helped me!
I had built a master-detail with original SQL as below:
select "ID", "ORDER_ID", "PROD_ID", "SHIP_DATE",
"RETURN_DATE", "QNTY_ORDERED", "QNTY_SHIPPED"
where "ORDER_ID" = :P10_ID
To get my product name and qnty on hand to show I joined my products table:
select "O"."ID", "ORDER_ID", "P"."PROD_ID", "SHIP_DATE",
"RETURN_DATE", "QNTY_ORDERED", "QNTY_SHIPPED",
from LS_ORDER_ITEM O, LS_PRODUCTS P
where P.ID1 = O.PROD_ID AND "ORDER_ID" = :P10_ID
BUT it stopped updating - I was getting the error in "Subject"
"make sure that your column aliases match your column names (for updateable columns). "
"PROD_ID" is an updateable column but I was displaying "P"."PROD_ID" from the products table. I changed it to "O"."PROD_ID" and it worked fine!
(This is posted for all those newbies like me that find this in the future...)
I had this error for 2 days. As an application developer I could not find the exact case from the forum or elsewhere on the web. As the matter of fact I found it recently. From where? From Enterprice manager. Tablespace is full. After adding memory the error "Current Version Of Data In Database Has Changed Since User Initiated Update" has gone. The error or exception thrown from DB is pretty annoying and misunderstanding. If the error was something related memory problem or not enough memory I could resolve it in minutes. Using APEX as developer by time we are getting closer to database administrator role.
After memory addition to tablespace my problem not solved at all. Some transactions gave the error and some did not. So, my previous thesis is wrong.
It is 4th day I am on this problem and I solved it by remaking primary key.