PROD: New Item Location Records Fail To Integrate To SIOCS (Doc ID 3019143.1)

Last updated on APRIL 29, 2024

Applies to:

Symptoms

When attempting to retry failed ItemLocCre messages, the following error occurs and the message is not successfully processed. Stores exist in the STORE_ITEM table.

MPS_STAGED_MESSAGE.MESSAGE_DATA for ItemLocCre Message Type:

<?xml version="1.0" encoding="UTF-8"?>
<ItemLocDEO>
  <itemId>102755552</itemId>
  <itemLocPhysDEOList>
     <physicalLoc>2106</physicalLoc>
     <itemLocVirtDEOs>
        <locationType>S</locationType>
        <localShortDesc>O Nelia Exit Detail Dress::8</localShortDesc>
        <localItemDesc>O Nelia Exit Detail Dress::8</localItemDesc>
        <status>C</status>
        <primarySuppId>2003105</primarySuppId>
        <sellingUnitRetail>399</sellingUnitRetail>
        <storePriceInd>N</storePriceInd>
        <purchaseType>0</purchaseType>
        <sellingUom>EA</sellingUom>
        <rfid>N</rfid>
        <isExternalCreateAllowed>N</isExternalCreateAllowed>
     </itemLocVirtDEOs>
  </itemLocPhysDEOList>
  <itemLocPhysDEOList>
     <physicalLoc>2105</physicalLoc>
     <itemLocVirtDEOs>
        <locationType>S</locationType>
        <localShortDesc>O Nelia Exit Detail Dress::8</localShortDesc>
        <localItemDesc>O Nelia Exit Detail Dress::8</localItemDesc>
        <status>C</status>
        <primarySuppId>2003105</primarySuppId>
        <sellingUnitRetail>399</sellingUnitRetail>
        <storePriceInd>N</storePriceInd>
        <purchaseType>0</purchaseType>
        <sellingUom>EA</sellingUom>
        <rfid>N</rfid>
        <isExternalCreateAllowed>N</isExternalCreateAllowed>
     </itemLocVirtDEOs>
  </itemLocPhysDEOList>
</ItemLocDEO>

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

oracle.retail.sim.common.core.SimServerException: Error processing message! [Inbound: true, MessageType: ItemLocCre, BusinessId: 102755552]
at oracle.retail.sim.service.mps.BaseSimMessageServiceHandler.buildException(Unknown Source)
at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(Unknown Source)
at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(Unknown Source)
at oracle.retail.sim.service.core.BaseServiceHandler.execute(Unknown Source)
at oracle.retail.sim.service.mps.MpsServiceImpl.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.mps.MpsServiceImpl.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.mps.MpsServiceImpl$Proxy$_$$_WeldClientProxy.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.ejb.MpsServiceBean.processStagedMessage(Unknown Source)
at sun.reflect.GeneratedMethodAccessor839.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
:
Caused by: oracle.retail.sim.common.core.SimServerException: Store not found for Id: 2106
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocConsumer.buildStoreNotFoundException(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocConsumer.updateDataBeans(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocConsumer.processItemStoreDeos(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocConsumer.processItemLocDeo(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocCreateConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.itemloc.ItemLocCreateConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.SimMessageConsumerProviderImpl.consume(Unknown Source)
... 62 more

Steps to Reproduce:


1. ItemLocCre messages have failed in MPS_STAGED_MESSAGE table due to STORE_ID not in the STORE table.
2. Store data is imported and stores exists in STORE table.
3. Select failed messaged and retry from MPS Staged Messages screen.

Messages not processed and fail with the same error.

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.