Pick Orders from MWM to CCB are failing in PIP Due To Mapping of Operations Area and Dispatch Group

(Doc ID 1481682.1)

Last updated on DECEMBER 01, 2016

Applies to:

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

Symptoms

Pick Orders from MWM to CCB are failing in PIP. There are two issues which is being observe.

1) For every pick up order, the Mapping for the OperationAreaCode is mapped with the country code instead of the service area code. This is in the transformation of ProcessWorkOrderCreateOUMWMUtilitiesReqABCSImplV2 process.
2) The Mapping of the DispatchGroup code is not working. Configured the FS_Order_DispatchGroup.dvm based on the rules mentioned in the ProcessWorkOrderCreateOUMWMUtilitiesReqABCSImplV2 process. But the same dvm is failing on the Provider process which is interacting with CCB (ProcessWorkOrderOUCCBUtilitiesProvABCSImpl).

The following error is being encountered.

<AIAAsyncErrorHandlingBPELProcessRequestMessage>
<part  name="FaultMessage">
<Fault>
<EBMReference/>
<B2BMReference/>
<FaultNotification>
<ReportingDateTime>2012-08-01T09:53:40-08:00</ReportingDateTime>
<FaultMessage>
<Code>XPathExecutionError</Code>
<Text>XPath expression failed to execute. An error occurs while processing the XPath expression; the expression is ora:processXSLT('Xform_ProcessWorkOrderEBM_to_CCBOrderCreateABM.xsl',bpws:getVariableData('ProcessOrderReqMsg','ProcessOrder')). The XPath expression failed to execute; the reason was: oracle.fabric.common.xml.xpath.XPathFunctionException: javax.xml.transform.TransformerException: oramds:/deployed-composites/default/ProcessWorkOrderOUCCBUtilitiesProvABCSImpl_rev1.0/Xform_ProcessWorkOrderEBM_to_CCBOrderCreateABM.xsl<Line 28, Column 321>: XML-22044: (Error) Extension function error: Error invoking 'lookupValue':'oracle.tip.dvm.exception.DVMException: The source column "COMMON" has already multiple occurences of source value "MWM" in dvm "oramds:/apps/AIAMetaData/dvm/FS_Order_DispatchGroup.dvm". Please ensure the source value is unique for a given source column.'. Check the detailed root cause described in the exception message text and verify that the XPath query is correct. </Text>
<IntermediateMessageHop/>
</FaultMessage>
<FaultingService>
<ID>ProcessWorkOrderOUCCBUtilitiesProvABCSImplProcess</ID>
<ImplementationCode>BPEL</ImplementationCode>
<InstanceID>107820</InstanceID>
</FaultingService>
</FaultNotification>
</Fault>
</part>
</AIAAsyncErrorHandlingBPELProcessRequestMessage>

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