Dimensions
Discussion List
-
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… -
Pushing data from FCCS to EPBCS with different parent member.Summary: Each month, we are pushing data from FCCS to EPBCS. We used to have the same hierarchy in both applications. FCCS: Legal Hierarchy (Primary) Management Hierarch…Pieter-Jan Vandendriessche 14 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close -
The Member Formula Tab is not editable for Currency DimensionSummary: When create new Currency Dimension we noticed the "Member Formula" tab is not editable (Greyed out) There is no issue for other Dimension, we can change "Data S…Daranee Sengsakdi 20 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can we update alias on the new alias table for an entity Dimension?I believe it should be possible to update alias on a new alias table, but when I tried, I received an error saying that journals are posted on this entity.B.Bhandari 57 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Any Template including parent code, all base code under it & all GLs mapped to those base codes?Auditors usually ask for this kind of data wherein the excel financials show the BS or PL any parent code and they require as to how the data is rolling up to these code…Neha!03 15 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Changing dimension name in FCCS post go-liveSummary: There is a client requirement to rename one of the custom dimensions post go-live. Is it technically feasible to accommodate a change in dimension name when the… -
10K Disclosure Tables in FCCSSummary: For an insurance company, preparing the 10K requires numerous disclosures, including, but not limited to, annuities, amortizations, and retirement plans. To fac…Saraiya Daisy Dhanesh 13 views 0 comments 0 points Started by Saraiya Daisy Dhanesh Financial Consolidation and Close -
Sharing entities in alternative and within the same hierarchies | Can we share parent entities or noContent We are required to create alternative entity hierarchies as well as sharing entities within the same hierarchy as it changes over time. We have intercompany elim…Jaco Steenkamp 176 views 16 comments 0 points Most recent by Tjeerd Huisman Financial Consolidation and Close -
Moving a subsidiary from one parent to another in an alternate hierarchy (shared member)Content We have two entity hierarchies: - GEO hierarchy which is our primary hierarchy (all base members are set up as Never Share) - consolidation in this hierarchy is …User_2025-03-10-22-05-05-773 286 views 16 comments 2 points Most recent by NK2025 Financial Consolidation and Close -
Journal Adjustment in Saved Assumption accountHello everyone, In FCC, Is it possible to make journals adjusting in accounts defined as saved assumption (amounts)? Thank you, regards.CarolinaRodriguez 42 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Days per Month in FCCS Calculation Manager - Leap YearsSummary: We would like a dynamically calculated member in our ACCOUNT dimension that will compute the number of days in a given PERIOD and aggregate appropriately in con…James Holland II 51 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Limit of number of members under one dimension in FCCS applicationOur customer has an FCCS application, DSO enabled, and has a requirement to add more than 10000 members under one of the custom dimensions. What are the performance impl…Naresh Kumar Intellicore 330 views 7 comments 0 points Most recent by Ashwin Prabhu Financial Consolidation and Close -
FCCS - return intercompany ownership method in Dynamic CalcSummary: Our clients require AR and AP reporting segmented by intercompany consolidation method—such as IC-to-Subsidiary, Equity, and other classifications. I'm currentl…MC00062 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Trailing 12 month (TTM or LTM)Summary: I need to add into the app for Actual LTM (last 12 months / trailing 12 months) calculation. I don't see the solution in the manual. It would seem that the best…DariaM 61 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Oracle FCCS, how to give access to power user to manage dimension?Summary: We setup an application using out-of-the-box features. We would like to allow user with Power user role to manage dimension. This Power user will add in new acc…Michelle Young 60 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Dynamic Calc on Scenario DimensionSummary: Currently, we have a level 0 scenario dimension member assigned with a member formula, and its data storage property is set to 'Dynamic Calc'. However, we are e…Rekha S 24 views 1 comment 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Exclusion of OBOC Movements from Configurable Consolidation RulesRecently we have been recommended (via SR) to add the OBOC movements (Acquisition of companies and businesses – OBOC and Disposal of companies and businesses - OBOC) to …Eduardo Abud 59 views 7 comments 0 points Most recent by Eduardo Abud Financial Consolidation and Close -
Never share and store explanationSummary: Hi , what is the difference between never share and store ? Content (please ensure you mask any confidential information): Version (include the version you are …Anchal Aggarwal 57 views 14 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 87 views 3 comments 0 points Most recent by Eduardo Abud Financial Consolidation and Close -
"process management enabled" property for account and entity dimension as falseSummary: can we set the process management enabled property to "false" for account and entity dimension in FCCS? does it have any performance impact on the approval proc…Vandita Vyas 13 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Change base currency of parent entity rollupSummary: Hi , We have a situation wherein the base currency defined for a parent rollup (lets say A) in alternate hierarchy is USD whereas, the child of entity A (lets s…Tejesh Mhatre 33 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Deleting Dimensions - Years Scenario Entity and AccountSummary: Are we able to delete unwanted Dimensions for Years, Scenario, Entity? Years: From Implementation, we started approvals for years all the way back to 2008 but w…William Macale 24 views 3 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
FCCS Dimension Attribute Values - Source_ERPSummary: Content (please ensure you mask any confidential information): Hi all Could someone give me some information on this attributes and their usage? Source_ERP - te…NK2025 21 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Metadata is out of sync. P&L Line Items, Issue: CHILDREN_ORDER.Summary: Metadata is out of sync. Cube: Consol, Dimension: Account, Parent: Reporting Line Items, Member Name: P&L Line Items, Issue: CHILDREN_ORDER. In Recommendation i… -
Can we add a parent member between FCCS_Total Equity and FCCS_Retained Earnings member in FCCS?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Vandita Vyas 42 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Translated Input Currency outside Total Input and AdjustHi @Ashutosh Bhatikar-Oracle, Is there any workaround or way to enable Journal Entry + USD tag outside creating members under Total Input and Adjust ? or is there any en… -
Restoring a seeded member to original position along with metadata properties.We have restored a seeded member FCCS_Mvmts_Fx_Total to its original position from Application>configuration > Actions dropdown > Review modifed artifacts > filtered Mov…Amara Sai Sandeep 31 views 4 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
Plug Accounts - how should plug accounts we created be placed within the Account hierarchy?Summary: Within a newly developed FCCS application we have multiple plug accounts, ex. Interco_Acc_Interest_Plug, Interco_Notes_Plug... Currently all of the Plug account…User_AZRIG 111 views 5 comments 0 points Most recent by Ashok_Yadav Financial Consolidation and Close -
How to best handle an entity structure change ?Hello, I was wondering if you could help me out on how to best handle an entity structure change. The case is the following : Entity A used to be owned by group 1. It is…Camille Dhallenne 46 views 4 comments 1 point Most recent by Siddhi_Shah Financial Consolidation and Close -
Allowed moving member "FCCS_Closing Balance" out of FCCS_MovementsSummary For any reason the metadata validation rules does allow this movements. But not allow returning them back.Content Hello, By mistake we tried to move the member "…MAcat 74 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close