Monday, April 28, 2008


Overloading PL/SQL

I was doing some research for a customer on overloaded code and came upon this blog entry, which I thought was a good overview with some hands-on examples.

Thursday, April 24, 2008

JD Edwards, Scaling, Performance, Hyperlinks, April CPU

JD Edwards

Some good updates on EnterpriseOne over at the JD Ewards Advisor blog.

Scaling Up

The High Scalability blog has some links to a presentation (slides and video) on how Google deals with scaling up (as you can imagine, they do a lot of that). I hope you have better luck with the video, I gave it five minutes and it still didn't finish downloading, so it may be 'overwatched' at the moment. In a way, that's mildly amusing, considering the video isn't scaling to meet demand. But the slides downloaded fine, and are full of eminently technical material (suitable for menacing non-technical relatives, saying that 'this is really interesting stuff' and 'just sit down here and I'll explain it all in terms you can understand').

Performance: CMT and Oracle

Considering CMT? Glenn Fawcett points out a few factors here on Utilizing CMT with Oracle.

Oracle Subdomains

Eddie Awad has come up with this great list of subdomains at his blog:

April CPU and EBS

A good summation of the April CPU, with links, over at the Oracle Security Blog.

Wednesday, April 23, 2008



A good blog from an Oracle employee working with our OBI EE product. A representative article is Oracle BI EE - Overriding Autogeneration of Dimension Level Names of Hyperion Essbase 9.3.1 Wow, I'm really tired from just typing that title. Good, hands on material.


David Peake gives us some unofficial (but probably pretty darned reliable) peeks over the horizon on the direction of APEX at his blog.

Hyperion Support Update

Hyperion e-Support Set To Retire
Hyperion Customer Support: Oracle recently announced the upcoming transition of Hyperion e-Support to OracleMetaLink 3. To help prepare customers and partners for this change, a new transition information website is now available. This will provide customers and partners more specific details regarding significant changes, transition information, benefits, FAQ, and a customer feedback e-mail account. MORE...

Tuesday, April 22, 2008

JD Edwards EnterpriseOne/World

General Availability of 8.12 Update 3

JD Edwards EnterpriseOne 8.12 Update 3 is now generally available. This update contains all Electronic Software Updates (ESUs) and Application Software Updates (ASUs) completed since the base release of EnterpriseOne 8.12 (April 2006) through February 5, 2008.

Special instructions for this update are posted to the Software Delivery site on Customer Connection. Directions for navigating to the instructions are included in the documentation booklet on the Electronic Product Delivery (EPD) site.
For a list of all available baseline ESUs, please click here (requires Customer Connection log in)

Upcoming Webinars/Advisor Webcasts

JD Edwards EnterpriseOne (time in MDT)
- Shop Floor Mgt Automatic Acctg. Instructions for Mfg Acctg, April 30, 10:00 a.m.
- Promoting Solution Explorer Objects in JDE EnterpriseOne, May 1,10:00 a.m.
- Planned Cross Docking, May 8,10:00 a.m.
- Pro Forma Journal Entries,,May 13,10:00 a.m.
- JDE E1 on iSeries - Gathering JDE, OS logs from System i May 14, 10:00 a.m.
- Failure Analysis for use in Service Mgmt & Capital Asset Mgmt, May 15,1:00 p.m.
- Using the XML Interoperability API with JDE TR 8.97, May 20, 1:00 p.m.
- Guaranteed Real Time Events with Tools Release 8.97, May 21, 10:00 a.m.
- User Defined Depreciation Overview & Adding New Depreciation Rule,May 22,10:00 a.m.
- Lead-Time and Back scheduling E1 Releases 8.10 and Above, May 28,10:00 a.m.

JD Edwards World
- A91 Address Book Enhancements, April 24, 10:00 a.m. (MDT)
- What’s New on World A9.1 for the State, Province / Country Code File; Authorized Alternate Payees, Sub ledger and sub ledger types in P04102, May 13, 1:00 p.m. (MDT)
- Benefits Administration, May 15, 10:00 a.m. (MDT)
- Transit from Purchasing to A/P, May 20, 9:00 a.m. (MDT)

Details for the above Advisor Webcasts can be viewed on Customer Connection

