Dimensions
Discussion List
-
If two different sets of accounts are maintained, what's the best practice to keep them separate?There are 2 sets of hierarchies in the system, statutory and management reporting hierarchy. Impact of some netting adjustments (journals) recoded on natural accounts of…Muhammad Shafy 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
How to reduce complexity of a custom dimensionSummary: One of our customers has an issue with consolidation times, that we think is caused by the growth of a custom dimension (as we've already looked at and optimize…Tjeerd Huisman 51 views 12 comments 1 point Most recent by Tjeerd Huisman Financial Consolidation and Close -
How can I get my Secondary Data Source to include Eliminations?Summary: We have our Primary Data Source stored as a child of the system generated FCCS_TotalInputAndAdjusted, which rolls to FCCS_Total Data Source. Since FCCS_Total El…B-MacMurdo 52 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Can we create periods beyond P13 in Period dimension in FCCS?Is it possible to create additional period members, such as Period 14, Period 15, etc., in PERIOD dimension to capture Oracle Fusion adjustments?Ashif 31 views 3 comments 0 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close
-
Journal is throwing error as we have duplicate member alias for parent & Child in account dimensionSummary: Hi, We are facing this problem in FCCS application. In account dimension, we have some members having same alias with Parent, all the siblings are having unique…Dwaipayan Goswami 12 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Entity alternate Hierarchy - Impact due to many HierarchiesHi, Currently, we have 3 alternate Hierarchies for Entity. As per new Reporting requirements, we need to create few more(Approx. 5). Could you please provide your expert…Sud VJ 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Deleting Approvals Task List ArtifactsSummary: Content (please ensure you mask any confidential information): I've been trying to delete a year member (FY22) out of a test FCC pod and have been encountering …Shane Rooney 81 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
USD_Reporting in different scalesSummary: Content (please ensure you mask any confidential information): Hello, We have the following question: The application we are implementing is a multicurrency wit…CarolinaRodriguez 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Risks associated with renaming attributesHello, Wanted to check and see if anyone has successfully renamed an attribute and the outcome. E.g.: You have a dimension with a list of attributes. The request is to r…ConsultingUser 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
The rationale for setting the solve order specifically to 58, rather than to 0, 20, 38, or 57.Summary: In FCCS, we are currently performing metadata validation and have encountered an error stating: "The Solve order for this member should be 58." We would like to…Zerlinda XU 112 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
RestDataGrid error in integration Fusion - EPMSummary: This month, the system gave an error in the transfer of data from ERP to EPM. The error is "RestDataGrid_XXXXXXXX is invalid". I saw other people having the sam…Pieter-Jan Vandendriessche 11 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close
-
How often does everyone run Restructure Cube in FCC?Summary: Our snapshot size decreased significantly after running the Restructure Cube job for the first time in non-production. Should we consider scheduling this job to…
-
Unusable FCCS SmartView/Report Retrieval Performance with DSO configurationSummary: We are developing a new FCCS application using the DSO (i.e. Dense Period and Movement dimensions) configuration. The SmartView retrievals and reports take upwa…Ken Chen666 62 views 11 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
Access rights add by SYSTEM with the February ReleaseWe've noticed a change in the access rights of members of the Movement dimension. Accesses were changed from Write to Read on 22/02, during the February release. These c…Pierre Sellier-185542 21 views 4 comments 0 points Most recent by Pierre Sellier-185542 Financial Consolidation and Close
-
Custom dimension shared memeber is disabledWe have a custom dimension called 'Business Type' in our FCCS Application that has been running for a few years. There are two members in the dimension: 'No Business Typ…Shravan446 21 views 2 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Dimension Editor Slow to AddSummary: Dimension Editor addition issues Content (please ensure you mask any confidential information): We are currently facing an issue with our FCCS implementation, w…Laura B Jones 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is there a way to consolidate from a point forward after adding an entity alternate hierarchy?Summary: Is there a way to not have to unlock prior periods to avoid the consolidation error when adding an alternate hierarchy when ownership management is not enabled?…LSN_CE 21 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Issue : Cut Custom3 member and shift to another parentSummary: We are facing very strange issues in FCCS. We are trying to cut (move) a member from one parent to another parent in custom3 and system is giving error as : a) …Jai Prakash 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Is there a limit in Oracle FCC for number of children under one parentMy current client has in their entity hierarchy a parent where it has 1000 members rolling up to it. We are asking them to add additional parents and divide this entitie…Silvie Mirek 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Text data on a formula row in Data FormsSummary: There is a Text appearing in a cell on a Formula Row in a Data Form, that I don't know where it is coming from. Content (please ensure you mask any confidential…Ilse De Vries 151 views 41 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS: Managing Consolidation methodsContent Hi all I wonder if someone could give me a little more information about the the following questions I have about the Consolidation methods described briefly in …NK2025 74 views 3 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
FCCS maximum limit allowed for AC dimensionSummary: FCCS maximum limit allowed for AC dimension Content (please ensure you mask any confidential information): We have a requirement to have a separate alternate AC…Vijayverma 11 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Issues in renaming account members in FCCS - DSOSummary: Renaming a member in accounts dimension in FCCS is causing a consolidation error. Content (please ensure you mask any confidential information): We have a base …Arpit Ojha 41 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Enable the BegBalance as Time Period in Actual ScenarioSummary: Enable the Begbalance member in the Actual scenario Content (please ensure you mask any confidential information): Hello team, We need to enable the Begbalance …CarolinaRodriguez 71 views 4 comments 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close
-
Local rates querySummary: Why is "Local Rates" editable in one application and noneditable in another application. Is there any settings. Content (please ensure you mask any confidential…Jai Prakash 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
MDSHIFT not working in FCCSSummary: Is MDSHIFT supported and has anyone got it working in FCCS? Content (please ensure you mask any confidential information): Is MDSHIFT supported and has anyone g…NarayananS 71 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Data: The member does not exist for the specified cube or you do not have access to it.Summary: After consolidation, we have noted that we cant see the account No 235800506 IS-INSURANCE MMC. It was successfully imported, but when we check the logs for the …Martha Pauline Malaluan 72 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Adjustment for unrealized profit or lossSummary: Post of the Investment and result of the holding company Content (please ensure you mask any confidential information): Hello, We are analyzing the adjustment o…CarolinaRodriguez 41 views 1 comment 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close
-
Change of Sign in SQL Data Management MappingsSummary: Content (please ensure you mask any confidential information): Hello everyone, I hope you are all doing well. I am reaching out to get your perspective on a cas…CarolinaRodriguez 11 views 2 comments 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close
-
Change of Sign in SQL Data Management MappingsHello everyone, I hope you are all doing well. I am reaching out to get your perspective on a case I am working on for a project. In the context of data management mappi…Miguel Medina Cerda 21 views 4 comments 0 points Most recent by N.S-Oracle Financial Consolidation and Close