My Oracle Support Banner

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 MAY 05, 2021

Applies to:

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

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

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
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.