View Forecast Rates Screen is Blank for Yield Curve Twist Method with ORA-01489

(Doc ID 2269255.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms