Dimensions
Discussion List
-
Incorrect YTD/QTD Due to Opening Balance in Stat AccountsSummary: I have a set of statistical accounts set up outside the Traditional balance sheet approach. When the period activity for these accounts is loaded and the Consol…Lakshmi Priya 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCC - Member Formula results do not aggregate up in two dimensionsSummary: I have written some formulae members that do the work as expected. The strange thing is that results do not aggregate up correctly for Custom 1 (Sparse) and Mov…Erik De Rouck 93 views 22 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCC 25.06 updateNeed some details around below update -: Label Change for Data Source Currency Attribute - We do not see this update in FCC test instance or may be I did not understand … -
Is performance affected by using multidimension mapping for all dimensions in EPM Data Management?Summary: Hello Oracle Experts, We are loading data from a source file with 4 columns (like Account, Entity, Cost Center, Department, Location). In our Data Management se…Vijay_Babu 21 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Writeback from FCCS to Oracle GL cloudIs it possible to write back consolidated data from FCCS to Cloud GL? How is that done as consolidated data will be mapped to cloud GL COA example dummy consolidation en…AditiKavdia 13 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Error occurred during Prior Period Data Updates.Summary: we are trying to use new feature : Enhanced Organisation by period, we have followed the steps but still we are getting an error. ERROR: Error occurred during P…Narinder Arora-162322 44 views 5 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
Behavior of Business Rule Calculation When Current Week Forecast is #MISSINGSummary: Inquiry regarding whether the business rule for calculating weekly forecast differences (FcstWeekDiff) functions correctly when the current week's forecast valu…Chihiro Tsunoda 41 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can "importAppSecurity" modify entity dimmension member's security?I want to know that "importAppSecurity" of epmAutomate can modify entity dimmension member's security(Access Permissions). We're using entity member's security, Managing…KANG HEEYOUNG 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Creating New Scenario and accounts for Comments and deleting Scenarios with historical dataSummary: If we were to create a new Scenario, along with 50 or more new accounts to hold "Text Data" as comments loaded from our users, would this significantly impact o…William Macale 22 views 5 comments 0 points Most recent by William Macale Financial Consolidation and Close
-
Attribute Member aggregation in YTD viewSummary: Hi all, We're looking to Set up Attribute dimension members in our Account dimension to support reporting on exception / non-exception items. I.e. Create a P&L …Tom Stevenson 14 views 2 comments 0 points Most recent by Tom Stevenson Financial Consolidation and Close
-
FCCS duplicate accounts issueWe are having an issue with duplicated accounts in FCCS when importing metadata from EDMCS. Wondering if anyone else has a similar issue or any suggestions for how to ha…Randy Haight 27 views 5 comments 1 point Most recent by Hyperion_Junkie Financial Consolidation and Close
-
Using Conditional Expressions in FCCS Import Format to Handle Empty ColumnsI need to perform an integration in Oracle FCCS where I have a third-party dimension. The issue is that from the source system (NetSuite), the information for this dimen…User_F8Z0S 21 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Data Exchange new dimension metadata refresh errorSummary: Content (please ensure you mask any confidential information): Hi All Under Data Exchange under the application section, there is an option to create additional…NK2025 47 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS_override rate is not a valid member of consolidation dimensionSummary: Content (please ensure you mask any confidential information): HI all We are getting the above error when we try to copy data for the override rate: Any reason …
-
Member formula performance after DSO MigrationHi everyone! I am looking for some advice. We have several member formulas on the Account dimension that we used prior to the DSO migration that used to run less than a …
-
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 13 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 53 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 32 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 16 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 12 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 111 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 22 views 2 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close