Increasing the Size of the RECORD_COUNT Columnn on an Instrument Table
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)
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)).
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