"Cannot add the QUOTE_COST_OPTION_SHIPMENT record. QUOTE_GID, COST_OPTION_SEQUENCE, SHIPMENT_SEQUENCE must be unique" Error When Sending in a Quote XML Update to OTM Using TransactionCode of 'IU' (Doc ID 2060540.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.3.1 to 6.4.2 [Release 6.3 to 6.4]
Information in this document applies to any platform.

Symptoms

When attempting to send in a Quote XML update to OTM using TransactionCode of 'IU', the following error occurs.

ERROR
-----------------------
IMessageText = CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION: insert into quote_cost_option_shipment (quote_gid,cost_option_sequence,shipment_sequence,is_primary,actual_cost,start_time,end_time,servprov_gid,transport_mode_gid,rate_offering_gid,rate_geo_gid,flight_gid,rate_from_location_gid,rate_to_location_gid,source_via_location_gid,dest_via_location_gid,voyage_gid,distance,perspective,rate_expiration,source_location_gid,source_location_name,source_address_line1,source_address_line2,source_address_line3,source_city,source_province,source_country_code3_gid,source_postal_code,dest_location_gid,dest_location_name,destination_address_line1,destination_address_line2,destination_address_line3,destination_city,destination_province,destination_country_code3_gid,destination_postal_code,shipment_type_gid,nfrc_rule_gid,domain_name,distance_uom_code,actual_cost_currency_gid,distance_base,actual_cost_base) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) at [XXX.537388880, 0, 0, Y, 0.0 USD, null, null, null, null, null, null, null, null, null, null, null, null, null, S, null, DUMMY LOCATION, null, null, null, null, null, null, null, null, DUMMY LOCATION, null, null, null, null, null, null, null, null, null, null, DOMAIN] Cannot add the QUOTE_COST_OPTION_SHIPMENT record. [QUOTE_GID, COST_OPTION_SEQUENCE, SHIPMENT_SEQUENCE] must be unique. java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_QUOTE_COST_OPTION_SHIPMENT) violated java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_QUOTE_COST_OPTION_SHIPMENT) violated at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210) at glog.util.jdbc.SqlUpdate.processBatch(SqlUpdate.java:145) at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:244) 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.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:171) at glog.util.persistence.BeanDataPersistenceExecutor.insertPerformed(BeanDataPersistenceExecutor.java:97) at glog.util.persistence.PersistenceExecutor.persistencePerformed(PersistenceExecutor.java:91) at glog.util.persistence.WaterFallInsertion.performedInsertion(WaterFallInsertion.java:264) at glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:106) at glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:49) at glog.util.persistence.InsertUpdate.doPersist(InsertUpdate.java:112) at glog.util.persistence.InsertUpdate.persist(InsertUpdate.java:54) at glog.util.persistence.PersistenceManager.execute(PersistenceManager.java:122) at glog.server.compareengine.TopicPublisher.persist(TopicPublisher.java:161) at glog.server.compareengine.TopicPublisher.publish(TopicPublisher.java:64) at glog.server.compareengine.CompareEngine.compare(CompareEngine.java:116) at glog.util.genericcontainer.GenericContainerUtilSessionBean.compare(GenericContainerUtilSessionBean.java:141) at glog.util.genericcontainer.GenericContainerUtilSessionBean.compareAndStore(GenericContainerUtilSessionBean.java:90) at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper.java:210) at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40) at glog.util.genericcontainer.GenericContainerUtilSes

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