Dimensions
Discussion List
-
Member Formula account doesn't rollup to Parent EntitySummary: I have two statistical accounts: TaxRate and TaxCalc. TaxRate stores a rate, while TaxCalc applies this rate to FCCS_Sales and stores the result (FCCS_Sales * T…ApOK 5 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Input at Parent EntitySummary There is requirement where we have to enter data at parent level Entity.Content Hello All, There is requirement in FCC where we have to enter data through custom…Tushant Pandey-151106 361 views 9 comments 0 points Most recent by Kasi1981 Financial Consolidation and Close
-
Removing closed entities from the entity hierarchy without impacting historical data.Summary: We would like to remove the Entities from the respective hierarchy of the Entity Dimension from the period in which the entity got discontinued but the same ent…
-
Quantity ConsolidationSummary: Content (please ensure you mask any confidential information): Hello, I need to consolidate quantity of product, i.e. tons of products. I understand that the am…CarolinaRodriguez 16 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can the parent entity marked as intercompany, be shared?Summary: Whether the Parent Subsidiary entity which is marked as intercompany entity can be shared or not? Content (please ensure you mask any confidential information):…Harshith J Rao 40 views 4 comments 0 points Most recent by Apeksha Nahar Financial Consolidation and Close
-
What should be a data storage of "FCCS_CTA" account in DSO application, Is it Store or Never Share?Summary: What should be a data storage of "FCCS_CTA" account in Dense sparse optimization application, Is it Store or Never Share? Content (please ensure you mask any co…Narinder Arora-162322 41 views 9 comments 0 points Most recent by Narinder Arora-162322 Financial Consolidation and Close
-
Behavior of Custom dim in Rates cubeSummary: Custom dimension causing issues in Rates cube Content (please ensure you mask any confidential information): Hi All, I would appreciate if somebody could help m…MihajloBel. 23 views 4 comments 0 points Most recent by MihajloBel. 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 …
-
Query on Member formulaSummary: Query on Member Formula: The current formula I'm using is: "STotal"->"FCCS_No Intercompany"->"FCCS_Data Input"->"FCCS_No Movement"->"FF100" = "SGA"->"FCCS_Total…ApOK 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Adding Comments to Accounts in Data FormSummary: Hi everyone, I am hoping someone can provide some guidance on a business requirement we have. We need to allow users to input comments directly next to accounts…
-
Changing Fiscal Year start periodContent We have a requirement to change our fiscal year start period from Apr to Jan. To do that we're looking at finishing year 1 (Apr-Mar), having one short year (Apr-…User503002-OC 104 views 9 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 42 views 3 comments 0 points Most recent by Lakshmi V-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…
-
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 32 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 28 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 13 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 12 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 32 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 22 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 21 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 31 views 4 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 14 views 3 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 42 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 33 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close