My Oracle Support Banner

Add Operation Failed Attempting to Save a New Data Filter on User Defined Table or Column (Doc ID 1932090.1)

Last updated on FEBRUARY 02, 2022

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.