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

(Doc ID 1472693.1)

Last updated on MARCH 08, 2017

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

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