"ORA-04044: procedure, function, package, or type is not allowed here" Error When Unassigning Order Release (Doc ID 1375449.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 5.5 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Apr-2013***

Symptoms


Unable to unassign order from shipment. Error received:

java.sql.SQLException: ORA-04044: procedure, function, package, or type is not allowed here

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:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:131)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:148)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:94)
at glog.util.remote.BeanManagedEntityBean.executeFindAll(BeanManagedEntityBean.java:1038)
at glog.util.remote.BeanManagedEntityBean$12.execute(BeanManagedEntityBean.java:493)
at glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1066)
at glog.util.remote.BeanManagedEntityBean.doFindMultipleSQL(BeanManagedEntityBean.java:491)
at glog.util.remote.BaseEntityBean$11.doIt(BaseEntityBean.java:765)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:798)

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