Web ADI allows for a smoother implementation of the excel integration and a central control instead of on every desktop. There are a couple of settings in Excel (like the old ADI) and in Internet Explorer (new settings) to enable the functionality to work smoothly.
Web ADI can be used to create journal entries and to download and upload Budget data.
For Oracle Web ADI to work with the new functionality you must change some configurations in Excel and IE.
The next section consists of a couple of steps that need to be taken to ensure that Web ADI will work as expected.
Here is how you would set the properties to be able to use Web ADI to allow you to create the template.
In Excel 2003 follow the given steps:
Tools | Options.
Click on the tab for Security.
Click on the button labeled Macro Security.
the radio button is set to Medium.
This will always prompt you to enable or disable macros.
Click on the tab Trusted Publishers and make...