Monday, April 21, 2008

Oracle Procurement News

Oracle Procurement Experts Answer Your Questions About ... Oracle Advanced Procurement Release 12
In this second in a series of columns featuring answers to customers' most frequently asked questions about Oracle Procurement products, Oracle sourcing expert Bill Tokheim offers details about R-12's new features and provides tips on how to successfully prioritize upgrade projects.

Two New Tools Save Time and Money in R12 Training and Documentation
Two interactive tools with a track record for saving training time and money for Oracle procurement applications are becoming available for the iProcurement module in Oracle E-Business Suite Release 12 for Advanced Procurement.

Oracle Sourcing R12 Soon to be Available Through Hubwoo
Look for details in the coming weeks about a plan to combine Oracle Sourcing with Hubwoo's global sourcing expertise and hosting services. The strategy calls for Hubwoo to implement an instance of Oracle Sourcing 12 (R-12) and make it available to customers that prefer on-demand.

Join the Discussion About Oracle Advanced Procurement
Check out this forum that allows you to share information and insights about Oracle iProcurement and read what other users have to say.

Oracle will be participating in a number of industry events for procurement professionals this spring. Venues where Oracle will be sponsoring, presenting, or exhibiting include the following:

May 4-7 Institute for Supply Management's Annual Conference in St Louis, Missouri
May 6-9 Sourcing Interests Group's Global Conference, Newport Beach, California

Managing SOA Presentation

Better Living Through OEM

- SOA Runtime Governance With Oracle Enterprise Manager

- Tuesday, 22nd April @ 11 a.m. PDT/3:00 p.m. EDT/6:00 p.m. GMT

Registrations open on OTN.

Friday, April 18, 2008

10046, Performance

10046, A Friend in All Weathers

H.Tonguç Yılmaz demonstrates that 10046 is a swiss-army-knife of a trace technique in his blog.

Performance and the Art of Being Nice

Nice can mislead you, at least the one in Unix, and the I'm Just a Simple DBA blog fills us in on some of the ins and outs of using the nice utility.

Thursday, April 17, 2008

Hyperion: Collaborate '08, Siebel

Hyperion and PeopleSoft: Collaborate '08

Mark Rittman, of Rittman Mead Consulting, is blogging from Collaborate '08, concentrating on Hyperion. You can find his updates here.

For updates from the PeopleSoft sessions, check out the Grey Sperling blog.


The Notes on Siebel blog continues their series on Order of Events.

Wednesday, April 16, 2008

April CPU Out, Humor

April CPU

The April CPU security patches are out. Start your way through the maze of documentation, binaries etc., right here at Metalink.

As always, test it, on the same equipment and load level as production if at all possible. Some errors only become evident at full load, so it's important to come up with a way to test under load. The traditional way to do this is to buy a load simulator (usually really expensive) and customize it for your system (even more expensive). But there are alternatives using scripts that can come close. My personal approach for customers is that they probably want to get this into test right away, but only apply on prod after a little time has passed, just in case. (And no, by 'a little time' I don't mean a geological period or until the next CPU, or until the DBA retires!).


On a (much) lighter note, I just came across a link at Dark Roasted Blend, one of my favorite non-Oracle related blogs, pointing to this YouTube link of Sid Caesar and Nanette Fabray
setting an argument to Beethoven's 5th. Brilliant!

Tuesday, April 15, 2008

PeopleSoft and Siebel SimBuilder

Critical Patch Update April 2008 (CPUApr2008) for Oracle and PeopleSoft Products

Oracle released the Critical Patch Update April 2008 to resolve a number of security vulnerabilities in Oracle, and PeopleSoft, and Siebel SimBuilder products.

An email communication to all customers announcing CPUApr2008 was sent on Tuesday, April 15. The information for the completed patches will be made available on MetaLink and Customer Connection on April 15.

The Critical Patch Update Advisory and associated document were posted on Customer Connection for PeopleSoft

Oracle Siebel SimBuilder customers should refer to OTN Critical Patch Update Advisory


Oracle Siebel CRM On Demand Webcasts

Transform Your Business through CRM: Introducing Oracle CRM On Demand

