9 Replies Latest reply: Apr 26, 2011 12:04 AM by Hussein Sawwan-Oracle RSS

    French language is not coming in GL and AP responsibility

    817846
      We have recently added a new language [French] in one of our R12.1.1 envirorment.

      Now. once I change my language to french, from the system administrator responsibily I can open the forms which are in french language. I have checked that it is taking the file .../forms/F/*.fmx file.

      But, from GL or AP responsibility, once I open the form [Say journal entry screen], the english is coming, not french. Say, for jounal entry sceen it is using form
      apps/apps_st/appl/gl/12.0.0/forms/US/GLXJEENT.fmx.

      I have checked that there is a directory named "apps/apps_st/appl/gl/12.0.0/forms/F/" which contains several files but not GLXJEENT.fmx.

      In that scenario what can I do to resolve the issues.

      Please note that I have applied and followed all the steps for new language installation without facing any issues or fixed them totally once faced.
        • 1. Re: French language is not coming in GL and AP responsibility
          user12001639
          Su,

          Can you please check if GL and AP resp is visible in below table:-

          select * from FND_MENUS_TL;

          If not then please run Maintain multi-lingual tables using ADADMIN.

          Thanks,
          JD
          • 2. Re: French language is not coming in GL and AP responsibility
            817846
            I have checked this select * from FND_MENUS_TL WHERE user_menu_name LIKE 'AP_%'. The result is coming in both french and US language. the french and us values are equal also.
            • 3. Re: French language is not coming in GL and AP responsibility
              user12001639
              Hi,

              If you have not read it previously then please go through belwo metalink note:-

              Globalization Guide for Oracle Applications Release 12 [ID 393861.1]

              Check below part of note:-

              Regenerate Forms and Reports
              If the character set of any existing Forms (.fmx and .mmx) and Reports (.rdf) files is different from UTF8, those files must be re-generated in the UTF8 character set. Note that the Forms (.fmb and .mmb) files remain in the local language character set.

              In AD Administration, use the "Generate forms files, reports files, and graphics files" menu from the "Generate Applications Files Tasks" menu

              For more details, refer to the source document:

              For more details, refer to the source document Oracle Applications Maintenance Utilities (available at Oracle Applications Documentation)
              Chapter 4, "Maintenance", Section "AD Administration", Subsection "Generate form files, reports files, and graphics files"

              Thanks,
              JD
              • 4. Re: French language is not coming in GL and AP responsibility
                Hussein Sawwan-Oracle
                I have checked that there is a directory named "apps/apps_st/appl/gl/12.0.0/forms/F/" which contains several files but not GLXJEENT.fmx.
                When you open the form from the application, click on Help > About, does it show the correct path?
                In that scenario what can I do to resolve the issues.
                Have you tried to regenerate the forms via adadmin?
                Please note that I have applied and followed all the steps for new language installation without facing any issues or fixed them totally once faced.
                Please see if these docs help.

                How to resolve NLS translation issues in an Ebusiness Suite 11i and R12 environment [ID 394112.1]
                How To Get The Guidelines To Install or Add the new NLS Language on E-Business Suite 11i or R12 ? [ID 1254325.1]
                R12 System Administrator Menu is showing English values in any NLS language [ID 563008.1]
                NLS : Some Menus AP, GL, PA, FND In fresh R12.0.4 installation with additional languages are still in English [ID 749576.1]
                Oracle Applications NLS Release Notes, Release 12.1 [ID 788053.1]

                Thanks,
                Hussein
                • 5. Re: French language is not coming in GL and AP responsibility
                  817846
                  No, when I click help > about, it is showing the ....../US/*.fmx path.

                  I have followed all the above mentioned documents to add new language.

                  "Have you tried to regenerate the forms via adadmin?"
                  I am going to do this? but, does it create the french version of fmx also? french version of fmx is missing in ...../F/ directory.
                  • 6. Re: French language is not coming in GL and AP responsibility
                    user12001639
                    HI,

                    did you folllow from note i mentioned earlier( it will not harm you in anyway...pls give it a try..choose 'all' or french at prompt for language):-

                    Regenerate Forms and Reports
                    If the character set of any existing Forms (.fmx and .mmx) and Reports (.rdf) files is different from UTF8, those files must be re-generated in the UTF8 character set. Note that the Forms (.fmb and .mmb) files remain in the local language character set.

                    In AD Administration, use the "Generate forms files, reports files, and graphics files" menu from the "Generate Applications Files Tasks" menu

                    For more details, refer to the source document:

                    For more details, refer to the source document Oracle Applications Maintenance Utilities (available at Oracle Applications Documentation)
                    Chapter 4, "Maintenance", Section "AD Administration", Subsection "Generate form files, reports files, and graphics files"
                    • 7. Re: French language is not coming in GL and AP responsibility
                      Hussein Sawwan-Oracle
                      Su wrote:
                      No, when I click help > about, it is showing the ....../US/*.fmx path.
                      It should show French -- Are you logged in the French interface?
                      I have followed all the above mentioned documents to add new language.

                      "Have you tried to regenerate the forms via adadmin?"
                      I am going to do this? but, does it create the french version of fmx also? french version of fmx is missing in ...../F/ directory.
                      Yes, it will create the forms under the French directory.

                      Thanks,
                      Hussein
                      • 8. Re: French language is not coming in GL and AP responsibility
                        817846
                        Thank you very much hsawwan for your response.
                        I have regenerated the forms using adadmin. I got the error in the following way->

                        The following Oracle Forms objects did not generate successfully:

                        ap forms/F APXPAWKB.fmx
                        ap forms/F APXWCARD.fmx
                        ar forms/F ARXLOBOX.fmx
                        pa forms/F PAXCARVW.fmx
                        pa forms/F PAXINRVW.fmx
                        ap forms/F APXINWKB.fmx
                        per forms/F PERIEOBJ.fmx
                        per forms/F PERGBOBJ.fmx
                        pa forms/F PAXPREPR.fmx
                        per forms/F PERWSCEI.fmx
                        per forms/F PERWSEAD.fmx
                        per forms/F PERWSPED.fmx
                        per forms/F PERWSEPI.fmx
                        per forms/F PERWSEMA.fmx
                        pay forms/F PAYGBR45.fmx
                        pay forms/F PAYGBTAX.fmx
                        per forms/F PERWSHRG.fmx
                        ssp forms/F SSPWSENT.fmx
                        ben forms/F BENEDSGB.fmx
                        inv forms/F INVMATWB.fmx
                        inv forms/F INVSDOSI.fmx
                        inv forms/F INVSDOIO.fmx
                        inv forms/F INVTTGPM.fmx
                        inv forms/F INVIDITM.fmx
                        po forms/F POXDOCEC.fmx
                        bom forms/F BOMFDRSO.fmx
                        cs forms/F CSXSEDBT.fmx
                        jl forms/F JLBRPECI.fmx
                        ghr forms/F GHRWS52A.fmx
                        ghr forms/F GHRWS52L.fmx
                        cs forms/F CSXSRISR.fmx
                        oks forms/F OKSAUCVT.fmx
                        iex forms/F IEXWRIOF.fmx
                        jmf forms/F JMFGTWKB.fmx

                        Now, what can I do to resolve this issue?
                        • 9. Re: French language is not coming in GL and AP responsibility
                          Hussein Sawwan-Oracle
                          I have regenerated the forms using adadmin. I got the error in the following way->
                          Can you open other forms (which were generated successfully) from the French interface?
                          The following Oracle Forms objects did not generate successfully:

                          Now, what can I do to resolve this issue?
                          Compile the objects manually as per these docs to find out why those forms failed to generate (make sure you have no invalid objects in the database).

                          How do I Generate Forms in R11i or R12? [ID 742617.1]
                          How to Generate Form, Library and Menu for Oracle Applications [ID 130686.1]

                          Thanks,
                          Hussein