Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI 12c - Error " ORA-00904: : invalid identifier"

yuvraj_patil002May 24 2015 — edited May 26 2015

Hi I am loading data from Excel to Oracle Db.

Connection everything is fine...

Please help me on below error.

ODI-1228: Task Create work table-LKM SQL to Oracle- fails on the target connection ST_TG table for Capacity Planning.

Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

Yuvi

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2015

Added on May 24 2015

#business-intelligence-applications, #data-integrator, #system-management-and-integration

3 comments

3,359 views