Date and Numeric fields into English for Arabic (XML Publisher)

How to display Date and Numeric fields into English for Arabic XML Publisher Reports

Please review the following for an understanding how both Arabic and English digits substitution can be use:

Oracle® Fusion Middleware
Report Designer's Guide for Oracle Business Intelligence Publisher
11g Release 1 (11.1.1)
http://docs.oracle.com/cd/E23943_01/bi.1111/e22254.pdf

10.9 FO Processing Properties

Bidi language digit substitution type
Default: None
Description: Valid values are "None" and "National".
When set to "None", Eastern European numbers are used.
When set to "National", Hindi format (Arabic-Indic digits)
is used. This setting is effective only when the locale is
Arabic, otherwise it is ignored.
Internal Name: digit-substitution



Further information can be found in:
( Doc ID 1097233.1 ) - BI Publisher Output Is Showing Hindi Numbers Instead Of Arabic Numbers
 

BI Publisher Output Is Showing Hindi Numbers Instead Of Arabic Numbers (Doc ID 1097233.1)

To Bottom

---

In this Document Symptoms   Cause   Solution   This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. Applies to: Oracle Application Object Library - Version 12.1.1 to 12.1.3 [Release 12.1] BI Publisher (formerly XML Publisher) - Version 5.6.3 to 5.6.3 [Release 5] Information in this document applies to any platform. Symptoms Output is a PDF output produced by XML Publisher 5.6.3 . When you run XML Publisher reports, it is resulting with hindi numbering instead of Arabic. Cause This is an issue with the setup of the Template or Data Definition of BI Publisher . Solution 1 - Please review your template in order to be sure you don't use the tag digit-substitution like : <?attribute@block:xdofo:digit-substitution;'hindi'?> 2 - Please query your Template in Bi Publisher then click on the Edit Configuration button  and : a)- Search for Bidi language digit substitution type b)- Set this property to none c)- Save d ) Please do the the same for your Data Definition . Then test by running a new Report.

( Doc ID 1412303.1 ) - E-BI/XMLP:English Numbers Shown In Arabic When BI/XML Publisher Reports Are Generated In Arabic 

E-BI/XMLP:English Numbers Shown In Arabic When BI/XML Publisher Reports Are Generated In Arabic (Doc ID 1412303.1)

To Bottom

---

In this Document Symptoms   Cause   Solution Applies to: PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later Information in this document applies to any platform. Symptoms On: PeopleTools 8.50 BI Publisher, (XML Publisher), ACTUAL BEHAVIOR --------------- When a PDF is generated through BI/XML Publisher for Arabic language, all numbers on the generated PDF file get converted to Arabic instead of getting generated in English. For other languages the numbers are generated in English. STEPS ----------------------- The issue can be reproduced with the following steps: 1. Open template and upload XML file 2. Preview in PDF from BI publisher viewer. 3. English numbers displayed in Arabic. Cause The issue is caused by the following known issue with the BI version 10.1.3.3 and lower. Bug:5985504 - NLS:ARABIC AND ENGLISH CONTENT WITH ARABIC AND ENGLISH NUMBERS/DATES. Solution Add <XSL:attribute ctx="block" name="xdofo:digit-substitution">none</xsl:attribute> in the form field for the numeric fields, before the data field tag. Note: This property can be set through the Report Definition properties or through the Global Properties. The property is in the "FO Processing" property group, and is called "digit-substitution" These need to be set to "None" to avoid the use of Arabic numeric digits when using Arabic locale. The property is only applicable when using Arabic locale.