Missing Infodom Views (e.g. BATCH_RUN_VIEW) After Installing OFSAAI 7.3.4 (Doc ID 1926873.1)

Last updated on MAY 22, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.4.0.0 to 7.3.4.0.0 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After installing Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.3.4 and an EPM application like Profitability Management (PFT), your database is missing views that should be created when the Information Domain (Infodom) is created.  You are missing objects like the following from the atomic schema:

BATCH_RUN_VIEW
MDB_ETL_MAPPING
MDB_EXECUTION_DETAILS
MDB_OBJECT_DEPENDENCIES
PR2_RULE_MAP
PR2_RULE_MAP_EXCLUDE
PR2_RULE_MAP_EXCLUDE_PR
REV_APPLICATIONS_CD
REV_APPLICATIONS_MLS
REV_OBJECT_APPLICATION_MAP
SCENARIO_MASTER
SHOCK_MASTER
STRESS_MASTER
T2T_UDP_LIST_VIEW

You expect these objects to be created when the Information Domain is created.  However, the objects are missing from the atomic schema.

Note: See <Document 1566694.1> "List of Objects Created in OFSAAI Infodom (Information Domain)" for a list of object created when you create an Infodom.

Cause

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