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

I thought this worth talking about as I've been in discussions with a number of people recently around best practices for data types etc. The example in the discussion was the implementation of Descriptive Flex Views in Oracle E-Business Suite.


As a bit of background for those who may not be aware, some standard E-Business Suite tables contains a number of generic fields which a developer can utilize to hold their own custom fields. For example, here is a descriptive flexfield against the documents attachment table FND_ATTACHED_DOCUMENTS.

DFF Definition

You can see I've created a new attribute against which I can hold some custom information. When I save and "freeze" that, I get a notification that the flexfield has been generated.

Compiling Success

Last modified on Continue reading
Tagged in: E-Business Suite sql
in Technical 2302 1
Last modified on Continue reading
in Technical 2753 0

It is quite common for warehouse developers to customise standard processes to add additional fields. Ideally this is done by modifying the appropriate mapping(s) to pass the field through, regardless of the technology use (Informatica, ODI etc). However in some instances, generally due to the complexity of a particular mapping process, developers implement these updates using a Post Load Process (PLP). From a technical perspective this can be done a number of ways, i.e. using a mapping, SQL statement updates and so on. The focus of this blog is the latter; specifically one of the traps that a developer can fall into when doing do.

First let's assume we have a simple mapping process which populates a table WC_DEMO_F. For demo purposes I can create that table as follows.

Create Table wc_demo_f As 
  Select level row_wid,
         'Row ' || To_Char(level,'FM999999') demo_value,
         'N' x_two_multiple
    From Dual
  Connect By Level <= 1000000;
Last modified on Continue reading
in Technical 2515 0

The new major release of Oracle BI Enterprise Edition 12c is now available.

Lots of new enhancements in this long-awaited release that brings the tech stack bang up to date with 12c of Weblogic.  Also, the type of visual analytics that were previously only available as a Cloud offering are now available on-premise.


You are initially welcomed with the "classic home page",


Last modified on Continue reading
in Installation and Patches 2877 2

Good to see that BI Applications is now available.  Some quite interesting features with this release including Taleo support and an interesting looking Load Plan Diagnostics and Automatic Correction Facility.  We already implement "email alerts" to users should there be any issues in the ETL, but it's great to see some proactive detection facilities now appearing natively in the product.

Certified of course with Oracle BI EE as are the older 11.1.1.X releases which is increasingly important with the May 2016 end of correction support for the older codebase.

Last modified on Continue reading
in Installation and Patches 3100 0