My Oracle Support Banner

FULFILORDAPPRDEL Messages Fails in RIB Hospital for RMFCS With "[E] Error ORA-01426: Numeric Overflow Returned By Program Unit" When Processing a Customer Order Cancellation. (Doc ID 2757312.1)

Last updated on FEBRUARY 05, 2024

Applies to:

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


When processing a Customer Order cancellation, FULFILORDAPPRDEL messages are failing with error in RIB Hospital for RMFCS:

"javax.ejb.EJBException: Error while calling Injector Service.: Client received SOAP Fault from server: EJB Exception: : java.lang.RuntimeException: Exception calling plsql inject. Error from {call RMSSUB_FULFILORD.CONSUME(?,?,?,?)}: [E] Error ORA-01426: numeric overflow returned by program unit CORESVC_FULFILORD_TSF.POPULATE_CANCEL_REC.
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.invokeInjectForMessageType(
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.inject(
at sun.reflect.GeneratedMethodAccessor1373.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke("

Steps to reproduce:

1. Order created and integrated to RMS.
2. Order integrated to WMS then a line is cancelled i.e. no stock available for the order.
3. SOStatus is sent to RIB (gets transformed in FULFILORDAPPRDEL before going to RMS).
4. Check QTY_Cancelled_SUOM but it was not updated with canceled quantity. Observe FULFILORDAPPRDEL message failed with error.




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

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