Author Archives: jpiwowar

Oracle Apps 11i: Back to the future

Should you be unlucky enough to have to install an 11i Vision instance in these more advanced days, here’s a roadmap to updating the database and tech stack afterward.

Changes

Fall is my favorite time of year. In part, it’s because of the weather where I grew up: muggy Pennsylvania summer and late-summer thunderstorms give way to crisp mornings, sometimes-warmish afternoons, and cool evenings. The air smells of wood smoke and dried leaves, and the colors of the sky and the trees are fantastic. Autumn [...]

Fun with EBS APIs, part II: Users and responsbilities (FND_USER_PKG)

A quick look at some of the things you can do with the API provided by the FND_USER_PKG package in E-Business Suite.

Fun with EBS APIs, part I: Profile options (FND_PROFILE)

A short demonstration of the use of the FND_PROFILE API in Oracle E-Business Suite.

Oracle Instant Client on OS X Lion: 32-bit only, for now

Upgrading to OS X Lion? Like using command-line sqlplus? Prepare to roll back.

NOW they’re fixed…

A short demonstration of how incorrect fixed object stats can really bog down an E-Business Suite instance startup.

LISP

After my recent public demo of the Oracle E-Business Suite Diagnostics, people at my current employer are more interested in using the tool. In the course of applying the most recent patches to the IZU product, I came across a few quirks that I thought I’d share. These are 11i-related issues, so the relevance half-life is short.

Oracle Apps DBAs, have you empowered your users?

A little bit of preachiness about the value of the Oracle E-Business Suite Diagnostics product. Hopefully, you’re using it. Actually, if you’re an Apps DBA, hopefully your users are using it

Presentation slides: Using Oracle EBS Diagnostics

I somehow got roped into giving a presentation at the BC Oracle Applications User Group meeting on May 26, on the topic of Using Oracle E-Business Suite Diagnostic Tools. Moment of weakness, I guess, but with less than 12 hours to go, it’d be very bad form to bail now. The talk itself is mostly [...]

Why merge EBS patches?

“Everyone knows” that merging E-Business Suite patches is a good idea. It should be the number one, first-pass answer to the question of how to speed up patching, before staged APPL_TOP, distributed AD, database tuning, or even adding more workers. As part of my continuing series, “Captain Obvious over-explains the basics,” I’ve provided an anecdote to illustrate why merging patches is a good idea.