Optimistic Row Locking in Oracle Application Express (APEX)
As is common with stateless web-based applications, Oracle Application Express (APEX) utilizes an Optimistic locking mechanism when updating data via …
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.
Oracle BI Cloud Service (BICS) – Going Beyond SampleApp
One of the products Oracle are currently pushing very heavily is Oracle BI Cloud Service (BICS). BICS allows customers to …
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 …
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 …