Certain Opportunities Are Failing To Be Converted To Quotes (Doc ID 1263395.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 2.5 to 2.5 [Release 2.5]
Information in this document applies to any platform.

Symptoms

When attempting to convert a opportunity to a quote for certain accounts the BPEL processes fail. In reviewing the oc4j log files the following error occurs.

...
10/10/05 15:10:32 com.oracle.bpel.xml.xpath.XPathFunctionException: file:///oracle/aia/soa/bpel/domains/default/tmp/.bpel_CreateSalesQuoteEbizProvABCSImpl_1.0_c7aec6cf771c116e95f179d08f6da665.tmp/Xform_CreateSalesQuoteEBM_To_CreateSalesQuoteABM.xsl<Line 103, Column 120>: XML-22044: (Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.RepositoryException: lookup could not find values in column name "EBIZ_01" for table name "CUSTOMERPARTY_PARTYLOCATIONID" using reference column name "COMMON" and reference value "36323533343839323535353633333630"
Please ensure lookup criteria has a match.'

10/10/05 15:10:32 at com.oracle.bpel.xml.xpath.XPathFunctionException.fillInStackTrace(XPathFunctionException.java:65)
...
10/10/05 15:10:32 Root cause:
; SystemID: file:///oracle/aia/soa/bpel/domains/default/tmp/.bpel_CreateSalesQuoteEbizProvABCSImpl_1.0_c7aec6cf771c116e95f179d08f6da665.tmp/Xform_CreateSalesQuoteEBM_To_CreateSalesQuoteABM.xsl; Line#: 103; Column#: 120
javax.xml.transform.TransformerException: file:///oracle/aia/soa/bpel/domains/default/tmp/.bpel_CreateSalesQuoteEbizProvABCSImpl_1.0_c7aec6cf771c116e95f179d08f6da665.tmp/Xform_CreateSalesQuoteEBM_To_CreateSalesQuoteABM.xsl<Line 103, Column 120>: XML-22044: (Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.RepositoryException: lookup could not find values in column name "EBIZ_01" for table name "CUSTOMERPARTY_PARTYLOCATIONID" using reference column name "COMMON" and reference value "36323533343839323535353633333630"
Please ensure lookup criteria has a match.'
at oracle.xml.jaxp.JXTransformer.reportXSLException(JXTransformer.java:926)
...

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