ORA-100 'No Data Found' Error When Accessing the FDM Objects Folder in FDM Administration for OFSA 4.5
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.
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
Million Knowledge Articles and hundreds of Community platforms