This discussion is archived
9 Replies Latest reply: Apr 25, 2011 10:04 PM by Hussein Sawwan-Oracle RSS

French language is not coming in GL and AP responsibility

817846 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

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