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


Duplex printing Batch Reports to multiple clients on an even number of pages using RTF templates

Invoice_Banner
Following on from my previous blog featuring RTF templates, this blog addresses another issue that was encountered when working with a client who required reports (Invoices, Purchase Orders etc) from Oracle EBS to be printed duplex and in batch.​Printing reports duplex as opposed to Simplex throws out an issue where 2 separate invoices can be print...
Continue reading
  310 Hits
  0 Comments
310 Hits
0 Comments

Adding a Barcode or Cheque font to a RTF template when using Template Builder for Word.

Adding a Barcode or Cheque font to a RTF template when using Template Builder for Word.
We have recently had demand from a client to create RTF templates for both printing cheques and invoices. Both of which require using fonts which are not default in Microsoft Word. This blog will firstly talk through how to add these fonts both to your local machine for use in the RTF template, and to the server for use within Oracle EBS. ...
Continue reading
  320 Hits
  0 Comments
320 Hits
0 Comments

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 we ...
Continue reading
  2610 Hits
  0 Comments
2610 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 FormsTransactional Reporting - Oracle XMLP or Oracle Reports, FSG'sAd/Hoc and Analytic - OBIEE or DiscovererMore and more organisations are now realising however the power ...
Continue reading
  2765 Hits
  0 Comments
2765 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
  2623 Hits
  0 Comments
2623 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 O...
Continue reading
  3065 Hits
  0 Comments
3065 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 onlyRight to AccessRight to ...
Continue reading
  3726 Hits
  2 Comments
Recent Comments
Guest — EnterpriseTouch
You could run Oracle EBS 11.5.10 CU2 on AWS. The whitepaper architecture would also apply to Oracle EBS 11.5.10 CU2 as well. Oracl... Read More
Thursday, 21 February 2019 06:17
Guest — soniamary
Thanks for sharing..!!!
Friday, 22 February 2019 05:29
3726 Hits
2 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 read...
Continue reading
  5032 Hits
  0 Comments
5032 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 flashb...
Continue reading
  4325 Hits
  0 Comments
4325 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-Busin...
Continue reading
  5216 Hits
  0 Comments
5216 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
  4664 Hits
  0 Comments
4664 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 there...
Continue reading
  5190 Hits
  0 Comments
5190 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 structur...
Continue reading
  4987 Hits
  0 Comments
4987 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
  5512 Hits
  0 Comments
5512 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 I...
Continue reading
  6276 Hits
  2 Comments
Recent Comments
Guest — JJ Kruger
Hi John Thanks for the article, but I have sort of the reverse effect. I need to enforce the built-in security on per_people_f bu... Read More
Tuesday, 07 January 2020 07:13
John
Hi, The default for secure views is to show all records rather than hide all - so if you don't have any security profile being pic... Read More
Tuesday, 07 January 2020 08:54
6276 Hits
2 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.BackgroundAs a bit of background for those who may not be aware, some standard E-Business Suite tables con...
Continue reading
  3894 Hits
  0 Comments
3894 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 FormWe 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 asking ...
Continue reading
  8888 Hits
  0 Comments
8888 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 SchemaOne 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 options h...
Continue reading
  7341 Hits
  0 Comments
7341 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 th...
Continue reading
  32664 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
32664 Hits
8 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