ERROR: "INSERT, UPDATE, or DELETE operation(s) failed" inside Data Verification Id (Doc ID 329475.1)

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)

Symptoms

You get the following error message when trying to update a table column inside the Data Verification Id:

"[1]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.

Changes

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');

Cause

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