OK, so there are a ton of things to do right after a fresh R12 install. And before anyone says anything, I know each of my steps has multiple steps; I though 6 things made a simpler blog title, that's all. Nevertheless, below are the major tasks I think every Apps DBA should do right away before letting anyone log in. I call these out for two … [Read more...]
9 reasons why the new Metalink sucks
I know I’m not alone, and I know I’m not the first to express displeasure, but let me just say: AAAARRRRRRRGHHHH!!!!! I’m going to call the new Metalink “Metaflash.” Seems like a good name for it. It combines “meta” and “flash” which sounds really hip and technical, yet communicates nothing. Kind of like shoving “i” or “e” in front of a … [Read more...]
Linux is the only choice for the E-Business Suite application tier
Some single points of failure are often unnecessary with Oracle E-Business Suite. By design, application code may easily run on multiple, inexpensive x86 (or x86_64) nodes running Linux. I often see organizations spending lots of money on commercial, internally redundant application computing nodes when they could be spending far less while … [Read more...]
FRM-40501: Could not reserve record [2 tries]; Oracle Apps Record-Locking
One of your end users attempts to modify a record, and the user is prompted with a dialog box asking "Could not reserve record [2 tries]. Keep trying?" The user answers "yes" and after being prompted a few more times the user gives up. Ultimately the user gets a "FRM-40501: ORACLE error: unable to reserve record for update or delete." When … [Read more...]
What should I check after bouncing E-Business Suite?
As an Oracle Apps administrator, it's a good idea to have a punch list of things to check after your applications have been started, to ensure all services are working correctly. For Release 11i, the following steps are a good starting point. It will take a few extra minutes to work through this list, but it's certainly more aggravating to get … [Read more...]
FNDCPASS doesn’t always use the SYSTEM password
FNDCPASS does not check the system password when used to change an applications user account. We can check this with a simple test. First, we’ll change the SYSTEM password to the default value “manager”: … [Read more...]
Seattle-area Oracle Applications Tech Group
Announcing the first meeting of the Seattle Oracle Applications Technology Group! This group will be dedicated to knowledge sharing and learning between Oracle Applications Technology professionals in the Puget Sound area. I'm hopeful we can get a regular group of Apps DBAs, developers, Apps admins, and other people connected with E-Business … [Read more...]
Firefox 3 certified against E-Business Suite
Steven Chan posted on his blog yeterday that Oracle has announced certification of E-Business Suite and Firefox 3. There are some pre-requisites which should be carefully reviewed, but this is great news for E-Business Suite customers pining to get off of Firefox 2. The framework patch 7651759 in particular specifically targets Firefox 3 users … [Read more...]
Phase in the Sun JRE plug-in
By now you probably know error correction support ends for JInitiator for E-Business Suite on July 31, 2009 (see Metalink note 552692.1). There has been a lot of strong encouragement from Oracle to migrate to the Sun JRE Native plug-in prior to the de-support date: Note 393931.1: Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle … [Read more...]
Proactive Maintenance for Oracle E-Business Suite
As a remote services provider, often we are often asked to provide proactive maintenance support for clients. For the purposes of this discussion, I’m going to separate operational support form maintenance support. Operational support surrounds management of the application operations, as they exist. For example, if I’m running 11.5.10.2 on … [Read more...]