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… -
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 43 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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 285 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 44 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 54 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 322 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 24 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 62 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 57 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 56 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 52 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 84 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 32 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…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…
-
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 178 views 15 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close -
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 109 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 44 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
-
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 21 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 96 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 27 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Writeback from FCCS to Oracle GL cloudIs it possible to write back consolidated data from FCCS to Cloud GL? How is that done as consolidated data will be mapped to cloud GL COA example dummy consolidation en…AditiKavdia 12 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close