Processing Events From e-Business to CRM On Demand Failing With "Xpath Expression Failed To Execute" Error

(Doc ID 1376625.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite - Version 3.1 and later
Information in this document applies to any platform.

Symptoms

Lead To Order PIP 3.1.1

When attempting to process an event from Oracle e-Business, SyncCustomerPartyListEbizReqABCSImpl is failing.
During call to label="XformOutputParameters_Create_To_SyncCustomerPartyListEBM, following error is seen:

ERROR
-----------------------
<exception class="com.collaxa.cube.xml.xpath.XPathException">XPath expression failed to execute.
An error occurs while processing the XPath expression; the expression is ora:processXSLT(xsl/OutputParameters_Create_To_SyncCustomerPartyListEBM.xsl,bpws:getVariableData(InvokeQueryCustomerPartyListCreateAdapter_QueryCustomerPartyListEbizCreateAdapter_OutputVariable OutputParameters),bpws:getVariableData(params)).
The XPath expression failed to execute; the reason was: oracle.fabric.common.xml.xpath.XPathFunctionException: javax.xml.transform.TransformerException: oramds:/deployed-composites/default/SyncCustomerPartyListEbizReqABCSImpl_rev1.0/xsl/OutputParameters_Create_To_SyncCustomerPartyListEBM.xsl<Line 867, Column 152>: XML-22044: (Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.ValidationException: Reference Column Name is empty for Cross Refrence Table Name "CUSTOMERPARTY_PARTYID"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Create a new account in e-Business
Run TCA program to process event

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