My Oracle Support Banner

"ORA-00904: "ORDER_RELEASE_REFNUM_QUAL_GID": invalid identifier" Error When ReleaseLine Includes Multiple RefNums of the Same Qualifier (Doc ID 981289.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.0 to 6.0.4 - Release: COREid
Information in this document applies to any platform.

Symptoms


A "Release" XML is sent inbound to OTM. This includes a "ReleaseLine" that has the same RefNum Qualifier listed more than once. As a result, the "Update_Flag" on this qualifier must be checked. The SQL statement used to checked this is incorrectly spelled and therefore failing with the following error:

select update_flag from order_release_line_refnum_qual where order_release_refnum_qual_gid = ?; [QUALIFIER_GID]

java.sql.SQLException: ORA-00904: "ORDER_RELEASE_REFNUM_QUAL_GID": invalid identifier

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:100)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:153)
at glog.util.jdbc.noserver.SqlQuery.resetArguments(SqlQuery.java:131)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:101)

The field should be: OR_LINE_REFNUM_QUAL_GID not ORDER_RELEASE_REFNUM_QUAL_GID

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
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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