"Cannot update the S_SHIP_UNIT record" Error When Running ORDER RELEASE MOD - EDIT SHIPMENT Agent Action After Deleting Ship Unit (Doc ID 1356830.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.1.0 to 6.1.6 [Release 6.1]
Information in this document applies to any platform.
***Checked for relevance on 17-Sep-2013***

Symptoms


ORDER RELEASE MOD - EDIT SHIPMENT agent action fails when order release ship unit is deleted with the following error



Cannot update the S_SHIP_UNIT record. [SHIP_UNIT_GID] must reference a valid SHIP_UNIT record.
java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_S_SHPUT_SHIP_UNIT_GID) violated - parent key not found


java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_S_SHPUT_SHIP_UNIT_GID) violated - parent key not found

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:191)
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:579)
at glog.business.planningstructure.PlanningObjectUpdateSessionBean.commitOrderMovementGraph(PlanningObjectUpdateSessionBean.java:109)
at glog.business.planningstructure.PlanningObjectUpdateSessionServerSideEJBWrapper.commitOrderMovementGraph(PlanningObjectUpdateSessionServerSideEJBWrapper.java:38)
at glog.business.planningstructure.PlanningObjectUpdateSessionBean.commitOrderMovementGraphs(PlanningObjectUpdateSessionBean.java:59)
at glog.business.planningstructure.PlanningObjectUpdateSessionServerSideEJBWrapper.commitOrderMovementGraphs(PlanningObjectUpdateSessionServerSideEJBWrapper.java:75)
at glog.business.planningstructure.PlanningObjectUpdateSessionServerSideEJBWrapper_fexvg1_EOImpl.commitOrderMovementGraphs(PlanningObjectUpdateSessionServerSideEJBWrapper_fexvg1_EOImpl.java:62)
at glog.business.shipment.ShipmentUpdateSessionBean.commitOrderModChanges(ShipmentUpdateSessionBean.java:1883)
at glog.business.shipment.ShipmentUpdateSessionServerSideEJBWrapper.commitOrderModChanges(ShipmentUpdateSessionServerSideEJBWrapper.java:431)
at glog.business.shipment.ShipmentUpdateSessionHome_qj7mtr_EOImpl.commitOrderModChanges(ShipmentUpdateSessionHome_qj7mtr_EOImpl.java:733)
at glog.business.omd.OrderModShipmentEditor.editShipments(OrderModShipmentEditor.java:528)
at glog.business.session.OMDProcessorSessionBean.editShipments(OMDProcessorSessionBean.java:84)
at glog.business.session.OMDProcessorSessionServerSideEJBWrapper.editShipments(OMDProcessorSessionServerSideEJBWrapper.java:89)
at glog.business.session.OMDProcessorSessionHome_f09cq7_EOImpl.editShipments(OMDProcessorSessionHome_f09cq7_EOImpl.java:645)
at glog.server.agent.business.order.ORModEditShipment.process(ORModEditShipment.java:87)
at glog.server.agent.business.order.ORActionTopic.persist(ORActionTopic.java:47)
at glog.server.agent.PersistActionTopic.execute(PersistActionTopic.java:34)
at glog.server.agent.ActionWorkflow.execute(ActionWorkflow.java:49)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:353)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:353)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.ContinuousEventQueueRunnable.processEvent(ContinuousEventQueueRunnable.java:31)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:96)
at glog.util.event.EventThread.run(EventThread.java:82)
at java.lang.Thread.run(Thread.java:619)
[agentSingleThreaded - 5]

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