12.2 Web Adi Template Is Saved Every Time The Macros Are Enabled (Doc ID 2160193.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Symptoms

Occurs in R12.2 but not 12.1

The customer creates and then saves their Web ADI Excel templates to a network drive so multiple users can use the same Web ADI template.

Each time a user opens the template from the network drive, when the new template is opened, it automatically saves a new version of the template to the users local desktop. This automatic save process is causing a couple of problems:

1. They have thousands of rows of data in the spreadsheet and this unnecessary Save process is taking a longer amount of time for the template to reopen because of the Save overhead.

2. When the user opens the excel file, they see the green progress bar at the bottom of the Excel spreadsheet that says: Saving bneradA637C.xlsm...
As mentioned above, it is automatically saving a new copy of the xlsm file to a local folder (A local folder that the user last saved a file to), which causes multiple versions of the template being saved on the users desktop - each time they open the template from the network drive it saves a new
version on the users desktop. These multiple files on their desktop is causing confusion for the users.

Steps to reproduce the issue on an internal 12.2.4 Vision instance:
Desktop Integration > Create Document
Integrator General Ledger - Journals
Viewer Excel 2010
Reporting No
Layout Functional Actuals - Single
Content None

Create
Open
Enable Macros
Insert Worksheet
Add a bunch of rows - this is to slow down the opening of the Excel file when we reopen it.

Enter 1 in Row 1 Column 1
Ctrl+C to copy the 1 in Row 1 Column 1
Ctrl+Shift+End and the Down Arrow to move to the end of the column - row 1048576.
Ctrl+V to copy the 1 into all of the rows for Column 1
Save as a XLSM spreadsheet on your desktop.
Close the spread sheet.
Now reopen the spreadsheet.
On the bottom right of the spread sheet you will see a green progress bar that says opening.
At the top of the spread sheet you will see: Security Warning Macros have been disabled with an Options... button.
Click on the Options button, Enable this content > Ok
You will see a green progress bar at the bottom of the Excel spreadsheet that says: Saving bneradE16BD.xlsm..

Similarly, when you open a previously saved .xlsm Web ADI template from your desktop,  enable macros, you will see that the date and time stamp on the file system on the desktop will get updated to the current date and time. 

Changes

 New Install of R12.2

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.