My Oracle Support Banner

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 11.3.1.8 and later
Information in this document applies to any platform.

Symptoms

On : 11.3.1.8 version, General

ACTUAL BEHAVIOR
---------------
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).

Cause

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
Symptoms
Cause
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.