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


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 generate a row for every date between X and Y (the most common I personally find), or simply just to generate some dummy data for testing purposes. Or even just as an academic exercise it is good practice to explore the options for achievin...
Continue reading
  2589 Hits
  0 Comments
2589 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
  5106 Hits
  0 Comments
5106 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
  27353 Hits
  2 Comments
27353 Hits
2 Comments

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 theme -  indexes . Whilst this may be more database design than coding concepts, the principles of course underpin any SQL statement that you write and such concepts are arguably one of the most important aspects of writing any piece of co...
Continue reading
  2372 Hits
  0 Comments
2372 Hits
0 Comments

Prune Days on an E-Business Suite Source Environment

Prune days... often misunderstood, often just left "as default". Possibly not helped by the fact that entering the search term into Google yields the following as the top hit: The LAST_UPD column in Siebel transactional database tables is used for incremental change capture. This timestamp reflects the actual event time. It is therefore possible fo...
Continue reading
  5074 Hits
  0 Comments
5074 Hits
0 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