Outbound Inventory Adjustment Messages Are Getting Failed In MPS_STAGED_MESSAGE When UIN Is Missing In ITEM_UIN (Doc ID 2805451.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Symptoms

Outbound inventory Adjustment messages are getting failed in MPS_STAGED_MESSAGE when no UIN in ITEM_UIN with error:

oracle.retail.sim.common.core.SimServerException: Error processing message! [Inbound: false, MessageType: InvAdjustCre, BusinessId: SIM#XXXXXX]
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$Proxy$_$$_WeldClientProxy.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.mps.MpsServerServiceImpl.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.mps.MpsServerServiceImpl$Proxy$_$$_WeldClientProxy.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.ejb.MpsServerServiceBean.processStagedMessage(Unknown Source)
...
at oracle.retail.sim.intrib.publisher.RibMessagePublisherEjbImpl.publish(Unknown Source)
at oracle.retail.sim.intrib.publisher.RibMessagePublisherEjbImpl$Proxy$_$$_WeldClientProxy.publish(Unknown Source)
at oracle.retail.sim.intrib.publisher.SimMessageRibPublisher.publish(Unknown Source)
...
Caused by: javax.validation.ConstraintViolationException
...

Steps to reproduce:

1. Create a serialized item (ITEM_LOC.UIN_TYPE = 'SN').
2. Perform a return transaction using POSTransactionService and add UIN to this transaction (Trade-in Scenario).
    Ensure to provide a reason which moves inventory to the unavailable bucket and UIN is not existing in item_uin table.
3. Observe that SIM generates Inventory adjustment message to RMS to move the inventory to nonsellable bucket and this is failing in MPS_STAGED_MESSAGE table.

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.