To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Financial Consolidation and Close
Discussion List
-
Manage OwnershipSummary: We currently had our ownership data (%, control, and method) stored in EDM. On a monthly basis we pull an extract out of EDM and import it manually into FCCS. D… -
Restrict system administrator from posting and approving journalSummary: Restrict system administrator from posting and approving journal Content (please ensure you mask any confidential information): Hi There, Is there a way we can …
-
Can we setup Rate Overrides as Periodic even if the Default Translation is YTD?Summary: Actual Requirement: The requirement is to load YTD TBs to the FCCS application and the same to be translated on the YTD Exchange Rates. Doing the same in FCCS a…
-
units * price in FCCSI'm familiar with Essbase and Planning but now I'm struggling with the setup up a units * price mechanism in FCCS. Both units and price are inputs, the revenue total sho… -
Foreign currency sensitivity calculationSummary: I want to calculate the impact when currency rates increase or decrease by 5% on income before tax. How to do that? Content (please ensure you mask any confiden…
-
How To - Writing Efficient Essbase IF StatementsSummary: This article describes how to write efficient Essbase IF statements, involving Essbase metadata and data conditions. Content (please ensure you mask any confide…
-
How to load parent member (store data type) with dynamic cal children account?Summary: I did integration from FCCS to PBCS but always failed to load parent member (store data type) with dynamic cal children account. FYI In FCCS the parent account …
-
How To: Design Consolidation Calculation Status Reports using Reports ModuleSummary: This tip depicts steps to design a Consolidation Calculation Status Report using FCCS Reports module Content (please ensure you mask any confidential informatio…
-
VBA trigger FCCS business rule, cannot pass entity and period parameter in to the business ruleSummary: VBA trigger FCCS business rule, cannot pass entity and period parameter in to the business rule Content (please ensure you mask any confidential information): W…
-
VBA trigger FCCS business rule, cannot pass entity and period parameter in to the business ruleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Task Manager Template non consolidation reports are showing dates instead of days (e.g Day -25)Hello Everyone, I have an issue with Task Manager reports and need your help. The Task Manager Template non consolidation reports are showing dates (2009-06-20T13:00:00,…
-
Report with Tbs and journal description detailsSummary: I have been asked to develop a report, where in the rows there is the information at accounting account level, in the first column the Tbs entries and in the fo…
-
FCCS report grid layout change to "Right to Left"Summary: Hello All - we have a requirement to publish a report in hebrew which reads "Right to left " . Can we do it in FCCS->Report->Grid? Content (please ensure you ma…
-
How to handle opening balance in new sub consolidationI try to create a new sub consolidation. Original structure A |------A1 |------B1 |------B2 New structure A |------A1 |------B |----B1 |----B2 After consolidation, the "…
-
In FCCS, how can a Power user could see Jobs executed by other usersSummary: Hi All, Is it possible that a Power user could see Jobs executed by other users? How can we achieve this? Content (please ensure you mask any confidential infor…
-
FCCS Web Form - P#@Cur(-1) like in HFMHello, in HFM we can use the function P#@Cur(-1) in the web form. Using P#@Cur(-1), if we select the first period of the year (January) we are able to see the Previous P…
-
Can we create a data source element to be used for contribution adjustments in Parent CurrencySummary: Content (please ensure you mask any confidential information): Hi all We would like to know if it is possible to create a data source element to be used for con… -
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …
-
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …
-
Clear data on Parent Input/Parent CurrencyHello all! How to clear data on FCCS_Parent Input/Parent Currency members since they are Restricted Members and cannot be set in the 'Clear Data' job? Thank You! -
Consolidation Journal report at FCCS_Intercompany eliminationSummary: Can we generate a report at FCCS_Intercompany eliminations as data source under consolidation journals report section Content (please ensure you mask any confid… -
Customize the CICTA redirection in FCCSSummary: Hi Is there any option to customize the CICTA redirection in FCCS? Can we do the redirection based on specific criteria? Thanks in advance. AK Content (please e…
-
Narrative Reporting- How to override a row dimension based on a selectable pov dimension?Summary: I have a custom dimension in the rows of a report. I need to set the row custom dimension based on the year in the pov. For example, If the year selected in the…
-
Unable to copy entries in Oracle FCC to post JV month end entriesSummary: Encountering an error when attempting to copy entries from October to November. The error message states, "You do not have access to the member: Special Operati… -
Custom CTA in FCCSSummary: Custom CTA in FCCS Content (please ensure you mask any confidential information): We have a requirement to calculate CTA differently for a set of entities. Here…
-
Can email notification in approval unit be automated in line with the promotional path?Summary: Issues with approval unit email notifications Content (please ensure you mask any confidential information):We have enabled Consolidation Bottom-up approval uni…
-
Report Issue in FCCSummary: I am getting below error in FCC reports. Looks like getting this issue in the latest patches. Anyone have noticed this issue? Content (please ensure you mask an…
-
Unable to see data in USD_ReportingSummary: Unable to view the translated data submitted at "Parent Currency" Content : We have submitted a journal for a parent entity. This is the consolidation and curre…
-
@CALCMODE(BOTTOMUP) increases Translate timeWe have used FCCS_10 and FCCS_20 rules to calculate / reclass some of the movement members for cashflow reporting and the Translate is taking around 30 minutes per perio…
-
Service Administrator in FCCSSummary: As Service Administrator, within FCCS, does it mean all Application Roles (i.e. Consolidation Journals - Approve) are automatically assigned to it? There's no w…