Data Management: SQLSYNTAXERROREXCEPTION: ORA-00904: "ATTR1X": INVALID IDENTIFIER
(Doc ID 2734159.1)
Last updated on OCTOBER 21, 2021
Applies to:
Oracle Account Reconciliation Cloud Service - Version N/A to N/A [Release 11.1]Information in this document applies to any platform.
Symptoms
Customer loading data to EPM Cloud (eg: ARCS) application
The following error appears in Data Management Process log:
FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW
Traceback (most recent call last):
File "<string>", line 1474, in updateTDATASEG_T_TDATASEGW
SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00904: "ATTR1X": invalid identifier
Observed that Customers have utilized all UD1-UD20 columns in the target application definition and no additional columns are available.
So customer added another column and tried to map it to ATTR1, then import is failing with error.
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 |