"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

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