Oracle 12c – Adaptive Execution Plans
Having not done a great deal with Oracle 12c, I was quite excited today to see an adaptive execution plan …
Category: 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.
Selectively Enabling Fields/Flexfields on a Query Only Oracle Form Using Personalizations
Selectively Enabling Fields or Descriptive Flexfields on a Query Only Form We have recently worked for a client who wanted …
Generating Rows Automatically in Oracle
Generating Rows Automatically in Oracle Quite often there is a need to generate rows in SQL. Whether it be to …
Best Practices – Extending E-Business Suite with Oracle Application Express (APEX)
This post follows on from a previous post which describes how to seamlessly integrate your APEX and E-Business Suite environments …
Extending E-Business Suite with Oracle Application Express (APEX)
Traditionally E-Business Suite projects have consisted of a number of technologies – Oracle Forms, OAF, Reports, XMLP, SQL*PLUS and so …
SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions – Part 2
If you missed part 1 then you can find it here. In this post I’ll be focussing on a somewhat common …
Prune Days on an E-Business Suite Source Environment
Prune days… often misunderstood, often just left “as default”. Possibly not helped by the fact that entering the search term …
Star Transformations with Bitmap Indexes
One area of data warehousing that often confuses people (typically those who have come from an OLTP development background) is …
SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions – Part 1
I wasn’t too sure of what title to use for this blog post. I wanted to share some things that …
Aggregation Based on Dimensions in OBIEE
The Business Model in OBIEE allows for measures to be aggregated using a variety of different functions. For most scenarios …