Oracle CRM On Demand delivers low-risk, hosted Customer Relationship Management with little, or no up-front IT investment, making it the ideal solution for companies of any size. With Oracle CRM On Demand, you can accelerate sales, improve marketing, and deliver consistently top-notch customer service. That's why more companies of all types and sizes trust Oracle CRM On Demand to centralize vital customer and sales data, and gain real-time snapshots of customer interactions.

Need to "see it to believe it"? Register now for an upcoming LIVE WEBCAST:
April 17, 2008
April 24, 2008
May 1, 2008
May 8, 2008
May 15, 2008
May 22, 2008
May 29, 2008

Eliminate Call Center Complexity with Oracle CRM Call Center On Demand

Traditionally, building and maintaining a contact center proved cost prohibitive and resource-intensive. Oracle CRM Call Center On Demand eliminates upfront capital expenditures and complex telephony infrastructure while providing a world-class call center solution. This enables the launch of a fully functional contact center, far more quickly, regardless of the size of your company. All you need is an internet connection and a phone.

Register now for an upcoming LIVE WEBCAST:
May 1, 2008

CPU Time Again, SOA, BI Publisher

CPU Time

And Integrigy does a little crystal-balling of the scope and variety of severities of the vulnerabilities covered by the April 2008 CPU.

SOA and Laundry, a New Analogy

People are trying to get their minds around the concept of SOA, and Antony Reynold's blog expands on the concept of SOA being like laundry rather than like legos. I must admit to missing the days when this stuff was like, oh, computer programs.

BI Publisher

Over at the In Depth Apps blog we have a valuable pointer to a Metalink note on BI Publisher Release 12 Known Issues. If you haven't looked at the blog, you should explore. There are some very useful posts in there.

Monday, April 14, 2008

Free Seminar: American DBA Online with Tom Kyte

American DBA Online Seminar on latest Oracle Database Technology

Join American DBA Online technical seminar on May 17, 2008 at the Hilton Hotel, Woodbridge, New Jersey with several of the database industry's most famous speakers. Mr. Tom Kyte, the Tom behind the "AskTom" column in Oracle Magazine will give the keynote speech on Oracle Database 11g.

Do not miss this opportunity to meet Tom and "AskTom" some questions. Oracle's support of this organization has allowed this event to be free. However, Pre-Registration is required.

Sunday, April 13, 2008

SOA, Stellent, Obfuscated PL/SQL, PL/Scope, TDE


Second in a series of articles on SOA over at the AMIS Technology Blog, this one is on Subscribing to and Consuming Business Events.

Not to Brag, but Some Bragging

Stellent security came up on the Bex Huff blog, and it came through with flying colors. Good news is nice once in a while in the security realm.

Mystery Code Competition, PL/Scope

Some news is out on the obfuscated PL/SQL contest that concluded on April 1st. You can find it over on Eddie Awad's blog.

Also at Eddie's blog is a followup article on PL/Scope in 11g RDBMS, with some input from Oracle's product manager for PL/SQL.

TDE Performance

In researching Transparent Data Encryption for a client I came upon this excellent hands-on article at Oracle-Base blog which includes a script to measure performance differences with TDE in place.

Saturday, April 12, 2008

Infogram Weekend Edition: Firefoxes of the Universe, Tank, The Amazing Lorenzo

Space Browsers

Wired's Gadget Lab blog has discovered (by way of the Hubble telescope) that there are browser logos in space. I would say something snide about IE and what its nebula looks like, but it's the weekend, so I'm in a very friendly mood.

Also at Wired Gadget Lab, be the first on your block to present a threat to world peace, or at least scare the heck out of the neighbors, by building your own 1/2 scale diesel Tiger 1 tank that fires paintballs.

Lorenzo the Flying Frenchman

A lot of performers call themselves the 'amazing this' or the 'astounding that', but Lorenzo, who calls himself the flying Frenchman, really is quite amazing in both his abilities and the affinity he has with his horses. You can see him here. Thanks to my dear friend Basri in Sinop, Turkey who sent in the link.

Thursday, April 10, 2008



Sounds like a government agency no one is supposed to know about, but it's
Oracle Authentication Services for Operating Systems. It's just been released, and you can read all about it over at Nishant Kaushik's Talking Identity blog.

