ORA-01480 when Saving Forecast Rates ID with Scenario Name Greater than 30 Characters (Doc ID 290184.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Risk Manager - Version 4.5.39 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

When attempting to save a new Forecast Rates ID with Scenario Name greater than 30 characters, the following error occurs. Unable to re-open the Forecast Rates ID and the application exitted.

Error:
(203105) Oracle drv_oci error:
ORA-01480:trailing null missing from STR bind value
SQL Statement: insert into ofsa_fcast_rates_Scenarios(fcast_rates_sys_id, scenario_num, scenario_name)
values (:fcast_rates_sys_id, :scenario_num, :scenario_name)

The issue can be reproduced with the following steps:
1.  Created a new Forecast Rates ID
2.  Created a new Scenario and type the scenario name = '1234567890123456789012345678901'
3.  Saved the Forecast Rates ID.
4.  Error message prompted and the Forecast Rates ID cannot be open again.

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