OFSAA Missing New Tables, Views, or Columns When Choosing Entities in T2T Data Extract Screen (Doc ID 1348564.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.8 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Data Mapping
Table to Table (T2T)

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.2.8, when attempting to choose a _V view from the Data Integrator, Choose entity screen the FSI_AMORTIZATION_TYPE_MLS_V does not appear in the list.

ACTUAL BEHAVIOR
It appears that certain views are missing from the Choose Entity screen.

EXPECTED BEHAVIOR
Expect to see all views and tables and columns in the source Atomic schema to appear.

The issue can be reproduced at will with the following steps:
1. Unified Metadata Manager -> Data Integrator Framework -> Warehouse Designer -> Database Extract
2. Open a seeded Staging T2T extract
3. Click Edit
4. Click Choose Entity
5. Scroll through the list

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