This discussion is archived
7 Replies Latest reply: Aug 8, 2013 4:12 PM by Hussein Sawwan-Oracle RSS

DFF Attribute translation issue

Jai001 Newbie
Currently Being Moderated

Hi,

 

We have many DFF attributes that need Spanish and Portuguese translations.

We have scripted the changes using an Oracle standard API.  See example below which changes 'Travel Authorization' in American to 'autorização de viagem' in Spanish.

The script runs perfectly when run on SQL*Plus in Windows.  But when we run the script via SQL*Plus on the application server (Linux), the value appears as 'autoriza? de viagem'.  This issue appears in all cases where the special non-American characters are used.

 

This may be a character set issue on the server.  If there are any possible fixes / ideas, please share.  Thanks in Advance.

 

    EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE=Spanish';

 

    fnd_flex_dsc_api.modify_segment
    (p_appl_short_name  => l_appl_short_name,
     p_flexfield_name   => l_flexfield_name,
     p_context_code     => l_context_code,
     p_column_name      => l_app_column_name,
     p_lov_prompt       => 'autorização de viagem',
     p_window_prompt    => 'autorização de viagem');

  • 1. Re: DFF Attribute translation issue
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    Pl post details of exact OS, database and EBS versions, along with the database characterset, and the NLS_LANG settings when the scripts are run Windows and Linux.

     

    HTH
    Srini

  • 2. Re: DFF Attribute translation issue
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Did you source the application env file or the database env file before starting sqlplus on the server?

     

    What does "echo $NLS_LANG" return after sourcing each env file?

     

    What if you update the same from the application, can you reproduce the issue then (using English and Spanish interface)?

     

    Thanks,

    Hussein

  • 3. Re: DFF Attribute translation issue
    Jai001 Newbie
    Currently Being Moderated

    Reply to Srini:

     

    OS on DB node: SunOS gildv906 5.10 Generic_144488-09 sun4u sparc SUNW,SPARC-Enterprise

    OS on CM node: Linux gildv212.<company>.net 2.6.9-89.ELhugemem #1 SMP Mon Apr 20 10:45:44 EDT 2009 i686 i686 i386 GNU/Linux

    OS on application node : Linux gildv213.<company>.net 2.6.9-89.ELhugemem #1 SMP Mon Apr 20 10:45:44 EDT 2009 i686 i686 i386 GNU/Linux

    Script was run on application node.

     

    DB version: 11.2.0.3.0

     

    EBS Version: 12.1.2

     

    Characterset of the database

    NLS_CHARACTERSET                UTF8

    NLS_NCHAR_CHARACTERSET   AL16UTF16

     

    NLS_LANG set to Spanish as seen in the script (EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE=Spanish').  The same exact script is run on both Windows and Linux.

     

    Reply to Hussein:

     

    Did you source the application env file or the database env file before starting sqlplus on the server?

    >> Yes

     

    What does "echo $NLS_LANG" return after sourcing each env file?

    >> American_America.UTF8

     

    What if you update the same from the application, can you reproduce the issue then (using English and Spanish interface)?

    >> If I change my language preference to Spanish, log out/log back in, traverse to the DFF setup and update the description to the desired Spanish value, it saves it correctly with all the special characters and the values can be retrieved.

  • 4. Re: DFF Attribute translation issue
    Jai001 Newbie
    Currently Being Moderated

    Srini and Hussein/others:

     

    Any thoughts on my issue?

     

    Is there a way to change $NLS_LANG on the server?  what will be the right value for Spanish and Portuguese?

  • 5. Re: DFF Attribute translation issue
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Satish,

     

    Your characterset supports both languages and you don't need to change it.

     

    Please answer my previous questions about "echo $NLS_LANG" after sourcing the database env file and after sourcing the application env file. Also, please mention which env file did you source before starting sqlplus.

     

    Thanks,

    Hussein

  • 6. Re: DFF Attribute translation issue
    Jai001 Newbie
    Currently Being Moderated

    Hussein

     

    This change was run on the application server.  I do not have access to the database server.

     

    $ ls -ltr /u01/app/st2dev2/st2dev2appl/APPSORA.env

    -rw-r--r--  1 st2dev2 dba 1068 Jul  1 06:26 /u01/app/st2dev2/st2dev2appl/APPSORA.env

    $ . /u01/app/st2dev2/st2dev2appl/APPSORA.env

    $ echo $NLS_LANG

    American_America.UTF8

     

    Thanks

    Satish

  • 7. Re: DFF Attribute translation issue
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Hi Satish,

     

    Would it be possible to try from the database node and see if you can reproduce the issue?

     

    Meanwhile, from the same application node, can you please try the following (it may sound stupid to you, but give it a try please and see how it works):

     

    1. Source the application env file

     

    2. Issue the following:

     

    $ export NLS_LANG=SPANISH_SPAIN.UTF8

     

    Then start sqlplus and see if it makes a difference.

     

    Thanks,

    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points