I have a basic tabular form and one column links out to a URL (documents on our server). The link works fine, but the table doesn't get updated on the Submit button.
In another report/form in this application there is a field called DOC_LINK in the table that gets created by concatenating fields entered on that form. The user enters data on that form and the select statement for that report concatenates the DOC_LINK based on various conditions and fields on the form. Here's a scaled down version (there are nearly a bazillion conditions that I have to use, and all works delightfully well):
SELECT DOC_ID, DOC_TITLE,
CASE WHEN STATUS_ID = 5
THEN 'file://nyServer/Documents/Obsolete Docs/' || ISO_NUMBER || REVNUMBER|| FILE_TYPE
END DOC_LINK
from "#OWNER#"."DOC_INFO"
where DOC_ID IS NOT NULL
ORDER BY 1
By using this and the update/inserts for that form/report, the DOC_LINK field never gets stored in the database, rather it's just used for the link action. I didn't have a need to store it but maybe now I do?
Because I need to call the rows from that table (DOC_INFO) when the record needs to be marked "Approved," I've created a tabular form on that table using a few of the fields. Because the DOC_LINK field was never stored I thought I'd use the same case statement for this tabular form to get the link. (The user needs the option to link out to this document to review before clicking the "Approved" checkbox on the tabular form.) I can use the same case statement for this tabular form and the link works fine, but I get this error when I click the submit button:
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 = "F60BB4F91CD869BA6BE0D52DEF590252", item checksum = "36FFF4C614872DDFD326F17F4CA151C4"., update "MYWORKSPACE1"."DOC_INFO" set "DOC_INFO_ID" = :b1, "DOC_TITLE" = :b2, "OWNER" = :b3, "APPROVAL_REQ" = :b4, "APPROVED" = :b5
I've tried turning off the MRU Routine and creating a simple UPDATE statement to no avail.
Sooooooooo, the question is, how do I get the link to work and update the table too? All I need to update is the APPROVED field, so the tabular form displays all fields as 'Display as Text' except for the Approved field which is a checkbox (Yes, No).
Your thoughts?
Thanks in advance.
Alexandra