My Oracle Support Banner

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 FEBRUARY 27, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.