I noticed Oracle Applications Manager has some very handy sql script you can use when monitoring your EBS environment. When starting up OAM, navigate to Site Map —-> Monitoring —-> SQL Extensions The following scripts are available… There is also a way to add your own personal sql scripts to […]
Bas Klaassen
invalid oraInventory in Oracle e-Business Suite
When running the http (CPU April 2007) patch on the Oracle EBS 11.5.9, I received some errors…It seemed the oraInventory was not valid, at least the http entry was missing. The oraInventory that was incomplete was the global oraInventory. I noticed that the local oraInventory in the $IAS_HOME was complete, but […]
Autoconfig templates ?
The company I work right now uses autoconfig. No problem off course, but they also have a lot off custom templates. Autoconfig uses templates to generate the configuration files so the EBS can work properly. When you want to add customizations the a template, you place that template in the […]
Oracle E-Business Suite R12 with OEM10G
After configuring the Oracle EBS 11.5.10 environment in OEM10G, it was time to also configure the new Oracle EBS R12 environment in OEM10G. Before I could configure R12 in OEM10G, I first had to upgrade the Oracle Applications plugin for EM10GR3. I downloaded the patches p5489352_R12_LINUX.zip and installed this patch […]
First patch for Oracle E-Business Suite R12
This morning I downloaded my first patch for the new Oracle EBS R12. Already there are 2 high priority patches for the new EBS, and I downloaded one of them (patch p5856453_R12[1].AD.A_R12_LINUX.zip). I could not help feeling a little bit excited, because patching is changed in EBS R12. The manual […]
Installing Oracle E-Business Suite R12
So, I finally installed the new EBS 12i release. I had to install with an empty database, because of disk space limits…But the important thing is that the installation was successful. Some first impressions…– the look and feel changed (we had already seen some previews..)– some strange options when logging in […]
Sizing Oracle EBS 12i
I wanted to find out how ‘big’ the new Oracle EBS 12i release really is. So, I downloaded the software from Edelivery and created a stage area. From the stage area I started the rapidwiz to check the required disk space. Here is the required disk space for Oracle EBS […]
FNDCPASS ALLORACLE
FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other schema in the EBS database. FNDCPASS can also be used to change the password of an application user (like sysadmin). To […]
Upgrading EBS 11i database (9.2.0.6) to 10GR2 database
I have upgraded my EBS 11.5.10 database (9.2.6.0) to release 10gR2 (10.2.0.2.0). I have followed note 362203.1 from Metalink to perform the upgrade. Here are some tips or problems I ran into… 1. The first patch is 5478710 (TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH O) After applying the patch […]
Changing background in Oracle EBS 11i
It would be nice to have your own company logo as background in the Oracle E-business suite. Default the background is white, but the following steps will put your company logo (or any other logo…) in the background. 1. modify the appsweb.cfg in the $OA_HTML/bin directory. Find the ‘background’ parameter […]
IE7 blocker
After my last automatic update on Windows XP, suddenly Internet Explorer 7.0 was installed instead of IE6. From that moment on, I had some problems when I wanted to start an Oracle EBS 11i session…I decided to uninstall IE7. After the uninstall, IE6 returned….But also my ‘install updates’ icon !!! Windows […]
FNDLOAD Oracle Alert
A month ago, I posted an article on this blog how to transfer an Oracle Alert using FNDLOAD. At the time, there was no documentation online about this, so I had to make the config file myself. This morning I was searching Metalink and ran into the following note 376891.1 (dated 14-JUL-2006) […]
Using FNDLOAD to transfer Oracle Alert
When you use Oracle Alert, a module from the Oracle EBS, you probably work with custom alerts next to the standard alerts provided by Oracle. When working with custom alerts, their will be changes to these alerts and those changes must also be applied to your production environment. Once you […]