1. Working with Oracle Smart View for Office
  2. Finding Information
  3. Frequently Asked Questions (FAQs) about Smart View

Frequently Asked Questions (FAQs) about Smart View

This FAQ provides links to helpful resources for frequently asked questions about Oracle Smart View for Office.

Frequently Asked Questions

Where can I find the Smart View Support Matrix and Compatibility?

Find information on Smart View support matrix and compatibility in the following topics:

Is Smart View compatible with Microsoft Office 32-bit and 64-bit versions?

Yes, Smart View uses a single installer for 64-bit and 32-bit versions of Microsoft Office. During Smart View installation, the installer automatically detects the corresponding Operating System and Microsoft Office bit type and installs accordingly. For more information, see About Installing Smart View in Oracle Smart View for Office Installation and Configuration Guide.

What is the impact on Smart View with Microsoft decommissioning Internet Explorer 11 on June 15, 2022?

Get information and recommendations on this in Internet Explorer 11 End of Support and Smart View in Oracle Smart View for Office Installation and Configuration Guide

How to address a provider error in Smart View ad hoc analysis?

Verify your connection URL syntax and credentials, and clear Smart View cookies. Find information to address this in these topics in Oracle Smart View for Office Installation and Configuration Guide:

While performing ad hoc analysis, if an error appears similar to "Ad hoc grid cannot be opened as there are no valid rows of data" then, clear the Suppress Rows, Suppress Columns, and Suppress Missing Blocks options in Smart View Options dialog. For more information, see Starting Ad Hoc Analysis in Oracle Smart View for Office User's Guide.

How to address a Member Out of Place error when refreshing a Smart View ad hoc sheet?

To resolve this error, try the following:

  • After copying content from one ad hoc sheet to the other, use the Smart View Import Metadata command to ensure that additional metadata is carried over to the other sheet. For more information, see Importing Metadata in Office Applications in Oracle Smart View for Office User's Guide.
  • Set the required alias table at the private connection level, so that it is applied by default every time you open the connection. For more information, see Selecting an Alias Table for the Connection in Oracle Smart View for Office User's Guide.
  • In the row drop-down member selector in forms, you can now enter and submit data without facing this error. When selecting and working with shared members or members associated with duplicate alias names, the drop-down member selector now displays member names for shared members and duplicate aliases, not their qualified or distinct alias names. For more information, see Using the Drop-down Member Selector on Row Dimensions in Forms in Oracle Smart View for Office User's Guide.

How to prevent Smart View from failing when clicking outside a modified cell in a form?

Starting Smart View Release 21.110, Excel no longer terminates intermittently after entering data in a form and clicking outside the modified cell. Please ensure that your Smart View version is updated to release 21.110 or later.

How to clear Smart View and WebView2 cookies?

Occasionally, you may need to clear Smart View cookies and WebView2 cookies to facilitate signoff and subsequent login processes. Clearing cookies also works if you are not getting the login dialog in Smart View for connecting to your business processes. For more information, see the following topics in the Oracle Smart View for Office Installation and Configuration Guide:

How to address the HTTP Error with Code -1 connection error?

Smart View may fail to connect to Planning or Planning Modules with the script error, 

An HTTP error occurred with the code "-1"

To resolve this error, see the workaround suggested in Connection Error in the Oracle Smart View for Office Installation and Configuration Guide.

How to prevent HTTP session timeouts?

HTTP session timeouts can occur, for example, when working with large queries that take a long time to run, or when you're experiencing slower internet connections. To prevent HTTP session timeouts, you may add DWORDS values to the Internet Settings key in your Windows Registry as explained in Smart View HTTP Session Timeout in the Oracle Smart View for Office Installation and Configuration Guide.

How to limit memory usage, prevent instability, and improve performance in Smart View?

Smart View is a Microsoft Office add-in. As an add-in, it is loaded in to the Microsoft Excel process. When a report is imported into Excel through Smart View, the Excel process consumes memory and this can negatively impact performance.

To limit memory usage and improve performance, you can take the actions listed in Performance and Memory Usage Considerations for Smart View with Excel in the Oracle Smart View for Office Installation and Configuration Guide.

Some third-party tools monitoring Microsoft Office, such as MacAfee or Trellix, may also interfere with Smart View and cause stability issues for Office and Smart View. For workaround, see Third-Party Monitoring Tools May Impact Smart View Stability in Oracle Smart View for Office Installation and Configuration Guide.

How to enable and disable Smart View and Office Add-ins?

You can enable and disable Smart View and other Microsoft Office add-ins from the Add-Ins tab in Excel Options. In some cases, Smart View performance can be improved when other Office add-ins are disabled. For more information, see Enabling and Disabling Smart View and Other Office Add-ins in Oracle Smart View for Office Installation and Configuration Guide.

How to prevent Excel from failing on using the Disconnect All command while using WebView2?

If you are using WebView2 and have issues with the Disconnect All command not working or Excel failing during a Disconnect All operation, try adding the registry flag, PreserveThirdPartyCookies, and set it to "0" as explained in WebView2 and Disconnect Issues in Oracle Smart View for Office Installation and Configuration Guide.

Why is it necessary to enable the .NET installation option while installing Microsoft Office?

During Microsoft Office installation, you must enable the .NET installation option. When enabled, files are placed in your Office installation that support interoperability between Office and other programs and add-ins, such as Smart View and Smart View extensions. For more information, see Office .NET Installation Option Requirement in Oracle Smart View for Office Installation and Configuration Guide.

Why Smart View should not be installed in the Windows Program Files Folder?

On Windows operating systems, such as Windows 10, non-administrator users are not authorized to modify the Program Files folder or the Program Files (x86). If an administrator installs Smart View in Program Files or Program Files (x86), a non-admin user will not be able to uninstall Smart View.

The default installation folder for Smart View is C:\Oracle\SmartView. Oracle advises that you do not install in Smart View in the Program Files or Program Files (x86) folder. For guidelines and procedure on installing Smart View, see Installing Smart View in Oracle Smart View for Office Installation and Configuration Guide.

How to use diagnostics tools and perform health checks in Smart View?

When an issue arises while using Smart View that you cannot resolve on your own, use the Smart View Diagnostic tools to create and collect log files and screenshots to send to Oracle Support. You can perform a "health check" on your system to optimize performance and to get information about your machine, Microsoft Office version, Smart View version, and the extensions you have installed.

For more information, see the following topics:

How to ensure that all Office applications are closed while installing, updating, or removing extensions?

For extensions to be properly installed, removed, or updated, all Office applications must be shut down. If any instance of Office is still running, Smart View is unable to apply the extension updates correctly. To check if all Office instances are closed properly, open the Windows Task Manager and look for Office application names as explained in Extension Updates and Office Applications Remaining Open in Oracle Smart View for Office Installation and Configuration Guide.

How to clean up any extension installation issues?

While installing extensions, the installer message window indicating success or failure status may sometimes lose focus and hide behind other open windows. The inability to see the status message may lead users to try installing the extension again, causing an error due to the previous open message window having a hold on the folder and files. To clean up such extension installation issues, first remove prior and pending extension installations trying the installation again as explained in Extension Installation from EPM Cloud and Message Window Focus in Oracle Smart View for Office Installation and Configuration Guide.