Consolidation
Discussion List
-
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 26 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 33 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 23 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 102 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 195 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 193 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 77 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 42 views 6 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Plan Type in Entity DimensionSummary: Hi All, Please explain as to whats the purpose of having the 'Plan Type' while creating members in the 'Entity' dimension as 'Consol' and 'Rates' since the FCCS…Vipusha Chandrakumaran 25 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to : Usage of Consolidation SettingsSummary: Hi, Could someone please explain the precise usage of consolidation settings and which options should be enabled under the types for optimal application perform…Sashidhar Reddy 22 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
SDM currency conversion not workingSummary: In SDM we are trying to execute currency conversion by following oracle standard document (, however we are not able to be get the results. Content: Conversion …Minal Jain-Oracle 14 views 3 comments 0 points Most recent by Minal Jain-Oracle Financial Consolidation and Close
-
Would Like Assistance with Performance Issue With ScriptWe have a script for doing a customize investment elimination but it seems to slow the consolidation. Script is not long (other than comments we added to explain the ste…Edwin Ocasio 82 views 36 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Enable Consolidation Member under Consolidation SettingsSummary: Enable Consolidation Member under Consolidation Settings Content (please ensure you mask any confidential information): We are using FCCS_Entity Input member as…Priyesh P. Rane 24 views 3 comments 0 points Most recent by Arun Ramamurthy -Oracle Financial Consolidation and Close
-
Issue with FCCS Create Block for Opening Balance AdjustmentSummary: Hello All - I need to copy the Opening Balance into Opening Balance Adjustment from one entity to the other. I see my script is not creating the block and check…Hari Jetti 48 views 20 comments 0 points Most recent by Pranab Kumar-279997 Financial Consolidation and Close -
proving total in FCCS_CTASummary: Client needs to show auditors that Total balance in FCCS_CTA is the sum of the parts (so to speak). Content (please ensure you mask any confidential information…Nancy Ackerman 30 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
We are facing performance issue in DSO applicationSummary: We are facing performance issue in DSO application. Force Translation (By Selected View) has been taken 4 hours for one period however non DSO was took 35 minut…Narinder Arora-162322 82 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Copy Ownsership to Next Year impacts all entitiesSummary: When I copy the ownership to the next year, all entities are impacted. Since I only want to see the status Ok/System Changed, I have to re-consolidate all my st…Marco Vissers 14 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
Seeded Consolidation Rules - Intercompany Consolidation or Intercompany Consolidation %Summary: Hi All, With regard to the seeded consolidation rules, please explain what does the attributes 'Intercompany Consolidation' and 'Intercompany Consolidation %' r…Vipusha Chandrakumaran 22 views 3 comments 0 points Most recent by Vipusha Chandrakumaran Financial Consolidation and Close
-
CTA is not calculated for Minority interest, when Parent and Base entity have same currencySummary: The Currency for Base and parent entity is same(i.e. CNY), so there in no CTA at parent currency for base entity. The base and the parent entity having same cur…Kirti 14 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unbale to export balances from data exchnage workbench in csv formatSummary: Unbale to export balances from data exchnage workbench in csv format. Content (please ensure you mask any confidential information): Export shows blank csv file…AlokPriyadarshi-Oracle 11 views 2 comments 0 points Most recent by AlokPriyadarshi-Oracle Financial Consolidation and Close
-
I have a situation where my 'Goodwill - Offset' member is computing data post-acquisition periodsSummary: I have a situation where my 'Goodwill - Offset' member is computing data post-acquisition period as well. Content (please ensure you mask any confidential infor…
-
How to handle parent entity move from a USD parent to an AUD parentSummary: What's the best way to handle the below scenario: Content (please ensure you mask any confidential information): When Entity is disposed from one parent and acq…