Background of textitems black or pink

8 July 2005 at 14:42 CEST | In 6i to 10g upgrade, Bugs and issues, Forms, Oracle |

We’ve been strugling with a Forms issue for quite a while now. We’ve converted about 300 forms from version 6i to 10g and found out that some of them use a very dark gray (almost black) or pink color as background for some textitems. It occurs for textitems that have no background color set. This shows as “Unspecified” in Forms Builder. When you initially start the Form all looks ok, but after opening and closing some other forms in the application the items suddenly change to this darkgray or pink color.

Quite a number of our Forms originated in SQL*Forms 3.0 and were converted to 4.5, 6i and now to 10g. As it turns out these have a different color pallete than the ones that were created in 6i straight away. It looks like Oracle changed their default color palette along the way. The old forms have exactly the same palette as is now available in the CDE1.PAL file still in the Developer Suite distribution.

I filed a TAR at MetaLink and that resulted in a new bug (4383847). As it turns out, Forms deployed over the web cannot cope with different color palettes in the same session. Oracle says it has something to do with Java restriction. The answer is that you should not use custom palettes. I tried to argue that my palettes aren’t custom but just the default ones of 10 years ago, but that didn’t help.

The steps to reproduce the issue are:

  • Start Forms Builder v9.0.4.1.0
  • Edit > Preferences
  • Set Color Mode to Editable
  • Restart Forms Builder
  • Save the new form (module1) under the name DEFAULT.FMB
  • In the Forms Object Navigator create a new Canvas
  • Also from the navigator, create a new Block (do not use wizard)
  • Set block property “Database Data Block” to No
  • Navigate to the Items node and press the green plus three times
  • Select all three new items and set the Canvas property to the created canvas
  • Set the Item Type of the second item to “Display Item”
  • Set the Item Type of the third item to “Push button”
  • Add a When-Button-Pressed trigger to the Push Button with the code call_form('cde1');
  • Open the layout editor
  • Shift the three items around to fix the overlap
  • Save the Form
  • Copy the DEFAULT.FMB to CDE1.FMB
  • Open the CDE1.FMB in Forms Builder
  • Change the Name property of the form to CDE1
  • Open the layout editor for this Form
  • Select Edit > Import > Color Palette
  • Browse to ORACLE_HOME\tools\common90 and import CDE1.PAL
  • Change the When-Button-Pressed trigger to call_form('default');
  • Save the Form
  • Compile both forms using Forms Builder
  • Start DEFAULT from Forms Builder
  • Notice the correct colors for the text item and display item
  • Press the button to start the CDE1 form
  • Notice the CDE1 form to open with pink items
  • Press the button to start the DEFAULT form
  • Notice the DEFAULT form now also opens with the pink items
  • Close your webbrowser and go back to Forms Builder
  • Now start the CDE1 form first
  • Again notice that the first form shows with the correct colors
  • Press the button to start the DEFAULT form
  • Notice the DEFAULT form opens with very dark gray (almost black) items
  • Press the button to start the CDE1 form
  • Notice the CDE1 form now also opens with the dark gray items

I already mentioned this problem in a previous blog posting about our Forms conversion. That raised some questions with people, so I decided to document it in this separate blog entry. Also in my quest for a solution to this problem I found several forum questions with the same behaviour of items changing to dark gray, black or pink. Hopefully this blog entry can be helpful to these people.

The only solution provided by Oracle was to manually import the default palette into each and every form. To us, that was not a workable solution. We’re planning on running Forms 6i client/server and WebForms 10g in parallel for a couple of months. Developers continue to work in 6i only and the Forms are converted to 10g when deploying. This means our conversion process has to be repeatable and manually importing a palette is not an option. Unfortunately the JDAPI does not support changing the palette, so we couldn’t automate it that way. The solution we choose was to use the JDAPI to set the background color property of all items where it is not set. I’m setting the background color to “r100g100b100″. In effect, this is just white but with a different name. This makes it possible to recognize the items that were changed by the JDAPI. Whenever Oracle fixes the palette-bug, I might decide to change these items back to Unspecified to get really transparent items. Now I’m having white items on a non-white canvas, which isn’t what the users ask for.

If you’re struggling with white background of readonly items (both textitems without modification rights and display items), please read note 305563.1 on MetaLink. It describes a applet parameter readOnlyBackground. You can set this to TRUE to force all read-only items to use the canvas color as background. A more usefull setting is AUTO which uses the canvas color as background for readonly items that do not have a specific background set. If a readonly item does have a background color set (e.g. a current record visual attribute) then that color is used when using AUTO.

Update 29-jul-2005: Also see this blog entry of Duncan Mills which describes changing the color palette of Forms and in his introduction mentions the issue with black-on-black items.

26 Comments