You can find some resources here:

to start with Oracle Authentication Services for OS Overview (PDF).


Sometimes even our folks get frustrated with Metalink (but it's an internal, 'family argument while still very affectionate' kind of frustration, you understand). Tim Dexter over at the Oracle BI Publisher blog had some problems getting directly to a Metalink note on java.lang.OutOfMemoryError and gives us the note number to look up if we encounter this in BIP.

Wednesday, April 9, 2008

Heros of the DB

Hero Worship

This week we posted here at the Infogram on superheros and the DB, now we'll get a little more down to earth, with a posting at Richard Foote's Oracle Blog on his Top 5 Influencial DBAs in My Career. I can only second his selections. But he actual only has four of them in the first posting, leaving us all waiting for the other shoe to drop for the last. He promises it will be someone controversial. It's almost certainly Bill Gates.

Big coincidence, by the way. Everyone on the list is an Oak Table

Tuesday, April 8, 2008

Oracle and Marvel, SQL Developer 1.5

Superheroes of the DB

It looks like you don't have to miraculously recover lost data to be a hero anymore, just use Oracle and you will likely acquire comic-book type superpowers. See this site for details.

I'm personally trying out for Hulk. I've got the weight part. Now I just need the superhuman strength, armor skin, etc.

SQL Developer

The new early adapter version of SQL Developer is available at OTN.

Monday, April 7, 2008

DBA Book, Hyperion, 11g Alert Log, Preventing Data Leaks

New DBA Book Out

Christopher Lawson, who wrote one of the better performance books of recent years, The Art and Science of Oracle Performance Tuning, has come out with a new tome (well, it's bit small to be a tome, but that sounds so much nicer). Snappy Interviews, 100 Questions to Ask Oracle DBAs is a set of questions and answers arranged by skill level for interviewers to use when conducting technical interviews with Oracle DBAs. The questions are all on the core RDBMS, not EBS or other Oracle products.

This could be a very handy book to have in your IT shop. Often the person giving a technical interview isn't the Oracle DBA, but a sys admin, programming manager or other position. This book will let you generate some good questions and get a pretty good idea if you are hearing 'review blather' or experience.

Of course there is a certain amount of flexibility one has to use in these interviews. In working with DBAs (and as a DBA) over the years I've found there are several different basic personality types. Only some of those personality types know the names of things directly at all times. The others are really fast at looking things up that they worked with before or really good at finding out what they don't know. Most of the questions in this book, however, cover ground that every experienced core DBA is likely to know, so it's a good investment. There is also a class of DBAs who don't know, don't really care, and hope for the best. Hopefully this book will help you keep those DBAs working in other companies, preferably your competitors' shops.

Of course a lot of DBAs wanting to interview for jobs are going to buy this book to 'cram for the tech interview', so make sure you get a few questions that aren't in the book to throw at them as well, such as: 'What is the air speed velocity of an unburdened swallow?' or 'What is your favorite color?' You'd be surprised how many people get thrown by that last one.

Hopefully, since Chris works in the realm of financial applicitions, he will produce a companion volume to this on questions to ask an Apps DBA.

Hyperion on DB2

Have Hyperion? On DB2? Tim Tow's Hyperion blog has an article for you on Hibernate Dialect for DB2.

11G Alert Log

The I'm Just a Simple has an article on some of the ups and downs of the XML-formatted alert log in 11i (and a note in the comments on where to find the old fashioned format).


A good article just out by way of Oracle's Database Insider newsletter on preventing data leaks at the source (PDF file).

Sunday, April 6, 2008

China Business Notes

China Business

Some of you may be wondering why we run articles on business in China in an Oracle Support blog. Well, three basic reasons

1. We can (fairly predictable and pretty darn tautological as well).

2. A lot of our customer have major business interests in China (ok, that might work).

3. The editor is studying Chinese and has been a major fan of Chinese culture all his life (Aha! Now we're getting to the bottom of it).

Anemic Stocks and the Flattening of IPOs

Well, we all knew that the mega-IPOs in China were a bit inflated. And what else is inflated? Why bubbles, of course. Things seem to be settling down a bit according to this article at the China Economic Review.

And there's a few words of caution to be found at the Managing the Dragon blog this week as well.

Friday, April 4, 2008

Infogram Weekend Edition, APEX 404

Infogram Weekend

This week we have interviews (they can keep you busy during a brief Metalink outage).

Over at the Mental_Floss blog is a link to the The Mike Wallace Interview . The University of Texas has an archive of videos available of this show from the late 1950s by Mike Wallace, later of 60 Minutes fame. I enjoyed watching the one with Salvador Dali, whom I hadn't seen on video since I was a child and saw him on the Tonight Show a time or two.

Right now I'm listening to Erich Fromm trying to scare people with megawar (I think it worked), and later I'm going to give Aldous Huxley a whirl.

Full shows, 1950s commercials and all. Be prepared to deal with hearing about the wonderful filters on Parliament cigarettes.

APEX and the 404

Need to muck about with 404 errors from APEX? The Inside Oracle APEX blog has a good article for you.

And since this is the weekend edition, here's a collection of fun and useful 404 pages from a contest over at Smashing Magazine.

This is one of my favorites for a support approach. It goes about trying to establish blame, even providing a flowchart.

Thursday, April 3, 2008


Hyperion Community Discussion Forums - Business Intelligence Foundation Hyperion Essbase

This is a very active discussion forum that covers Hyperion Essbase and tools, including Essbase Administration Services, Essbase Integration Services, ASO, BSO, Hyperion Visual Explorer, Smart View for Office, and respective administration/development topics.



Siebel System Requirements and Supported Platforms & Miscellaneous Documentation

The purpose of this section is to provide you with information that will help you in planning the installation or upgrade of your Oracle's Siebel applications. You will find release-specific information here.

Siebel Discussion forums

Check out the latest threads in the Commmunity Discussion forums for Siebel. While Siebel Technology section here is most popular but if
you are doing anything with the Siebel Diagnostic Tool then check this out as well.

Oracle Updates

White Papers
Oracle Database 11g Architecture on Windows
Oracle Database 11g for Windows provides an optimized database solution for deployments that require enterprise scalability, reliability, and high performance.

Oracle Database 11g Application Development
The modern IT organization uses multiple application development languages and tools. This white paper outlines how Oracle Database 11g provides a single integrated platform, offering high performance and scalability for most popular technologies.

Outlasting the Competition: Why High Availability is Critical to Midsize Businesses
This white paper identifies the decision factors in moving to a high availability solution, and how Oracle Real Application Clusters provides a fault-tolerant, scalable and cost-effective solution for growing businesses.


The Latest Updates to Oracle's Applications Strategy
Ed Abbo, Senior Vice President of Oracle's Applications updates listeners on the exciting innovations within Oracle Applications, how Oracle is integrating all its new product lines and why customers should adopt the latest releases.

Wednesday, April 2, 2008

Performance and Storage

Better Performance Through Caching

Kevin Closson, an authority on storage and performance, thinks well of Gear6, as he mentions at his blog here. There are several hardware solutions traditionally used when dealing with a performance problem:

  1. Throwing CPU at the problem. Rarely helps, plus the CPUs are made of silicon and tend to break when thrown at the problem.
  2. Throwing disks at the problem. Much louder than solution one, but only works if you were actually short on disk space, not just trying to throw something at the problem.
  3. Increasing caching. Okay, now we're getting somewhere. If you can cache more data AND design the application to make use of that cache you may actually improve things.
Gear6 helps you with adding caching to an existing system. Intriguing.

Tuesday, April 1, 2008


Changes at Hotsos

Wow, this was a surprise. Doug's Oracle blog just found that Cary Milsap is leaving Hotsos and founding his own company (well, another of his own companieis, Hotsos was his company). See the details here on Cary's blog.

BIP and APEX, Security, ADF


Tyler Muth's blog has an article that combines two of our clients' areas of interest: Calling BI Publisher Web Services from APEX.


Bex Huff blog brings us a link to the Oracle/Stellant security survey at IOUG here.

JDeveloper and ADF

Have you looked at the Diving into Oracle ADF blog lately and the great sample application (with lots of useful 'grotty technical details')?

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.