OFSAA: Tables Referenced in REV_TABLES_B and REV_TABLES_TL but Not Present In Physical Atomic Schema
Last updated on JANUARY 02, 2015
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA)
When doing some analysis of the the data / metadata structure and content of the OFSAA data model there appears to be an anomaly. Looking at the contents of the metadata table REV_TABLES_B and REV_TABLES_TL, there are rows in this table which refer to a number of tables that do not have a physical representation in the Atomic schema. These tables are:
These tables seem to represent the entity "super types" present in the ERWIN model. Is it therefore the case that these tables do not need to have a physical representation?
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