Product Master Data Management (MDM) Process Integration Pack (PIP): Products With Special Character like “&” in Description OR Long Description fails to Sync to Siebel (Doc ID 2011768.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Product Master Data Management Integration Base Pack - Version 11.2 and later
Information in this document applies to any platform.

Symptoms

Application Integration Architecture (AIA)
Foundation Pack (FP) - 11.1.1.x (where x is >= 6)
Product MDM PIP 11.2 + Communications (Comms) PIP 11.3

Current Behavior:
While Syncing a Service Bundle which has Products Or a Simple Product Sync , in which the products Description or Long description has Special Character like (&) fails in Service SyncItemListPIMReqABCSImpl with following Error

ERROR:

...
An error occurs while processing the XPath expression; the expression is ora:processXSLT('xsl/XformSyncPriceListResponseEBMToPublicationServiceABM.xsl',bpws:getVariableData('syncPriceListListReqMsg','SyncPriceListListEBM'),bpws:getVariableData('PublicationXSLTParameters')).
The XPath expression failed to execute; the reason was: oracle.fabric.common.xml.xpath.XPathFunctionException: javax.xml.transform.TransformerException: oramds:/deployed-composites/default/SyncItemListPIMReqABCSImpl_rev1.0/xsl/XformSyncPriceListResponseEBMToPublicationServiceABM.xsl<Line 47, Column 136>: XML-22044: (Error) Extension function error: Error invoking 'parseEscapedXML':'oracle.xml.parser.v2.XMLParseException; lineNumber: 1; columnNumber: 12806; Expected name instead of .'.
Check the detailed root cause described in the exception message text and verify that the XPath query is correct.
...

Steps to Reproduce:
1. Create Products which have description and includes special Characters like & (ampersand)
2. Associate those products into Service Bundles and Publish the Service Bundle
   OR
   Publish the Product simply
    from PIM to Siebel    
3. Service SyncItemListPIMReqABCSImplProcess is triggered as part of the PIP and fails with the error  

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