بعض الزملاء واجهتهم مشاكل فى العربى و الفونت عند ادخال تقارير الى application و لهذا استخدموا طريقة xml و نجحت فهل هناك احد الزملاء يعرف كيف استطيع ان اضيف تقرير الى البرنامج بواسطه Xml هذا - الخوات
جراكم الله خيرا

SR Number 5207675.992 Open Date 05-MAR-06 12:14:00
Support Identifier 10602957 Name Riad Ashrey
Severity 2 Last Update 26-MAR-06 00:08:34
Product Business Intelligence Publisher Product Version 11.5.10.2
Platform AIX5L Based Systems (64-bit) Detailed Status Hard Close
SR Reference n/a BUG Reference n/a

Abstract

ARABIC APEAR ??? IN PDF FORMAT (XML PUBLISHER)


Resolution History


05-MAR-06 12:14:00 GMT


Can you easily recover from, bypass or work around the problem? = NO
Does your system or application continue normally after the problem occurs? =

YES
Are the standard features of the system or application still available; is the
loss of service minor? = NO

### Informational Only:Warning Presented to Customer ###
You chose 'Other technical issues with this product' from the Type of Problem
list. This is a generic TAR form which will require additional time to be
routed appropriately. You may be able to expedite the resolution of your TAR
by doing the following: 1. Use your browser’s back button to return to the
Create a TAR – Brief Description page. 2. Select an option from the Type of
Problem list that more closely describes the problem.

### Requested files:ACT(Note 183274.1),RDA (Note 175853.1). Files to be loaded.
Select One

### Detailed Problem Statement ###
We Use XML Publisher
we Create new report then create data defination and templete for this report
and upload Templete.
when we run this report with RTF format the output is good means no problem in
RTF Format beacuse arabic apear Arabic but
when we run the same report with the PDF Format All Arabic Text Apear ?????
What is the Problem?

### Steps to Reproduce Problem ###
We Use XML Publisher
we Create new report then create data defination and templete for this report
and upload Templete.
when we run this report with RTF format the output is good means no problem in
RTF Format beacuse arabic apear Arabic but
when we run the same report with the PDF Format All Arabic Text Apear ?????
What is the Problem?

### Instance Name(s) and Type of System(s) Where Error Occurs ###
Test

### Recent Changes to this Environment ###
No

### Workarounds Used ###
No

### How is this Issue Impacting Your Business ###
-

Contact me via : MetaLink


05-MAR-06 12:15:18 GMT


Allocation Type: Template Parse
Product ID: 1479.0 Component: UNKNOWN SubComponent:
Skill ID: 5503.0 Description: System Admin
Analyst Chosen: HNAWITO.EG
Level 3.
TAR General Flag set to: true

05-MAR-06 12:19:00 GMT

The customer : RIADASHREY : has uploaded the following file via MetaLink:D:\RIAD\XXARRCT\Report.pdf


05-MAR-06 12:20:03 GMT

The customer : RIADASHREY : has uploaded the following file via MetaLink:D:\RIAD\XXARRCT\report.rtf


05-MAR-06 12:21:01 GMT

New info : RIADASHREY :
Hi
The Output for PDF and Word Uploaded
Regards
Riad

05-MAR-06 12:30:01 GMT

The customer : RIADASHREY : has uploaded the following file via MetaLink:D:\RIAD\XXARRCT\XXARRCT.rtf


05-MAR-06 12:31:00 GMT

New info : RIADASHREY : Hi
This is the Template which I use
Regards
Riad

05-MAR-06 12:33:55 GMT

.
Hi Riad,

Thank you for using MetaLink. We are currently reviewing/researching the situation and will update the SR / call you as soon as we have relevant inf
ormation. Thank you for your patience.

Best Regards,
Hussein
Oracle Support Services

STATUS
=======

@WIP -- Work In Progress



05-MAR-06 12:34:00 GMT

Email Update button has been pressed: Sending email to [email protected].

05-MAR-06 13:46:24 GMT

.
ACTION PLAN
============
1. what is the version of XML PUBLISHER used?
2. Can you upload XML output generated from the report?
3. debug xml publisher using note:286962.1



05-MAR-06 13:46:33 GMT

Email Update button has been pressed: Sending email to [email protected].

05-MAR-06 13:46:42 GMT

Email Update button has been pressed: Sending email to [email protected].

05-MAR-06 13:59:01 GMT

The customer : RIADASHREY : has uploaded the following file via MetaLink:D:\RIAD\XXARRCT\output.pdf


05-MAR-06 14:00:01 GMT

The customer : RIADASHREY : has uploaded the following file via MetaLink:D:\RIAD\XXARRCT\output.rtf


05-MAR-06 14:02:02 GMT

New info : RIADASHREY :
Hi
1. what is the version of XML PUBLISHER used?
We user version 5.5

2. Can you upload XML output generated from the report?
I upload 2 files

Regards
Riad

05-MAR-06 14:04:49 GMT

