Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ARABIC font in Report 12c PDF output error ?????????

hassan mohamedMar 24 2019 — edited Apr 8 2019

Comments

Dan Andro-Oracle

Hi,

Please upload the pdf output.

Regards,

Dan

hassan mohamed

thanx dan

aa.jpg

Dan Andro-Oracle

Hello,

Can you provide the actual pdf output? I need to check if PDF subsetting is implemented or not.

Regards,

Dan

Dan Andro-Oracle

Hi,

PDF Subsetting is not enabled. make sure C:\Windows\fonts is present in REPORTS_PATH. Edit uifont.ali from DOMAIN_HOME\config\fmwconfig\components\ReportsToolsComponent\<reports_tools_name>\tools\common and at the end add

*="tahoma.ttf"

Copy this uifont.ali file to ORACLE_HOME/tools/common

Restart WLS_REPORTS and the reports server and retest.

Regards,

Dan

hassan mohamed

hi Dan

i do all but same

Hi

Please Try setting the Oracle Arabic Report - if no changes occurred then i have questions for you

Does your data stored in the db as the same?

Do you enabled Arabic languages before or after db installation ?

what is output of the following query

SELECT parameter , value

     FROM NLS_DATABASE_PARAMETERS

    WHERE parameter like ‘%CHARACTERSET%';

This blog helps in recognizing and solving the ??? problem

Amatu Allah

hassan mohamed

slam alikm Amatu Allah

arbic lang  in db is  right accurate

i set lang before db

qury is error

ORA-00911: invalid character

00911. 00000 -  "invalid character"

*Cause:    identifiers may not start with any ASCII character other than

           letters and numbers.  $#_ are also allowed after the first

           character.  Identifiers enclosed by doublequotes may contain

           any character other than a doublequote.  Alternative quotes

           (q'#...#') cannot use spaces, tabs, or carriage returns as

           delimiters.  For all other contexts, consult the SQL Language

           Reference Manual.

*Action:

Error at Line: 7 Column: 26

Please make sure you are connected to system or sys then give us a print screen from the query output.

I would like to make sure you correctly write it.

Amatu Allah.

hassan mohamed

slam alekom Neveen

NLS_CHARACTERSET AR8MSWIN1256

Amatu Allah Neveen Ebrahim

hassan mohamed wrote:

slam alekom Neveen

NLS_CHARACTERSET AR8MSWIN1256

Please read the blog quite well i covered all the possible problems out of my experience.

e.g. make sure you are having the same Arabic character set for both server and forms and if the data was saved in ??? or any improper characters it can't be recovered. Only the new inserted and saved records are the measurement that your problem is solved not the old data it can't be recovered. For now, I think you have to check the NLS_LANG of the client side

1.     Client Side:

Create a New User environment Variable named 'NLS_LANG'  give it the following value and save it: AMERICAN_AMERICA.AR8MSWIN1256

hassan mohamed

do all but same

Dan Andro-Oracle

Hi,

Open the PDF, type CTRL+D, co to the Fonts section and upload a printscreen with the output.

Regards,

Dan

User_W4MZZ

Salam alikom i ve the same probleme on my report 12c with the arabic caractère did u please found the solution if yes help me thkx

1 - 15

Post Details

Added on Mar 24 2019
15 comments
4,218 views