Welcome to the Beyond Blog

Beyond 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


Using REST to access Oracle APEX Cloud data in R

A while back I wrote a blog post on The Power of R, and I want to extend that a little now by looking at how easy it is to source data from an APEX Cloud instance directly into a R program. To give a bit of background on this, for the past few weeks I've been looking after 5 baby rabbits that were rescued by our friend who is a vet. We had to weigh...
Continue reading
  344 Hits
  0 Comments
344 Hits
0 Comments

Architectural Considerations for Integrating Oracle APEX Applications with E-Business Suite

Traditionally the development strategy for customisations within an organisation using Oracle E-Business Suite has been roughly the following. Data Entry - OA Framework or Oracle Forms Transactional Reporting - Oracle XMLP or Oracle Reports, FSG's Ad/Hoc and Analytic - OBIEE or Discoverer More and more organisations are now realising however the po...
Continue reading
  317 Hits
  0 Comments
317 Hits
0 Comments

Oracle APEX Exploitation - Part 4

It's been a while since I wrote the first few posts on APEX exploits, so I'm going to briefly discuss an attack that is very widespread and potentially dangerous. SQL Injection In very brief terms, SQL injection involves an attacker causing the server to execute SQL code that it was not intending to, by passing that SQL into a vulnerable statement....
Continue reading
  802 Hits
  0 Comments
802 Hits
0 Comments

Automating Oracle APEX Backups with Subversion

I know there are already a good number of blogs/guides out there already describing various methods of automating the backup of APEX applications, however I thought I'd share the method I recently implemented internally as it uses a remote subversion repository. This gives rise to a number of subsequent benefits such as holding a full version histo...
Continue reading
  2187 Hits
  0 Comments
2187 Hits
0 Comments

Oracle APEX Application Exploits - Part 3

Oracle APEX Exploitation - Part 3 This is the third in my series of short posts about methods thatc an be used to exploit your Oracle APEX applications. The first two posts concentrated on URL Injection which is relatively easy to protect against, however this third post is going to focus on something that is a bit more difficult to stop, and not q...
Continue reading
  2251 Hits
  0 Comments
2251 Hits
0 Comments

Oracle APEX Application Exploits - Part 2

Oracle APEX Exploitation - Part 2 Following on from my previous post in a series on common exploits in Oracle Application Express, in this post I am going to continue the theme of URL modification, however this time to allow us to execute procedures where we shouldn't be able to. This issue arises from the fact that we can use the construct BRANCH_...
Continue reading
  1500 Hits
  0 Comments
1500 Hits
0 Comments

Oracle Apex Application Exploits - Part 1

Oracle APEX Exploitation - Part 1 I decided to write a short series of posts detailing some different mechanisms that a malicious user may use to "attack" an application written in Oracle Application Express (Apex) - note - "Attack" is used loosely here in that it is more of "making the application perform in a way it was not intended". These posts...
Continue reading
  1812 Hits
  0 Comments
1812 Hits
0 Comments

APEX Organization/Position Chart Plugin (Google API)

A while back I posted instructions on how to create an organization/position chart in Oracle APEX using the Google Charts API . That was a little manual and not massively simple, so I have encapsulated that process into an APEX plugin which is released Apex.World . The GitHub project page can be found here which is the master repository for this pl...
Continue reading
  1525 Hits
  0 Comments
1525 Hits
0 Comments

Deferred Query Region Selector in Oracle APEX

Whilst working on a client project recently I created a page in APEX with a number of different regions, selectable via a Region Selector . The way this page was to be used, the user may not always want to click on every single region each time they use the page. Unfortunately the default behaviour with APEX is that all regions are rendered on the ...
Continue reading
  2577 Hits
  1 Comment
2577 Hits
1 Comment

BI with D3 Visualisations in APEX

Oracle's APEX ships with some great plugins such as D3 Collapsible Treemaps. The most immediate way to see these is to install the Sample Charts application and have a play with it. Now it is then fairly striaghtforward to utilise this plug-in in your own APEX applications. Here I simply exported the plugin from the Sample Chart applications and lo...
Continue reading
  733 Hits
  0 Comments
Tags:
733 Hits
0 Comments

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 the built in Automatic Row Processing functionality . When a row is read from the database an MD5 checksum is generated. When the record is written back, the MD5 checksum is regenerated prior to writi...
Continue reading
  5120 Hits
  0 Comments
5120 Hits
0 Comments

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 - if you missed that then you can find it here . Parsing Schema One of the first things you will need to decide upon when writing applications in APEX for E-Business Suite is the Parsing Schema . There are two main optio...
Continue reading
  4954 Hits
  0 Comments
4954 Hits
0 Comments

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 on. Each of these has its own pro's and con's however most are reasonably time-tested and well integrated into the E-Business Suite technology stack. Over recent years Oracle have put a lot of time and effort into t...
Continue reading
  27015 Hits
  2 Comments
27015 Hits
2 Comments

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

76 King Street, Manchester

M2 4NH United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk