My Oracle Support Banner

SHIP_COMMIT_ALLOC_JOIN Error After Sending Shipment Actual (Doc ID 1393415.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.3 and later   [Release: 6.2 and later ]
Information in this document applies to any platform.

Symptoms

When uploading a shipment actual for a shipment which has Commitment Allocation configured, the following error is received even though there is plenty of counts still available on the Commitment Allocation Record:

2011-10-27 12:09:46.057 632927 Error Exception Cannot add the SHIP_COMMIT_ALLOC_JOIN record. SHIPMENT_GID, COMMIT_ALLOC_USAGE_GID must be unique.
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIP_COMMIT_ALLOC_JOIN) violated

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIP_COMMIT_ALLOC_JOIN) violated

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3467)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeUpdate(SqlPreparedStatement.java:35)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:241)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:161)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:90)
at glog.util.remote.BeanManagedEntityBean.executeUpdate(BeanManagedEntityBean.java:795)
at glog.util.remote.BeanManagedEntityBean$1.execute(BeanManagedEntityBean.java:197)
at glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1068)
at glog.util.remote.BeanManagedEntityBean.doCreate(BeanManagedEntityBean.java:193)
at glog.util.remote.BaseEntityBean$1.doIt(BaseEntityBean.java:455)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:798)
at glog.util.remote.BaseEntityBean.ejbCreator(BaseEntityBean.java:453)
at glog.ejb.capacity.db.ShipCommitAllocJoinBeanDB.ejbCreate(ShipCommitAllocJoinBeanDB.java:53)
at glog.ejb.capacity.ejb_ShipCommitAllocJoin_fkapym_Impl.ejbCreate(ejb_ShipCommitAllocJoin_fkapym_Impl.java:250)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.ejb.container.manager.ExclusiveEntityManager.create(ExclusiveEntityManager.java:801)
at weblogic.ejb.container.manager.ExclusiveEntityManager.remoteCreate(ExclusiveEntityManager.java:772)
at weblogic.ejb.container.internal.EntityEJBHome.create(EntityEJBHome.java:270)
at glog.ejb.capacity.ejb_ShipCommitAllocJoin_fkapym_HomeImpl.create(ejb_ShipCommitAllocJoin_fkapym_HomeImpl.java:83)
at glog.business.shipment.PlanningObjectCommitter.commitShipCommitAllocJoins(PlanningObjectCommitter.java:2223)
at glog.business.shipment.PlanningObjectCommitter.commitTShipment(PlanningObjectCommitter.java:1198)
at glog.business.planningstructure.PlanningObjectUpdateSessionBean.commitOrderMovementGraph(PlanningObjectUpdateSessionBean.java:131)
at glog.business.planningstructure.PlanningObjectUpdateSessionServerSideEJBWrapper.commitOrderMovementGraph(PlanningObjectUpdateSessionServerSideEJBWrapper.java:38)
at glog.business.planningstructure.PlanningObjectUpdateSessionServerSideEJBWrapper_fexvg1_EOImpl.commitOrderMovementGraph(PlanningObjectUpdateSessionServerSideEJBWrapper_fexvg1_EOImpl.java:59)
at glog.business.shipmentactual.ShipmentActualExecutor.executeShipmentActual(ShipmentActualExecutor.java:644)
at glog.business.shipmentactual.ShipmentActualExecutor.execute(ShipmentActualExecutor.java:346)
at glog.business.shipmentactual.ShipmentActualExecutor.execute(ShipmentActualExecutor.java:147)
at glog.business.shipmentactual.ShipmentActualSessionBean.executeShipmentActual(ShipmentActualSessionBean.java:105)
at glog.business.shipmentactual.ShipmentActualSessionServerSideEJBWrapper.executeShipmentActual(ShipmentActualSessionServerSideEJBWrapper.java:85)
at glog.business.shipmentactual.ShipmentActualSessionHome_4tsowh_EOImpl.executeShipmentActual(ShipmentActualSessionHome_4tsowh_EOImpl.java:59)
at glog.integration.application.shipment.ShipmentWrapper.invokeShipmentActualSession(ShipmentWrapper.java:1175)
at glog.integration.application.shipment.ShipmentWrapper.invokeShipmentActualSession(ShipmentWrapper.java:1155)
at glog.integration.application.shipment.ShipmentWrapper.persistViaShipmentActualSession(ShipmentWrapper.java:1214)
at glog.integration.application.shipment.ShipmentWrapper.persistContainerSelf(ShipmentWrapper.java:1371)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:349)
at glog.integration.application.shipment.ShipmentInterface.persistIndivXML(ShipmentInterface.java:262)
at glog.integration.application.shipment.ShipmentInterface.persistXML(ShipmentInterface.java:190)
at glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:195)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:224)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:363)
at glog.server.workflow.transproc.TransProc.execute(TransProc.java:110)
at glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:38)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:134)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:352)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:146)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:98)
at glog.util.event.EventThread.run(EventThread.java:86)
at java.lang.Thread.run(Thread.java:619)
publishWait - 2

A few lines before the error one can see where it seems the values are backwards (it puts shipment gid first instead of the commit usage gid in the brackets).

2011-10-27 12:09:45.438 632927 Debug Sql select commit_alloc_usage_gid,shipment_gid from ship_commit_alloc_join where commit_alloc_usage_gid = ? and shipment_gid = ?; http://ELX.01000, ELX.EUP-2011-ITSU-HUPO-0001 publishWait - 2

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.