External Predicate data is not gained when using CSV Utility. Error: CSVUtil.SQLException: java.sql.SQLSyntaxErrorException: ORA-00904: "DOMAIN_NAME": invalid identifier

(Doc ID 1499396.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.0 and later
Information in this document applies to any platform.

Symptoms

On OTM version 6.2.5 version.

We want to export out of OTM the VPD predicate information.

We do this by using the UPLOAD functionality in OTM in the "Upload an XML/CVS Transmission" and intend for the CSV Utility to do the work.

The CSV file we are using to upload to OTM contains:

 -dataFileName EXTERNAL_PREDICATE.csv -command xcsv -tableName EXTERNAL_PREDICATE -whereClause "VPD_PROFILE_GID like 'OTMSBX.%'"

When we upload this to OTM we get the following error.

ERROR
-----------------------
CSVUtil.SQLException:
java.sql.SQLSyntaxErrorException: ORA-00904: "DOMAIN_NAME": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "DOMAIN_NAME": invalid identifier

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Aim is to EXPORT data out of OTM.
2. Try to us the UPLOAD functionin OTM
3. Take the details that should be entered in the OTM screen "Export CSV" and place them into a CSV file.
4. Upload that file into OTM.


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