Data Management: SQLSYNTAXERROREXCEPTION: ORA-00904: "ATTR1X": INVALID IDENTIFIER
(Doc ID 2734159.1)
Last updated on AUGUST 23, 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.
Customer loading data to EPM Cloud(eg: ARCS) application
Following error appears in Data Management Process log:
2020-10-12 09:25:52,925 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 Customer 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 below error.
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