Error: "SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00904: "BAL"."SEGMENT1": invalid identifier" When Running the Import Task in Data Management

(Doc ID 2311172.1)

Last updated on OCTOBER 16, 2017

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

When trying to perform a import from from EBS, it fails with the following error message in the process details log:

2017-08-09 14:40:08,371 FATAL [AIF]: Error in EBS/FS Load Data - loadTDATASEG_T
Traceback (most recent call last):
File "<string>", line 1140, in loadTDATASEG_T
SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00904: "BAL"."SEGMENT1": invalid identifier

2017-08-09 14:40:08,722 DEBUG [AIF]: CommData.updateRuleStatus - END
2017-08-09 14:40:08,723 FATAL [AIF]: Error in Launch GL Load Balances Data

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms