My Oracle Support Banner

RMSSUB_DSD.CONSUME(?,?,?,?)}: [E] Order Has Not Been Approved (Doc ID 2862936.1)

Last updated on MAY 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Symptoms



Error for On the fly Purchase Order Receiving .


ERROR
-----------------------
"RMSSUB_DSD.CONSUME(?,?,?,?)}: [E] Order has not been approved"
Caused by: javax.ws.rs.InternalServerErrorException: Exception calling plsql inject. Error from {call RMSSUB_DSD.CONSUME(?,?,?,?)}: [E] Order has not been approved.
ExceptionVo{statusCode=500, status=Internal Server Error, message=Exception calling plsql inject. Error from {call RMSSUB_DSD.CONSUME(?,?,?,?)}: [E] Order has not been approved., stackTrace=java.lang.RuntimeException: Exception calling plsql inject. Error from {call RMSSUB_DSD.CONSUME(?,?,?,?)}: [E] Order has not been approved.
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.invokeInjectForMessageType(PlsqlApplicationMessageInjectorServiceBean.java:178)
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.inject(PlsqlApplicationMessageInjectorServiceBean.java:69)
at com.oracle.retail.rib.integration.services.slave.subscriber.RemotePlsqlApplicationMessageInjectorResource.inject(RemotePlsqlApplicationMessageInjectorResource.java:50)
 

Steps to reproduce:

1. Create "On the fly Purchase Order " in EICS
2. Check whether message(DSDReceiptCre) processed successfully from MPS_STAGED_MESSAGE in EICS
3. The order is expected to flow in MFCS but in RIB-RMS following error message found:



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.