ORA-01480 when Saving Forecast Rates ID with Scenario Name Greater than 30 Characters
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.
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.
(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.
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