Patch Set Update: Oracle Smart View

by | Aug 18, 2015 | Finit

Finit has delivered solutions for the office of finance 20 years, beginning in 2002 with a focus on Oracle EPM. In 2011, we were the first OneStream implementation partner and delivered the first OneStream solution to go live. We no longer offer consulting services for Oracle EPM. However, the functional experience and technical expertise built from this experience form the foundation of our industry-leading OneStream practice.

The new feature of note in this version is Financial Managment Journals Extension Support.  The Oracle Journals for Financial Management extension works with Smart View version and later, and with Oracle Hyperion Financial Management and later.


  • The Smart View executable installer file can be used to install with both 32-bit and 64-bit versions of MS Office
  • When upgrading from release and earlier, or from a Smart View Patch Set Exception (PSE) release, Oracle recommends uninstalling Smart View before installing release
  • Where using 64-bit MS Office, and using either Hyperion Planning or the Smart View migration utility function, refer to the PSU Readme for related information

Backward Compatibility

Smart View supports the EPM System product versions listed in the Release Compatibility tabs in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on OTN:


There is no documentation other than the ReadMe available at this time. When it is published, Oracle will make it available in the Oracle Help Center

Essbase Fixes

  • Starting with Smart View release, you can now perform Smart View Undo and Redo operations on a grid within a multiple-grid worksheet by using the right-click menu. On a multiple-grid worksheet, right-click on a cell within the grid on which you want to perform the Undo or Redo operation, then select Smart View, and then Undo or Redo.
  • A user with access privileges to an Oracle Essbase database is unable to create a Smart Query when connected to that database.
  • Smart View refresh on multiple-grid worksheets fails when the sheet name contains a single quote (‘).
  • Using a mix of dragging the mouse and pressing the Ctrl key to select a range of members for zooming in causes duplicate members to display.
  • The HypZoomIn function does not work when the active sheet is not connected, even though a connection was made on a previous sheet.
  • In some cases, when using a private connection with an ASO application, some ad hoc functionality, such as Zoom Out, Keep Only, and Remove Only, was not working.
  • When performing ad hoc analysis against an Essbase data source, custom headers or footers are not displayed correctly in print preview.
  • Users cannot submit #MISSING values using the Submit Data option, and must use the Submit Data Without Refresh option instead.

Financial Management Fixes

  • When opening a form for the first time in Smart View, the preferences set from Smart View are honored instead of the preferences set in the Financial Management web application.
  • For Financial Management data sources, HsSetText sends 0.000000 instead of cell text that HsGetText retrieves in the same sheet.
  • Member search in the Member Selection dialog box doesn’t yield any results when working with Web Data Entry Forms.
  • POV Manager does not display the dimension members for data points pasted in PowerPoint.
  • If a web form contains the @Cur function and is saved locally as a sheet, and is then reopened in Smart View, an “Invalid Dimension ID” error occurs when data is submitted.

Relevant Links

Subscribe To Our Blog

  • This field is for validation purposes and should be left unchanged.