How to Populate the DISPLAY_CD Column for a Simple Dimension (Account Officer, Bank, etc.) (Doc ID 1447601.1)

Last updated on MAY 15, 2014

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 to 7.3 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 15-May-2014.

Goal

In Oracle Financial Services Analytical Applications (OFSAA), how can you populate the "Display Code" (DISPLAY_CD) column for a Simple Dimension?  The Dimension Management interface does not have a field for entering this value for a Simple Dimension.

For example, how do you populate the BANK_DISPLAY_CD column in the "Bank" simple dimension table FSI_BANK_CD?  Or how do you populate the ACCOUNT_OFFICER_DISPLAY_CD column in the "Account Officer" simple dimension table FSI_ACCOUNT_OFFICER_CD?

Note: Users often need to populate these Display Code columns for a T2T process where data is moved from a STG_<table name> table into a FSI_D_<table name> table.  The seeded T2T process joins the dimension column on the STG table to the DISPLAY_CD column on the simple dimension table.  If the DISPLAY_CD column is not populated, the T2T process will fail.

For example, the V_BANK_CD column in STG_LOAN_CONTRACTS joins to the BANK_DISPLAY_CD column in FSI_BANK_CD to populate the BANK_CD column in FSI_D_LOAN_CONTRACTS.

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