Unable To Send A Completed Activity From MWM To FWPIP After Patch Update V2.1.0.1 With Error Indicating 'ServerXPath expression failed to execute' (Doc ID 1452532.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.1.0 and later
Oracle Process Integration Pack for Oracle Utilities Field Work - Version 3.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to submit a completed Activity from MWM to FWPIP, the Activity will complete from MWM but always fails when going to FWPIP with the following error:

ERROR
-----------------------
17:15:21,624 [DEFAULTWorker:1] ERROR (com.splwg.base.messaging.impl.HTTPSender) HTTP status code (500) was returned.
env:ServerXPath expression failed to execute.
An error occurs while processing the XPath expression; the expression is ora:processXSLT('Xform_OrderCompleteABMReqMsg_to_WorkOrderEBMReqMsg.xsl',bpws:getVariableData('ProcessOrderCompleteReqMsg','ProcessOrderComplete')).
The XPath expression failed to execute; the reason was: oracle.fabric.common.xml.xpath.XPathFunctionException: javax.xml.transform.TransformerException: oramds:/deployed-composites/default/ProcessWorkOrderCompleteOUMWMUtilitiesReqABCSImplV2_rev1.0/Xform_OrderCompleteABMReqMsg_to_WorkOrderEBMReqMsg.xsl<Line 37, Column 192>: XML-22044: (Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.ValidationException: Reference value is empty for Reference Column Name "OU_MWM_01" and for Table Name "oramds:/apps/AIAMetaData/xref/FS_ORDER_ID.xref" Please ensure Reference value is non-empty'. Check the detailed root cause described in the exception message text and verify that the XPath query is correct.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms