Monday 6 April 2015

EBS : Arabic characters are appearing as "?" Question mark in the standard output of CCR

Solution:

Check ALBAN*.ttf files exists in the directory $OA_JRE_TOP/lib/fonts/
ls -l $OA_JRE_TOP/lib/fonts/ALBAN*.ttf

  1. If it doesnt exists 

  1.1 Copy it from the $FND_TOP/resource/ directory
 cp $FND_TOP/resource/ALBAN*.ttf $OA_JRE_TOP/lib/fonts/

  1.2 Restart the apache and the oc4j
          cd $ADMIN_SCRIPTS_HOME
         adapcctl.sh stop
          adoacorectl.sh stop
          adoacorectl.sh start
          adapcctl.sh start

  1.3 Retest the issue.

       Reference : PDF Reports Show Arabic Characters As Question Marks (Doc ID 1199013.1)

  2. If exists

     2.1 Login as SYSADMIN
     2.2 System Adminstrator --> Profile --> System
     2.3 Check the profile option "FND: NATIVE CLIENT ENCODING" is set to the database character set
    Check the database character set using the below query
    SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET';

No comments:

Post a Comment

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...