ERROR: "INSERT, UPDATE, or DELETE operation(s) failed" inside Data Verification Id
Last updated on SEPTEMBER 24, 2007
Applies to:Oracle Financial Data Manager - Version: 4.5.39
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA)
You get the following error message when trying to update a table column inside the Data Verification Id:
"INSERT, UPDATE, or DELETE operation(s) failed!"
You are using a user defined table. You try to update a column in the Data Verification Id that is on the same row with a SYSDATE date column or a date column with timestamp appended to it. The column may also have a SYSDATE or timestamp appended to it. You can successfully update the SYSDATE or timestamp column in SQL*Plus.
Users manually updated a date column one of two ways:
1) update table set date_column=SYSDATE, or
2) update table set date_column = TO_DATE('03-31-2005 11:00 AM', 'MM-DD-YYYY HH:MI AM');
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms