Column Missing from the List of Source Entities in Database Extracts (Doc ID 1301364.1)

Last updated on MAY 14, 2015

Applies to:

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

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), in Data Integrator, you need to edit an Extract Definition and map a column to a target as described in a Readme note.  However, you do not see the column is the list of available Source Entities.  This prevents you from completing the post-install steps.

For example, the ALM BI 5.1 with ALM 5.2 instructions state you need to do the following:

11. Add and Map JOINT_ACCOUNT_FLG to FCT_COMMON_ACCOUNT_SUMMARY.n_acct_joint_ind in the following T2T definitions(data type of source and destination column should be same)

T2T_FACT_ACCOUNT_SUMMARY_CASA
T2T_FACT_ACCOUNT_SUMMARY_FORWARDS
T2T_FACT_ACCOUNT_SUMMARY_LOANS
T2T_FACT_ACCOUNT_SUMMARY_MUTUAL_FUNDS

However, when you go to edit the T2T_FACT_ACCOUNT_SUMMARY_CASA extract, you do not see JOINT_ACCOUNT_FLG listed as an available source column.

Steps to Reproduce:
  1. Go to Unified Metadata Manager > Warehouse Designer > Database Extracts
  2. Select an Extract
  3. Review the list of columns under "Extract Entities"
You do not see the column under "Extract Entities" and you do not see it in the DI Mapping screen.

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