Tag Archives: tools

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.

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

Finding debug and trace profiles in EBS

Two recent requests in rapid succession (“why is the instance running so slowly when I do X?” and “why is this mount point filling up with .dbg files?”) prompted me to dust off an old script.

Christmas comes early: SQL Developer Data Modeler now free(r)!

One the eve of Oracle OpenWorld, Oracle sneaks in a licensing change to one of its products. Take off your cynic’s cap, darn it, they just made something free: SQL Developer Data Modeler.

Recently relevant (to me) links

A handful of interesting links, while I wait for my mental content logjam to break.

Downloading OTN software using wget

One of my most frequently-visited blog posts is Retrieving Oracle patches with wget. Recently, a commenter asked about using wget to download software from Oracle Technet (OTN). It’s a little more complicated to use wget to download from OTN, because there are cookies involved. This post discusses how to extract the relevant cookies from Firefox and Google Chrome, and use those cookies with wget to retrieve files.

Compiling JSPs in EBS? Try being selective first.

If you’re in a position where you need to compile some of the JSPs in your EBS system, consider whether you need to compile them all, or can get away with compiling just a few.

Unix shell geekery: Finding the ten largest residents of a directory

Strange things can happen when people ask themselves a question and are unwilling to let go of it. Some retreat into seclusion to ponder the meaning of life. Some waste hours reading ultimately unrelated content on Wikipedia. Some spend way too much time writing marginally (if that) useful solutions to their questions. In this post, I’m guilty of that last one, though I’ve also been known to do the Wikipedia thing. My question? “Hey, if how could I find the largest files and subdirectories in this directory?”