Delegated Proxy Access in E-Business Suite R12.2
I’ve posted a few things over the previous months regarding new or changed functionality in E-Business Suite R12.2, and here …
Relationship Issues
Relationship Issues No, this isn’t the latest agony aunt column – I’m talking about data relationships! Specifically, relationships between columns …
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 …