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


Scheduling Concurrent Programs to Run Between Specific Times of the Day

I've seen this question come up a few times on the Oracle Community Forums recently, so I thought I'd write a quick blog post about it. The question is along the lines of "How can I schedule a concurrent program to run every X minutes between Y o'clock and Z o'clock each day?" . For this example, we'll assume we have a program "Active Users" that w...
Continue reading
  396 Hits
  0 Comments
396 Hits
0 Comments

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
  625 Hits
  0 Comments
625 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
  886 Hits
  0 Comments
886 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
  1109 Hits
  0 Comments
1109 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
  1292 Hits
  0 Comments
1292 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
  1924 Hits
  0 Comments
1924 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
  2300 Hits
  0 Comments
2300 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
  1741 Hits
  0 Comments
1741 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
  2296 Hits
  0 Comments
2296 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
  2446 Hits
  0 Comments
2446 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
  3466 Hits
  0 Comments
3466 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
  3879 Hits
  0 Comments
3879 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
  3943 Hits
  0 Comments
3943 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
  2231 Hits
  0 Comments
2231 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
  6135 Hits
  0 Comments
6135 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
  5218 Hits
  0 Comments
5218 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
  27582 Hits
  2 Comments
27582 Hits
2 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