Special character problem in XML Publisher
XML publisher cannot generate report due to the presence of special characters in data fetched from EBS tables. NLS_CHARACTERSET parameter value in the instance is AL32UTF8. The special characters such as pound(£), apostrophe('), hyphen(-) etc. are coming as multibyte junk characters in generated XML.Please advise on how to resolve the issue. Is there a way to escape those characters?
2