My Oracle Support Banner

ScheduledValuation DB Insert Fail 'Cannot Insert The Value NULL Into Column 'DepositMoneyTypeCode' (Doc ID 2868261.1)

Last updated on MAY 10, 2022

Applies to:

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

Symptoms

On : 11.2.5.1 version, Cycle Scheduled Valuation

A ScheduledValuation attempts to write record to AsScheduledValuationDeposit table for a Fixed Fund that is tracked at the Fund Level.
The mMoney in a "by fund tracking" Fund is not known as a Deposit since it is coming from AsFundValue and should not attempt to write to AsScheduledValuationDeposit.
If this Money is truly entering the ScheduledValuation process as an AsFundValue Record then it should come out of the process as an AsScheduledValuationFund Record.

The Last Valuation Records before the ScheduledValuation are from a FundTransfer where Money is moved from a Fixed Fund that is tracked at the Deposit Level, to a Fixed Fund that is tracked at the Fund Level.

The Insert fails with the following error:


ERROR
-----------------------
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.WAS-v20180710-6c446ab): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'DepositMoneyTypeCode', table 'OIPA.dbo.AsScheduledValuationDeposit'; column does not allow nulls. INSERT fails.
Error Code: 515
Call: INSERT INTO AsScheduledValuationDeposit (SCHEDULEDVALUATIONDEPOSITGUID, CURRENCYCODE, CURRENTBONUSINTERESTRATE, CURRENTINTERESTRATE, DEPOSITCASHVALUE, DEPOSITEFFECTIVEDATE, DEPOSITGAIN, DEPOSITGUARANTEEDAMOUNT, DEPOSITINITIALCASHVALUE, DEPOSITINITIALUNITS, DEPOSITINTERESTBONUS, DEPOSITMVAAMOUNT, DEPOSITMONEYTYPECODE, DEPOSITNETGAIN, DEPOSITPRINCIPAL, DEPOSITRATELOCKDATE, DEPOSITSEEDGUID, DEPOSITSURRENDERVALUE, DEPOSITTRANSACTIONNAME, DEPOSITUNITS, DEPOSITVALUATIONGUID, FUNDGUID, FUNDTYPECODE, GUARANTEEDINTERESTRATE, INTERESTAMOUNT, INTERESTRATE, ORIGINALDEPOSITDATE, SCHEDULEDVALUATIONGUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [DDF94999-E73A-4A9C-9E1E-BE5ECC327CA2, null, 0.0, 0.0475, 84.711591295, 2021-09-30, 2.46297910163472, 0.0, 0.0, 0.0, 0.0, 0.0, null, 2.46297910163472, 82.248612193, null, null, 0.0, null, 0.0, null, 6BF85F30-5AF3-4085-92CA-1A5C20C939D0, null, 0.02, 0.08, 0.0475, null, 7C273EB3-2CAA-4629-B694-A7BC266B8B66]
Query: InsertObjectQuery(com.adminserver.pas.dcl.ScheduledValuationDepositDcl@9baf78de)

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.