Monitoring Oracle Data Integrator (ODI) Load Plan Executions with BI Apps
Update – 22/08/2018 I have added a simple version of the Load Plan Monitor to GitHub (Available Here). Please provide …
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.
Integrating external command line tools with Oracle data
One thing I find interesting to explore is the integration of different tools with Oracle which may not always be …
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 …
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 …