Dimensions
Discussion List
-
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 69 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 …
-
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 29 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 40 views 11 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 14 views 1 comment 0 points Most recent by Girish Joshi 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 165 views 6 comments 0 points Most recent by Ajay Kumaran-Oracle 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 27 views 7 comments 0 points Most recent by Ashutosh Bhatikar-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 22 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 12 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 12 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 12 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
-
How to Remove Description from MetadataSummary: We have exported the Account metadata file and want to clear out the Description field. We deleted the data under Description, but after the Import and database…
-
Hierarchy update for a past period.Summary: Our current period is March FY26. However, we need to make a hierarchy update to 3 specific entities that need to roll up to different parents starting from pas…Krithika - PwC 42 views 7 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Clear Data: Issue Using Attribute Dimension for ENTITYSummary: We need to clear the ‘Amount Override’ data in the FCC consolidation cube. We attempted to create a new ‘Clear Data Profile’ and must restrict the entities to o…Andreas Otto 35 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
what is the best course of action when parent entity is moving under new parent?Summary: This is EOBP Enabled application. In Jan FY26, one parent entity having 400+ Children is moving to another parent. Oracle does not recommend sharing the parent …
-
In EDM, the entity was of being moved.The original request was to move Entity 118 from US to US_W_MD, since both fall under the same hierarchy. In EDM, the entity was inserted under US_W_MD instead of being …Anchal Agarwal 22 views 2 comments 0 points Most recent by Anchal Agarwal Financial Consolidation and Close
-
Metadata Repair UtilitySummary: Utility to help determine metadata out of sync issues. Content (please ensure you mask any confidential information): Attached video explains Metadata Repair Ut…Ashutosh Bhatikar-Oracle 31 views 4 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
Creating replica of a cube with same members with unique description and aliases.Summary: There is a client requirement in which as per regulatory existing cube needs to be restructured as new compliance in which the metadata members structure should…Bakul Dehariya 11 views 11 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
how to assign security for an entity in oracle FCCSHow to assign security groups/roles to an entity in oracle financial consolidation and close application. Production is already live. Need to add new security groups to …Meghana_Kota 33 views 3 comments 0 points Most recent by JB_Purchase Financial Consolidation and Close