Customer Orders With Multi Qty Fail in SIM With ' Item <XXXXXX> can not be added to the Fulfillment Order more than once.' Error (Doc ID 2643698.1)

Last updated on AUGUST 14, 2022

Applies to:

Symptoms

In Oracle Retail Store Inventory Management (RSIM), when attempting to persist the customer order messages from Oracle Retail Order Management System (OMS), the following error occurs.  Single line multi-quantity orders are failed in SIM at the very initial step i.e, once the Order Broker brokers it to a store location the order message is failed in MPS_STAGED_MESSAGE with the below error and the order never bridges into SIM.


ERROR
-------
oracle.retail.sim.common.core.SimServerException: Error processing message! [Inbound: true, MessageType: FulfilOrdStDlvCre, BusinessId: <xxxxxxxxx>]
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.GeneratedMethodAccessor792.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.MethodInvocationEventCallbackInvocationContext.proceed(LifecycleEventCallbackInvocationContext.java:150)
at com.oracle.pitchfork.intercept.InterceptionMetadata.invokeTimeoutMethod(InterceptionMetadata.java:626)
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:678)
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:652)
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 <XXXXXXXX> can not be added to the Fulfillment Order more than once.
at oracle.retail.sim.server.integration.consumer.fulfillmentorder.FulfilOrdConsumer.buildItemDuplicateException(Unknown Source)
at oracle.retail.sim.server.integration.consumer.fulfillmentorder.FulfilOrdCreateConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.fulfillmentorder.FulfilOrdCreateConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.SimMessageConsumerProviderImpl.consume(Unknown Source)
... 63 more


The following message is inbound the RIB which fails to process in SIM.MPS_STAGED_MESSAGE table.

Cause

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