ODI Generating Staging Table Column Names with Underscores and Number Causing "ORA-00911: invalid character"
(Doc ID 2870890.1)
Last updated on OCTOBER 02, 2023
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 and later
Oracle Data Integrator on Marketplace - Version 220.127.116.11.200123 and later
Information in this document applies to any platform.
While executing a mapping in Oracle Data Integrator (ODI) to load data from Business Intelligence Cloud Connector (BICC), Flat file, or Oracle using LKM BICC to ADW External, LKM File to Oracle, or LKM Oracle to Oracle knowledge modules, the following error occurs:
Observe the staging columns named as _1,_2,_3 etc as showing in the below image. Column names are a number prefixed with an underscore.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!