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

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

1548 Hits

0 Comments

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

244 Hits

0 Comments

Tags:

APEX APEX 5.1

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

520 Hits

0 Comments

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

344 Hits

0 Comments

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

580 Hits

0 Comments

580 Hits

0 Comments

Beyond Blog

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