7 Replies Latest reply: Aug 8, 2013 6:12 PM by Hussein Sawwan-Oracle RSS

    DFF Attribute translation issue

    Jai001

      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

          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

            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

              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

                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

                  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

                    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

                      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