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...]
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...]
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...]