DcsTransferReview Message Fails With 'Invalid store review status for creation of store order.' (Doc ID 3023985.1)

Last updated on DECEMBER 19, 2024

Applies to:

Goal

You have observed these messages pile up in MPS_STAGED_MESSAGE table in an environment where SIOCS is integrated with MFCS via DirectDB method. You want to know the reason of this pile up.

DcsTransferReview MessageType

Message:
<?xml version="1.0" encoding="UTF-8"?>
<TransferDcsDeo>
   <transferId>70026</transferId>
   <status>I</status>
   <sourceLocationId>81</sourceLocationId>
   <sourceLocationType>S</sourceLocationType>
   <destinationLocationId>963</destinationLocationId>
   <destinationLocationType>S</destinationLocationType>
   <deliveryDate>2024-10-28T00:00:00Z</deliveryDate>
   <notAfterDate>2024-11-01T00:00:00Z</notAfterDate>
   <inventoryType>A</inventoryType>
   <createTransfer>false</createTransfer>
   <updateTransfer>true</updateTransfer>
   <deleteTransfer>false</deleteTransfer>
   <updateDetails>false</updateDetails>
</TransferDcsDeo>

Error:
Caused by: oracle.retail.sim.common.core.SimServerException: Invalid store review status for creation of store order.
    at oracle.retail.sim.server.integration.consumer.dcs.TransferReviewDcsConsumer.buildInvalidStatusForCreate(Unknown Source)
    at oracle.retail.sim.server.integration.consumer.dcs.TransferReviewDcsConsumer.processCreateStoreOrder(Unknown Source)
    at oracle.retail.sim.server.integration.consumer.dcs.TransferReviewDcsConsumer.handleMessage(Unknown Source)
    at oracle.retail.sim.server.integration.consumer.dcs.TransferReviewDcsConsumer.handleMessage(Unknown Source)
    at oracle.retail.sim.server.integration.consumer.SimMessageConsumerProviderImpl.consume(Unknown Source)

Solution

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