ORA-100 'No Data Found' Error When Accessing the FDM Objects Folder in FDM Administration for OFSA 4.5

(Doc ID 290966.1)

Last updated on AUGUST 05, 2010

Applies to:

Oracle Financial Data Manager - Version: 4.5 to 4.5.39 - Release: 4.5 to 4.5
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5

Checked for relevance on 05-Aug-2010.


In OFSA 4.5, when attempting to update or query table and column registration in Financial Data Manager (FDM) Administration, the following error occurs:

ORA-100 No Data Found

There are also mismatch or missing entries between the rows on the OFSA_TAB_COLUMNS table and OFSA_TAB_COLUMNS_MLS for tables getting the ORA-100 error message.

There are also ORA-00001 Unique Constraint error messages when attempting to unregister and re-register the tables which receive the ORA-100 error message.

Issue does not appear to affect all tables and seems to affect only newly added columns.

Steps to reproduce

1. FDM Administration ---> FDM Objects Folder (on the left hand side) --> Columns Tab --> Tables
2. Select a Table.


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