Reports
Discussion List
-
Viewer Roles cannot view data in SmartViewSummary: Viewer roles seem to not able to retrieve data using SmartView - either by formulae or ad-hoc. Content (required): Viewer roles does not seem to be able to view…ThalNP 6 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Display the FCCS_Consol Method as numbers in ReportsSummary: Display the FCCS_Consol Method in Reports Content (required): I have a requirement to display the FCCS_Consol Method in the Report columns for each entity. When…
-
Custom Solve Orders on Mvmt and Consol Removed with 22.5Summary: We had an issue with the latest patch, 22.5, where our custom Consolidation and Movement solve orders were wiped out by the patch. The patch listed a specific s…John_OIiphant 22 views 1 comment 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to get the Excel option in FCCS Reports - Report Format?Summary: Get the Excel option in FCCS Reports - Report Format? Content (required): Is there any way to get the Excel option under Report Format along with HTML and PDF? …ApOK 11 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Making Period and Movement Dense: Report Performance Issues with QTD/YTD ViewsHi everyone, I am looking into making Period and Movement dense in our FCC application and am finding that the QTD/YTD View performance is unacceptable. 1-second Smart V…Matt Maurer 101 views 22 comments 1 point Most recent by Emanuele Panichi Financial Consolidation and Close -
Does the Default Alias Setup works in FCCS?Summary: we did setup the default alias in the FCCS setting to be one of the custom alias tables we created. In smatview the setup is not reflected and once we connect t…Emanuele Panichi 1 view 2 comments 0 points Most recent by Emanuele Panichi Financial Consolidation and Close
-
Unable to Use Multiple UDAs in FR ReportsHi All, I have created 2 UDA's for one of member in the View dimension in FCCS. I am trying to use this in my FR Report Header by referencing it through the following co…User_ATFGI 21 views 6 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
how to set Advanced Option on suppression rows in a specific member selectionSummary: Content (required): I have a BS reports with Accounts and Movements in rows. The select members for movement is: "Descendants of [FCCS_Movements].[FCCS_ClosingB…Gianluca Natili 1 view 0 comments 0 points Started by Gianluca Natili Financial Consolidation and Close -
'Check' Function in Data Management giving error if we use alternate hierarchy for Entity in FCCSSummary: Im using 'Check' feature in Data Management (4th fish in Import-Validate-Export-Check ) 'Check' is giving me error if I use alternate hierarchy for entity dimen…Srinivas Hindupur-Oracle 11 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can you connect Oracle ERP to Repository / Reporting Web Studio?Summary: Client is trying to create an automated data load reconciliation report at hash totals. As the DM cannot extract data at dynamic calc members, we are looking in…Ryan Heyvaert 11 views 5 comments 0 points Most recent by Al Marciante-Oracle Financial Consolidation and Close
-
Footing errorsContent In FCC financial reports there is option to set rounding. The problem is that after rounding, sum of accounts balances is different than parent value which inclu…User_YZ4FW 8 views 4 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
Cannot Open Next Generation Reports in ExcelContent It's not possible to download next gen reports in Excel. I found a document on the Oracle Support. The Excel download is currently not available (only for Narrat…User_NJ6WE 27 views 5 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
How to create a financial report showing 12 months rolling backSummary: I need to create a report that always shows data for 12 months period back starting the choice made on a prompt for year and period Content (required): So, if I…Gianluca Natili 21 views 3 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close
-
Hide attributes dimensions from member selectionSummary: The FCC administrator would like to hide the attribute dimensions so that it does not appear in the member selection dialog box. Content (required): The attribu… -
Turn Off Elimination for historical periodsIs there a way to turn off elimination in FCCS for (historical) periods? Background:. We have a pretty standard application which consolidates many entities from a GL. O…user1726347 11 views 4 comments 0 points Most recent by user1726347 Financial Consolidation and Close
-
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
-
Pre defined substitution variablesContent I am looking for a list of pre-defined substitution variables within the FCC application. Is there a listing available of the pre-defined variables that can be s…Benjamin Moster 36 views 6 comments 0 points Most recent by Jing Xue-Oracle Financial Consolidation and Close
-
Task Manager - Integration to Reports DcoumentsSummary Documents uploaded in Reports DirectoryContent Good Day, is it possible to create an integration on the Task Manager to select a documents that was uploaded on t…Resh 8 views 3 comments 1 point Most recent by Kurt - Fcm Support-Oracle Financial Consolidation and Close
-
Entity Structure - Segment Reporting Investment eliminationContent Hi Team, We have 2 structures in entity dimension, 1st represents Segment hierarchy and 2nd represents legal reporting structure. The elimination for Investment …User_3UODH 24 views 5 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
FOLLOW-UP ~ EPM – Best Practice: How to Wow Your Users and Make Your EPM Solution Shine!Content Following the recently delivered event "How to wow your users and make your EPM solution shine" https://cloudcustomerconnect.oracle.com/posts/343fe13a76# I wante…Andy King-Oracle 24 views 0 comments 0 points Started by Andy King-Oracle Financial Consolidation and Close
-
FR Formatting QuestionContent Hi All, I am not sure if this is correct forum for this topic so please tell me if there is a better place, but I have a client that would like to embed their FR…Preston Oakes 12 views 4 comments 0 points Most recent by Preston Oakes Financial Consolidation and Close -
Service Status legend - What does Green Indicate?Content Hi All, I was curious if anyone had any insight on what the service status green "Service up" means? Shouldn't we expect each day to be yellow (Planned Maintenan…Preston Oakes 7 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is drill through from Oracle Fin Reporting Web Studio Reports possible?Summary Is drill through from Oracle Fin Reporting Web Studio Reports possible?Content I am unable to see an option of drill through in the Oracle Financial Reporting We…
-
Member Formula equation adding MovementContent Hi All, I am trying to get a pretty straight forward math equation to work as a member formula. I have created a stat account and would like to simply take (FCCS…Preston Oakes 15 views 2 comments 0 points Most recent by Preston Oakes 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
-
New layout reports sectionSummary The new release has changed the layout of the reports sectionContent Hi, I saw that on the new version 21.02.91 there was an update on the Reports section. Previ…User_XN844 17 views 1 comment 0 points Most recent by Dave Roberts_-Oracle 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 -
The Ability to Report on Task Manager CommentsContent Our business partner would like to have a report that shows which tasks were on time, which were late, and the comments added in the task, so they don't have to …Austin Loud 5 views 1 comment 0 points Most recent by Tom LeFebvre-Oracle Financial Consolidation and Close -
FCCS Security Roles and the account FCCS_CSTATUS FILTERSummary User has a Viewer role and is provsioned for read-only on the member, but cannot run reportContent Hello. I created a report with the calc status in a second gri…
-
Notes in new Reports featureContent Hello, We are starting to explore using the Reports tool that is now included in the core Products (Financial Close & Planning). One thing that we noticed is tha…