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


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 th...
Continue reading
  33626 Hits
  8 Comments
Recent Comments
Guest — Abha
Hi, I have followed all the steps as mentioned in your post to integrate APEX with EBS. But when I click on the APEX link from EB... Read More
Thursday, 03 May 2018 08:29
Guest — Hazel Noble
Hi John, Thanks very much for this useful blog; we're just implementing APEX to replace Discoverer and will be utilising your blo... Read More
Tuesday, 05 June 2018 13:33
Guest — sa
Hi We Unable to get the value of apps.icx_sec.getsessioncookie... can you please help .....
Tuesday, 19 March 2019 10:14
33626 Hits
8 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 code....
Continue reading
  4442 Hits
  0 Comments
4442 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 for...
Continue reading
  7421 Hits
  0 Comments
7421 Hits
0 Comments

Star Transformations with Bitmap Indexes

One area of data warehousing that often confuses people (typically those who have come from an OLTP development background) is bitmap indexes... why do we use them from a design point of view? How does the optimizer use them? What benefits do they have?Whilst this topic alone can (and does) cover entire books, I'm hoping to give a brief overview of...
Continue reading
  5074 Hits
  0 Comments
5074 Hits
0 Comments

SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions - Part 1

I wasn't too sure of what title to use for this blog post. I wanted to share some things that I see quite regularly at various sites in SQL or PL/SQL code where the developer has either not fully understood what they have written, or have done so under assumptions or risk. These are not necessarily always "mistakes" as such (and they may similarly ...
Continue reading
  4636 Hits
  0 Comments
4636 Hits
0 Comments

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Suite 1.01 Jactin House,

24 Hood Street, Manchester

M4 6WX United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk