Dimensions
Discussion List
-
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 288 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 41 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 384 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 71 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 81 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 31 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 74 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 107 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 11 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 42 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 21 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… -
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 -
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 51 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 89 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 31 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 91 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 41 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close