Can the OFSAA Ledger_Stat Balance Fields Precision be Increased to (22,3) , (22,4) or (22,6)? (Doc ID 1340440.1)

Last updated on AUGUST 02, 2016

Applies to:

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

Goal

Currently, LEDGER_STAT M1 to M12 and YTD1 to YTD2 columns have some datatype mismatch with the tables STG_GL_DATA and FCT_LEDGER_STAT. STG_GL_DATA and FCT_LEDGER_STAT have amount columns defined as (22,3).  Current Ledger_Stat amount columns are defined as (15,4). 

Can Ledger_Stat precision be changed to (22,3)?

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