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

Extracting Data from Oracle Fusion SaaS using Data Replicator in Oracle Analytic Cloud Service

Daniel Willmott

Thursday, 25 October 2018

Cloud Business Intelligence

If you were keeping up to date with the goings on at Oracle OpenWorld last week, then you may have caught Larry Ellison announcing the ' Fusion Analytics Data Warehouse '. Whilst the specific features that were showcased are unlikely to be avai...

Auditing Record Changes in an E-Business Suite Environment

Monday, 15 May 2017

John Keymer

E-Business Suite

A question that comes up all the time on the OTN Forums is "How do I know who updated this record?" . Generally the response is to point the member in the direction of the last_updated_by column on the table. The next question often then comes up... So how do I see what the old value was?" . Hmmmm... a little more tricky. We can try to look at flas...

2997 Hits

0 Comments

2997 Hits

0 Comments

BI with D3 Visualisations in APEX

Wednesday, 03 May 2017

Mark Daynes

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...

1785 Hits

0 Comments

Tags:

APEX APEX 5.1

1785 Hits

0 Comments

Creating an Organization or Position Hierarchy Chart

Thursday, 20 April 2017

John Keymer

Other Technical

Many clients I have worked for have expressed an interest in a graphical organization chart generated from their E-Business Suite ERP system. Unfortunately the org chart diagrammer in EBS isn't really all that great. And the strategic Oracle reporting tools (Business Intelligence etc) are even worse! It's actually surprisingly difficult to render a...

2343 Hits

0 Comments

2343 Hits

0 Comments

The Basics of Consumption Queries in SQL

Friday, 31 March 2017

John Keymer

SQL

I was inspired to post this blog by a post on the OTN Forums where a user was asking about calculating the consumption of hours against a target - that is, given a target of X hours with N hours per day, how many days would it be until they reached the target? I knew I had done similar things several times in the past, and each time I always seem t...

1360 Hits

0 Comments

1360 Hits

0 Comments

Customising Your E-Business Suite Look and Feel

Friday, 17 March 2017

John Keymer

E-Business Suite

With every major release of Oracle Applications in recent years there has been a new look and feel for OAF pages. BLAF (11i), Swan (R12.1) and finally Skyros (R12.2). One would imagine that once R12.3 comes out (or even the latter end of R12.2) it will be with the Alta skin - R12.2 already has some nods towards this. Customer response to the E-Busi...

2936 Hits

0 Comments

2936 Hits

0 Comments

Beyond Blog

Extracting Data from Oracle Fusion SaaS using Data Replicator in Oracle Analytic Cloud Service

Auditing Record Changes in an E-Business Suite Environment

BI with D3 Visualisations in APEX

Creating an Organization or Position Hierarchy Chart

The Basics of Consumption Queries in SQL

Customising Your E-Business Suite Look and Feel

Demonstration

Contact