Cancelling PO In RMS Does Not Update PO Status In PURCHASE_ORDER Table (Doc ID 2958981.1)

Last updated on JULY 13, 2023

Applies to:

Goal

When attempting to process a POHdrMod message published by Retail Merchandising system after a partially received PO is cancelled,
the following error occurs.

ERROR
-----------------------

oracle.retail.sim.common.core.SimServerException: Error processing message! [Inbound: true, MessageType: POHdrMod, BusinessId: 2596193]
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.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.mps.MpsServiceImpl$Proxy$_$$_WeldClientProxy.processStagedMessage(Unknown Source)
at oracle.retail.sim.service.ejb.MpsServiceBean.processStagedMessage(Unknown Source) at sun.reflect.GeneratedMethodAccessor803.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(MethodInvocationInvocationContext.java:101)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroucept.InterceptionMetadata.invokeTimeoutMethod(InterceptionMetadata.java:627)
:
:
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: Purchase order has open deliveries! Cann't modify the Purchase order: 2596193
at oracle.retail.sim.server.integration.consumer.order.PurchaseOrderConsumer.buildPurchaseOrderHasOpenDeliveriesException(Unknown Source)
at oracle.retail.sim.server.integration.consumer.order.PurchaseOrderModifyConsumer.closePurchaseOrder(Unknown Source)
at oracle.retail.sim.server.integration.consumer.order.PurchaseOrderModifyConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.order.PurchaseOrderModifyConsumer.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.consumer.SimMessageConsumerProviderImpl.consume(Unknown Source) ... 62 more

1. Login to SOCS
2. Receive 2 items in a PO which has 4 items in total.
3. PURCHASE_ORDER status changes to 2 - In Progress.
4. In RMS, user cancels remaining 2 items which are not received.
5. PODtlMod and POHdrMod  messages are published from RMS.
6. PODtlMod  is processed in SIOCS and item Expected Qty is set to 0.
7. POHdrMod  message fails and Status remains as 2.

Solution

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