O SpecGold OracleBusIntApps7 clr



   Call us now 

  Manchester Office

  +44 (0) 8450 940 998




Welcome to the Beyond Blog

As you'd expect from the winners of the Specialized Partner of the Year: Business Analytics at the Oracle UKI Specialized Partner Awards 2014, Beyond work with leading edge BI Applications primarily within the UK Public Sector. We intend to share some of our ideas and discoveries via our blog and hopefully enrich the wider discussion surrounding Oracle Business Intelligence and driving improved insight for customers

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
    Login Login form

So a couple of weeks back I had a quite an exciting moment. Why? Well I downloaded myself an E-Business Suite R12.2.4 Vision virtual machine from Oracle E-Delivery.
After the initial pain of unzipping many gigabytes of zip files, concatenating chunks together etc and finally importing into virtual box, I finally got it up and running. This is the single-tier install and here are the specs of the virtual machine I am using:

Base Memory 7Gb
Processors 2
Network Host Only Network
Disk Drives USB External Drive

This is running on my laptop which is an Intel i7 with 16Gb RAM.

Post importing, after changing the default user passwords (which the system prompts you to do on login), I set up the machine to use a static IP address (note I had the adaptor set on a host-only network). To do this I simply executed /u01/install/scripts/ and as I was happy to re-use the existing domain ( I didn't have to do anything thereafter. Ensure you create an entry in your windows host file for for the static IP address you're using though.

Starting up the instance is done in two stages - the database and then the app.


The database starts up relatively quickly on my machine, however the app takes literally forever! This is part due to weblogic server now being used in the underpinning architecture, and of course partly because it's running on a humble laptop. It's literally a case of start it off, leave it running, and go and do something else for half an hour or so. You'll see it going through the various startup steps.

Startup Steps

Eventually (!) you should see everything is done. Once you've successfully started then you should be able to hit the login screen on, which as you can see looks a bit different to the R12 vanilla screen.

Last modified on Continue reading
Tagged in: E-Business Suite
in Technical 4197 4

Oracle BI Enterprise Edition 11g has been around for many years now and there are many people using versions.  This goes out of error correction support on the 14th May 2016, so something you want to be planning for if you're using that in production.  You've got a couple of interesting options though:

1) Upgrade to BI EE - yes there wasn't a version - which you can do as an "in-place" upgrade and you'll get a new version of BI EE with a few extra bits and pieces too, such as a new chart type and you can save measures, etc.

2) Upgrade to the latest 12c release.  If you're using BI Applications or onwards then this is supported for you too.  12c comes with a more "modern" look and feel - certainly if you've seen the cloud offerings it'll be familiar - but it's much more than a pretty face, there's a lot of back end changes that make environmental management easier.

Why wouldn't you go straight for 12c then?  Well, make sure you pay careful attention to the certification matrix to ensure that your infrastructure is upto date enough to support it and also read the full upgrade document so you know what you need to do before you embark.  You need to migrate BI Publisher too if you use it.

If you do have any specific questions then drop me a comment.

Last modified on Continue reading
in Installation and Patches 1950 2

Oracle Application Express (APEX) is increasingly being used to produce custom developments within Oracle E-Business Suite. I've posted previously about how to configure your custom applications to use E-Business Suite context for purposes such as foundation API's, MOAC security, profile values and such (using fnd_global.apps_initialize), however I've generally put in a note of warning that such techniques may not work with Human Resources Security. So here I will explain why that is, what you might be able to do to get around that. This assumes the Embedded PL/SQL Gateway (EPG) is being used.

First, let's recap how HR Security is implemented with E-Business Suite, taking People table as an example.
We have the base table per_all_people_f which is not secured (by VPD or otherwise). Built upon this are a set of secure views such as per_people_f which are queries from the base table however with a call to the API hr_security as follows.

per_people_f snippet

The key call in this code is to hr_security.show_person(...) which evaluates the users access to that person record based upon the security profile the user is currently using (the actual method for this depends on whether Cross Business Group security is in use).

Last modified on Continue reading
in Technical 4424 2

The latest Oracle BI EE 12c VM is now available for download.

Last modified on Continue reading
in Technical 3056 0

I recently needed to use the LISTAGG function in a custom Oracle ODI interface. However to my dismay I found that ODI didn't recognise LISTAGG as an aggregate function (i.e. didn't add a GROUP BY clause to the SQL generated).

No Group By

After a bit of searching on Google I found I wasn't the only person to have hit this and found this blog post which explains a method for adding the function to the language in the ODI topology. I tried and failed - no matter what I did I couldn't get it to work.
So instead I tried a little trick I have used in the past for something simlar - to add a commented out aggregate function in the column source.


Last modified on Continue reading
Tagged in: ODI
in Business Intelligence 6353 3