How to Populate the DISPLAY_CD Column for a Simple Dimension (Account Officer, Bank, etc.)
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.
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?
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms