BatchUpdateException: error occurred during batching: ORA-01722: invalid number Error When Trying to Create a Moving Average Hybrid Yield Curve (Doc ID 1410894.1)

Last updated on FEBRUARY 10, 2012

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.10 and later   [Release: 7 and later ]
Oracle Financial Services Funds Transfer Pricing - Version: 5.6 and later    [Release: 5 and later]
Oracle Financial Services Asset Liability Management - Version: 5.6 and later    [Release: 5 and later]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x
Rate Management

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.2.10, when attempting to create hybrid yield curve of the type 'Moving Average', the following error occurs when pressing Apply:

ERROR
Error~java.sql.BatchUpdateException: error occurred during batching: ORA-01722: invalid number

Similar error also appears when you hit Generate

ERROR
java.sql.BatchUpdateException: error occurred during batching: ORA-01722: invalid number Error

STEPS
The issue can be reproduced at will with the following steps:
1. Create a new IRC of the Structure type Hybrid
2. Select an IRC and choose Hybrid Curve Type: Moving Average
3. Attempt to complete the generate and apply and errors appear

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