My Oracle Support Banner

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.

Symptoms

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.

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
Cause
Solution


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