Increasing the Size of the RECORD_COUNT Columnn on an Instrument Table (Doc ID 2237003.1)

Last updated on FEBRUARY 28, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

In the Oracle Financial Services Balance Sheet Planning (BSP) data model, can you increase the size of the RECORD_COUNT column in the instrument tables (ex. FSI_D_CASA)?

To improve processing performance by the cash flow engine (CFE), you aggregated individual instrument records with similar characteristics into a single record and you want to store the number of records aggregated in RECORD_COUNT.  In the case of deposits and credit cards, you aggregated over 1 million records in some cases.  However, a count over 1 million will not fit in RECORD_COUNT which is limited to 6 digits (NUMBER(6)).

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