This discussion is archived
13 Replies Latest reply: Feb 1, 2013 10:13 AM by aucp01 RSS

Missing buttons on our french Apex 4.2.1.00.08

aucp01 Newbie
Currently Being Moderated
Hello all,

We have recently installed Apex version 4.2.1.00.08.

Problem:
The english interface is all good but when we use the french version, a few buttons (if not all) are not displayed in the interface.

Example:
In english, under the "Home" tab, there is a button on the "Team Development" region title. This button calls the Preferences page.
In french, no button displayed.

Source code generated in english:
<div class="aRegionHeading">
<h1>Team Development</h1>
<span class="aButtonContainer">
<img src="/i/f_spacer.gif" class="settingsIcon" alt="Set Preferences for Team Development Metrics" />
</span>
</div>

Source code generated in french:
<div class="aRegionHeading">
<h1>Développement d'équipe</h1>
<span class="aButtonContainer">

</span>
</div>

Question:
Why the <a> tag is not generated ?

Thanks a lot for your time!

Patrice
  • 1. Re: Missing buttons on our french Apex 4.2.1.00.08
    jkallman Employee ACE
    Currently Being Moderated
    Hi Patrice,

    By chance, are you able to reproduce this in French on apex.oracle.com?

    Can you describe, a bit more about the missing button for Team Development Preferences? I'm having trouble identifying exactly which page you're referring to (my guess is 4500:1000).

    Joel
  • 2. Re: Missing buttons on our french Apex 4.2.1.00.08
    984486 Newbie
    Currently Being Moderated
    Hello Patrice,

    I installed APEX 4.2.1 to XE 11g-Database. When I switched to German language I think there is a similiar problem; no buttons displayed (SQL-Workshop=> create .... the buttons Cancel, Next, Add Colomn were not diplayed); in English it works fine. Is it in French the same?
  • 3. Re: Missing buttons on our french Apex 4.2.1.00.08
    aucp01 Newbie
    Currently Being Moderated
    Hello Joel,

    Thank you for your response.
    You are right, I do not have the problem in french (or even in German language - for user6314415) in apex.oracle.com.

    My problem is that in our installation we do not see the buttons when in french.
    For example in the SQL Command page of the SQL Workshop (page 1003), in french I see the icons for "Clear command" and "Find tables" but I do not see the Save and Run buttons. In french we should have the buttons "Enregistrer" and "Exécuter" but nothing is displayed.

    The html code related to these buttons is not generated in our page 1003 when we are in french. No problem in english.
    In apex.oracle.com, the source code of page 1003 contains code for the 2 buttons (in english and in french).

    The db side of the apex installation has been made by a DBA. She told me her installation is OK.
    On the app server side, I have deployed the apexListener 1.1.4 and i.war on WebLogic 10.3.5.
    This is on a lab environment, we are planning to migrate our Apex apps from 3.2.1.00.12 to 4.2.1.00.08 ASAP.

    Any idea on what is wrong with our installation ?
    Thank you.

    Patrice
  • 4. Re: Missing buttons on our french Apex 4.2.1.00.08
    jkallman Employee ACE
    Currently Being Moderated
    Hi Patrice,

    Sorry, but I really don't have any words of wisdom here. I can try and guess that this is a browser caching issue perhaps, but that doesn't really seem all that plausible. If it were a mere CSS style issue, then you would still at least see the HTML for the buttons in the page itself.

    Ultimately, I think this problem is best served by Oracle Support, as they will be able to gather much more information than you can share on the OTN forum. But just to satisfy my curiosity, can you connect as SYS and run the following SELECT statement and share the results here?
    select flow_id, button_name, button_image_alt from apex_040200.wwv_flow_step_buttons where flow_id = 4502 and flow_step_id = 1003.4502;
    Joel
  • 5. Re: Missing buttons on our french Apex 4.2.1.00.08
    FMignault Oracle ACE
    Currently Being Moderated
    Bonjour Patrice,


    Est-ce que vous avez bien chargé le français ?

    Vous devez faire un : ALTER SESSION SET CURRENT_SCHEMA = APEX_040200;

    avant d'exécuter le script load_fr.sql



    Francis.
  • 6. Re: Missing buttons on our french Apex 4.2.1.00.08
    aucp01 Newbie
    Currently Being Moderated
    Hi Joel,

    The output is as follows:

    FLOW_ID BUTTON_NAME BUTTON_IMAGE_ALT
    4502 RETURN Retour
    4502 CANCEL Annuler
    4502 SAVE Enregistrer
    4502 SAVE Enregistrer
    4502 RUN Exécuter


    ... and for my french helper ...

    Bonjour Francis,

    Oui, le ALTER SESSION a bien été exécuté par le DBA en charge de l'installation. Du reste, la très grande majorité de l'interface française est correcte. Il semble ne me manquer que quelques boutons et / ou images.

    Par exemple, sur la page d'accueil, le région "Team Development" présente une image / bouton à la droite du titre. Lorsque je bascule en français, il n'y a pas d'image. L'examen du code HTML de cette page montre en anglais la présence d'un span class=aButtonContainer. À l'intérieur des balises du span, un hyperlien est présent qui défini le IconButton. En français, rien de tel. L'intérieur du span est vide.

    Je crois que si je parviens à comprendre ce qui conditionne la génération de ce code, je saurai ce qui me manque.

    Un grand merci pour votre aide.


    - Patrice
  • 7. Re: Missing buttons on our french Apex 4.2.1.00.08
    SathishJS Explorer
    Currently Being Moderated
    Can you please run the following Query and see whether the values are in-sync, I tried with German, so your flow_id and flow_step_id will be different with respect to french

    select * from apex_040200.wwv_flow_step_buttons where flow_id = 4500 and flow_step_id = 1003 and button_name = 'RUN'
    union
    select * from apex_040200.wwv_flow_step_buttons where flow_id = 4503 and flow_step_id = 1003.4503 and button_name = 'RUN'

    if you see the button_plug_id is null then please try to update the button_plug_id with the value which you are getting from

    select button_plug_id from apex_040200.wwv_flow_step_buttons where flow_id = 4500 and flow_step_id = 1003 and button_name = 'RUN'

    In the meantime will investigate whether this is a bug and update you as well. Thanks for reporting this issue.

    Edited by: Sathish J S on Jan 18, 2013 5:24 AM
  • 8. Re: Missing buttons on our french Apex 4.2.1.00.08
    jkallman Employee ACE
    Currently Being Moderated
    Hi there,

    I have good news and bad news.

    The good news - I had no issues reproducing this. I installed Application Express 4.2.1 and also installed the French version. Sure enough, there are no buttons displayed in SQL Workshop.

    The bad news - this is a bug. I just filed Bug 16191354 for this issue. We need to investigate this further and determine what the appropriate fix will be. I guess the upside is that this only impacts SQL Workshop, but it also essentially renders SQL Workshop useless in any language other than English.

    I'll report back to this thread when we have an appropriate fix. My apologies for the disruption this has caused.

    Joel
  • 9. Re: Missing buttons on our french Apex 4.2.1.00.08
    aucp01 Newbie
    Currently Being Moderated
    Hello Sathish,

    I think you've found the problem.

    The following Query:

    select * from apex_040200.wwv_flow_step_buttons where flow_id = 4500 and flow_step_id = 1003 and button_name = 'RUN'
    union
    select * from apex_040200.wwv_flow_step_buttons where flow_id = 4502 and flow_step_id = 1003.4502 and button_name = 'RUN'

    gives us 2 rows, the french one having the button_plugin_id NULL.
    As soon as we've set the value of the button_plugin_id (french) to the value of the other row (english), the french button "Exécuter" displayed in the Apex page.

    So now we must understand why this value is initially set to NULL in our Database ?
    Is there some trace in the Apex installation process where we can see if something has been done the wrong way ?

    Many thanks for your help.

    - Patrice
  • 10. Re: Missing buttons on our french Apex 4.2.1.00.08
    jkallman Employee ACE
    Currently Being Moderated
    Hi Patrice,

    This is an identified bug (16191354) and we are working on a patch for this issue. Stay tuned.

    Joel
  • 11. Re: Missing buttons on our french Apex 4.2.1.00.08
    jkallman Employee ACE
    Currently Being Moderated
    Hi Patrice,

    There is now a patch set exception for Bug 16191354 available on My Oracle Support (http://support.oracle.com). You can search for it by bug number under "Patches and Updates".

    A few notes about this bug and bug fix:

    1) This only impacts customers who install APEX 4.2.1 anew. If you installed APEX 4.2 and applied the APEX 4.2.1 patch set, you would not encounter this problem.
    2) This only impacts the translated versions of SQL Workshop in APEX 4.2.1.
    3) If you choose to load another language later, you should run this patch script again. It is safe to re-run.

    Sorry for the troubles with this bug, and thanks again for reporting it.

    Joel
  • 12. Re: Missing buttons on our french Apex 4.2.1.00.08
    aucp01 Newbie
    Currently Being Moderated
    Thanks Joel,

    We'll try it soon and let you know if this solves our problem.

    - Patrice
  • 13. Re: Missing buttons on our french Apex 4.2.1.00.08
    aucp01 Newbie
    Currently Being Moderated
    Hello Joel,

    Sorry for the delay.

    Just to confirm everything is now OK. The patch works well for us.
    Many thank's for your time and support.

    - Patrice

Legend

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