Cannot See New Mortgage Column in Data Filter ID - Exists in OFSA_TAB_COLUMNS_V

(Doc ID 951392.1)

Last updated on OCTOBER 26, 2009

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5 to 4.5.39
This problem can occur on any platform.


In an Oracle Financial Services Applications (OFSA) 4.5 module, you cannot see a new column in the Data Filter ID.  You recently added the column to an instrument table and used the Object Re-Registration wizard in Financial Data Manager (FDM) Administration to add it to the OFSA metadata.  When that did not work, you un-registered and re-registered the table.  However, you still cannot see the column in the application.

You can see the new column in OFSA_TAB_COLUMNS_V but cannot see it in the Data Filter ID.

Steps To Reproduce:

  1. Add a new column to a table
  2. Log into FDM Administration
  3. Go to Wizards > Register > Re-Register Object...
  4. Go to FDM Objects and un-register the table
  5. Go to Wizards > Register > Object... and register the table
  6. Log into an OFSA module like Performance Analyzer
  7. Open a Data Filter ID and select the Mortgage table

You cannot see the new column in the list of columns.


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