Can the Simple Dimension Code Column Size be Increased in Precision?

(Doc ID 2391269.1)

Last updated on APRIL 25, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Goal

Can the *_CD col size be increased in precision from the standard Number(5) to Number(25)?

There is a requirement to create a number of custom simple dimensions (creating FSI_*_CD and FSI_*_MLS tables in Erwin) and load the data from Data Relationship Management (DRM). DRM has values greater than NUMBER(5). Can these new custom tables be built and registered as a simple dimension if the *_CD col is larger than NUMBER(5)?
These codes will be used in data filters in allocations and reporting.  New columns will be introduced into existing and or new instrument tables.  Currently not using the T2T but that is an option for future use.
The out of the box (OOB) domain data-type/size will not be changed.  At the moment, the request is only to allow new _CD columns on new DIM tables. Existing OOB Simple-dimensions tables/columns will not be altered.

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