AIA 2.4: Customer Changes In Siebel Fail Sync To BRM (Doc ID 1286984.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Communications Integration Pack for Order to Billing - Version 2.4 to 2.4 [Release 2.4]
Information in this document applies to any platform.

Symptoms


When attempting to Process change of customer information. Change is made in Siebel and fails to make it to BRM.
the following error occurs.

ERROR
-----------------------
Process SyncAccountSiebelReqABCSImpl fails with the following error.

XPath expression failed to execute.
Error while processing xpath expression, the expression is "ora:processXSLT('ListOfSwicustomerpartyio_To_SyncCustomerPartyListEBM.xsl',bpws:getVariableData('InvokeSWICustomerPartyOutput','SWICustomerPartyQueryByExample_Output'),bpws:getVariableData('params'))", the reason is FOTY0001: type error.
Please verify the xpath query.



SyncAccountSiebelReqABCSImpl fails with the following messages (Extract only from oc4j log in opmn logs.)

...
<2010-11-18 10:30:23,087> <DEBUG> <default.collaxa.cube.xml> <BPELFunctionResolver::resolveFunction> Resolving function {http://schemas.oracle.com/xpath/extension}processXSLT arity 3 result com.collaxa.cube.xml.xpath.BPELXPathFunctionWrapper@1cfb807
<2010-11-18 10:30:23,087> <DEBUG> <default.collaxa.cube.xml> <BPELXPathExpressionFactory::create> Created xpath expr ora:processXSLT('ListOfSwicustomerpartyio_To_SyncCustomerPartyListEBM.xsl',bpws:getVariableData('InvokeSWICustomerPartyOutput','SWICustomerPartyQueryByExample_Output'),bpws:getVariableData('params'))  the expr object ora:processXSLT('ListOfSwicustomerpartyio_To_SyncCustomerPartyListEBM.xsl',bpws:getVariableData('InvokeSWICustomerPartyOutput','SWICustomerPartyQueryByExample_Output'),bpws:getVariableData('params'))
<2010-11-18 10:30:23,088> <DEBUG> <default.collaxa.cube.xml> <XPathUtil::getNamespaceContext> Namespace Context rootMap: {xp20=http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.Xpath20,  xacml=urn:oasis:names:tc:xacml:2.0:context:schema:cd:04, xsd=http://www.w3.org/2001/XMLSchema, abcsext=http://xmlns.oracle.com/ABCSImpl/Siebel/Core/SyncAccountSiebelReqABCSImplExtension/V1,  ora=http://schemas.oracle.com/xpath/extension, aiaerrhndl=http://xmlns.oracle.com/AIAAsyncErrorHandlingBPELProcess, corecom=http://xmlns.oracle.com/EnterpriseObjects/Core/Common/V2, ns1=http://www.siebel.com/xml/SWICustomerPartyIO, corecustebo=http://xmlns.oracle.com/EnterpriseObjects/Core/EBO/CustomerParty/V2,  bpelcommon=http://schemas.oracle.com/service/bpel/common, corecust=http://xmlns.oracle.com/EnterpriseServices/Core/CustomerParty/V2, orcl=http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc,  bpws=http://schemas.xmlsoap.org/ws/2003/03/business-process/, wsa=http://schemas.xmlsoap.org/ws/2003/03/addressing, ids=http://xmlns.oracle.com/bpel/services/IdentityService/xpath, ldap=http://schemas.oracle.com/xpath/extension/ldap, client=http://xmlns.oracle.com/ABCSImpl/Siebel/Core/SyncAccountSiebelReqABCSImpl/V1, aiautil=http://www.oracle.com/XSL/Transform/java/oracle.apps.aia.core.xpath.AIALocalizedStringUtils, xref=http://www.oracle.com/XSL/Transform/java/oracle.tip.xref.xpath.XRefXPathFunctions, aia=http://www.oracle.com/XSL/Transform/java/oracle.apps.aia.core.xpath.AIAFunctions,  hwf=http://xmlns.oracle.com/bpel/workflow/xpath, appcontserv=http://www.oracle.com/AIA/AppContextTransformService, ehdr=http://www.oracle.com/XSL/Transform/java/oracle.tip.esb.server.headers.ESBHeaderFunctions, sblaggrtbl=http://xmlns.oracle.com/pcbpel/adapter/db/top/SyncAcctSiebelAggrEventConsumer,  bpelx=http://schemas.oracle.com/bpel/extension, =http://schemas.xmlsoap.org/ws/2003/03/business-process/, sblqrycust=http://siebel.com/asi/V0}
scopedMap: {}
<2010-11-18 10:30:23,102> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Obtaining a list of files in the current directory
<2010-11-18 10:30:23,102> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Creating SFTP-based Managed Connection Using SFTPManagedConnection
<2010-11-18 10:30:23,103> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> SFTP Host: localhost
<2010-11-18 10:30:23,103> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> SFTP Post: 22
<2010-11-18 10:30:23,103> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> SFTP Username: aia
<2010-11-18 10:30:23,103> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Setting up SFTP connection
<2010-11-18 10:30:23,103> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Setting up the SFTP connection with Transport provider=[socket]
<2010-11-18 10:30:23,104> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> The  connection parameters are: Host: localhost Port: 22 UserName: aia Proxy  Host: Proxy Port: -1 Proxy UserName: Connection Type: socket HTTP User Agent: FileFTPAdapter Socks Local Lookup: false
<2010-11-18 10:30:23,104> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Trying to set up a password authenticated session using sockets:

XML-22000: (Error) Error while parsing XSL file (Namespace prefix 'sblcust' used but not declared.).
 javax.xml.transform.TransformerException: XML-22900: (Fatal Error) An internal error condition occurred.
 at oracle.xml.jaxp.JXTransformer.reportException(JXTransformer.java:881)
 at oracle.xml.jaxp.JXTransformer.transform(JXTransformer.java:477)
...
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NullPointerException
 at oracle.xml.xslt.XSLStylesheet.execute(XSLStylesheet.java:580)
 at oracle.xml.xslt.XSLProcessor.processXSL(XSLProcessor.java:322)
 at oracle.xml.jaxp.JXTransformer.transform(JXTransformer.java:460)
 ... 76 more900
---------
java.lang.NullPointerException
 at oracle.xml.xslt.XSLStylesheet.execute(XSLStylesheet.java:580)
 at oracle.xml.xslt.XSLProcessor.processXSL(XSLProcessor.java:322)
 at oracle.xml.jaxp.JXTransformer.transform(JXTransformer.java:460)
...
 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
 at java.lang.Thread.run(Thread.java:595)
10/11/18 10:30:23 javax.xml.xpath.XPathExpressionException: FOTY0001: type error
10/11/18 10:30:23  at oracle.xml.xpath.JXPathExpression.evaluate(JXPathExpression.java:222)
10/11/18 10:30:23  at com.collaxa.cube.xml.xpath.BPELXPathUtil.evaluate(BPELXPathUtil.java:189)
...

 

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