Junk Characters Appearing In Front Of Symbols When Letters Are Generated In Word (Doc ID 564276.1)

Last updated on FEBRUARY 08, 2015

Applies to:

Adverse Event Reporting System - Version 4.6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Feb-2015***

Symptoms

-- Problem Statement:
In AERS 4.6, after generating a letter from a PSP template file, the symbols like '®', '%' from letter
template are preceded by the character 'Â' in the letter opened in Microsoft Word.
The 'Â' character is not generated if letters are opened in HTML format inside a Web browser.
Also, the letters are opened up without any additional characters in Microsoft Word in AERS 4.5.

EXPECTED BEHAVIOR
When the generated letter is opened in Microsoft Word, the symbols '®', '%' should not be
preceded by 'Â' character.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Go to opapps46\aers\database\schema\is\psp\ location and open for edit an existing letter
    template (e.g. letter_initialletter.psp);
2. To open the generated letter with Word, add the following line at the very beginning of the
    letter template:
   <% owa_util.mime_header(ccontent_type => 'application/msword');
     owa_util.http_header_close; %>
3. Define vDrugName in Variable Declarations section:
    vDrugName de_suspect_drugs.drug_name%TYPE := null;
4. Add the following statements:
  <%
  for drugs in
  (select drug_name, preferred_name
  from de_suspect_drugs
  where de_suspect_drugs.case_id = p_caseid and primary_flag='Y'
  )
   loop
  vDrugName:= drugs.drug_name||'®('||lower(drugs.preferred_name)||')';
   end loop;
  %>
5. In the HTML body of the letter template, add a text containing a reference to the special
    symbol (e.g. ®):
    "Thank you for providing us with information regarding the adverse events that you experienced
      while using <%=vDrugName%>."
6. Save the template with the modification;
7. Reload the PSP template into the AERS database by executing the following command:
    loadpsp -replace -user <user>/<passwd>@<db_aers> <letter_template>.psp
8. Login to AERS as a user having permissions to generate letters (e.g. SUPERUSER);
9. From main menu select "Cases"/"Open case";
10. Select a case and click on Open button;
11. From main menu select "Actions"/"Generate Letter";
12. From "Select Template" window, click on "Initial Letters" and select "Initial letter";
13. Press "OK" button;


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms