My Oracle Support Banner

Error "ORA-00904: "ATTR1X": invalid identifier" when Extracting All Data Columns Using Data Export To File Functionality in FDMEE (Doc ID 2729772.1)

Last updated on NOVEMBER 27, 2020

Applies to:

Oracle Account Reconciliation Cloud Service - Version 20.10.52 and later
Information in this document applies to any platform.

Symptoms

Extracting the data while including Target Dimension class as Attribute dimension, it fails with an error.

ERROR
---------
SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00904: "ATTR1X": invalid identifier

It is possible to extract the columns which Target dimension class is UDA or any other dimension name. However when extracting the 38 columns, out of which  22 columns they are able extract using Target Dimensions class as UDA but failed for the one that is assigned to Attribute dimension.

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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