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   ...
Post a Comment
Read more

LDT Commands in Oracle Apps

 Oracle Applications (Oracle E-Business Suite) use Loader Data files (LDT files) for migrating application configurations and data between instances. What are LDT Files? LDT files are plain text files used by the FNDLOAD utility in Oracle E-Business Suite to upload or download data from the database. They are commonly used for migrating setups, such as concurrent programs, value sets, and lookups, across different environments. LDT Commands: 1.        Download Data to LDT File FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct output_file.ldt FND_PROGRAM APPLICATION_SHORT_NAME="Application_Short_Name" CONCURRENT_PROGRAM_NAME="Program_Name" 2.        Upload Data from LDT File FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct input_file.ldt Key Parameters apps/apps_pwd : The username and password for the Oracle Apps database. 0 Y...
Post a Comment
Read more

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...
Post a Comment
Read more