My Oracle Support Banner

AsPolicyValue And AsDepositValue Tables Not Working Correctly After Upgrade (Doc ID 2950958.1)

Last updated on JUNE 07, 2023

Applies to:

Oracle Insurance Policy Administration J2EE - Version and later
Information in this document applies to any platform.


On : version, Fund Information

Following an upgrade from OIPA v10.2.40 to v11.3.1,
it appears that the AsPolicyValue and AsDepositValue are not updated correctly.
The AsPolicyValue still has the old column names and nothing was updated.

As a result, after making the changes, the system is encountering errors that the
BEGINENDFLAG column (which was supposed to be removed) does not allow Nulls.
The business is unable to remove the column manually because as part of the upgrade, values
that were in CashValue were supposed to be moved to EndCashValue if that
column was set to “E” and values were supposed to move to BeginCashValue where the column would have been “B”.

The AsDepositValue table looks incorrect as well.
The new columns were added but the older columns “BeginEndFlag” and “CashValue” were not removed.
Only the “Units” column was removed.


Configuration that refers to modified tables to be updated as well, with the
Upgrade Utility tool so that it works post upgrade.


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

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