Dimensions
Discussion List
-
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… -
Reconsolidate of historical data for hierarchy changesSummary: We have frequent update for primary hierarchy. When updating hierarchy's we always have to reconsolidate historical data from inception. There was an enhancemen…Divya_Masoodi 51 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
How to extract FCCS Account hierarchy levels over seperate columns in SmartViewWe want to extract the FCCS Account Hierarchy with levels spread over seperate columns like it is done in Cloud ERP. Is this possible in FCCS as well? Current Extract in…Wilfried121 22 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Entity Movement ReportSummary: Is there a standard report that shows Entity movement for a given period by displaying variances for one Parent to another? I know there's the Data Status repor… -
price quantity analysis translation effect breakdown in FCCSummary: I have build a price analysis variance split between two revenue numbers in FCC. We use it in Entity Currency but as a next step we would additionally like to v…Erik De Rouck 12 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
How to remove FCC forever intersections created by disabled/hanging balancesAs FCCS requires unique data source, we'll be ending up with hanging USD in RP_GLxxx that will be offset by USD Override JEs in RP_JE_USDOR for disabled entities. Though…Matt S [GE] 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
What's best practices to leverage dimension for non-gaap reporting in FCCSI am currently using FCCS and Planning apps with similar dimensions and want to determine best practices when reporting non-gaap results. Current design recommendation w…Scott Archila 11 views 2 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
FCCS_YTD usage in configurable rules causes consolidation to never completeSubmitted an SR for this, but was told to submit the issue here. SR: 4-0000129502 We are having an issue using FCCS_YTD in configurable rules - has anyone else ran into …Dale Joosten 31 views 7 comments 0 points Most recent by Dale Joosten Financial Consolidation and Close
-
Dynamic Time Series: month to dateSummary: Hi All, I'm trying to make use of the Dynamic Time Series feature in FCCS in order to create a month to date option in a report. However, although I have adjust…DylanPauwels 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Added new Parent for existing members.Will we be able to get the data by default?We have added a new parent for the existing members in the Entity Hierarchy. We are looking for a way to get the data under the new parent by other than running Consolid…Shilpa Char 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Change in Account type is not working correctlySummary: Hi all, We are having an account tagged as Asset account type. Now, as per the requirement, we want to change the account type to Expense as the same account sh…Aditya Mehta 32 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Substitution Variable - Not Working in Custom Application FDMEESummary: Issue with using Substitution Variable in FDMEE Content (please ensure you mask any confidential information): Hi All, we noticed an issue with a Custom Applica…Antonio Barbaro 22 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Perfomance with 3 different alias tableCreat new table alias impact in the performance? It will take more time in calculation with diferents table alias? It will increase time of searching in smart view?ALopezS 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Metadata - Never share Member followed by shared memberSummary: In the Legal Entity metadata file, in the order of sequence can we have member with shared as 1st and then followed by never share Content (please ensure you ma…Vijayverma 36 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Custom Dimension or Supplemental DataSummary: Custom Dimension or Supplemental Data Content (please ensure you mask any confidential information): Hello team, We are in a new FCC implementation and we have …CarolinaRodriguez 41 views 5 comments 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close
-
FCCS_Net Income Out of the fox FunctionalitySummary: P&L accounts that sit outside of FCCS_Net Income being treated like a Balance Sheet account Content (required): We have encountered a system issue as it relates…
-
Metadata Validation Error - Dynamic CalcSummary: Content (please ensure you mask any confidential information): I am getting the following metadata validation error for one of the base members of Account dimen…ApOK 32 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
shared member not rolling up to dynamic calc account in FCCSSummary: My account hierarcy is below Dynamic calc parent can't accumumulated its descendant (shared member) data. I've checked member option tab and data storagae in di…
-
Has the member formula definition for FCCS_OpeningBalance_Cash changed in the last 6 months or so?Summary:We are seeing that the quarters are now referencing the closing balance of the prior quarter an not the last period of the prior year for FCCS_YTD view. We have …Nathan Foutch 101 views 17 comments 0 points Most recent by Nathan Foutch Financial Consolidation and Close
-
problems with service phoenixGood afternoon, everyone! Is anyone else experiencing a serious slowdown problem with the Phoenix server? All my applications are unable to work: ARCS, FCCS and PlanningUser_RYTJW 13 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Closing entity in FCCS when ownership management is not in useSummary: Closing entity in FCCS when ownership management is not in use Content (please ensure you mask any confidential information): Hi, We would like to close / inact…soile.alm 22 views 3 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Root Cause of Metadata Synchronization IssuesSummary: While creating the metadata members in Account dimension outside the BS hierarchy, we are experiencing an out-of-sync issue, which prevents us from inputting da…
-
How to restrict the "FCCS_Balance" Account values to the specific member of custom dimension?Summary: We have enabled Balance the Balance Sheet calculation for our client and it is calculating the different between Total Assets and Total Liabilities and Equity a…Harshith J Rao 22 views 3 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Sharing Parent Members in the Account DimensionSummary: There’s a myth that we can’t share parent members in the account dimension. In reality, we can share parent members in the account dimension. However, the commo…
-
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…Mihajlo 91 views 10 comments 0 points Most recent by Jing Xue-Oracle Financial Consolidation and Close
-
An error occurred while copying ownership data to next yearWe created alternate hierarchy in the FCCS application, we need the data from previous period also to be rolled up to the current period, so we unlocked the hierarchies …
-
Account with member formula does not aggregate to Top Custom dimensionSummary: I have a Dynamic Calc member with the following member formula in my DSO application: IF (@ISMBR("FA_Fixed")) "COSTot" = "BurdenSGA" + "RegionAllocDiff" + "ICAl…ApOK 12 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Enhanced ASO Cube Dimensions Table in Activity ReportAs per September 2024 patch update - Enhanced ASO Cube Dimensions Table in Activity Report update has been featured. We want to know how it affects the application & how…PRASANNJEET DAS 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Issue with data retrievalSummary: I have a statistical hierarchy with the following structure: The member formula for the dynamic calc accounts is composed of members from the Primary Balance Sh…ApOK 11 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Solve Order for Account MembersSummary: I have a statistical hierarchy with the following structure: The base members are dynamic calc with a solve order higher than 58. The formulas calculate correct…