Customer Batch Load Failing Invoking lookupXRef For CUSTOMERPARTY_PARTYID.xref (Doc ID 1382077.1)

Last updated on OCTOBER 04, 2016

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

When attempting to do initial customer load, BatchLoadCustomerPartyListEbizReqABCSImpl is failing during label="XformOutputParameters_Create_To_SyncCustomerPartyListEBM" with following error :

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_To_SyncCustomerPartyListEBM.xsl',bpws:getVariableData('Invoke_BatchLoadCustomerPartyListEbizAdapter_BatchLoadCustomerPartyListEbizAdapter_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/BatchLoadCustomerPartyListEbizReqABCSImpl_rev1.0/xsl/OutputParameters_To_SyncCustomerPartyListEBM.xsl<Line 896, Column 152>: XML-22044: (Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.ValidationException: Reference Column Name is empty for Table Name "oramds:/apps/AIAMetaData/xref/CUSTOMERPARTY_PARTYID.xref" Please ensure Reference Column Name is non-empty'. Check the detailed root cause described in the exception message text and verify that the XPath query is correct.

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