TrackBack URI

  1. A comment I got by email from a reader:

    Hi Wilfred,

    I reproduced the colour problem as per your description. That is using the default.fmb and cde1.fmb that use the default and cde1 colour palettes respectively.

    After that, I wondered would this still happen if I take the fmb file convert to xml and then back to fmb format. I was not able to reproduce it - that was good! I’m assuming when converting back to fmb from xml it would use the default colour palettte - since no palette information is stored in the xml file.

    So, I’m asking. Did you guys try this? Is this a viable solution? Is there anything lost by doing the fmb -> xml -> fmb conversion process?

    Would this also be possible with fmb -> fmt -> fmb conversion process?

    Comment by Wilfred — 18 July 2005 #

  2. We also found out that converting to XML and back resets the color palette. You can easily check by looking at the XML file itself. There is no information on color palettes in there. I’ve asked Oracle about this and this is a known bug. It will be fixed in a future version as converting to XML and back should retain all properties.

    The problem we had with XML conversion is that quite a number of our forms did not convert to XML (and back) without errors. This is why I did not follow this path any further.

    Converting a file to FMT and back does retain the color palette, so that’s also not a solution.

    For now, we have a workaround to set all items to r100g100b100 as described in this blog posting. I’ve been in contact with Oracle and they are planning palette features in JDAPI for a future release. It’s supposed to be logged as enhancement requests 1087437 and 2252171 but they are not published on MetaLink.

    Comment by Wilfred — 18 July 2005 #

  3. Hi Wifred. From your response, I have a couple of questions.

    1. Can you identify which palette(s) a Form is using? Either in Forms itself? or externally using a Unix grep?

    2. Can Forms store more than 1 palette per Form?

    3. What sort of errors did you receive doing the fmb->xml->fmb conversion process?

    Thanks,
    Armando Cabrera

    Comment by Armando Cabrera — 18 July 2005 #

  4. To identify the palette in Forms Builder, you first have to set the color mode to editable (see blog entry), restart Forms then go to the layout editor and select Edit > Layout options > Color Palette. This will show the palette and you can inspect all items in it for its name and color values.

    I don’t think the actual name of the palette is stored in the Forms itself, so that’s not something you can look for. You could convert the file to FMT and grep that file. But then you would still need to know what color names to grep for. This means you will have to identfy a name of a particular palette entry that is not in the default palette.

    To answer your second question: No. Forms will only store one palette per form. Each form can have its own palette, but from the response I got from Oracle support I understand you can have only one palette for your entire forms session when running on the web. This is supposed to have something to do with Java restictions.

    I got a whole bunch of different errors converting to XML and back. Since we were very close to the deadline I did not investigate any further. I saw a lot of bugfixes on the XML conversion in patchset 2 (v9.0.4.2.0) so I will have another look at it after the summer. By then I will also be implementing version control and that works much better with ASCII files. So, I will then again try to convert all files to XML before checking them into Subversion. If it still doesn’t work, I’ll go with FMT files.

    Comment by Wilfred — 18 July 2005 #

  5. Also see this blog entry of Duncan Mills which describes changing the color palette of Forms and in his introduction mentions the issue with black-on-black items.

    Comment by Wilfred — 29 July 2005 #

  6. Natural Herbalz Health care Products Reviews in Men’s and Women’s health, General and Sexual Health, Weight loss and Diet health, Skin care and Hair Care by http://www.naturalherbalz.com

    Comment by penis enlargement — 15 October 2008 #

  7. Provillus Review - Best hair loss, hair fall and hair regrowth products for men’s and women’s hair for stop losing hair and grow fast longer and shinning new hair by http://www.managehairloss.com

    Comment by Provillus — 29 October 2008 #

  8. Revitol products review, solutions and treatments on Revitol anti aging, Revitol acne treatments, Revitol cellulite problems, Revitol skin exfoliator, Revitol skin cleansing, Revitol anti wrinkles, Revitol stretch marks by http://www.revitolskincarez.com

    Comment by Revitol — 9 November 2008 #

  9. Acomplia (Zimulti / Rimonabant) is used in the treatment of obesity and related conditions. Acomplia (Rimonabant / Zimulti) is The new weight loss medication breakthrough from Sanofi-Aventis , exceeding Phentermine in it’s ability to help you lose the weight! It is a CB1 cannabinoid receptor antagonist ,and Its main avenue of effect is reduction in appetite by http://www.genericacomplia.biz

    Comment by Acomplia Rimonabant — 26 November 2008 #

  10. SEO PAKISTAN - SEARCH ENGINE OPTIMIZATION AND SEARCH ENGINE MARKETING SERVICES COMPANY IN PAKISTAN FOR LINK BUILDING AND SEARCH ENGINE RANKING. http://www.seoptimizerz.com

    Comment by SEO Pakistan — 26 November 2008 #

  11. Thanks for such an important articles about Anti Aging. This is a very needed because my friend sis is suffering from anti aging and i want to help her.
    so please guide me.
    Thanks

    Comment by Harry — 12 December 2008 #

  12. Acomplia (Rimonabant) is an appetite suppressant diet pill. Acomplia is used complementary to diet and exercise to treat obese or overweight patients who suffer from Type 2 diabetes and abnormal levels of fat in the blood. It can also prevent the risk of cardiovascular disease.  http://www.genericacomplia.co.uk

    Comment by Generic Acomplia — 12 December 2008 #

  13. Thanks for such an important articles about Anti Aging. This is a very needed because my friend sis is suffering from anti aging and i want to help her.
    so please guide me.

    Comment by Elena — 15 December 2008 #

  14. This is a informative post about Cellulite and there side effect.
    Thanks for sharing such an informative post with us.

    Comment by Elena — 16 December 2008 #

  15. It a nice site collecting all info about Cellulite.
    I want to know more about Cellulite because my friend is to much fat.so i want to know how can we less cellulite in our body.

    Comment by Britney — 17 December 2008 #

  16. This is a informative post about Cellulite and there side effect.
    Thanks for sharing such an informative post with us and also for time to post this post.
    Thanks

    Comment by Kelly — 18 December 2008 #

  17. Thanks for such an important articles about stretch marks. This is a very needed info about online stretch marks buying. :D

    Comment by Helan vilsion — 18 December 2008 #

  18. Thanks for providing information me such an important information about cellulite remover.
    I need this info for my friend.please guide me.
    Thanks

    Comment by Kettie — 18 December 2008 #

  19. Satisfied Man - Penis Enlargement Pills Work! Penis Enlargement USA has the highest rated Penis Enlargement Products Available at http://www.Naturalherbalz.com

    Comment by penis enlargement — 13 August 2009 #

  20. Hair Loss Treatments - Products Cures and Solutions Guide. Read the Hair Loss Guide - Know about Causes, Treatments, Solutions and hairstyles for Men and Women at http://www.Managehairloss.com

    Comment by Hair loss — 13 August 2009 #

  21. May be you guys says right but there is not of more things of we can do than we can do more batter than the this. http://www.cheaphostingwebsolution.com/

    Comment by Cheap Web Hosting — 14 August 2009 #

  22. hi every one .. I want to know some thing. Which is that how to increases our own website pr . My site is that http://www.penisenlargementy.com

    Comment by Natural Penis Enlargement — 14 August 2009 #

  23. Cheap Penis enlargement, Male enhancement, premature ejaculation and erectile dysfunction products and treatments at http://www.gordoniihoodia.net

    Comment by male enlargement — 3 September 2009 #

  24. Penis enlargement by Naturalherbalz will improve every aspect of your life immensely. As long as you make use of all the resources available to your through this site, your visit here will not be in vain. We offer you the best penis enlargement methods you can attain on the market today at http://www.Naturalherbalz.com

    Comment by Penis enlargement — 7 September 2009 #

  25. Permanent Penis Enlargement Pills stimulate development of the erectile chambers internally, allowing for a lot more blood to be held, thus giving a much longer and thicker erection. Male enhancement pills will not only increase the length and thickness of your erections but you’ll also experience longer lasting and rock hard erections with most decent enhancement products. This offers you permanent gains in length, girth, stamina and confidence. Most men these days if they are really honest would appreciate help in at least one of these areas; permanent penis enlargement pills will help them all!
    http://marketonlinehealth.com

    Comment by natural penis enlargement — 8 September 2009 #

  26. This is one of the best blog i have just seen, i am really feeling honor and pleasure that i am able to post my views here in this blog, a really appreciatable work done by webmaster of this blog. Going great man! keep it up. http://www.viagra-viagra.com

    Comment by Viva Viagra — 4 October 2009 #

Trackback/Pingbacks:

  1. OraTransplant Background of textitems black or pink | Cellulite Creams

    [...] OraTransplant Background of textitems black or pink Posted by root 6 minutes ago (http://www.oratransplant.nl) Comment by provillus 29 october 2008 revitol products review solutions and powered by wordpress with pool theme design by borja fernandez Discuss  |  Bury |  News | OraTransplant Background of textitems black or pink [...]

  2. Stop That Belly Fat

    Stop That Belly Fat... Diet......

  3. Anti Aging Facial Care | Free Resveratrol Miracle

    [...] background of textitems black or pink – we’ve been strugling with a forms issue for quite a while now. we’ve converted about 300 forms from version 6i to 10g and found out that some of them use a very dark gray (almost black) or pink color as background for some textitems. … [...]

Sorry, the comment form is closed at this time.

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds.