Cannot Update or Delete Records with Null Value in Data Verification ID
Last updated on MAY 13, 2010
Applies to:Oracle Financial Data Manager - Version: 4.5
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
INSERT, UPDATE, or DELETE operation(s) failed!
Check table rows and columns for NULL values.
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.
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