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 JULY 25, 2022

Applies to:

Symptoms

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(PlsqlApplicationMessageInjectorServiceBean.java:181)
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.inject(PlsqlApplicationMessageInjectorServiceBean.java:68)
at sun.reflect.GeneratedMethodAccessor1373.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)"

 
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.

Changes

Cause

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