OIPA PIT Valuation Database Tables Datatype Definition Changes Between V11.2 And V11.3
(Doc ID 2878565.1)
Last updated on JUNE 23, 2022
Applies to:Oracle Insurance Policy Administration J2EE - Version 184.108.40.206 and later
Information in this document applies to any platform.
On : 220.127.116.11 version, General
Following an upgrade from v11.2 and v11.3 , some of the PIT tables, AsPolicyValue, AsFundValue and AsDepositValue, have multiple columns' datatypes changes from v11.2 to v11.3.
In v11.2, the columns where defined as [decimal](31, 10) where as in v11.3 they are changed to [decimal](19, 4).
Columns are [CashValue], [Principal] which became [BEGINCASHVALUE], [ENDPRINCIPAL], [BEGINPRINCIPAL], [ENDPRINCIPAL].
Units went from [decimal](31, 10) to [decimal](18, 10).
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