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

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