When Unassigning Order from Shipment Receiving Error Exception java.sql.SQLException: ORA-04044: procedure, function, package, or type is not allowed here (Doc ID 1344730.1)

Last updated on JUNE 01, 2017

Applies to:

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

Symptoms

When unassigning order from buy shipment the following error is seen

Exception select jorj.job_gid, jorj.order_release_gid from job_order_release_join jorj, job j where j.consol_gid is not null and jorj.job_gid = j.job_gid and (jorj.order_release_gid = 'DOMAIN/SUBDOMAIN.ABC-20110726-0004') [ExecuteThread: '32' for q]
2011-07-26 15:32:58.007 125772 Error Exception java.sql.SQLException: ORA-04044: procedure, function, package, or type is not allowed here


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:124)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeQuery(SqlPreparedStatement.java:28)
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)
at glog.util.remote.BaseEntityBean.ejbFindSQL(BaseEntityBean.java:763)
at glog.ejb.job.ejb_JobOrderReleaseJoin_1tn1wu_Impl.ejbFindSQL(ejb_JobOrderReleaseJoin_1tn1wu_Impl.java:555)
at glog.util.remote.BaseEntityBean.ejbFindSQL(BaseEntityBean.java:787)
at glog.ejb.job.ejb_JobOrderReleaseJoin_1tn1wu_Impl.ejbFindSQL(ejb_JobOrderReleaseJoin_1tn1wu_Impl.java:575)
at glog.ejb.job.JobOrderReleaseJoinBean.ejbFindByOrderReleasePKs(JobOrderReleaseJoinBean.java:38)
at glog.ejb.job.ejb_JobOrderReleaseJoin_1tn1wu_Impl.ejbFindByOrderReleasePKs(ejb_JobOrderReleaseJoin_1tn1wu_Impl.java:235)
at sun.reflect.GeneratedMethodAccessor4443.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.manager.BeanManagedPersistenceManager.enumFinder(BeanManagedPersistenceManager.java:120)
at weblogic.ejb20.manager.BaseEntityManager.enumFinder(BaseEntityManager.java:1713)
at weblogic.ejb20.internal.EntityEJBHome.finder(EntityEJBHome.java:643)
at glog.ejb.job.ejb_JobOrderReleaseJoin_1tn1wu_HomeImpl.findByOrderReleasePKs(ejb_JobOrderReleaseJoin_1tn1wu_HomeImpl.java:173)
at glog.business.action.helper.OrderActionHelper.getJobOrderReleaseJoinPKs(OrderActionHelper.java:1768)
at glog.business.action.helper.OrderActionHelper.unassignOrdersFromShipmentGraph(OrderActionHelper.java:157)
at glog.business.action.order.OrderActions.unassignUnassignableOrders(OrderActions.java:540)
at glog.business.action.order.UnassignOrdersActionExecutor.unassignOrders(UnassignOrdersActionExecutor.java:77)
at glog.business.session.OrderActionSessionBean.unassignOrders(OrderActionSessionBean.java:315)
at glog.business.session.OrderActionSessionServerSideEJBWrapper.unassignOrders(OrderActionSessionServerSideEJBWrapper.java:386)
at glog.business.session.OrderActionSessionHome_likuwd_EOImpl.unassignOrders(OrderActionSessionHome_likuwd_EOImpl.java:3340)
at glog.business.session.gen.OrderActionSessionSkel.unassignOrders(OrderActionSessionSkel.java:623)
at glog.business.session.gen.OrderActionSessionSkel.exec(OrderActionSessionSkel.java:160)
at glog.webserver.wrapper.SkelImpl.execDispatch(SkelImpl.java:15)
at glog.server.wrapper.WrapperSessionBean.execDispatch(WrapperSessionBean.java:57)
at glog.server.wrapper.WrapperSessionServerSideEJBWrapper.execDispatch(WrapperSessionServerSideEJBWrapper.java:42)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl.execDispatch(WrapperSessionHome_a06097_EOImpl.java:46)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:477)
at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:108)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:420)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:415)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:30)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
[ExecuteThread: '32' for q]

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