Consolidation
Discussion List
-
Organization MovementSummary: There is one requirement received from business. there is hierarchy need to move one structure itself. Here i am attached the screen shots. I have data loaded i… -
How to redirect FX Variance for Historical Override Account to Movement member?For a historical rate override account, can the FX Rate variance be redirected to a movement member instead of plugging the variance in CTA account?
-
FCCS - Cannot post into a periodHello, When trying to post a journal into FCCS, I am seeing the following error: "Consolidation cannot be performed. The selected Entity:100 is not started for the Scena…BenSayers 32 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Month number from Month Name in FCCI am trying to derive month number from Month name (example, 1 for Jan, 2 for Feb etc.) using below member formula but not able to get the expected results when retried.…
-
FCCS - Organization by PeriodSummary: In FCCS, we use 2 entity hierarchies (in the entity dimension) : 1 legal hierarchy and 1 management hierarchy. The management hierarchy changes every year. We h…Julie Belurier 242 views 7 comments 0 points Most recent by Ritesch Malhoe Financial Consolidation and Close
-
Entity is disposed from one parent and acquired by another parentSummary: What's the best way to handle the below scenario: Entity is disposed from one parent and acquired by another parent. Can we share the entity to the new parent a…SKM 61 views 7 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Shared entity members and rules - rules only runs for primary memberWe have a couple of rules in the main consol rules which should only run for certain entities. To do this we added an if statement for the entities for example, IF (@ISM…EmmaPa 41 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
the starting month is April-2023 and there are values in the YTD of January-23. Do you know how ISummary: Guys, this company has April as its starting month and I enabled the fccs application with this definition. however, after loading data for the year 2023. it is…Silvia Arraiol 11 views 2 comments 0 points Most recent by Sanjana Soni Financial Consolidation and Close
-
eliminationSummary: Alternate hierarchy doesn’t roll up correctly for the Alternate hierarchy parent Entity due to missing elimination. Content (please ensure you mask any confiden…Gayathri C 11 views 1 comment 0 points Most recent by Jack Burton-Support-Oracle Financial Consolidation and Close
-
data not consolidating to parent entityI have a very basic FCCS setup and trying to consolidate the data. I am not able to see anything at parent company. I can see data at Parent Current → Contribution combi…S Kumar-Oracle 88 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Entity Hierarchy movement causing Data issueIn the month of May (P5) a Parent entity E_923 was created in FCCS entity hierarchy and an existing level 0 member E252 (which initially was under E_919) was moved to E_…Karthiga Devi Ramanathan 31 views 5 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
OpeningBalance Adjustement Movement not rollup to parentSummary: i have written a simple ODR to pick a OpeningBalance movement value and move it in OpeningBalance Adjustement with reversal sign, it's working fine at child ent…Narinder Arora-162322 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
"EXTENDMOVEMENTSCOPE" substitution variable is not visible after monthly update 24.06The ExtendMovementScope substitution variable is now enabled by default. This allows you to include Movement dimension members that are created outside of the FCCS_Movem…MKhade 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Identify the parameters for the Manage Configuration Rule in order to configure Calc FCCS_20Summary: We need to identify the parameter for the Manage Consolidation Rules with FCCS_20 Calculations_localCurrency final rules. The purpose is to execute 2 consolidat…MiguelRamirezLeos-Oracle 21 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
USD Translated currency input journal not rolling up for Non USD Parent entityWe posted a Translated Input currency journal in USD at a Non-USD entity. While running Translation and consolidation, it is not rolling up to its non-USD parent entity …SagarR 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unexpected behavior on intercompany eliminations on Disposals in a staged Entity's hierarchySummary: I have two hierarchies with the same base members: one flat another staged. In the flat hierarchy, the disposal of entity RU83 is treated correctly by the nativ…Fabio Fiore 32 views 6 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Consolidation MethodWhat consolidation method that I should choose between subsidiary or holding for this structure? and why. I ask this question cause I found out the difference of consoli…
-
How to clear overridden pown data?Summary: How to clear overridden percentage ownership data from "Consolidation: Manage Ownership"? Content: Data is loaded in January as follows: Scenario, Year, Period,…Shawn Paperwala 11 views 2 comments 0 points Most recent by Shawn Paperwala Financial Consolidation and Close
-
How to trace the data input mechanismSummary: Hi All, Are there any ways in which we can trace whether the data for a particular member has been uploaded directly through forms / Smart View / Data Integrati…Vipusha Chandrakumaran 21 views 5 comments 0 points Most recent by Rahul G.-Oracle Financial Consolidation and Close
-
Subsidiary owned 100% gets proportion effect up to its parent equal to ownership % of its subsidiaryHi, We have a situation where a new entity gets activated in April FY23 as a 100% owned subsidiary (E122), which consolidates to a parent that is 45% owned (using propor…
-
Add Consolidated Entity in HierarchySummary: We are adding a new consolidated entity in the entity hierarchy structure example (110C). What steps we need to take in FCC when adding a consolidated entity. U…Sanjana Soni 31 views 4 comments 0 points Most recent by Rahul G.-Oracle Financial Consolidation and Close -
Backup consolidation dataSummary: I wanna backup consolidation data for certain period only to be imported to testing environment. Because there's shared entity member before primary entity memb…
-
Custom CTA Calculation in FCCSSummary: The client has requested a customized CTA translation rule. We have drafted the rule below, but it’s not producing the expected results. Could you assist in pro…Jane Wang 23 views 3 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Member formula not calculating for Store memberWe have created an additional scenario (Actual_Var) in FCCS application for calculating the periodic variance between two months. E.g. between May and Apr. To achieve th…SagarR 101 views 18 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS not creating block on entitySummary: I have a requirement where the block for entity has to be created based upon exiting entity. The rule has been added to FCCS_10. If entity [US_DIRECT].[E.10008]…Pranab Kumar-279997 192 views 25 comments 0 points Most recent by Ashutosh Bhatikar-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 196 views 6 comments 0 points Most recent by Karan Varshney Financial Consolidation and Close
-
FCC Recompute OwnershipSummary: Sometime in June, FCC started requiring the Recompute Ownership Data job to be run anytime after the database was refreshed. The database refresh could be run f…Sahithi Damaraju 71 views 7 comments 0 points Most recent by Sahithi Damaraju Financial Consolidation and Close
-
Substitution Variable is not working every timeSummary: we are using substitution variable to pick a previous month to run the calc script. it does work fine, when all Entities are impacted but when we run consolidat…Narinder Arora-162322 51 views 9 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Defining Entity HierarchySummary: Hello Experts We have following entity hierarchy. There, we have defined the Company X as a subsidiary. However we have following doubts to be cleared. 01. We h…Kalana Prasad 1 view 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
is there any way to get all the eliminations and journals in one report in FCCS?We have one requirement from client to have one report containing all the eliminations and journals, is this possible in FCCS?Ethien Eid 41 views 6 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close