Combining Facts/Subject Areas in Oracle OBIEE – Part 2
A while back I wrote a post about how to combine measures from different facts in an OBIEE analysis. If …
Conditionally Disabling Descriptive FlexField (DFF) Segments in E-Business Suite
There have been quite a few posts on the Oracle OTN Forums E-Business Suite space recently with people asking some …
Combining Facts/Subject Areas in Oracle OBIEE
I wanted to write this as an introduction to combining data from multiple facts/subject areas into a single analytic. The …
Table configuration in E-Business Suite R12.2 to support Online Patching
With a lot of E-Business Suite customers looking to upgrade to R12.2.x within the near future (if they haven’t already), …
A quick look into E-Business Suite R12.2.4 Vision
So a couple of weeks back I had a quite an exciting moment. Why? Well I downloaded myself an E-Business …
Querying HR Secured Views in Oracle Application Express
Oracle Application Express (APEX) is increasingly being used to produce custom developments within Oracle E-Business Suite. I’ve posted previously about …
Using LISTAGG and other meta columns in ODI interfaces
I recently needed to use the LISTAGG function in a custom Oracle ODI interface. However to my dismay I found …
(Mis)using the WITH clause in Oracle
The WITH clause (or subquery factoring clause) is a very useful construct. It allows us to materialize the results of …
Predicate Evaluation Order – Using Generic Fields
I thought this worth talking about as I’ve been in discussions with a number of people recently around best practices …
Post Load Processes – Don’t Neglect Your Statistics!
It is quite common for warehouse developers to customise standard processes to add additional fields. Ideally this is done by …