Daily Archives Wednesday, July 2008

Groups are Grrrreat

Connect has been live for several weeks now. We spent only a few days running it concurrently with original Connect, and then Rich slapped redirects in place for the old URLs. It didn’t make much sense to maintain two instances
Traffic, which had dwindled significantly has ramped back up to between 13-15,000 pageviews each week. This [...]

COBOL Reborn

LewisC’s An Expert’s Guide To Oracle Technology

If you started in IT in the last 10 years, the odds are good you’ve never programmed in COBOL. If you started between 10 and 20 years ago, it’s possible that you missed that particular language. Over 20 years, you’ve probably had to at least do a little COBOL. I did about 3 years of it in my early days. Ma

Simple Customization of the Oracle BI Applications Data Warehouse

In today’s posting on the Oracle BI Applications, we’re going to take a look at adding custom data into the BI Apps data warehouse. In my experience there are a number of common scenarios where new data needs to be added to the BI Apps data warehouse, including:

Adding new columns, or new flexfields, to existing [...]

UKOUG

A good day today. I was privileged enough to be at the paper selection day for the UKOUG conference in December 2008. For those who don’t know what happens, and perhaps suspect some sort of elite giving themselves presentation slots, here is roughly how it works. 

Firstly a reasonably large group of reviewers from around the world, though naturally UK biased,  score your abstract on a scale from 1 (very poor) to 6 (excellent). They also have an opportunity to comment. These scores are then collated and a small team review the scores and allocate presentations to available slots. The purpose of the 2nd review is twofold - first it allows the team to review the agenda for balance of both topics and target audience - this year for example you will be especially well-served if you are a relatively new dba - and secondly it allows for the moderation of some of the scores - where for example only a very few people have scored a particular abstract. Finally, because some presenters get consistently high scores (Jonathan Lewis being the obvious prime example)  then there is the opportunity to ensure that other, maybe lesser known, presenters also get a look-in as well.

So what did this mean this year, well we had 212 submissions for the Server Technology arena (apps dba submissions are separate). We needed to fill 64 slots. So that means we needed to eliminate 7 out of 10 submissions. The average score for  this stream was 4.5 (that’s halfway between good and very good.)  and on average over 18 reviewers would have scored your submission. To get into the Top Quartile (more or less to be guaranteed a place) then you needed to score 4.93 (Very Good) on average. To restate - to stand a good chance of getting in, your abstract needed to show a group of nearly 20 Server Technology specialists that it was either very good or excellent. The bar to present at UKOUG is extremely high. Those who will be receiving congratulations communications should feel justly proud. Those who are planning to go, well you should be spoiled for choice. You can register your interest (and maybe win a laptop) here.  

So What’s In the Oracle BI Apps Data Warehouse?

So before we start thinking about how we’re going to extend and customize the Oracle BI Applications data warehouse (technically called the “Oracle Business Analytics Warehouse”) it’s probably worth having a think about what’s in the warehouse in the first place. Now this isn’t quite as easy as it seems as Oracle only grant access [...]

Enterprise 2.0 Bootcamp on July 28

As Justin blogged yesterday, Oracle is hosting an Enterprise 2.0 Bootcamp on July 28 at the big blue disk drives in Redwood Shores.
I won’t be able to make it, but Paul will be in attendance, along with Justin and the usual suspects. This should be an interesting event where attendees get a chance to interact [...]

How we fill the shopping malls

I don’t go shopping very often. I like to buy things, don’t get me wrong. But I don’t like to shop, don’t like the marketing, the noise, the lines.But when I do go shopping, I am startled by how full the parking lots are and how busy the shops are.Afte…

XML Goodness in SQL - Part 2

In part 1, we reviewed HTTPURIType and DBURIType. Let’s now go over a few examples of more advanced XML using the SQL functions XMLTable and XMLQuery, Oracle’s native support for XQuery.

SQL functions XMLQuery and XMLTable are defined by the SQL/XML standard as a general interface between the SQL and XQuery languages. XMLQuery and XMLTable let [...]