Bas Klaassen
(0 comments, 13 posts)
This user hasn't shared any profile information
Posts by Bas Klaassen
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 wants to install IE7 again. On Metalink I found the following tool from Microsoft. It’s a IE7 blocking tool, so the automatic updates are installed, but IE7 is not.
Download the exe form the following site ….
After installing the .exe, 4 files are placed on your computer.
When executing the IE70Blocker.cmd, a new registry key is created which prevents IE7 from being installed by the next automatic update…
From the command prompt
C:\>IE70Blocker /B
MICROSOFT TOOL KIT TO DISABLE DELIVERY OFMICROSOFT INTERNET EXPLORER 7
Copyright (C) Microsoft Corporation. All rights reserved.
Blocking deployment of Internet Explorer 7.0 on the local machine
The operation completed successfully
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)
According to this note Oracle has its own config file to transfer Alerts using FNDLOAD. This note was not present at the time I needed it, but seems to be now. Still, there are a few things I don’t understand :
Why is the alert config file (alert.lct) not present in the $FND_TOP/patch/115/import , where all the other config files are placed ?
Why is Oracle Alert not mentioned in any FNDLOAD documentation on Metalink ? For example, note 274667.1 shows us all the data types that can be downloaded using FNDLOAD..but an Alert is never mentioned.
It seems I have done a lot work for nothing, but at least I learned how FNDLOAD works in detail.
I suggest that everybody who wants to transfer Alerts using FNDLOAD, uses the Oracle config file ($ALR_TOP/patch/115/import).
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 have tested the new/adjusted Alert, Oracle offers you a way to transfer the new/adjusted Alert from your test database to your production database. When signing in the Oracle Alert module as the Alert manager, there is a function called ‘Transfer Alert’, which allows you the transfer an Alert from one database to the other. This transfer works with a database link.
There are a few disadvantages when using this method to transfer Alerts to the production database.
- There is no version administration, you do not know what version is in the production database.
- What if somebody is changing the Alert in the Test environment……then this change is also transferred to production.
- Before uploading an Alert, you must first delete the Alert in the target database
I was asked to find out if it was possible to transfer these alerts using the FNDLOAD tool from Oracle.
FNDLOAD is a concurrent program that can move Oracle Applications data between database and text file. FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database. Conversion between database format and text file format is specified by a configuration file. But i could not find anything regarding upload/download of an Oracle Alert. So, my conclusion was that i must be possible to use FNDLOAD to transfer Alerts, but that there is no configuration file provided by Oracle. I had to create a configuration file myself.
(more…)
Recent Comments