My Oracle Support Banner

Smart View - FAQs and Guidelines (Doc ID 2559453.1)

Last updated on JUNE 26, 2023

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Purpose

This document  helps to clarify the questions related to Smart View.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 1)  How to download and install smart view Client?
 2)  How to Configure Fusion URL in Smart View?
 3)  How to connect to fusion instance  from Smart View?
 4)  What are all the basic roles required to connect from Smart View to Fusion applications?
 5)  What are all the steps required to connect from Smart View after P2T?
 6)  How to Navigate to Smart View addin Excel?
 7)  When creating a Smart View report, the following error shows "Maximum number of rows [25000] exceeded". How to resolve?
 8)  Where can we find the log files for Smart View ?
 9)  How to rectify Essbase connection error in Smart View ?
 10)  Whether Smart View will reflect the segment security role which is assigned to user?
 11)  Users with Custom Role are not able to access Smart view and receive connection error "50239"?
 12)  How to Resolve “Unable to connect to the provider” error?
 13) How to collect fiddler trace for Smart View?
 14)  How Submit Data button functions in SmartView?
 15)  How to show only member description and not Member value-Member description in Smart View?
 16) How to remove cube from Smartview OR How to hide cube in smartview for particular users?
 17)  Is there a way to Auto-Prompt for the newest version of SmartView (in Excel) in Oracle Fusion?
 18)  How to Hide the Data with Zero value and #Missing in Report?
 19)  What is the reason that SmartView report is not displaying segment values as per account hierarchy structure ?
References

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