Cannot Update or Delete Records with Null Value in Data Verification ID (Doc ID 233978.1)

Last updated on MAY 13, 2010

Applies to:

Oracle Financial Data Manager - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
Checked for relevance on 13-May-2010
Oracle Financial Services Applications (OFSA) 4.5
Data Verification ID Spreadsheet Window

Symptoms

When attempting to delete a record using Data Verification ID, the following error occurs:

Error:
 [1]INSERT, UPDATE, or DELETE operation(s) failed!
Check table rows and columns for NULL values.

Steps:
1. Try to update or delete a record with Null Value.
2. Received the above error.
3. Hit okay and received the following SQL statement:

delete from DEPOSITS
where ACCOUNT_NUMBER = '984439541'
and AGGREGATION_04 = 1 and TP_COA_ID = 49500
and TRANSFER_RATE = 0.000000;

Transfer_Rate has NULL value not 0.00.

4. If you only include the columns in the Data Verification that are Not Null in the view, and edit an existing record, it is successful. However, if you select all of the columns in the view to use in the Data Verification ID including the Nullable column and try to edit an existing record, you will receive the error.

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