Dimensions
Discussion List
-
Dynamic Accounts - QuestionSummary: Dynamic Accounts - Question Content (please ensure you mask any confidential information): Hi All, in my FCCS application I created a specific dynamic account. …Antonio Barbaro 47 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Movements dimension errorSummary: When updating the movements dimension via Smart View I accidently moved one of the seeded FX members to a new parent. The database was refreshed before I realis…Paul Wilcock 47 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 30 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
FCCS database refresh error "Shared member [AC_15209] with no actual member"Summary: Hello, we have encounter a situation where when we delete an account AC_15209 and refresh a database it getting failed with error as "Shared member [AC_15209] w…AniketAB 44 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
New alternate hierarchy but no opening balances for shared membersSummary: We have added a new alternate hierarchy that shares some of the entities from the primary (Total_Geography) hierarchy but also has some of it's own entities. We… -
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 65 views 14 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…
-
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 18 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
-
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 17 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…
-
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 182 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 287 views 16 comments 2 points Most recent by NKW 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 43 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 53 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 343 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 66 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 65 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 62 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 51 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 95 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 14 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 38 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 22 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…NKW 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 41 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…