How to fix the Oracle error ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.?

In this post, you’ll learn more about the Oracle ErrorORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.

Reason for the Error ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.

Base dimensions of a unique concat must have TEXT or ID datatypes.

How to fix the Error ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition. ?

You can fix this error in Oracle by following the below steps

Specify a valid list of dimensions when defining a unique concat dimension.