My Oracle Support Banner

"unique constraint (GLOGOWNER.PK_SHIPMENT_STOP_REFNUM) violated" Error When Attempting to Unassign Order Release from Shipment (Doc ID 1472693.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.2.7 [Release 6.2]
Information in this document applies to any platform.

Symptoms

When attempting to Unassign an Order Release that is on a Miltistop Shipment where each Stop have Remarks and Reference Number Qualifiers the following error occurs.

ERROR
-----------------------

insert into shipment_stop_refnum (shipment_gid,stop_num,shipment_stop_refnum_qual_gid,shipment_stop_refnum_value,domain_name) values (?,?,?,?,?) at [LEE.01719, 2, ACCOUNT_CODE, 123, LEE]

Cannot add the SHIPMENT_STOP_REFNUM record. [SHIPMENT_GID, STOP_NUM, SHIPMENT_STOP_REFNUM_QUAL_GID, SHIPMENT_STOP_REFNUM_VALUE] must be unique.

java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT_STOP_REFNUM) violated

View Diagnostics

View Log
At 2012-06-21 11:11:59.410

insert into shipment_stop_refnum (shipment_gid,stop_num,shipment_stop_refnum_qual_gid,shipment_stop_refnum_value,domain_name) values (?,?,?,?,?) at [LEE.01719, 2, ACCOUNT_CODE, 123, LEE]
  Cannot add the SHIPMENT_STOP_REFNUM record. [SHIPMENT_GID, STOP_NUM, SHIPMENT_STOP_REFNUM_QUAL_GID, SHIPMENT_STOP_REFNUM_VALUE] must be unique.
  java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT_STOP_REFNUM) violated


java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT_STOP_REFNUM) violated

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9447)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeBatch(SqlPreparedStatement.java:97)
at glog.util.jdbc.SqlUpdate.processBatch(SqlUpdate.java:145)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:243)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:166)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:91)
at glog.util.beandata.BeanDataInserter.insertDBBatch(BeanDataInserter.java:358)
at glog.util.beandata.BeanDataInserter.insertDB(BeanDataInserter.java:302)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:197)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:232)
at glog.business.util.EntitySaver.insert(EntitySaver.java:252)
at glog.business.util.Persistence.insertupdate(Persistence.java:337)
at glog.business.shipment.PlanningObjectCommitter.commitTShipmentStop(PlanningObjectCommitter.java:1972)
at glog.business.shipment.PlanningObjectCommitter.commitTShipmentStops(PlanningObjectCommitter.java:1887)
at glog.business.shipment.PlanningObjectCommitter.commitTShipment(PlanningObjectCommitter.java:960)
at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentNode(ShipmentUpdateSessionBean.java:841)
at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraphUnlocked(ShipmentUpdateSessionBean.java:1521)
at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraph(ShipmentUpdateSessionBean.java:1278)
at glog.business.shipment.ShipmentUpdateSessionServerSideEJBWrapper.commitShipmentGraph(ShipmentUpdateSessionServerSideEJBWrapper.java:344)
at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraph(ShipmentUpdateSessionBean.java:1820)
at glog.business.shipment.ShipmentUpdateSessionServerSideEJBWrapper.commitShipmentGraph(ShipmentUpdateSessionServerSideEJBWrapper.java:303)
at glog.business.shipment.ShipmentUpdateSessionHome_qj7mtr_EOImpl.commitShipmentGraph(ShipmentUpdateSessionHome_qj7mtr_EOImpl.java:1018)
at glog.business.action.order.OrderActions.postProcessingAndCommitShipmentGraph(OrderActions.java:804)
at glog.business.action.order.OrderActions.unassignUnassignableOrders(OrderActions.java:658)
at glog.business.action.order.UnassignOrdersActionExecutor.unassignOrders(UnassignOrdersActionExecutor.java:77)
at glog.business.session.OrderActionSessionBean.unassignOrders(OrderActionSessionBean.java:427)
at glog.business.session.OrderActionSessionServerSideEJBWrapper.unassignOrders(OrderActionSessionServerSideEJBWrapper.java:472)
at glog.business.session.OrderActionSessionHome_likuwd_EOImpl.unassignOrders(OrderActionSessionHome_likuwd_EOImpl.java:4809)
at glog.business.session.gen.OrderActionSessionSkel.unassignOrders(OrderActionSessionSkel.java:644)
at glog.business.session.gen.OrderActionSessionSkel.exec(OrderActionSessionSkel.java:168)
at glog.webserver.wrapper.SkelImpl.execDispatch(SkelImpl.java:16)
at glog.server.wrapper.WrapperSessionBean.execDispatch(WrapperSessionBean.java:62)
at glog.server.wrapper.WrapperSessionServerSideEJBWrapper.execDispatch(WrapperSessionServerSideEJBWrapper.java:48)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl.execDispatch(WrapperSessionHome_a06097_EOImpl.java:58)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
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:473)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1 - Create two Order Releases.

2 - Plan the Orders onto a Shipment.

3 - Add the a RefNum to Shipment Stops:

4 - Navigate to one of the Order Releases.

5 - Click Actions > Order Management > Unassign Order Release > Unassign Oder - Buy.

6 - The error is shown.

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.