Skip to main content

Data With Arabic Characters In XML Format


Issue:


"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://4i.test.com:8000/OA_CGI/FNDWRR..."
In the source code of the XML (View > Source) for the Arabic characters you found the following junk characters :
"<FILE_DATA>¿¿¿ ¿¿ ¿¿ ¿¿ ¿¿
¿¿¿¿¿·¿¿¿¿¿¿¿¿
¿¿¿¿¿¿¿
¿¿¿¿
¿¿¿¿
¿¿¿¿
¿¿¿¿¿
¿¿¿¿ </FILE_DATA>"
which can not be interpreted by XML parser.



Solution:


The issue will be resolved with the following settings:
1. Uncheck the "Allow Native Client Encoding" from the System Administrator > Install > Viewer Options  for the XML text/xml mime type
2. Set the profile option  "FND:Native Client Encoding" to WE8MSWIN1252.
3. Change the prolog value to
<?xml version="1.0" encoding="ISO-8859-6"?>  in rdf report.



Reference: 


Show Text Type Attachment Data With Chinese Characters In XML Format (Doc ID 427886.1)


Comments

Post a Comment

Popular posts from this blog

API to Create & Update Price Adjustment and Order Lines

Important Tables: select header_id from oe_order_headers_all; select line_id from oe_order_lines_all; select list_header_id from qp_list_headers_all; select list_line_id from qp_list_lines; CREATE OR REPLACE PROCEDURE apps.xxapply_discount (p_header_id number) IS    v_api_version_number           number := 1;    v_return_status                varchar2 (2000);    v_msg_count                    number;    v_msg_data                     varchar2 (2000);    -- in variables --    v_header_rec                   oe_order_pub.header_rec_type;    v_line_tbl                     oe_order_pub.line_tbl_type;    v_action_request_tbl   ...

Uninvoiced Receipts Query Oracle r12

Uninvoiced Receipts: SELECT   pha.segment1 po_number,          TO_CHAR (pha.creation_date, 'DD-MON-RRRR') po_date,          (SELECT   vendor_name             FROM   ap_suppliers ap            WHERE   ap.vendor_id = pha.vendor_id)             supplier_name,          pla.quantity,          pla.unit_price,          pla.quantity * pla.unit_price AS line_amount,          (SELECT   concatenated_segments             FROM   gl_code_combinations_kfv gcc            WHERE   gcc.code_combination_id = pda.code_combination_id)             charge_account,          rsh...