ORA-01722: invalid number Error Thrown During OFSAAI Excel Upload (Doc ID 1458960.1)

Last updated on MAY 16, 2012

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Oracle Financial Services Analytical Applications (OFSAA) - Version 6.0

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.3 when attempting to do an Excel Upload into FSI_D_CASA, the following error occurs.

ERROR
Insert into FSI_D_CASA(IDENTITY_CODE

[ETL-EXCELUPLOAD]Error flag :false
[ETL-EXCELUPLOAD]Error is Failed Executing Batch: error occurred during batching: ORA-01722: invalid number

Failed to upload data into FSI_D_CASA

STEPS
The issue can be reproduced at will with the following steps:
1. Create Excel-Entity Mapping
2. Run the Excel Upload for the mapping
3. See generated ORA-01722: invalid number error

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