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"
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.