Oracle Application Express (APEX) 4.0.2 patch is now available on MySupport and a re-release is available on OTN as of last Friday November 19th, 2010. You can read all about Oracle APEX 4.0.2 here. In addition to fixing 111 bugs (thanks to all who made the time and effort to report these), APEX 4.0.2 also introduces two new themes, theme 21 and theme 22.
I have been using theme 21 to build a number of internal applications here at Oracle. I am a big fan of the new theme, for me it feels modern, renders fast, and has lots of nice templates. I like the button templates, specifically the opportunity to choose a "hot" button to highlight one button over others. I also like the new horizontal progress train (list template), which works very well for wizards. Interactive reports have also been attractively styled. Theme 21 is red (red tabs in gray top bar, red and gray buttons), and for those who don't want a red theme, theme 22 is the same but in blue (blue tabs in gray top bar with yellow and gray buttons). These new themes are xhtml1-strict so don't use them if you want any IE 6 compatibility.
A large number of improvements have also been made to existing themes. To take advantage of the improvements to themes 1-20 you will need to recreate your themes. If you have significantly customized your version of theme 1-20 you will want to reintegrate your customizations, or simply not upgrade your theme. To switch a theme, navigate to share components, then themes, renumber your theme (see task on right side bar), create a new theme, then switch your theme.
I hope everyone enjoys the new themes as much as I do.