Add Operation Failed Attempting to Save a New Data Filter on User Defined Table or Column
(Doc ID 1932090.1)
Last updated on JUNE 02, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2.1 to 8.0.5 [Release 7 to 8]Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
On OFSAAI 7.3.2.1, when attempting to save a new data filter on a custom table and column, the following error occurs:
ERROR
Add Operation failed
The issue can be reproduced at will with the following steps:
1. Created the table directly in the database
2. Registered the instrument table, and directly inserted into the below REV_ metadata tables:
REV_TABLE_CLASS_ASSIGNMENT
REV_COLUMN_PROPERTIES
REV_TAB_COLUMNS_MLS
REV_TAB_COLUMNS
REV_TABLES_TL
REV_TABLES_B
3. Master Maintenance -> Filters
4. Create a new data filter on a custom table
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |