My Oracle Support Banner

JSON Key Values Prefixed with '@' Incorrectly Converted to Hex Values for Special Characters in ODI Complex File Technology (Doc ID 2886779.1)

Last updated on AUGUST 29, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version and later
Information in this document applies to any platform.


While loading a JavaScript Object Notation (JSON) file to database using Complex File Technology in Oracle Data Integrator (ODI), if the JSON Keys in the file are prefixed with '@' symbol, the Native Format Builder wizard converts the special characters like backslash "/" or comma "," in the Key value to hexadecimal and loads the same way to database. For example:


Any character set selected in the wizard such as US-ASCII, UTF-8, ISO-8859-1 has the same behaviour.




To view full details, 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 a vibrant support community of peers and Oracle experts.