How to Resolve Invalid MDB Functions in the Schema Atomic in OFSAAI 7.3 (Doc ID 2255310.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.4.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Metadata Browser (MDB)

Goal

On OFSAAI 7.3.3.4.0, there appear to be several MDB functions which are invalid in the atomic schema:

TEXT
----------------------------------------------------------------------------------------------------
* FUNCTION FN_MDB_CNT_CUST_GRP_IDS line 9
  MDB_OBJECT_TYPE_LAYOUT,REV_OBJECT_REPOSITORY_B
  ^PL/SQL: ORA-00942: table or view does not exist

* FUNCTION FN_MDB_CNT_GRP_IDS line 9
  REV_OBJECT_REPOSITORY_B
  ^PL/SQL: ORA-00942: table or view does not exist

* FUNCTION FN_MDB_CUSTGRID_GRP_IDS line 14
  MDB_OBJECT_TYPE_LAYOUT,REV_OBJECT_REPOSITORY_B B1
  ^PL/SQL: ORA-00942: table or view does not exist

* FUNCTION FN_MDB_CUST_URL line 7
  from MDB_OBJECT_TYPE_LAYOUT
  ^PL/SQL: ORA-00942: table or view does not exist

* FUNCTION FN_MDB_GRID_GRP_IDS line 14
  MDB_OBJECT_TYPE_LAYOUT,REV_OBJECT_REPOSITORY_B B1
  ^PL/SQL: ORA-00942: table or view does not exist

* FUNCTION FN_MDB_GRP_NAMES line 14
  MDB_OBJECT_TYPE_LAYOUT,REV_OBJECT_REPOSITORY_B B1,forms_locale_master
  ^PL/SQL: ORA-00942: table or view does not exist

* FUNCTION FN_MDB_HIER_CODE line 13
  from REV_OBJECT_ATTRIBUTE_DTL, MDB_OBJECT_TYPE_LAYOUT
  ^PL/SQL: ORA-00942: table or view does not exist

* FUNCTION FN_MDB_T2T_VIEW line 11
  from mdb_setupinfo
  ^PL/SQL: ORA-00942: table or view does not exist

How to resolve the above errors?

Solution

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