PROD: New Item Location Records Fail To Integrate To SIOCS
(Doc ID 3019143.1)
Last updated on APRIL 29, 2024
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 24.0 and laterInformation in this document applies to any platform.
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
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 |