.
UPDATE
=======
kindly, execute all steps in the action plain.The problem of PDF is realted to Font so kindly execute the rest of the action plain to check the
cause exactly.
I am requesting the XML data generated from the report no the output from the xml publisher.


05-MAR-06 14:04:57 GMT

Email Update button has been pressed: Sending email to [email protected].

06-MAR-06 07:54:04 GMT

New info : RIADASHREY :
Hi


we create a xdodebug.cfg file containing following two lines

LogLevel=STATEMENT
LogDir=/tmp/xdodebug.err

then

we Place the xdodebug.cfg under /lib directory.

we also set debug=Y
but no output created
why?

Riad


06-MAR-06 08:20:52 GMT

.
UPDATE
=======
did you restart the apps?


06-MAR-06 08:21:00 GMT

Email Update button has been pressed: Sending email to [email protected].

06-MAR-06 09:08:08 GMT

New info : RIADASHREY :
hi
Yes we restart apps
riad

06-MAR-06 11:46:02 GMT

.
UPDATE
=======
Did you created this file under <java.home>/lib?
The should have the following lines:
LogLevel=STATEMENT
LogDir=/tmp
restart apps


06-MAR-06 11:46:13 GMT

Email Update button has been pressed: Sending email to [email protected].

08-MAR-06 05:29:11 GMT

.
UPDATE
=======
Your problem is due to fonts used, So kindly run the XML publisher in debug mode to get your font directory setting and any other related issue
with character set.


08-MAR-06 05:29:20 GMT

Email Update button has been pressed: Sending email to [email protected].

08-MAR-06 11:30:05 GMT

New info : RIADASHREY :
Hi
We do all steps but no output log file created.

Riad


08-MAR-06 16:23:18 GMT

.
ACTION PLAN
============
1. First I need to varify that XML Publisher 5.5 installed at your apps do the following:
select BUG_NUMBER ,ARU_RELEASE_NAME from ad_bugs where BUG_NUMBER in
('4206181','4236958','3822219','3263588','4561451','3554612');
2. If it is applied do the following:
Please copy the files from $FND_TOP/resource to the /lib/fonts directory (under OA_JRE_TOP and JRE_TOP) on all W
eb and concurrent nodes . The font files are:
ALBANYWT.ttf - "single-byte" characters only
ALBANWTJ.ttf - Unicode font with Japanese Han Ideographs
ALBANWTK.ttf - Unicode font with Korean Han Ideographs
ALBANWTS.ttf - Unicode font with Simplified Chinese Han Ideographs
ALBANWTT.ttf - Unicode font with Traditional Chinese Han Ideographs
Please refer to the OracleMetaLink document 240862.1, Install Oracle Unicode Fonts for Dynamic Image Generation in Oracle Applications, f
or more details





08-MAR-06 16:23:29 GMT

Email Update button has been pressed: Sending email to [email protected].

11-MAR-06 06:50:01 GMT

New info : RIADASHREY :
Hi
when we run sql statment
SQL*Plus: Release 8.0.6.0.0 - Production on Sat Mar 11 09:47:04 2006

© Copyright 1999 Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL> select BUG_NUMBER ,ARU_RELEASE_NAME from ad_bugs where BUG_NUMBER in
2 ('4206181','4236958','3822219','3263588','4561451','3554612');

BUG_NUMBER ARU_RELEASE_NAME
------------------------------ ------------------------------
3263588 11i
3554612 11i
3822219 11i
4206181 11i
4236958 11i
4561451 11i

6 rows selected.

also
our DBA copy the files from $FND_TOP/resource to the /lib/fonts directory (under OA_JRE_TOP and JRE_TOP) on all Web and
concurrent nodes .
The font files are:
ALBANYWT.ttf - "single-byte" characters only
ALBANWTJ.ttf - Unicode font with Japanese Han Ideographs
ALBANWTK.ttf - Unicode font with Korean Han Ideographs
ALBANWTS.ttf - Unicode font with Simplified Chinese Han Ideographs
ALBANWTT.ttf - Unicode font with Traditional Chinese Han Ideographs
also we refer to the OracleMetaLink document 240862.1

But The arabic appear ??????????
Regards
Riad

11-MAR-06 07:26:01 GMT

The customer : RIADASHREY : has uploaded the following file via MetaLink:D:\RIAD\XXARRCT\debug.zip


11-MAR-06 07:27:01 GMT

New info : RIADASHREY :
Hi
we debug xml publisher using note:286962.1
we attached the zip file

Regards
Riad


11-MAR-06 11:40:06 GMT

.
UPDATE
=======
Hi Riad,

Your update has been received and progress will continue on this Service Request (SR) during the next business day.

Best Regards,
Hussein

STATUS
=======

@RVW -- Engineer to Review New Information



11-MAR-06 11:40:14 GMT

Email Update button has been pressed: Sending email to [email protected].

11-MAR-06 12:03:53 GMT

you need to use the XML publisher . this is not a very difficult task you can review the XML publisher guide from the documentation on how to convert your custom or standard report using the XML publisher