ISSUE/QUESTION: 

When a user clicks on the return to vendor button, after the inventory was received from a purchase order, and then inspects the inventory as serviceable before sending the shipment, this leaves the shipment without a return_price and it is expected when the inventory is INSPREQ to have one but after the inspection, the return_price is not being populated as expected.

ENVIRONMENT: 

Maintenix

AUDIENCE: 

ALL

RESOLUTION/ANSWER: 

When encountered, a script will be needed to update the return_price of the outbound shipment.

UPDATE ship_shipment
SET return_price = 0
WHERE shipment_db_id = xxxxxxx
AND shipment_id = xxxxxx;
 

CAUSE:

Return_price being set as null instead of 0

ADDITIONAL INFORMATION: N/A

SCRIPTS/LOGS: 

<pERR-12116879] Uncaught exception processing 'com.mxi.mx.web.servlet.shipment.SendShipment'.>
javax.ejb.TransactionRolledbackLocalException: EJB Exception:
at weblogic.ejb.container.internal.EJBRuntimeUtils.asTxRollbackLocalException(EJBRuntimeUtils.java:151)
at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:471)
at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:410)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:239)
at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:195)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:46)
at com.mxi.mx.core.ejb.shipment.Shipment_6khnwk_ELOImpl.updateAndSend(Unknown Source)
at com.mxi.mx.web.servlet.shipment.SendShipment.processLogic(SendShipment.java:93)
at com.mxi.mx.common.servlet.AbstractLogicServlet.processRequestInternal(AbstractLogicServlet.java:281)
at com.mxi.mx.common.servlet.AbstractLogicServlet.processRequest(AbstractLogicServlet.java:194)
at com.mxi.mx.web.servlet.LogicServlet.processRequest(LogicServlet.java:169)
at com.mxi.mx.common.servlet.AbstractServlet.doGet(AbstractServlet.java:189)
at com.mxi.mx.common.servlet.AbstractServlet.doPost(AbstractServlet.java:264)

Caused by: java.lang.NullPointerException
<2019-02-12T03:43:35,199Z> <ERROR> <com.mxi.mx.common.cache.CacheFactory> <lprpmroap02.cl.lan.com> <mxsystem> <59b676a9-51fc-444f-b097-fdf15379b337-0070287b> <{type=EJB, action=com.mxi.mx.common.ejb.cache.CacheInvalidatorBean::cacheInvalidationTimerCallback}> <MXLOG-000000> <error encountered while refreshing SQL authentication provider availability>
java.lang.NoSuchMethodError: com.bea.core.repackaged.springframework.util.StringUtils.isEmpty(Ljava/lang/Object;)Z
at com.mxi.mx.common.wls.utils.WeblogicUtils.getAdminServerJMXConnection(WeblogicUtils.java:111)
at com.mxi.mx.common.wls.security.WebLogicSecurity.isSqlAuthenticatorPresent(WebLogicSecurity.java:929)
at com.mxi.mx.common.wls.security.WebLogicSecurity.isUsingMaintenixDBLogin(WebLogicSecurity.java:779)

SOURCE: 

OPER-29551

VERIFIED: