My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

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


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



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

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