3.1 Boundaries and Limitations

This section includes the details of Boundaries and Limitations used in Data Model Utilities.

Instrument Table - ID Numbers

ID numbers can have a maximum length of 25 digits.

Dimension Leaf Member Set Up

Dimension Leaf values can have a maximum of 14 digits.

Only 26 key (processing) dimensions are allowed in the database. Examples of seeded key leaf types are Common COA ID, Organizational Unit ID, GL Account ID, Product ID, and Legal Entity ID.

The maximum number of columns that the Oracle database allows in a unique index is 32. This is the overriding constraint. After subtracting IDENTITY_CODE, YEAR_S, ACCUM_TYPE_CD, CONSOLIDATION_CD, and ISO_CURRENCY_CD, this leaves 27 columns available for Key Processing Dimensions (leaf dimensions). BALANCE_TYPE_CD is now part of the unique index so this brings the maximum number of leaf columns down to 26.

Balances

Balances stored in Instrument tables are limited to 999,999,999,999.99. Balances stored in the LEDGER_STAT table are limited to 99,999,999,999.9999. The maximum precision for a balance used in a calculation process is 15 digits, with the range of 1.7e-308 to 1.7e+308. Calculation precision on larger numbers is compromised.

Rates

By default, rates stored in instrument tables are limited to 999.9999 and -999.9999. More precision can be achieved by increasing the number of decimals in the column. Internally, rates are stored with the same precision as balances.

Hierarchy Level Limitation

Hierarchies with 15+ level is NOT supported within any Enterprise Performance Management (EPM) - ALM/FTP/PFT/HM processes.