ASNInCre Messages Fail in SIM With 'ORA-00001: unique constraint (DSD_LINE_ITEM_UK) violated' (Doc ID 2758173.1)

Last updated on MAY 16, 2023

Applies to:

Symptoms

Retail Store Inventory Management (RSIM) does not allow two supplier Advanced Shipment Notification (ASNs) for a Direct Delivery Purchase Order (DSD PO) where the same item is repeated with different quantity. The message fails with the following error:

Aug 20, 2020 11:02:14,323 AM CDT>   Batch 0: [5][2][4][100696076][100.0][50.0][Null(NUMERIC)][Null(NUMERIC)][USD][100.0][Null(VARCHAR)][Null(NUMERIC)][5000][161][1888850030][][][Null(VARCHAR)][Null(NUMERIC)][Null(NUMERIC)][Null(NUMERIC)][Null(NUMERIC)]
  Batch 1: [6][2][4][100696076][100.0][50.0][Null(NUMERIC)][Null(NUMERIC)][USD][100.0][Null(VARCHAR)][Null(NUMERIC)][5000][161][1888850030][][][Null(VARCHAR)][Null(NUMERIC)][Null(NUMERIC)][Null(NUMERIC)][Null(NUMERIC)]>
java.sql.BatchUpdateException: ORA-00001: unique constraint (DSD_LINE_ITEM_UK) violated
  at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9775)
  at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1448)
  at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9540)
  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:238)
  at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:197)
  at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeBatch(BaseOracleDao.java:221)
  at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeBatch(BaseOracleDao.java:198)
  at oracle.retail.sim.server.dataaccess.daoimpl.VendorDeliveryCartonOracleDao.insertLineItems(VendorDeliveryCartonOracleDao.java:119)
  at oracle.retail.sim.server.dataaccess.daoimpl.VendorDeliveryCartonOracleDao.insertCarton(VendorDeliveryCartonOracleDao.java:75)
  at oracle.retail.sim.server.dataaccess.daoimpl.VendorDeliveryCartonOracleDao$Proxy$_$$_WeldClientProxy.insertCarton(Unknown Source)
  at oracle.retail.sim.server.integration.consumer.asn.ASNInVendorDeliveryCreateConsumer.handleMessage(ASNInVendorDeliveryCreateConsumer.java:175)
  at oracle.retail.sim.server.integration.consumer.asn.ASNInCreateConsumer.handleMessage(ASNInCreateConsumer.java:31)
  at oracle.retail.sim.server.integration.consumer.asn.ASNInCreateConsumer.handleMessage(ASNInCreateConsumer.java:1)
  at oracle.retail.sim.server.integration.consumer.SimMessageConsumerProviderImpl.consume(SimMessageConsumerProviderImpl.java:40)
  at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(SimMessageProcessHandler.java:73)
  at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(SimMessageProcessHandler.java:1)
  at oracle.retail.sim.service.core.BaseServiceHandler.execute(BaseServiceHandler.java:37)
  at oracle.retail.sim.service.mps.MpsServiceImpl.processStagedMessage(MpsServiceImpl.java:88)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.