RDF Paper Layout output showing different language(Greek) than required American English

Way-1 The charset property against the field was getting set to an erroneous value, it should have been 31, but was getting set to 371. Unfortunately you can’t see charset directly in Oracle Reports. The solution was to change the report to a REX format using rwcon60 alter the charset property of the offending fields and then convert it back to an RDF. I have searched on My Oracle Support but can’t find the article again (and Oracle blew away most of my favourites when we went across to MOS L. ). If it’s any help here’s the UNIX script we developed to fix the rdf our server. All references to ppsnli you will need change to your server. You need to put the file name as a parameter to the script name. e.g. if you save the script as FIXRDF run it as FIXRDF ================================================================================================================================================= #!/bin/sh ORACLE_HOME=/ppsnli/product/806 . $ORACLE_HOME/PPSNLI_auohspsnl08.env LD_LIBRARY_PATH=$ORACLE_HOME/jre11813/lib/i686/native_threads:$ORACLE_HOME/lib:$LD_LIBRARY_PATH REPORTS60_TMP=/tmp rwcon60 batch=yes stype=rdffile source=$1.rdf dtype=rexfile dest=$1.rex overwrite=yes rm -f dummy2.rex sed -e ‘s/CHARSET = 0/CHARSET = 31/’ -e ‘s/CHARSET = 781/CHARSET = 31/’ -e ‘s/CHARSET = 178/CHARSET = 31/’ -e ‘s/CHARSET = 871/CHARSET = 31/’ < $1.rex > dummy2.rex rwcon60 batch=yes overwrite=yes stype=rexfile source=dummy2.rex dtype=rdffile dest=$1.rdf rm dummy2.rex ================================================================================================================================================ Run the shell script by below command on linux ./FIXRDF.sh $MCLCUS_TOP/reports/US/MCCOSDMINV Run the shell script by below command on solaris sh FIXRDF.sh $MCLCUS_TOP/reports/US/MCCOSDMINV =======================Solari============Version================================================================================================ #!/bin/sh ORACLE_HOME=/oraapp/EBSSMOKE/apps/apps_st/appl . $ORACLE_HOME/APPSEBSSMOKE_ebststcm02.env # LD_LIBRARY_PATH=$ORACLE_HOME/jre11813/lib/i686/native_threads:$ORACLE_HOME/lib:$LD_LIBRARY_PATH REPORTS60_TMP=/tmp rwconverter batch=yes stype=rdffile source=$1.rdf dtype=rexfile dest=$1.rex overwrite=yes rm -f dummy2.rex sed -e 's/CHARSET = 0/CHARSET = 31/' -e 's/CHARSET = 781/CHARSET = 31/' -e 's/CHARSET = 178/CHARSET = 31/' -e 's/CHARSET = 871/CHARSET = 31/' < $1.rex > dummy2.rex rwconverter batch=yes overwrite=yes stype=rexfile source=dummy2.rex dtype=rdffile dest=$1.rdf rm dummy2.rex ============================================================================================================================================== Way-2 Certain fonts chosen in Report Builder on Windows have no mapping in UNIX and end up being set to 'Symbol' for whatever reason. Point in case is Fixedsys on Windows which maps to 'Symbol' on UNIX. The quick fix is to add the following section into uifont.ali file located: $ORACLE_HOME/guicommon/tk/admin/uifont.ali # Added PDF section below to cater for symbol fonts [ PDF ] Symbol = Arial This will ensure that any time a font is not mapped to anything in UNIX it will at least generate a legible font (Arial or whatever you choose). Note, only one mapping assignment should be declared. Ref: Symbol Characters ("Greek") Instead Of Expected Characters Are Displayed in Reports or Reports Parameter Form ( Doc ID 300416.1 ) PDF Concurrent Output Displays Unexpected Font After Upgrade To R12 from 11i ( Doc ID 1321874.1 ) ========================================================================================================================================

attachment details of any entity

SELECT fad.document_id, fad.entity_name, fad.pk1_value, fds.media_id, fds.file_name FROM fnd_attached_documents fad, per_objectives peo, fnd_documents fds --, fnd_lobs flb ,FND_DOCUMENTS_LONG_TEXT, FND_DOCUMENTS_SHORT_TEXT,FND_DOCUMENTS_LONG_RAW WHERE fad.pk1_value = TO_CHAR (peo.objective_id) AND fad.entity_name = 'PER_OBJECTIVES' AND fad.document_id = fds.document_id -- AND fds.media_id = flb.file_id AND ( TO_CHAR (peo.start_date, 'YYYY') = '2020' OR TO_CHAR (peo.target_date, 'YYYY') = '2020' );