My Oracle Support Banner

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


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