View Forecast Rates Screen is Blank for Yield Curve Twist Method with ORA-01489
(Doc ID 2269255.1)
Last updated on MARCH 30, 2021
Applies to:
Oracle Financial Services Asset Liability Management - Version 8.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
In Oracle Financial Services Asset Liability Management (ALM) 8.0.2, in the Forecast Rates rule, when you try to view Forecast Rates that use the "Yield Curve Twist" Forecast Method, the rates fail to load and you get a blank screen for a specific As of Date:
Checking the alm.log in the OFSAA web server log directory, the following error exists:
[06-02-17 10:19:53 AM] ~ ERROR ~ ALM ~ [ForecastRatesQuery][fCastIRCQuery][Yield Curve Twist View][Inside Catch of CallableStatement] :: java.sql.SQLException: ORA-01489: result of string concatenation is too long
java.sql.SQLException: ORA-01489: result of string concatenation is too long
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1054)
at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3716)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:1015)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:979)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:579)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_ForwardOnlyResultSet.next(Unknown Source)
at com.ofs.fsapps.alm.query.ForecastRatesQuery.ircYieldCurveDetails(ForecastRatesQuery.java:4115)
at com.ofs.fsapps.alm.query.ForecastRatesQuery.fCastIRCQuery(ForecastRatesQuery.java:1815)
at com.ofs.fsapps.alm.action.ForecastRatesAction.forecastRateMethod(ForecastRatesAction.java:1080)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
etc.
This issue occurs for a specific As of Date. You can get the screen to load successfully for other As of Dates. You expect the Forecast Rates, with the Yield Curve twist applied, to be displayed for all As of Dates.
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 |