Error while select a column name in aggregation having two spaces (Doc ID 2987798.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Goal

Getting an error in DIH (Data Integration Hub) when attempting to aggregate data using a column name that contains two spaces. Specifically, the issue arises when selecting a column with the name "Initiative1 Partner Surrogate Key," where there are two spaces after the keyword "Initiative1." This results in an error during the aggregation process.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.