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 12.2.1.4.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

 

Cause

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.