Select Page

Let’s Talk About Stats (Baby…)

My upgrade of to has finally completed. HURRAH!


It only took 3 DAYS to run though, and I’m going to tell you why!

The upgrade process clearly states that, after the 4 repositories are created, you should refresh the statistics on your Oracle database. I duly went onto MOS and downloaded the latest statistics package from MOS Article 781927.1. I ran the package and sent the upgrade on it’s way.

Only… I downloaded and ran the WRONG package!

The MOS article includes two SQL scripts: coe_siebel_profile.sql and coe_siebel_stats.sql. You’ll notice that the stats script has a link name of “Siebel Stats updated May 2012”? That is coe_siebel_stats and that is the one you want to run.

Take it from me, this is a good lesson learnt – after re-building stats, having waited two days for the merge to complete, it finished within minutes!

Siebel / Installation Issues

A very quick update to keep you abreast of issues that I’m finding with the and updates.

I mentioned in an earlier post that List Applets weren’t working for me in and I’ve just found out why – the installation process tries to run a DDL Sync and fails. A kind reader, Benny, has pointed out that this is due to hardcoded tablespace names in the installation batch file. Manually running a Synchronise from Database Utilities resolved the issue.

I’ll maintain a list of issues below and update this post as I or others find new problems:

1List applets don't workAfter enabling OpenUI, list applets do not render correctly.Manually run a DDL Sync after the SIF import process
2List applets don't work in ChromeAccessing OpenUI through Chrome results in list applets failing to render correctly.Disable Ad-Block for the domain hosting the Siebel instance
3Screen Tab images missing in HI ClientAfter upgrade, the Screen Tab icons are missing in the High Interactivity clientAs per the 'Open UI Best Practice' document, you must unzip as per instructions

If you find any issues or solutions to issues listed, please post in the comments below and I’ll update the table above.

Siebel Public Sector – Siebel OpenUI

I’ve downloaded and installed and applied to my vanilla 8.2.2. Public Sector installation and it is looking AWESOME! I’m not seeing any of the problems that I saw with (List Applets not working) and it really does look like Siebel but in the 21st century!


One thing that I will note is that I could not get Siebel OpenUI to work with Chrome – I’m using version 23.0.1271.97 and it will not render List Applets correctly. IE 9 and Firefox 17.0.1 worked perfectly.

Here’s a screenshot of Siebel running on my Asus Transformer Prime, using the Android Chrome browser. Note the interesting page title, a spin off from when Siebel Public Sector was ‘Siebel Homeland Security’ – you might be familiar with the ‘HLS’ prefix of Publc Sector objects in tools:


Open UI on my Samsung S3, using the stock Android browser:


Just for the fun of it, here’s a screenshot of Siebel Public Sector in Firefox on a Linux Mint 10 installation:


Anyone else have any experiences with OpenUI that they’d like to share?

Siebel – Siebel OpenUI

Following on from yesterdays article, I thought I’d better add a quick update for those looking to deploy OpenUI on the 8.2.x platform.

Looking at Oracle eDelivery Cloud, the 8.2.x patch is incorrectly listed as – obviously downloading this will not give you the software that you need for the patch containing OpenUI. To get the appropriate patch you need to:

  1. Log in to My Oracle Support
  2. Click on ‘Patches and Updates’
  3. Click the ‘Product or Family (Advanced)’ link
  4. In ‘Product’ select ‘Siebel Industry Applications’
  5. In ‘Release’ select ‘Siebel CRM 8.2.2’
  6. Remove the platform filter
  7. Click ‘Search’
  8. If you then order by ‘Release’ you’ll see the appropriate patch set to download: 23016


I’ve had problems with OpenUI, installed on top of a vanilla installation – list applets are not working properly at all. I’m installing as we speak and will post my findings on the issues that I’m discovering.

Please feel free to add a comment to this or the previous article with your experiences of OpenUI and the and patch sets.

Siebel – Siebel OpenUI

Wow, can’t believe I missed this one! My good friend @lex over at the Siebel Essentials Blog has posted about the general availaibility of Siebel, which includes the long awaited Innovation Pack 2012 which itself includes Siebel Open UI!

[imagebrowser id=8]

Well, Christmas or not there’s no way I was going to miss out on this one! So, I downloaded and installed and here’s how it all went:


  1. Go to Oracle Delivery Cloud and sign in
  2. Select ‘Siebel CRM’ as the Product Pack and an appropriate platform. You’ll still, for some infuriating reason, find 8.1.1.x under 32-bit Windows and 8.2.2.x under 64-bit Windows. Very odd
  3. Download the 5 ZIP file components of the installation and unzip them all to a common folder
  4. Open up a command prompt, as administrator, and CD to the unzip folder
  5. Set the JAVA_HOME variable, if required. For example: set JAVA_HOME=”E:\Java\jre6″
  6. Run snic.bat
  7. Create a new image, patch set
  8. Go through the usual process of selecting desitnation, platform and components and pick one or more languages
  9. Though it looks like the JAVA process has frozen / crashed, it’s now unzipping the JAR files into appropriate installers


  1. Installation is the same as you would expect, if you have installed or 8.2.2. Check out my earlier article for some gotchas on the new installation process
  2. You’ll still get the stupid “you’re about to install into a non-empty directory” message. For a patch? Really?
  3. The patch process also takes ages. This, I suspect, is because the installer recognises it’s own instability and does a ‘backup’ (i.e. OS level folder copy) of the entire SIA / SEA folder before it does anything. I still think Oracle have taken a huge step backwards with the clunky and unreliable installer
  4. Once you’ve installed Enterprise, Web Server, Web Client and Tools (very important!) you’re ready for the next step

Enable Open UI

  1. First up, you won’t find the instructions for enabling OpenUI in the patch documentation. Instead, refer to MOS article 1499842.1 for a Deployment Guide for Open UI
  2. Unzip ‘’ from within the Siebel Tools REPPATCH folder. Here you’ll find instructions on what projects to lock and a .BAT file to import all the appropriate SIFs to enable OpenUI
  3. Lock the projects, create the new Reports project then edit the preferences file appropriately – it’s all documented in the instructions
  4. Run the import batch file and check the result in the Notifactions\Log folder. I chose ‘Import All Packages’ to save time. This seemed to work perfectly first time though it took forever as each SIF is imported individually, using a new Siebel Tools process
  5. Perform a full compile of the SRF and deploy to your server environment
  6. Now you have two choices – clone an existing OM (recommended) or update an existing one to use OpenUI in place of HI. I went for cloning as, though it’s more involved, it allows me to access and compare my existing HI OM
  7. Personally, I used the server manager scripts that were generated from the mergecfg.exe tool to create the OM. I first created a new OM component then used the scripts to update the partameters to match those of the existing Sales (SSE) OM component
  8. In the parameters for the new OM, set the new ‘EnableOpenUI’ paramter to ‘True’
  9. In IIS, create a new Virtual Directory for your new OM and create appropriate entries in eapps.cfg to point to it. I called my OM ‘SSEOUIObjMgr_enu’ and the Virtual Directory and eapps entry ‘sales_openui_enu’. You can use the editmetabase.exe tool in the SWE bin folder to do this (metabaseedit.exe sales_openui_enu E:\sba81\SWEApp\BIN\ENU\eapps.mtb)
  10. Restart everything, just to be sure

Now, navigate to your new OpenUI enhanced Siebel application and note that big red INTERAL Oracle warning sign! For internal use only? Perhaps QA should have removed that before making the software freely available for download!

I’ll obviously have a lot more on Open UI later on in the new year but until then, enjoy and have a Very Merry Christmas!