Financial Consolidation and Close
Discussion List
-
How are people working around closing balance input missing in next monthSummary: How are you getting the correct movement data when loading closing balance input values in 1 month with a closing balance and then the next month it is 0 but no… -
Run consolidate rule via EPM AutomateSummary: We wanted to schedule consolidation job in FCCS but could not find any mean to automate the same except scheduling a job. Is it possible to trigger "Consolidate…
-
Deleting fccs custom dimension memberSummary: Requirement is to delete "Total Asset" member from a custom dimension. Any idea, how can I? Content (please ensure you mask any confidential information): Versi…
-
How do I calc a default movement based on a #missing value of "Closing Balance - Input"?Content From the info tab of the calculate movements section of the local currency consolidation step: If a data-point for which a closing balance was previously entered… -
Translating Opening Balance Adjustments with Local Rate - FCC 30 Insertion RuleSummary: Local rates not getting picked-up in rule while translating opening balance adjustments Content (please ensure you mask any confidential information): FIX ("Par… -
@SUBSTRING function not working in FCCSThis formula works in Planning (and in pure Essbase) but not in FCCS. The validation in the formula editor is successful but, I get an error message that the the form is…
-
New substitution variables on Oct 2023 updateSummary: Can we just ignore new substitution variables if we want to keep using FCCS just as it is? Content (required): Three new substitution variables are introduced o…
-
Does anyone load stat account data directly into FCC? If so, how?Summary: We are currently loading STAT account data via a one sided journal in the GL, but would like to start loading directly into FCC. Content (please ensure you mask…
-
FCCS Amount Override not working second time roundSummary: Content (please ensure you mask any confidential information): I have a situation where I need to enter two amount overrides at two different points in time, th…
-
An error has occurred. Please investigate the logs when running recomputeSummary: Content (please ensure you mask any confidential information): when we try to recompute we get this error: Recompute ownership starting Recompute ownership star… -
Setup EPM Agent (Additional?)Hello all, How do you get the EPM agent to pull data from an additional data source? How or where is it configured? We have a single EPM which pulls data into our FCC/AR…
-
ODR Block creation issue using Member FunctionsSummary: ODR Block creation issue using Member Functions: Hybrid application with DSO Block gets created with below code when ran for individual entities but when runnin…
-
Correct Usage of Essbase Member Set FunctionsSummary: This article explains correct usage of Essbase Member set functions @LEVMBRS, @GENMBRS, @ISLEV and @ISGEN Content (please ensure you mask any confidential infor…
-
FCCS - On Demand Rule Best Practice: Avoid IF condition check on Entity dimension.Summary: This article explains best practice related to avoid IF condition checks on Entity dimension Content (please ensure you mask any confidential information): In F…
-
Is there any impact on the functionality in fccs due to the redwood themeIs there any impact on the functionality in fccs due to the redwood theme MJ
-
Journal not balanced by currency errorSummary: Content (please ensure you mask any confidential information): Hi all We are getting this error for a new added Unbalanced Journal - allowed by the application …
-
YTD Journals on PnL membersSummary: Hi, We want to load YTD JVs on BS and P&L members. When we are loading the JVs on FCCS_Periodic, FCCS_Mvmts_NetIncome as an Auto Reversal JVs; Journals are work…
-
Opening balance for new top parent entitySummary: Starting 2023 P1 a new top parent entity has been added. However, opening balance is not populated and another movement such as acquisition neither, leading to …
-
Data Integration Pipeline - EPM Platform Job - Clear Data not working / need additional parameters?Hello, We have an FCCS "Clear Data" task that exists in the local FCCS application & runs fine manually via "Overview" -> "Clear Data" from FCCS, but we cannot get it to… -
Unable to redeploy Enterprise journal template after making changes to adhoc users sectionSummary: Content (required): Hello all I have created an enterprise journal template in FCCS to post journals from ARCS. I have posted certain adjustments as adhoc journ…
-
Users Unable to see the existing file and folders (flat file) in Data exchangeSummary: Hi , Power users having access all the entity, he trying to upload the file in Data Exchange card. but he can upload the file but file is not visible and he can…
-
year end reporting - extra data - approval flow - use of scenariosSummary: At Year-end some extra accounts need to be reported. We would like to have a separate approval level activated, but not all entities need to input these data. C…
-
Phases submission requirements differs per group of entitiesSummary: Is it possible to make the approval phases "asymmetrical" in use during approval ? Meaning: some entities need to submit all data (Phase 1 + 2 + 3 + 4 + 5), oth…
-
Approval Groups and HierarchiesSummary: Is it possible to assign approval groups to different entities within an approval unit? For example, within the data source we have members that allow finance u…
-
Date of Change in Ownership PercentageSummary: The client has sold Investments of its Subsidiary on 3rd July 2023 but we are unable to specify the date of sale while changing the ownership percentage. Conten…
-
SubVar DataLoadConsolMember set to TRUE is not workingSummary: We add this subvar DataLoadConsolMember to TRUE to prevent data amount override being cleared during export data to FCCS using Replace Method, but don't know si…
-
Data Load Rule Data Not Populating FCCSHi all, We are trying to directly integrate FCCS and OAC, so we have set up a data load rule that extracts the data from FCCS and puts it in an excel file that gets pick…
-
FCCS Data Management job fails with tunnelling error messageSummary: We have jobs being run overnight with EPMAutomate used to extract data from our Oracle Fusion ERP and load into FCCS and EPBCS within 5 minutes of each the one …
-
Rule-set with partner elimination and current period-1Content I created two rule-sets: 1. With the following dataset: "Current scenario, current year, current period, fccs_parent total, parent currency and fccs_ytd" and it'…
-
Metadata Validation Error - Dynamic CalcSummary: Content (please ensure you mask any confidential information): I am getting the following metadata validation error for one of the base members of Account dimen…