Smartview
Discussion List
-
How to build a FRS report to show trailing actuals and budget for an entitySummary: We have two separate FRS reports to print 12 month trailing budget and actual, which are working fine. The new requirement is to print the actual for the curren…SuniChacko 25 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Do we really need the BIAdministrator role for the Account Inspector to show balances on parents?Summary: We noticed an interesting phenomena in General Ledger features that are based directly on the balances cubes (Inquire on Detail Balances, Account Monitor, Accou…Thomas De Leeuw 32 views 2 comments 0 points Most recent by Thomas De Leeuw General Ledger & Intercompany
-
Alias tables in SmartviewSummary: How are these created / where are they coming from? Can additional Alias Tables be created? Content (required): In SmartView (Essbase) when switching between Al…Delaney Wastler 43 views 4 comments 0 points Most recent by Bala Murali SV General Ledger & Intercompany
-
Multiple currencies are visible in SmartviewSummary: On test instance, we see the currencies outside of USD and STAT are disabled under Manage Currencies and are also not listed in Manage Reporting Currencies and …
-
Tree Version Start and End DateSummary: Purpose of Tree Version Start and End Date Content (please ensure you mask any confidential information): Can someone please help me to understand the purpose/o…ramesh.sivapalan 72 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to connect to Oracle Cloud ERP in Smartview using HS Functions?Hi, We are trying to connect to Essbase cube of Oracle Cloud ERP via Smartview. Specifically, we are trying to use HS functions (Example: HSGet, HSset). But when we try …Guntuka VenkataKrishna 32 views 2 comments 0 points Most recent by Guntuka VenkataKrishna General Ledger & Intercompany
-
Changing Accounting Calendar from Fiscal to Calendar Year in Oracle FusionSummary I am trying to change our accounting calendar from Calendar Year to a Fiscal Year. Has anyone been able to do this and are there any downstream impacts?Content W… -
What are the privileges required to access smart viewSummary: What are the privileges required to access smart view Content (required): What are the privileges required to access smart view Version (include the version you…Dilip Kumar Ranga 488 views 8 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
Smartview query: There are 2 database connections in smartview and both are visible.Summary:Smartview query: There are 2 database connections in smartview and both are visible when we try to connect to Databsase connection. We want to hide one which is …
-
FRS & Smartview Report helpSummary: In the FRS & Smart View report we have ''AccountingPeriod'' dimension where we can see GL Periods and able to select. But our requirement is to select date rang…
-
When I use zoom it on smartview, can the hierarchy open downwards instead of upwards?Summary: When I open the account hierarchy using zoom it, the parent accounts are placed below the child accounts. Is it possible to change this? Parents are ranked firs…
-
How to create a trial Balance either in OTBI or FRC ?Summary: How to create a trial Balance either OTBI or FRC ? Content (please ensure you mask any confidential information): Hello The company would like to have a trial b…Cesar Saveedra 13 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
View Cash Position Report is not fetching the Closed Booked Balance, Inflow and Out FlowCash Management UI View Cash Position we are not able to see the Closed Booked Balance, Inflow and Out Flow amounts. We have executed the below jobs, but still not fetch…Koteshwar Tippani 32 views 2 comments 0 points Most recent by Koteshwar Tippani General Ledger & Intercompany -
Best practice for AR Aging to TB ReconciliationSummary: Best practice for AR Aging to TB Reconciliation Content (please ensure you mask any confidential information): Currently we see huge difference between AR Aging…Ajay Hareesh 22 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Secondary ledger is not available to select on Inquire and Analyze Balances or SmartViewSummary: We are in the process of creating a secondary ledger. The secondary ledger has been created, chart of accounts created, value sets created, primary to secondary…Nicole Croll 97 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Can a new dimension be added that can be used in smart view and financial reporting studio?Summary: We are on Oracle Fusion Cloud 23C. There is a requirement to add a new dimension to classify an account as GAAP or non-GAAP that can be used in SmartView or Fin…Daisy.Dabandan DS 21 views 2 comments 0 points Most recent by Daisy.Dabandan DS General Ledger & Intercompany
-
Does ADFdi, SmartView and VB Extension for excel supported with Google SheetSummary: Our client is only using Google products and not having MS office products. In this case does ADFdi, SmartView and VB Extension for excel supported with Google …
-
can we include other fields apart from POV dimensions in the SmartView report.Summary: inclusion of additional fields in Smartview reports apart from POV Dimensions like journal source and category in SAAS. Content (please ensure you mask any conf…Priyankagupta_NATWEST 21 views 2 comments 0 points Most recent by Priyankagupta_NATWEST General Ledger & Intercompany
-
Support of Smart View - 23.100Summary: Support of Smart View - 23.100 Content (required): We would like to know if we could install Smart View version 23.100 on Citrix VM within VMware to connect to …Sunil Yerramsetti 58 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle General Ledger & Intercompany
-
Which privilege in role setup allows drill through access to the General Ledger via Smartview?Which privilege in role setup allows drill through access to the General Ledger detail balances via Smartview?luke.syv8 61 views 5 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How to isolate natural account when selecting descendants on account member selection in Smartview?Summary: I am creating a Smartview report and selecting account member from member selection. I want the last level to be displayed without the hierarchy string, so I se…
-
Smartview Hierarchies - Member Selection & naming ConventionsSummary: Using Smartview for Essbase and wondering if naming conventions can be changed and how hierarchy displays are determined. Content (required): In the Member Sele…Delaney Wastler 21 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Can someone help us on how to properly install SmartView to office 365?Summary: All users have recently been upgraded to Microsoft Office 365. As a result their Smartview has been unable to be installed to it. This is causing a major issue …
-
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 141 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How To Allow User To Use Smart View Without Granting BI Administrator Role?Summary: How To Allow User To Use Smart View Without Granting BI Administrator Role? Content (required): Hi All, I have the same question like Doc.2527426.1,but the role…
-
Security featureSummary: Privilege(s) is/are required for making smartview work Content (required): Can you please tell us what privilege(s) is/are required for making smartview work ? …Shubhojit 11 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
SmartView: Display Parent Value Above Child ValueSummary: Hi All, I am trying to create a report in Smartview and even when i select the SmartView option for anchestor postion as TOP. still my parent account always dis…Prasanthkothurii 82 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
Does Scheduled Process Validate and Upload Budgets cause a GL Balances Cube update, impacting users?Summary: Users in Smartview and General Accounting UI Inquire and Analyze Balances received error messages and lost connectivity to GL data (cube) unexpectedly around th…Carol Fergusson 31 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Smart View v 23.1Summary: Will the new features in Smartview v 23.1 be available for ERP users? Content (required): The new Smart View features in version 23.1 show as applicable only fo…
-
Is there any solutions when spreadsheets freezes just before it connects to the environment?Summary: Spreadsheet freezes just before it connects to the environment. Is there any way to handle the following situation besides shutting down Excel? Content (require…Sawako Nishiuchi-Oracle 51 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany