Error: Cannot view XML input using XSL style sheet
We are getting an error when trying to review report output in XML type text/XML
URL
http://server.domain:port/OA_CGI/FNDWRR.exe?temp_id=35619285
Error
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh
button, or try again later.
--------------------------------------------------------------------------------
An invalid character was found in text content. Error processing resource
'http://server.domain:port/OA_CGI/FNDWRR.ex...
CAUSE
Wrong setup for profile options "FND: NATIVE CLIENT ENCODING" which need to be set to "UTF8"
Check that setup is correct for this profile option at every level and not only at site level, because other level are overwriting Site level.
SOLUTION
Run the following sqlplus statement from sqlplus as the apps user to check that the profile is set as UTF8 at all levels:
SELECT po.user_profile_option_name, po.profile_option_name "NAME"
, DECODE (TO_CHAR (pov.level_id), '10001', 'SITE'
, '10002', 'APP', '10003', 'RESP', '10004', 'USER', '???') "LEV"
, DECODE (TO_CHAR (pov.level_id)
, '10001', '', '10002', app.application_short_name
, '10003', rsp.responsibility_key, '10004', usr.user_name, '???')
"CONTEXT"
, pov.profile_option_value "VALUE"
FROM fnd_profile_options_vl po, fnd_profile_option_values pov
, fnd_user usr, fnd_application app, fnd_responsibility rsp
WHERE (po.profile_option_name = 'FND_NATIVE_CLIENT_ENCODING')
AND pov.application_id = po.application_id AND pov.profile_option_id =
po.profile_option_id
AND usr.user_id(+) = pov.level_value AND rsp.application_id(+) =
pov.level_value_application_id
AND rsp.responsibility_id(+) = pov.level_value AND app.application_id(+)
= pov.level_value
ORDER BY "NAME", pov.level_id, "VALUE";
/
Post a Comment
Post a Comment