Blogging About Oracle Applications

Integration Hub – Branding

The Integration Hub has come a long way since I first saw it as the Enterprise Portal 8.8. The biggest selling point in my opinion has always been the branding features. Even though the options never really changed, they did evolve from doing most of the work at the back end (Application Designer) and tying it together from the front end.

The Branding Center lets you do most of your changes online. Thus not needing a Branding Administrator to have access to Application Designer. A real plus, because a web designer without in depth PeopleSoft knowledge could in theory go through the system quite quickly and change it into something beautiful for a company.

However, as always, there has to be a caveat:

You can only select PeopleSoft stylesheets when assembling
themes, configuring headers, configuring footers, and setting
menu overrides


In other words: the biggest impact you can put on a website, coloring, placement, alignment, sizing, is still dependent on going into Application Designer and putting in our own objects. Which is strange, since you can add Stylesheets online via PeopleTools > PortalBrandingBranding Objects. At this component you can for example also add images, which in turn can be used to make your own custom header.

Seems like it should not be that much work for Oracle to switch everything to online Branding. I for one am hoping it will come with one of the next releases or patches.

Customize OBIEE login page

A login window never really meets requirements (or they are just plain ugly to look at). The typical PeopleSoft login window is one of them, all the languages you will never install is the most heard remark by (super)users.

Another one of those login windows is the one from OBIEE. In itself it doesn’t look bad at all. And in my own opinion, the language selection is a nice option, it’s just annoying it will always default it back to the system default when you try to log back in the next time. The main issue with login windows however is the lack of disclaimer space. You would think system builders put in an option for system administrators to add a simple text to do something like that, but alas, no dice.

Luckily it’s almost never impossible to do it anyway. For OBIEE you need to follow a few steps:

Change Language Selection

  1. Login to your server and navigate to the following location:
  2. Open the file instanceconfig.xml and locate </ServerInstance> at the bottom of the file
  3. Above this tag you add the tag <Localization>
  4. Within this tag you have a couple of options:AllowedLanguages allow you to configure a limited set of languages your user can choose from on the login page; examples of entries are en or nlAllowedLocales does pretty much the same, but then for allowed locales; examples of entries are en-gb or en-us
  5. When you added what you wanted, save the file and restart the presentation services through Enterprise Manager

Complete example of instanceconfig.xml


<!– To configure a limited set of languages to be available to users uncomment the <AllowedLanguages> tag below and choose a subset set of language tags from the list. Values must be comma separated. –>


<!– To configure a limited set of locales to be available to users uncomment the <AllowedLocales> tag below and choose a subset set of locale tags from the list. Values must be comma separated. –>



Create Custom Messages

  1. Login to your server and navigate to {MWHOME}/instances/{DOMAINNAME}/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/msgdb
  2. Create a folder called customMessages. The system is case sensitive on this part, so make sure you name it exactly as shown
  3. Create a subfolder called l_en. If you need more languages, you can create them with the same naming convention, for example l_nl or l_de. When you’ve allowed for more languages to choose from on the login page, the different languages will be loaded from these folders
  4. Navigate into the l_en folder and create the file customMessages.xml
  5. Edit the file and put something like the following code:

    <?xml version=”1.0″ encoding=”utf-8″?><WebMessageTables xmlns:sawm=”″

    xmlns:sawr=”″ sawm:systemMessages=”false”>

    <WebMessageTable lang=”en-us” system=”CommonUITemplates” table=”Messages”>

    <WebMessage name=”kuiHelpTOCCustomLinks”>


    ,’OTBI Help':’http:///{MWHOME}/Oracle_BI1/otbi/help/OTBI_User_Help/launch.html’



    <WebMessage name=”kmsgYourCustomMessageName“>


    Your custom message





  6. Save the file
  7. Navigate to {MWHOME}/Oracle_BI1/bifoundation/web/msgdb/pages/common
  8. Edit the file signin.html to add the custom message
  9. Place the html code wherever you want, the following will suffice to get the text loaded:
    <sawm:messageRef name=”kmsgYourCustomMessageName”/>Styling and placement is up to you
  10. Save the file and reload the presentation services through Enterprise Manager

Oracle Applications and BI

With the introduction of Fusion Applications a while back now, Business Intelligence has been pushed into the applications stream by Oracle. The wow factor for most of the Fusion Applications package comes with the ability to do a lot of analysing. The question is, did Oracle pull a rabbit out of its hat or was this a lingering ability by the company that has never been in sight of the group of Oracle Applications users?

Continue reading