My Oracle Support Banner

"Store does not exist for transfer" Error When 'SOHdrDel' Message is Processed in SIM (Doc ID 2689733.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

When a transfer from warehouse to store is deleted from Retail Merchandising System (RMS) and generate a SOHdrDel message, this message is not processed in SIM and the following error is seen in the STAGED_MESSAGE table.

ERROR:

oracle.retail.sim.common.core.SimServerException: Error processing message! [Inbound: true, MessageType: SOHdrDel, BusinessId: XXXXXXX]
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 sun.reflect.GeneratedMethodAccessor740.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)
at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:101)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at com.oracle.pitchfork.intercept.MethodInvocationInvocatio at weblogic.ejb.container.injection.EjbComponentCreatorImpl.invokeTimer(EjbComponentCreatorImpl.java:71)
at weblogic.ejb.container.injection.InjectionBasedEjbComponentCreator.invokeTimer(InjectionBasedEjbComponentCreator.java:185)
at weblogic.ejb.container.manager.BaseEJBManager.invokeTimeoutMethod(BaseEJBManager.java:199)
at weblogic.ejb.container.timer.TimerImpl.timerExpired(TimerImpl.java:343)
at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:301)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:670)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:644)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:415)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:355)
Caused by: oracle.retail.sim.common.core.SimServerException: Store does not exist for transfer: <XXXXXXXX>
at oracle.retail.sim.server.integration.consumer.stockorder.StockOrderDeleteConsumer.buildStoreNotFoundException(Unknown Source)
at oracle.retail.sim.server.integration.consumer.stockorder.StockOrderDeleteConsumer.findTransfer(Unknown Source)
at oracle.retail.sim.server.integration.consumer.stockorder.StockOrderDeleteConsumer.processTransfer(Unknown Source)
at oracle.retail.sim.server.integration.consumer.stockorder.StockOrderDeleteConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.stockorder.StockOrderDeleteConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.SimMessageConsumerProviderImpl.consume(Unknown Source)
... 63 more

 

Steps to Reproduce:

RMS:

  1. Create a RMS transfer from Warehouse to a store
  2. Approve the TSF

SOCre message is received and processed by SIM



SIM:


5. Check that on SIM the status continue as Approved and the message SOHdrDel is on error on MPS.
6. Check the MPS_STAGED_MESSAGE table.

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.