My Oracle Support Banner

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

Last updated on MARCH 22, 2021

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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