Dimensions
Discussion List
-
opening balance not rolling upWe had a restructure that led us to add parent entity to an existing top node parent entity. Upon running the Consolidate rule, it is only rolling up the movements and n… -
Shared Member created not really SharedSummary: Shared Members being created using Import or Smartview but not truly shared and cannot be deleted Content (please ensure you mask any confidential information):…Martijn Nauta 36 views 10 comments 0 points Most recent by Martijn Nauta Financial Consolidation and Close -
FCCS – Clarification on Entity Hierarchy Changes with Ownership Enabled and ORG by Period DisabledWe have the following requirement in Oracle FCCS: Ownership Management: Enabled ORG by Period: Disabled Currently, the entity structure is: Group1 ├── ABA └── ABC (Store… -
Alternate hierarchy in Data Source dimensionIn my current engagement, we are creating CashFlow Adjustments setup. For the same, we need to have one Data Source member on which we can put the CashFlow Adjustments b…Aditya Mehta 33 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Oracle FCCS - Alternate Hierarchy QuestionHi All, I’m working in FCCS and running into an issue with shared entities in the Entity dimension. Current setup: I have a primary hierarchy (Assume XYZ) under FCCS_Tot…Shubham Bhandari - Deloitte 42 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Rule Calc Issue for New Block CreationSummary: Have created a new Data Source member to capture cash flow calculated data. Using the below Rule for new block creation. The Rule works if the Target and Source…PeterGSmith 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Change data load from periodic data to balancesSummary: Our application is setup with data loads for Periodic data to be loaded into FCCS application. We are implementing cashflows now and would like to change from l…Divya_Masoodi 92 views 16 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
ICP Member Alias Still Changes When Entity Alias Is Modified After Applying the 26.06 PatchSummary: The patch says "36256442: When you enter an alternate alias for an entity, it now no longer changes the default alias in the corresponding ICP member". We are o…Vyshnavi Bandaru 42 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Adjustment entity in FCCSSummary: Can I add an adjustment entity in FCCS with EOBP enabled wherein I can set the ownership method as "Aggregation" ( which was previously available) instead of Su…rashmi.subash 15 views 1 comment 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
FCCS_ClosingBalance_Input – Performance Impact When Loading Zero YTD BalancesHi Everyone, We load YTD Ending Balances using FCCS_ClosingBalance_Input. In certain subsequent periods, balances drop to zero and we end up loading a large volume of ze…Bhavishya Edula 34 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Deleting multiple shared members taking a lot of time.Summary: Delete shared entity members in "Overview / Entity" is taking ages (2 minutes per member… second member taking exponentially longer). Has anyone encountered thi…Tjeerd Huisman 73 views 10 comments 0 points Most recent by Tjeerd Huisman Financial Consolidation and Close -
Import entity crashing applicationSummary: we have EDMCS to FCCS entity push which is set as "Clear members."but whenever we are pushing from edmcs or importing the extract file of EDMCS into fccs after …Satish9090 31 views 8 comments 0 points Most recent by Brent Litchy Financial Consolidation and Close
-
Data DuplicationSummary: In Oracle FCCS, stat accounts are being loaded to the No Movement member, which is currently positioned as a child of Mvmts_Subtotal. This configuration is caus…Saraiya Daisy Dhanesh 72 views 20 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Managing User-Defined Attributes (UDA) for Accurate Period-Specific Financial DisclosuresSummary: Hi Experts, We have a requirement to retrieve data based on the control method, such as subsidiary, joint venture, or associate. To achieve this, we introduced …
-
Moving Level0 members of account hierarchy without affecting the locked prior period dataHi We need to move few Level0 members from different parents to another set of existing parents for the current period. But when I move them to new parents and consolida…PavanKorandla 42 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Entity Proportion Adjustment (EPA) and Entity Elimination Adjustment (EEA) ExplanationWe recently have found some unexpected amounts on both Consolidation dimension members that are children of Entity Total Adjustment: Entity Proportion Adjustment (EPA) a…Eduardo Abud 183 views 6 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Dynamic member formula based on POV in reportHow to automate calculation of Day sales outstanding ratio using member formula in each period based on POV selected in report.Amara Sai Sandeep 11 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
FCCS Change in Entity CurrencyWe have a scenario where an entity needs to move from BGN to EUR as its functional currency. I understand that creating a new entity is the common approach, but I wanted…
-
Cashflow - Rollforward Data Input - without using Rollforward data formsHello Everyone, Are there any other ways to load roll-forward cashflow data without data forms input? For example a. Create a Net Movement member where we load the GL da…Bhavishya Edula 11 views 0 comments 0 points Started by Bhavishya Edula Financial Consolidation and Close
-
any known issues in 26.04 with essbase data consistency?Summary: We are seeing an issue in an ASO cube where the same intersection will return different values depending on the time periods on the grid. We cannot recreate the…Nathan Foutch 25 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can alias tables be updated for the intercompany dimension in FCCS?We have an alias table called "Member Name & Description" where we concatenate the member name and description together, separated by a special character ("_"), so both …EPM_Brett 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Bulgaria currency change - how to transfer balances from old entity to the new mid year?Summary: We now have 2 Bulgaria entities (one in BGN and one in EUR) and are looking for the easiest option to transfer 2026 balances from the Old entity to the New enti…
-
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 11 views 5 comments 0 points Most recent by Tom Stevenson Financial Consolidation and Close
-
Error in dynamic calculation from September FY26Summary: Error in dynamic calculation from September FY26, it works correctly in previos months and years. Content (please ensure you mask any confidential information):…VicFlores 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
IFRS 18 - How to have 2 separate Profit and Loss account structure in Oracle EPM FCCSSummary: As IFRS 18 will be effective from 1 April 2027 onwards, and 1 year comparative number is required to reflect the requirement of IFRS 18, we need to know how Ora…
-
Disable Entity rollup for specific % AccountsWe have percentage Accounts in FCCS, and their data is currently rolling up to the parent entity, which is not what we want. For example, the entity structure is: Parent…Aiswarya_1234 1 view 1 comment 0 points Most recent by Anand Thota Financial Consolidation and Close