PeopleSoft : Handling Special Character Issue in BI(XMLP) Publisher Reports

Some time BI Publisher report got error due to special character in xml file.To handle this we have to modify xml file.

We have to use <?xml version="1.0" encoding="iso-8859-1"?> instead of  <?xml version="1.0"?> it will allow report to run if data has some special characters.


If you are using rowset based xml generation use substitute function to replace the tag before writeline.

/* Create Sample XML File */
      &strXMLFile = &ObjRowsetXSD.getXMLData(&rs1, &StrXMLfilepath | &StrXMLfileNm | ".XSD");
      &strXMLFile = Substitute(&strXMLFile, "<?xml version=""1.0""?>", "<?xml version=""1.0"" encoding=""iso-8859-1""?>");
      &SampleXMLFile.WriteLine(&strXMLFile);



If you are generating XML directly in code then use

&XMLdoc = CreateXmlDoc("<?xml version='1.0' encoding=""iso-8859-1""?><ROOT/>");