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.
Extracting the data while including Target Dimension class as Attribute dimension, it fails with an 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.
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