Database Configuration

Users and Groups

User names have a maximum of 16 characters.

OFSAA Assumption Rule Names

The maximum number of characters in a short description name is 15, and in a long description name is 60.

Number of assumption rules

The maximum System ID number in the system is 9,999,999,999. The maximum number of assumption rules for each rule type is 16,000.

SQL Statements in All Processes

SQL statements within processes are limited to a maximum length of 65,535 characters.

User Interface Display of Dates

All dates displayed in user interfaces have an input and display range of 01/01/1901 to 12/31/2499.

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, 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.

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 9999.999999 and -9999.999999. More precision can be achieved by increasing the number of decimals in the column. Internally, rates are stored with the same precision as balances.

Terms and Frequencies

The maximum size of a term used within any process is 32,767, although interface limits are imposed to restrict this number to 999 when entered through a user interface. Terms affected by this restriction include payment frequency, reprice frequency, original term, amortization term, negative amortization frequency, and payment change frequency.