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

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
  129 Hits
  0 Comments
129 Hits
0 Comments

GDPR and Oracle E-Business Suite

​I'm presenting at a small group in the near future on sources of personal data in Oracle E-Business Suite and how this relates to the GDPR regulations. If you're interested in this, you can find my slides below. File Name: General-Data-Protection-Regulation-GDPR-and-Oracle-E-Business-Suite File Size: 658 kb Download File
  421 Hits
  0 Comments
421 Hits
0 Comments

Oracle E-Business Suite Person Data Removal Tool - Roadmap Released

I wrote recently on the complexities of achieving GDPR compliance in an environment. Last week Oracle published the following MOS note:  Oracle E-Business Suite Data Removal Tool Roadmap (Doc ID 2384629.1) which whilst doesn't contain a great deal of information, is worth bookmarking. The current planned delivery timeline (subject of course to...
Continue reading
  628 Hits
  0 Comments
628 Hits
0 Comments

Is your E-Business Suite ERP ready for GDPR?

If there's one thing that is causing a lot of stir within organisations at the moment it's GRPR . As the date of enforcement approaches rapidly ( 25 May 2018 ), more and more data controllers are becoming increasingly nervous as to whether their Enterprise Systems can support the requirements of GDPR. Particularly, but not only Right to Access Righ...
Continue reading
  730 Hits
  0 Comments
730 Hits
0 Comments

Oracle HRMS - Which View Should I Use?

Enter your custom HTML codes in this section ... Taking a break out of the APEX Exploits series for this as it's something I keep coming across at different client sites. select p.full_name, su.supervisor from per_people_x p, per_assignments_x a, per_people_x s where a.person_id = p.person_id and a.person_id (+) = a.supervisor_id; With me (or the r...
Continue reading
  1337 Hits
  0 Comments
1337 Hits
0 Comments

Auditing Record Changes in an E-Business Suite Environment

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...
Continue reading
  1777 Hits
  0 Comments
1777 Hits
0 Comments

Customising Your E-Business Suite Look and Feel

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...
Continue reading
  949 Hits
  0 Comments
949 Hits
0 Comments

Delegated Proxy Access in E-Business Suite R12.2

I've posted a few things over the previous months regarding new or changed functionality in E-Business Suite R12.2, and here is something that I think will be particularly useful. In previous versions of E-Business Suite it's possible to grant access to full account level access to another user, however as of 12.2 this has been enhanced to responsi...
Continue reading
  1718 Hits
  0 Comments
1718 Hits
0 Comments

Conditionally Disabling Descriptive FlexField (DFF) Segments in E-Business Suite

There have been quite a few posts on the Oracle OTN Forums E-Business Suite space recently with people asking some kind of variation of the following question. How can I disable specific descriptive flexfield segments for specific users? As per My Oracle Support Document 372034.1 , this functionality is not supported by forms personalization and th...
Continue reading
  2146 Hits
  0 Comments
2146 Hits
0 Comments

Table configuration in E-Business Suite R12.2 to support Online Patching

With a lot of E-Business Suite customers looking to upgrade to R12.2.x within the near future (if they haven't already), I thought it might be useful to illustrate some of the key differences. I'll spread this out over a number of different posts, however for today I am going to look at database tables . Prior to Release 12.2, the following structu...
Continue reading
  3142 Hits
  0 Comments
3142 Hits
0 Comments

A quick look into E-Business Suite R12.2.4 Vision

So a couple of weeks back I had a quite an exciting moment. Why? Well I downloaded myself an E-Business Suite R12.2.4 Vision virtual machine from Oracle E-Delivery. After the initial pain of unzipping many gigabytes of zip files, concatenating chunks together etc and finally importing into virtual box, I finally got it up and running. This is the s...
Continue reading
  3473 Hits
  0 Comments
3473 Hits
0 Comments

Querying HR Secured Views in Oracle Application Express

Oracle Application Express (APEX) is increasingly being used to produce custom developments within Oracle E-Business Suite. I've posted previously about how to configure your custom applications to use E-Business Suite context for purposes such as foundation API's, MOAC security, profile values and such ( using fnd_global.apps_initialize ), however...
Continue reading
  3363 Hits
  0 Comments
3363 Hits
0 Comments

Predicate Evaluation Order - Using Generic Fields

I thought this worth talking about as I've been in discussions with a number of people recently around best practices for data types etc. The example in the discussion was the implementation of Descriptive Flex Views in Oracle E-Business Suite. Background As a bit of background for those who may not be aware, some standard E-Business Suite tables c...
Continue reading
  1816 Hits
  0 Comments
1816 Hits
0 Comments

Selectively Enabling Fields/Flexfields on a Query Only Oracle Form Using Personalizations

Selectively Enabling Fields or Descriptive Flexfields on a Query Only Form We have recently worked for a client who wanted a form within Oracle E-Business Suite to be read-only on a particular responsibility, except for the descriptive flexfield . I've also by chance come across a couple of posts on the Oracle OTN Forums recently too that are askin...
Continue reading
  5495 Hits
  0 Comments
5495 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
  4709 Hits
  0 Comments
4709 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
  26408 Hits
  2 Comments
26408 Hits
2 Comments

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

Barnett House, 53 Fountain Street,

Manchester M2 2AN United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk