My Oracle Support Banner

Not Able To Delete More Than One Assumption From a Conditional Assumption in a Prepayment Rule (Doc ID 2996404.1)

Last updated on JANUARY 12, 2024

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.1.2 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.1.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

On ALM 8.1.2.2, not able to delete more than one assumption from a conditional assumption in a prepayment rule. When attempting to delete after save the screen shows blank rows for "deleted assumptions". Errors are thrown in the Web server log files.

ERROR

Tomcat alm.log shows error:

"[22-09-23 14:59:59,606 GMT PM] [INFO ] [WEB] [PrepaymentAction][saveConditionalAssumption][caXMLData] :: 711787-1< PARAMETER NAME="assetSelected" VALUE="true">< PARAMETER NAME="ppmtCalculationMethod" VALUE="1">< PARAMETER NAME="ppmtCashFlowTreatment" VALUE="1">< PARAMETER NAME="totalRows" VALUE="1">< PARAMETER NAME="preModellookupMethod" VALUE="0">< PARAMETER NAME="arrListMethodDetails[0].startDate" VALUE="01/01/1900">< PARAMETER NAME="arrListMethodDetails[0].endDate" VALUE="12/31/2499">< PARAMETER NAME="arrListMethodDetails[0].ppmtCoefficient" VALUE="1.0000">< PARAMETER NAME="arrListMethodDetails[0].ppmtModel" VALUE="206080">< PARAMETER NAME="arrListMethodDetails[0].ppmtModelSelection" VALUE="1">< PARAMETER NAME="index" VALUE="70029">< PARAMETER NAME="spread" VALUE="0.00">< PARAMETER NAME="associatedTerm" VALUE="1">< PARAMETER NAME="seasonality" VALUE="false">< PARAMETER NAME="seasonalityValues[0]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[1]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[2]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[3]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[4]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[5]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[6]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[7]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[8]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[9]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[10]" VALUE="1.0000">< PARAMETER NAME="seasonalityValues[11]" VALUE="1.0000">4,3 [22-09-23 14:59:59,608 GMT PM] [INFO ] [WEB] [AssumptionSpecificationInsertQuery][getPrepaymentInsert][prepayment.isRuleSaved()] :: false [22-09-23 14:59:59,609 GMT PM] [INFO ] [WEB] [AssumptionSpecificationInsertQuery][getPrepaymentInsert][Inside caFlag is True condSysId] :: 711787 [22-09-23 14:59:59,690 GMT PM] [ERROR] [WEB] Exception in execute java.sql.SQLSyntaxErrorException: ORA-01722: invalid number"

java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]


Tomcat log shows error:

[22-09-23 14:59:55,011 GMT PM] - leaf name !!! Default Member
[22-09-23 14:59:55,011 GMT PM] [INFO ] [$LOG_INSTANCE] GlobalCommonConstant.LOGGER_COMMONAPP - leaf name !!! Default Member
30-Sep-22
Pooled object created 2023-09-22 07:13:04 -0700 by the following code has not been returned to the pool:
org.apache.tomcat.dbcp.pool2.impl.ThrowableCallStack$Snapshot
at org.apache.tomcat.dbcp.pool2.impl.ThrowableCallStack.fillInStackTrace(ThrowableCallStack.java:71)
at org.apache.tomcat.dbcp.pool2.impl.DefaultPooledObject.allocate(DefaultPooledObject.java:194)
at org.apache.tomcat.dbcp.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:450)
at org.apache.tomcat.dbcp.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:352)
at org.apache.tomcat.dbcp.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:752)
at com.ofs.reveleus.factory.Connections.getTomcatConnectionFromPool(Connections.java:110)
at com.ofs.reveleus.factory.Connections.getConnection(Connections.java:72)


The issue can be reproduced at will with the following steps:
1. Navigate Asset Liability Management -> ALM Assumption Specification -> Prepayment Rules -> Prepayments
2. Edit existing prepayment rule
3. Edit Conditional Assumption for defined rule with more than 2 data filter assumptions defined
4. Select two or more rows from the screen and press delete
5. Save and Save
6. Upon re-edit the screen shows blank row for deleted assumptions

Changes

 

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
Changes
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.