EBS, Blogs of Note, SOA, Oracle Support, Business and IT, APEX, ADF, Hyperion

General, Miscellaneous and a Bit of Everything
Christopher Gait, Oracle Infogram Editor | Mar 4, 2010 19:44 +0000

EBS

At the Oracle E-Business Suite Technology blog this week:





Blogs of Note

Kevin Closson singles out the Oracle-Base blog as one of his favorites, and Kevin's blog is one of my favorites, so I'm passing it along. This is a real technical treasure trove. Consider these samples:



SOA

Over at the Inside scoop on Oracle SOA Suite, BPM and EDA blog we have a link to a good technical article: Setting Web Service and JCA Adapter Endpoints Dynamically in Oracle SOA Suite

At the same blog we find the start of a series on advanced fault handling.

Oracle Support

Chris Warticki has moved his postings to Oracle Communities, which makes getting a login there worthwhile by itself. But he is still posting links to his postings at his blog. This one is entitled: Support Synchronization - Best Practices .

Business and IT

Over at the Tech Demo Guy blog there's a good quick set of 5 Rules for Selling Technology to Business Audiences. Worth a read.

APEX

Anton Nielsen brings us a technical hint at this blog: APEX Refresh Classic Report Region AJAX style.

ADF

Keeping the users out of trouble by Integration in Oracle ADF with ADF Task Flows and Dynamic Regions Pending Changes at the Andrejus Baranovskis's Blog.

Hyperion

As Glenn Schwartzberg's Essbase Blog tells us, Kaleidescope is already on the horizon and closing fast on our position. Time to figure out what you want to attend. As I always found at technical conferences, there's always too much interesting stuff going on. There's only one solution, but cloning technology and phase-shifting to attend two events at once are still a ways off. The next best thing is reading up on the schedule in advance and make up your mind.

Hyperion, SQL and APEX, Lies, Damn Lies and Statistics, SOA, OBIEE

General, Miscellaneous and a Bit of Everything
Christopher Gait, Oracle Infogram Editor | Feb 25, 2010 15:43 +0000

Hyperion

Just came across a Hyperion blog I hadn't seen before, one run by Johnson & Associates Consulting called the Hyperion Consultant Blog. Let me know what you think of it.

SQL and APEX

A posting over at John's Blog touches the tip of the veritable iceberg of the potential impact of views on performance. Through a simple example he shows how you can end up with a reduntant sort operation from using a view. But there can be lots of other impacts, and I've seen views of such intricacy and inefficiency that they've turned out to be the cause of major performance problems. Often it starts out as: well, we just need a view to simplify coding this report. Then over the months and years it is forgotten that the view was created for a specific report and it starts to be used as if it were a table, then there are modifications, then someone creates a view that uses the view as an element, and from there it's all downhill in a handbasket.

So views are a great way to help out developers, but don't let them take on a life of their own or they can become a real problem.


On APEX, have you been hearing the hoopla about Application Express for a long time and meaning to 'get around to that'? Well, have a look at this site and you can set up an account and mess around in your very own workspace to get familiar with APEX. I think you will find it an elegant and useful product for fast development (and a lot of more complex tasks).


One more item in the wonderful world of APEX this week: How to Avoid Bot Spammers in APEXover at Martin Giffy D'Souza's APEX blog.

Lies, Statistics and Their Ilk

In a posting entitled Autotrace Lies Too! Kerry Osborne digs in to some of the behavior of autotrace and the intricacies of how close an explain plan is to what the optimizer really ends up doing. He points back in the posting to an excellent posting from Tom Kyte on the same subject.

SOA

Looking for a trimmed down summary of SOA 11g: Cluster installation? Well, there's the link over at the SOA@Oracle SCA, BPEL, BPM & Service Bus. The blog title is almost as long as the process.

OBIEE

Working with OBIEE? You should definitely take a look at the Oracle Business Intelligence obiee 101 blog. Lots of nice little technical how-to's. Definitely something to add to your RSS feeds. Example: OBIEE Popup Box.