Note: This post relates to an issue which has been produced in Version 11.1.1.7.150120 for the purposes of this blog. It may not be present in previous…
Read more →Session variables are used in the OBIEE repository for (amongst other things) setting user context information for use in analytics and dashboards. These can…
Read more →As is common with stateless web-based applications, Oracle Application Express (APEX) utilizes an Optimistic locking mechanism when updating data via the built in Automatic…
Read more →One of the products Oracle are currently pushing very heavily is Oracle BI Cloud Service (BICS). BICS allows customers to leverage the features of…
Read more →Update – 22/08/2018 I have added a simple version of the Load Plan Monitor to GitHub (Available Here). Please provide any feedback via GitHub.…
Read more →One thing I find interesting to explore is the integration of different tools with Oracle which may not always be obvious. For example, take…
Read more →Having not done a great deal with Oracle 12c, I was quite excited today to see an adaptive execution plan arise from a very…
Read more →Selectively Enabling Fields or Descriptive Flexfields on a Query Only Form We have recently worked for a client who wanted a form within Oracle…
Read more →Generating Rows Automatically in Oracle Quite often there is a need to generate rows in SQL. Whether it be to generate a row for…
Read more →This post follows on from a previous post which describes how to seamlessly integrate your APEX and E-Business Suite environments – if you missed…
Read more →