Reports
Discussion List
-
How to write a query to pull FCCS Users through a Non-COnsolidation ReportSummary: Currently we are using "select * from FCM_USERS" query to create the report. But it pulls the entire users from the LDAP. However, we want to confine the users …Santosh Tenkala 13 views 2 comments 0 points Most recent by Santosh Tenkala 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 53 views 7 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
EPM Automate Commands to run Intercompany ReportsSummary: Looking for a way to run reports right after a scheduled DM integration runs Content (required): Hi, My client has to run intercompany reports every time we pus…Michael C Stefanavage 14 views 2 comments 0 points Most recent by Michael C Stefanavage 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 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close
-
Consolidation Journal Report IssueSummary: Report times out when running against single account Content (required): When running a consol journal report it times out when running against a single account…Jeremy Stubbs 2 views 0 comments 0 points Started by Jeremy Stubbs Financial Consolidation and Close
-
Reporting Web Studio - PromptSummary Can't set 'prompt'Content Hello dear colleagues, I'm trying to set up a Report that have two columns, one for each Year (current | previous). Following the same … -
Showing Balance Sheet Accounts with natural signage from TB and P&L Accounts with sign flip in FCCSummary: Hi All Client requires us to show Balance Sheet Accounts with natural signage from ERP and P&L Accounts with sign flip. This requirement is from reporting stand…Parmit Choudhury-Deloitte 32 views 5 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
Scalled reporting currencySummary: Hi All, Recently we migrated data from EPBCS to FCCS on EUR_Reporting currency. However, in it's reports and forms, the customer would like to have the possibil…DylanPauwels 13 views 1 comment 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
Need to create report for the supplemental data in our application and have the frequency dimensionSummary: We are creating report for the supplemental data in our application and need to have the frequency dimension (year, period in the parameter of the report). When…Subramanian Karunamoorthi 4 views 4 comments 0 points Most recent by Subramanian Karunamoorthi Financial Consolidation and Close -
Tax Reporting TRCSSummary: Hi, Has anyone developed any out of the box reports in Narrative Reporting for Tax Reporting TRCS that we can leverage or additional documentation or knowledge …
-
Can MR reports from Narrative reporting be launched via FCCSSummary: Is it possible to run a Management Report such as a trial balance that was developed in EPRCS from within FCCS? Content (required): We are shifting to MR report…Michael C Stefanavage 24 views 2 comments 0 points Most recent by Michael C Stefanavage Financial Consolidation and Close
-
Possibility to Include Original Transaction Currency in Data Exchange OutputSummary: Possibility to Include Original Transaction Currency in Data Exchange Output Content (required): Is it Possibility to Include Original Transaction Currency in D…Amit Agarwal-158816 12 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close -
FCCS Financial Report folder: How to set NO ACCESS security for a group to this moduleContent Hi All We want to limit the access to some user group ( power users / Planner User) to the Financial reports / folders under the REPORTS folder. This works fine …Nkehli 37 views 12 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
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 4 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 24 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 12 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 142 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 2 views 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 27 views 6 comments 0 points Most recent by Dave Roberts_-Oracle 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 13 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 12 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
-
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 12 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 38 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