Dimensions
Discussion List
-
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 37 views 3 comments 0 points Most recent by JB_Purchase Financial Consolidation and Close -
Data Exchange new dimension metadata refresh errorSummary: Content (please ensure you mask any confidential information): Hi All Under Data Exchange under the application section, there is an option to create additional…NKW 61 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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 1 view 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Translation Issue for Shared Members in Journal InputSummary: Hi Experts, We are encountering an issue where translation is not working for shared members in journal input for Parent Currency. However, under Managed Data, …PAMUDI 54 views 9 comments 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…Kelsey Peluso 14 views 0 comments 0 points Started by Kelsey Peluso Financial Consolidation and Close
-
Metadata Validation Error: Data SourceSummary: Source Data Type error for Data Source hierarchy custom member - if outside FCCS_Total Data Source hierarchy. Content (please ensure you mask any confidential i…Erisia 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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 257 views 27 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close -
FCCS Data Source Alternate HierarchiesSummary: Creating Alternate hierarchies/views in Data Source Hierarchies in FCCS Content (please ensure you mask any confidential information): For Reporting purpose, we…CBalaKrishna 41 views 7 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close -
ORA‑00001 Error When Synchronizing AUH “Total Geography”Hi all, I’m getting this error when saving/synchronizing the AUH “Total Geography” in FCCS: "Error while saving/synchronizing the AUH 'Total Geography' : ORA-00001: uniq…MKhade 22 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Default movement calculation doensn't work for P&L accounts ?Summary: FCCS_YTD_Input + FCCS_ClosingBalance_Input works fine with BS accounts, but problem exists with P&L accounts ? Content (required): Hi everybody, We are utilizin…
-
Cost Center dimension custom allocationSummary: We have implemented an alternate cost center allocation process in our application. In this setup, data is allocated from a source cost center to multiple targe…Krithika Krishan - PwC 21 views 1 comment 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
How To: Setup Default MovementsSummary: This article provides recommendation to setup Default Movement attribute correctly on Movement members. Content (please ensure you mask any confidential informa…Ashutosh Bhatikar-Oracle 21 views 5 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Note: Essbase 21c and @QUERYBOTTOMUPSummary: Article describes FCCS calculation script and member formula guidance related to usage of new @QUERYBOTTOMUP Essbase 21c function. Content (please ensure you ma…Ashutosh Bhatikar-Oracle 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Custom dimension cost center allocationSummary: Currently our custom dimension cost center is calculated based on an allocation % defined in a custom allocation form, a rule defined calculates and rolls up th…Krithika Krishan - PwC 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Split by IFRS standard: in what dimension?Summary: How to split (journal) entries by IFRS standard in FCC? Content (please ensure you mask any confidential information): The requirement is that a report can be r…Joost Mellegers 31 views 7 comments 0 points Most recent by Girish Joshi 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…
-
FCC application - Assign UDA using GroovySummary: In FCC application, I am trying to write a groovy script to assign a UDA to an account member, but its failing at saveMember() saying its not allowed. Do we hav…HarryEPMUser 11 views 2 comments 0 points Most recent by HarryEPMUser Financial Consolidation and Close
-
Converting FCC application to DSO Impact on Data Source DimensionSummary: As per the Oracle Documentation after DSO conversion - These Data Source dimension members are no longer used for consolidation after the migration process: FCC…ShaikNizamuddin 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
YTD Activity Load/Calculation without ClosingBalance Input in FCCSSummary: Is it possible to load YTD data in FCCS with respective account to movement mapping other than FCCS_Closing Balance Input via data exchange. Content (please ens…Saraiya Daisy Dhanesh 13 views 1 comment 0 points Most recent by Lakshmi V-Oracle 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 15 comments 0 points Most recent by Odin Mjølsnes Financial Consolidation and Close
-
FCCS custom dimensions participate in consolidationSummary: In FCCS Consolidation 3 custom dimensions (Cost Center, LOB, Location) to participate in Consolidation process Content (please ensure you mask any confidential …Jay Mehta 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
its taking 1 hour to complete refresh dbSummary: Hi everyone. Its taking 1 hour time to refresh database in both FCCS test and production instances. Earlier it would be around 10 minutes. How to resolve this i…Amara Sai Sandeep 44 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Dimension LimitsI have been told previously (and also see in other questions within the community) that there is a 10k limit on each dimension. Does anyone know if Oracle will update th…Casey Kempel 21 views 2 comments 0 points Most recent by Ckacharl-Oracle Financial Consolidation and Close
-
FCCS: Change Signage of Account Types according to Source SystemSummary: We would like to know about the Impacts/Challenges of applying the customize signage for Asset/Liabilities/Equity/Revenue/Expense which aligned with ERP signage…Karan Varshney 213 views 7 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
Oracle FCCS should show Periodic and QTD values as identical for quarter-end periods.Summary: In FCCS, the view dimension currently calculates QTD (Quarter-to-Date) as a cumulative value of the periodic entries. For example: January: Periodic and QTD are…Sydaiah - IVZ 22 views 4 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Smart View Adhoc Refresh - Alternate & Default Alias Table Behavior differencesHow can we make an alternate alias table the default in Smart View? Currently, when an ad hoc grid is saved with an alternate alias table, it does not refresh with the s…B.Bhandari 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to use Clear Shared Members dimension import option when importing from EDM?Summary: The Clear Shared Members option shows an error in FCC when importing dimension metadata from Enterprise Data Management (EDM) because we cannot perform any acti…Emily172 11 views 2 comments 0 points Most recent by Chansouda-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 131 views 4 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Error while importing Entity dimension into FCCSummary: While importing Entity dimension to FCC I got error "Business rule failed to execute. See the job console page for error details." & "No members were deleted du…KonradKo 22 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close