OFSAAI F2T Data Load Fails With ORA-01722: invalid number Error (Doc ID 1594879.1)

Last updated on JUNE 01, 2017

Applies to:

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

Symptoms

On OFSAAI 7.3.2.2, when attempting to run a file to table (F2T) data load, the following error occurs:

ERROR
Record 1: Rejected - Error on table LOOKUP_TEMPLATE_TABLE, column ORG_UNIT_ID.
ORA-01722: invalid number

Record 2: Rejected - Error on table LOOKUP_TEMPLATE_TABLE, column RETURN_VAL2.
ORA-01722: invalid number

Record 3: Rejected - Error on table LOOKUP_TEMPLATE_TABLE, column RETURN_VAL2.
ORA-01722: invalid number

Record 4: Rejected - Error on table LOOKUP_TEMPLATE_TABLE, column RETURN_VAL2.
ORA-01722: invalid number

Record 5: Rejected - Error on table LOOKUP_TEMPLATE_TABLE, column RETURN_VAL2.
ORA-01722: invalid number

Record 6: Rejected - Error on table LOOKUP_TEMPLATE_TABLE, column RETURN_VAL2.


The issue can be reproduced at will with the following steps:

1. Define Data Source using File
2. Define F2T Mapping
3. Create/Execute batch using load data

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