DcsItemApprove Message Types Fail in SIOCS with Non-Stock Holding Store Locations Included in MESSAGE_DATA (Doc ID 3020761.1)

Last updated on MAY 10, 2024

Applies to:

Symptoms

When attempting to process 'DcsItemUda' messages in the MPS_STAGED_MESSAGE table, the following error occurs.

ERROR
---------
oracle.retail.sim.common.core.SimServerException: Error processing message! [Inbound: true, MessageType: DcsItemUda, BusinessId: SIM#7062]
at oracle.retail.sim.service.mps.BaseSimMessageServiceHandler.buildException(BaseSimMessageServiceHandler.java:80)
at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(SimMessageProcessHandler.java:100)
at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(SimMessageProcessHandler.java:22)
at oracle.retail.sim.service.core.BaseServiceHandler.execute(BaseServiceHandler.java:39)
at oracle.retail.sim.service.mps.MpsServiceImpl.processStagedMessage(MpsServiceImpl.java:192)
at oracle.retail.sim.service.mps.MpsServiceImpl.processStagedMessage(MpsServiceImpl.java:123)
at oracle.retail.sim.service.mps.MpsServiceImpl$Proxy$_$$_WeldClientProxy.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.ejb.MpsServiceBean.processStagedMessage(MpsServiceBean.java:126)
at sun.reflect.GeneratedMethodAccessor832.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:344)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
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:186)
at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocatioonContext.java:150)
at com.oracle.pitchfork.intercept.InterceptionMetadata.invokeTimeoutMethod(InterceptionMetadata.java:627)
at weblogic.ejb.container.injection.EjbComponentCreatorImpl.invokeTimer(EjbComponentCreatorImpl.java:71)
at weblogic.ejb.container.injection.InjectionBasedEjbComponentCreator.invokeTimer(InjectionBasedEjbComponentCreator.java:193)
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:681)
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:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: oracle.retail.sim.common.core.SimServerException: Item does not exist: 45214491
at oracle.retail.sim.server.integration.consumer.dcs.ItemUdaDcsConsumer.handleCreateItemUda(ItemUdaDcsConsumer.java:63)
at oracle.retail.sim.server.integration.consumer.dcs.ItemUdaDcsConsumer.handleMessage(ItemUdaDcsConsumer.java:58)
at oracle.retail.sim.server.integration.consumer.dcs.ItemUdaDcsConsumer.handleMessage(ItemUdaDcsConsumer.java:16)
at oracle.retail.sim.server.integration.consumer.SimMessageConsumerProviderImpl.consume(SimMessageConsumerProviderImpl.java:43)
at oracle.retail.sim.service.mps.SimMessageProcessHandler.handleOperation(SimMessageProcessHandler.java:89)
... 61 more



Steps to Reproduce:

1. Records from ITEM_MASTER are in ICL_RMS_ITEM_MASTER table.
2. Item 45214491 not processed into SIOCS
3. Error in DCS_WORK table for Item Work Type.

ORA-00942: table or view does not exist.

Cause

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