Checking fnd_user_preferences
In Oracle’s Enterprise Business Suite (EBS), the fnd_user_preferences table contains some important parameters related to identity management. These are mostly set when you register an EBS instance with a 10g AS (Application Server) identity infrastructure (i.e. using the txkrun.pl script).
Some of the parameters you’ll see are OIDhost, OIDport, SSLOnly, appname.
This information can be helpful in [...]
DBD::Oracle and cron
So, everyone knows that cron runs things with absolutely no user environment at all. Well, not exactly. On Linux, for example, It actually uses the “default” environment that probably includes “PATH=/usr/bin:/bin” and little else. As a result launching any kind of script using cron can be a problem.
I recently ran into this when trying to [...]
What’s the system time on that db?
Needed to check this today to make sure an apps db wasn’t out of sync with its corresponding infrastructure partners.
SQL> SELECT TO_CHAR(SYSDATE ,
2 ‘Dy DD-Mon-YYYY HH24:MI:SS’) as
3 “Current Date/Time” FROM DUAL;
It’s little stuff like this that can make you crazy.
NTP was invented back around 1980 by Dave Mills at the University of Delaware. [...]
Reporting tablespace usage
Thanks to V.S. Babu for this neat little SQL script that gives a quick enumeration of tablespace usage perfect for harried Oracle Internet Directory admins. I found this code in one of V.S.’s posts entitled Tablespace Information. V.S. has a whole section on Oracle administration and development that is worth a look.
For OID admins I [...]
Tuning Oracle Internet Directory
Short of taking hostages from the Oracle consulting team before the production turnover of your first OAS (Oracle Application Server) 10g implementation, anyone responsible for an environment dependent on Oracle Internet Directory (OID) is going to have to familiarize themselves with the basics of managing what is a remarkably complex RDBMS-backed LDAP directory server.
For those [...]
Last login date for Oracle SSO users
No, this post won’t reveal that secret date known to all President’s since 1948 as to when the aliens will return.
ORASSO.WWSSO_AUDIT_LOG_TABLE_T records every login by users authenticated through Oracle 10g Application Server (OAS) SSO. This table lives in the Infrastructure Metadata Repository database. Records go back as far as the last time it was truncated, [...]
Selectively nulling USER_GUID values on EBS
Two previous posts ( this and this) dealt with nulling USER_GUIDs in the FND_USER table on Oracle’s EBS (Enterprise Business Suite) in a post clone situation. This is done for the purpose of getting synchronization between EBS and OID (Oracle Internet Directory) working. In this post I’ll share a technique discovered by my colleague Carl [...]