Oracle experts Rocela events for 2012

Rocela’s Oracle experts have been involved in a considerable number of client side activities this year – from assisting large enterprise organisations declare their Oracle ULA to helping a global utilities company upgrade to Oracle R12.

Our website, twitter and blog all try to educate, deliver value and convey our deep knowledge of ‘all things Oracle’ however there is nothing better than looking us in the eye and asking us the difficult questions.

That is why we are planning a Roadshow of events for 2012 – taking us all around the UK (Edinburgh, Aberdeen, London, Manchester) to talk to large enterprise organisations on;

• Oracle Thought Leadership – a peer to peer ‘behind closed doors’ session discussing Oracle trends, product roadmap, Cloud, ULA’s, Virtualisation, Strategic Vendor Management to name a few.
Rocela Control ™ Session – a presentation on the complexities of Oracle license management and how our proven SAM methodology, Rocela Control ™ can help. This will also include a client case study, where one of our customers will present on their situation, what problems and impacts this was causing and how engaging with Rocela benefited.
• R12 Sessions – presentations and peer to peer discussions on how we can help assess whether Oracle R12 is best for your organisation and how its new features/functions will benefit.

We have run a number of these sessions before which have prompted the following comments;

“Great to hear from other contacts in the industry and how they have tackled the same sort of issues we are facing.” IT Director, Retail Company

“(This session) has helped us consider whether Oracle R12 is the right move for us.” IT Manager, Public Sector Organisation

“Rocela has given me an invaluable insight into the benefits and pitfalls of Oracle’s ULA’s – many of which I was not aware of before!” License Manager, Financial Institute

If you are struggling with the complexity of Oracle licensing, need to reduce risk and cost or need advice on Oracle R12, then please email Linda Anderson on with your contact details and highlight which event you would be interested in attending.

Have a Merry Christmas and a Prosperous 2012.


Have you recently upgraded from Oracle E-Business R11 to R12 and found yourself unable to launch APEX from the responsibility menu – Part II?

By Andrew Archibald, Senior Consultant for Rocela

Following on from my previous posting, where I discussed the issue with launching APEX applications from custom responsibilities, I have further developed this code to launch APEX in a separate window instead of using the current window. The previous code took the user from their responsibilities menu to APEX but did not allow for easy access back to responsibilities.

So, as I mentioned previously, launching APEX has become harder with R12 and to launch in a separate window is even harder!

There are two issues that have to be overcome;

• First, is the inability of being able to launch APEX through a MOD PL/SQL function
• and second, by default you cannot put a JavaScript call into your form function, such as

However, this can be overridden by changing the profile option “restrict text input” which is used to restrict entering JavaScript in the field. This can be changed however some security concerns have arisen as a result.

So how do you launch in a separate window? Well, you have to use a combination of JavaScript and HTML in your JSP file. You then have to redirect the LaunchApex.jsp back to the responsibilities page and open APEX in a new window.

First off we need to fetch details of the Oracle E-Business responsibilities for our JSP;

String l_apps_launcher = ctx.getProfileStore().getProfile(“APPS_SERVLET_AGENT”);
l_apps_launcher = l_apps_launcher + “/OA.jsp?OAFunc=OAHOMEPAGE”;

This can then be used in the HTML header to redirect the page once the page is loaded. This will take the main window back to the responsibilities menu;

<meta HTTP-EQUIV=”REFRESH” content=”0; url=<%=l_apps_launcher%>”>

Then add in Javascript code in the header to launch APEX in a new window;

<script language=”JavaScript”>
function open_on_entrance(url,name)

new_window =‘<%=l_launcher%>’,’launchapex’, ‘menubar,resizable,dependent,status,scrollbars,width=1200,height=1100,left=5,top=5’)
// –>

Then lastly, we add an ‘on load’ process to the HTML body tag;

<body onload=”javascript:open_on_entrance()” >

And that’s it! Hopefully you will find this useful. I firmly believe that this reinforces APEX as a great tool to extend Oracle E-Business Suite. What do you think?

%d bloggers like this: