4 Replies Latest reply: Apr 29, 2012 10:56 PM by Srini Chavali-Oracle RSS

    Bi Discoverer NLS_DATE_LANGUAGE to force English

    540301
      Hi Gurus,


      In our EBS R12.1.2 , we have 4 LNS Languages. If the users are viewing the Discoverer Reports in Preferred Language Spanish, we want to force the NLS_DATE_LANGUAGE=AMERICAN instead of NLS_DATE_LANGUAGE=SPANISH. Please help how it can be set to alway to be NLS_DATE_LANGUAGE=AMERICAN.


      Thanks for viewing.
      -Samar-
        • 1. Re: Bi Discoverer NLS_DATE_LANGUAGE to force English
          540301
          Issue which we are facing is once the users select the English, all the discoverer reports are running fine and URL has something like


          http://hostname:8000/discoverer/viewer?NLS_LANG=AMERICAN_AMERICA&NLS_DATE_FORMAT=DD-MON-RRRR&NLS_NUMERIC_CHARACTERS=.%2C&NLS_DATE_LANGUAGE=AMERICAN&NLS_SORT=BINARY&&VIEWER=&

          If the user select any other language for example Spanish, they getting error date format is not ok and URL looks like

          http://hostname:8000/discoverer/viewer?&NLS_LANG=SPANISH_AMERICA&NLS_DATE_FORMAT=DD-MON-RRRR&NLS_NUMERIC_CHARACTERS=.%2C&NLS_DATE_LANGUAGE=SPANISH&NLS_SORT=BINARY&&VIEWER=&

          Now if from the Spanish URL I just change the value of NLS_DATE_LANGUAGE=SPANISH to NLS_DATE_LANGUAGE=AMERICAN, reports start working fine. And it is resolving the issue.. How can I set at BI Discoverer Level or EBS level to always have the NLS_DATE_LANGUAGE=AMERICAN or if there is any other solution for the other languges.


          Appreciate the help.

          Thanks
          -Samar-
          • 2. Re: Bi Discoverer NLS_DATE_LANGUAGE to force English
            Srini Chavali-Oracle
            Have users set the Territory option in EBS Preferences ? If so, have them unset this option and try again

            HTH
            Srini
            • 3. Re: Bi Discoverer NLS_DATE_LANGUAGE to force English
              540301
              Hi Sirni,

              Do you mean that the Territory option in EBS perferences should be unset even Users select any non-American Lang ?

              Thanks
              -Samar-
              • 4. Re: Bi Discoverer NLS_DATE_LANGUAGE to force English
                Srini Chavali-Oracle
                I believe so - have one user set territory back to America and try the report - it should work. We faced a similar issue and setting it to America worked for us. You would have to determine what is the right solution in your case.

                HTH
                Srini