For Shipment Group, Cannot Re-Calculate A Secondary Charge Shipment, Error: Exception Cannot add the S_SHIP_UNIT record. S_SHIP_UNIT_GID must be unique. (Doc ID 1393946.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On OTM version 6.2.3 version recalculating the cost of a Secondary Charge Shipment allocated to a Shipment Group ends with the following error:

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

Error
ErrorErrorStack TraceStack Trace insert into s_ship_unit (s_ship_unit_gid,s_ship_unit_xid,transport_handling_unit_gid,unit_length,unit_width,unit_height,unit_weight,unit_volume,flex_commodity_code,flex_commodity_qual_gid,is_splitable,ship_unit_count,early_pickup_date,received_weight,received_volume,received_ship_unit_count,ship_unit_gid,unit_net_weight,unit_net_volume,received_net_weight,received_net_volume,core_diameter,unit_diameter,tag_1,tag_2,tag_3,tag_4,t_ship_unit_gid,is_count_splittable,total_gross_weight,total_gross_volume,range_start,range_end,domain_name,total_gross_volume_uom_code,total_gross_weight_uom_code,unit_diameter_uom_code,core_diameter_uom_code,received_net_volume_uom_code,received_net_weight_uom_code,unit_net_volume_uom_code,unit_net_weight_uom_code,received_volume_uom,received_weight_uom,unit_volume_uom_code,unit_weight_uom_code,unit_height_uom_code,unit_width_uom_code,unit_length_uom_code,total_gross_volume_base,total_gross_weight_base,unit_diameter_base,core_diameter_base,received_net_volume_base,received_net_weight_base,unit_net_volume_base,unit_net_weight_base,received_volume_base,received_weight_base,unit_volume_base,unit_weight_base,unit_height_base,unit_width_base,unit_length_base) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) at [LEE.3-4238473561_1-001-001, 3-4238473561_1-001-001, LARGE BOX, 1.0 FT, 1.0 FT, 1.0 FT, 10.4535923744953 KG, 1.0 CUFT, null, null, N, 1, null, null, null, null, LEE.3-4238473561_1-001, 10.0 KG, 1.0 CUFT, 0.0 LB, 0.0 CUFT, null, null, null, null, null, null, null, Y, 10.4535923744953 KG, 1.0 CUFT, 1, 1, LEE]

Cannot add the S_SHIP_UNIT record. S_SHIP_UNIT_GID must be unique.

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





View Diagnostics View Log

At 2011-12-29 10:46:14.753

insert into s_ship_unit (s_ship_unit_gid,s_ship_unit_xid,transport_handling_unit_gid,unit_length,unit_width,unit_height,unit_weight,unit_volume,flex_commodity_code,flex_commodity_qual_gid,is_splitable,ship_unit_count,early_pickup_date,received_weight,received_volume,received_ship_unit_count,ship_unit_gid,unit_net_weight,unit_net_volume,received_net_weight,received_net_volume,core_diameter,unit_diameter,tag_1,tag_2,tag_3,tag_4,t_ship_unit_gid,is_count_splittable,total_gross_weight,total_gross_volume,range_start,range_end,domain_name,total_gross_volume_uom_code,total_gross_weight_uom_code,unit_diameter_uom_code,core_diameter_uom_code,received_net_volume_uom_code,received_net_weight_uom_code,unit_net_volume_uom_code,unit_net_weight_uom_code,received_volume_uom,received_weight_uom,unit_volume_uom_code,unit_weight_uom_code,unit_height_uom_code,unit_width_uom_code,unit_length_uom_code,total_gross_volume_base,total_gross_weight_base,unit_diameter_base,core_diameter_base,received_net_volume_base,received_net_weight_base,unit_net_volume_base,unit_net_weight_base,received_volume_base,received_weight_base,unit_volume_base,unit_weight_base,unit_height_base,unit_width_base,unit_length_base) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) at [LEE.3-4238473561_1-001-001, 3-4238473561_1-001-001, LARGE BOX, 1.0 FT, 1.0 FT, 1.0 FT, 10.4535923744953 KG, 1.0 CUFT, null, null, N, 1, null, null, null, null, LEE.3-4238473561_1-001, 10.0 KG, 1.0 CUFT, 0.0 LB, 0.0 CUFT, null, null, null, null, null, null, null, Y, 10.4535923744953 KG, 1.0 CUFT, 1, 1, LEE]
Cannot add the S_SHIP_UNIT record. S_SHIP_UNIT_GID must be unique.
java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_S_SHIP_UNIT) violated


java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_S_SHIP_UNIT) 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:142)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:238)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:161)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:90)
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:336)
at glog.business.shipment.PlanningObjectCommitter.commitTSShipUnits(PlanningObjectCommitter.java:586)
at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraphUnlocked(ShipmentUpdateSessionBean.java:1484)
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:1666)
at glog.business.action.ShipmentPlanningActionExecutor.reCalculateShipmentCost(ShipmentPlanningActionExecutor.java:755)
at glog.business.session.ShipmentPlanningActionSessionBean.reCalculateShipmentCost(ShipmentPlanningActionSessionBean.java:603)
at glog.business.session.ShipmentPlanningActionSessionServerSideEJBWrapper.reCalculateShipmentCost(ShipmentPlanningActionSessionServerSideEJBWrapper.java:1668)
at glog.business.session.ShipmentPlanningActionSessionServerSideEJBWrapper_7zfvrj_EOImpl.reCalculateShipmentCost(ShipmentPlanningActionSessionServerSideEJBWrapper_7zfvrj_EOImpl.java:3379)
at glog.business.session.gen.ShipmentPlanningActionSessionSkel.reCalculateShipmentCost(ShipmentPlanningActionSessionSkel.java:1333)
at glog.business.session.gen.ShipmentPlanningActionSessionSkel.exec(ShipmentPlanningActionSessionSkel.java:257)
at glog.webserver.wrapper.SkelImpl.execDispatch(SkelImpl.java:15)
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)


View Diagnostics View Log




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

1 - Logg onto an Internal OTM 6.2.4 system

2 - Navigate to: Shipment Management > Group Management > Shipment Group.

3 - Edit a Shipment Group that already has a Secondary Charge Shipment associated to the group.

4 - Click the hyperlink for the Secondary charge Shipment.

5 - From the Shipment click Actions> Shipment Management > > Shipment Management > Change Shipment Costs > Recalculate Shipment Cost.

6 - The error is displayed:

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