Smart View
Discussion List
-
I can't create new journals in Smart ViewSummary: The journal template dropdown list does not appear when creating a new journal entry Content (required): in new ad hoc I have the period available but the templ…Ana Laura Arguello 11 views 4 comments 0 points Most recent by Ana Laura Arguello Financial Consolidation and Close -
What's New in EPM Cloud Release 21.09Summary Learn about what's new in EPM Cloud Release 21.09.Content Please refer to the September 2021 What’s New guide to understand the new features included in EPM Clou…Laura Ferris-Oracle 9 views 2 comments 3 points Most recent by David Samaniego Financial Consolidation and Close -
Can I link underlying workings to a SmartView upload file?Summary: We are new to FCCS and a lot of our users have existing working files that they want to use as a data source to load to FCCS using SmartView. The users want to … -
Is there for an easy way for users to migrate forms in smartview when service URL changesSummary: Our production FCCS is moving - same domain just different service. Our users are using forms to load movement analysis from smartview. Can the forms easily be …Jeremy Stubbs 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Importing closing balances to consolidateSummary: We have FCCS module to use but have been unsuccessful in executing data. The main issue is just trying to get data imported to run a consolidation. I can perfor…Hiren Kantilal 1 view 1 comment 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
How will documents uploaded to cloud be stored?Summary: Content (required): With Dec 2021 update announcing that documents can be uploaded to cloud, will these be backed up in snapshot? will they be lost during app r…MrKellyGreen 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
SmartView drill down functionality issue - Chrome extensionSummary: SmartView template is based on Shared connection, running a Adhoc Analysis. While using the drill through functionality, a new chrome browser opens up but it le…wilson.chelakadan 1 view 1 comment 0 points Most recent by JoachimB Financial Consolidation and Close -
FCCS View Dimension security wiped out after release patch applied 21.04.62Content Last Friday PROD environment was patched to 21.04.62 and it wiped out security in View dimension. We have faced this same issue for 21.02 release patch. Just wan…
-
Why does the dimension member change to Dimension name after a Smart view refreshSummary: Ad-hoc Smart view. Extended dimensions. One dimension reverts to the TOP Dimension member upon refresh. Need to reselect the dimension member needed and refresh…Catherine Arnold 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Smart View Add-On for AdministratorSummary: On one PC I am not able to use this add-in. When I right-click on the dimension to edit, nothing happens. This used to work on this PC. I have tried uninstallin… -
Need advice on creating Dashboard for Current Year and Previous Year data togetherSummary: I have a requirement to create a dashboard for some of the KPI accounts. It should display data for the current month and 5 previous months (with comparison aga…TarunG-Oracle 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
User Excel Addin Ribbon - Replicating the Excel Ribbon I Built Years Ago For Smart ViewContent I have been asked for years to create a ribbon for Smart View that replicates some of the functionality of the Essbase Ribbon I built way back when. I have avoid…Kyle Goodfriend, In2Hyperion-Oracle 23 views 8 comments 5 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Financial Consolidation and Close -
Drill Thru issues in Smart View and FormsSummary: It is Flat flie data, i enable YES in the drill region and drill summary in application options, in the process details it green tick marks. but when i drill th…Nagarajan Mouttouvelou 11 views 1 comment 0 points Most recent by Nagarajan Mouttouvelou Financial Consolidation and Close
-
SmartView Query DesignerSummary: This month we moved our FCCS production environment from Classic environment to Gen 2 EPM Environment and having SmartView Query Designer issues connectioning t…
-
Performance issuesSummary: Performance in running consolidation, translation and SmartView use has become seriously bad since 1 week and has become even worse this week Content (required)…Alie van Davelaar 11 views 2 comments 0 points Most recent by Rich Wilkie-Oracle Financial Consolidation and Close
-
FCCS / EPBCS Adhoc Queries to @HSGETVALUEContent Hi Is there any easy way to convert existing SmartView Adhoc query to a series of @HSGETVALUE function calls. It would make building out some reporting so much e…
-
Using Substitution Variables in Data Exchange FilesSummary Using Substitution Variables in Data Exchange FilesContent Hi- Is there a possibility to use substitution variable as a suffix in Data Exchange output files? We …Amit Agarwal-158816 5 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS: Movement dimension with Dynamic Calc on Member Formula is slow to refreshContent Hi all From Oracle suggestions: https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/agfcc/working_with_member_formulas_sui.html It is not recomme…Nkehli 19 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Export a particular journalSummary Export a particular journalContent Hi- Is it possible to export a particular journal from last period? We have a journal posted in last month which goes in more …Amit Agarwal-158816 17 views 5 comments 1 point Most recent by DISHIL SHAH Financial Consolidation and Close
-
Data entered via Smart View is getting cleared after running ConsolidateContent Edit: The issue was that the Movement member that we were using was set to Enable Dynamic Children. I'm assuming that by having this set to Yes, it was essential…Matt Maurer 13 views 4 comments 1 point Most recent by Matt Maurer Financial Consolidation and Close -
SmartView performanceSummary Very bad performance when refreshing SmartView sheetsContent We are facing extreme long refresh duration of retrieve sheets in Smartview > 13 min of 1 sheet and …Alie van Davelaar 23 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Exchange Rates Form having issuesSummary Cannot load rates using the provided forms or adhoc form after recent patchesContent Hi, when trying to load exchange rates using webform and or a smartview adho…Jeremy Stubbs 11 views 2 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close
-
Scaling options for SV in Powerpoint/WordContent Hi All, Has any one found a solution to being able to use scaled numbers when copying and pasting data points from SmartView in Excel to Powerpoint or Word? I am…Preston Oakes 8 views 4 comments 0 points Most recent by Preston Oakes Financial Consolidation and Close -
Retained earnings closing balance of FY20 not equal to opening of FY21Summary Retained earnings closing balance of FY20 not equal to opening of FY21Content Hi- We came across an issue where the "Retained Earnings Current" closing balance o…Amit Agarwal-158816 22 views 0 comments 1 point Started by Amit Agarwal-158816 Financial Consolidation and Close
-
Question on simplified dimension editor and shared member hierarchyContent In our test app (21.04) I'm trying to add a member (shared-account) to an alternate hierarchy. I tried first with the classic editor but although this appeared t…Jeremy Stubbs 16 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Round ReportSummary Rounding ProcessContent After completing the consolidation process, for reporting purposes, we need to apply a rounding at the account level. Not only applying s…Carolina Rodríguez Fleming 29 views 3 comments 0 points Most recent by Carolina Rodríguez Fleming Financial Consolidation and Close
-
Consolidation Enable Features - QuestionSummary Consolidation Enable Features - QuestionContent Hello Everybody, I have a question related to Consolidation Enable Features. I need to enable "Translated Currenc…Antonio Barbaro 23 views 3 comments 0 points Most recent by Keith Glide Financial Consolidation and Close -
How to Search/Navigate from SmartView for an Journal input intersection to the Journal Entry postedContent If a users see any intersection in SmartView with data source as Journal Input, users find very difficult most of the time to figure out the Journal entry and it… -
Smart View Retrieval Time on LTM Members in FCCSContent Hi folks, Hoping someone may be able to assist with what I feel should be a simple calculation (I'm very new to coding member formulas in FCCS). I have created L…Stefan Fisette 15 views 4 comments 0 points Most recent by Stefan Fisette Financial Consolidation and Close
-
Data Export using Data Exchange in FCCS as a fileSummary Data Export using Data Exchange in FCCS as a fileContent Hi Friends, I am exporting data from FCCS in a file using Data Exchange Option. The file contains the da…Amit Agarwal-158816 27 views 3 comments 1 point Most recent by Amit Agarwal-158816 Financial Consolidation and Close