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 30, 2022
Applies to:Oracle Product Master Data Management Integration Base Pack - Version 11.2 to 11.2 [Release 11.2]
Information in this document applies to any platform.
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
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
... 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
Publish the Product simply
from PIM to Siebel
3. Service SyncItemListPIMReqABCSImplProcess is triggered as part of the PIP and fails with the error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document