Consolidation
Discussion List
-
Consolidation runs twice when started in SmartViewSummary: We are noting that when users initiate a consolidation from SmartView the consolidation runs twice, and as the two overlap, the second one invariably fails and … -
Reversal entry from GL to use historical ratesSummary: An entry needs to use the historical rates to balance Content (required): It's an equity account reversal entry from GL; it is suppose to take the historical ra… -
Treatment of opening balance for aggregation of P&L and Balance Sheet accountsHi All, We have a situation on our Balance Sheet where we are rolling up multiple accounts into a summary account "Cashflow Hedge Reserve" this account is dynamic and is…Brian Somers 63 views 4 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close -
Holding Parent entities in FCCSSummary: Hi Experts, We have a requirement, where a parent entity is holding for it's parent hierarchy. Below is the example: 'E_1001_Co' (which is a parent of E_1001 an…Anand Rasa 112 views 8 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close -
Amount Override is not working in FCCSSummary: In FCCS, looks like amount override is not working. I have loaded the data using DM from ERP and configured this account as '125649' with historical amount over…SenthilSSN 375 views 3 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
Eliminations using Override intead of Parent CurrencySummary: Hi Experts, We are having a requirement of considering 'Override translated balances' of historical accounts for Elimination, instead of Parent Currency. Where …
-
Ignore an account under FCCS_Retained EarningsSummary: HI, As per the reporting requirement, we have created a base account members 'A32111' as equity under FCCS_Retained Earnings, but the same base account should n…
-
sizing MS SQL to OracleSummary: hi team for Sizing from MS-SQL to Oracle DB Content (required): i want to migrate Microsoft SQL VM with 16 vcpu , 128GB Memory to cloud as oracle database ( is …
-
FCCS Time bound configuration for ValidationsSummary: Hello All, Is there any way in FCCS to configure data validations on Period basis. I mean, can I provide a condition like a validation to be applied for only Ja…
-
Reporting currency translation issue with some entitiesSummary: Hi, We have 3 Reporting currencies in FCCS, but one of them i.e. GBP_Reporting is not getting translating for some entities and periods. Same entities are trans…
-
Notifications to All UsersSummary: is there a way to send notifications to all users (or a subset of them) whenever a Consolidation is triggered ? I tested a bit the notification feature but soun…Emanuele Panichi 63 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Consolidation delay starting in EssbaseSummary: There several minutes delay between the launching of consolidation rule and the effective starting into Essbase sessions; once started it's very fast. How this …Fabio Fiore 53 views 1 comment 0 points Most recent by Pavan-Oracle Financial Consolidation and Close -
FCC Configurable Consolidation screen display issueHi All, I'm having an issue with one of my client's application (client A) where the Configurable Consolidation screen gets cut off. I am not able to see the Currency an…Marie Traverso 33 views 2 comments 0 points Most recent by Marie Traverso Financial Consolidation and Close
-
What is the exchange rate when we run the scenario to YTD?Summary: Content (required): Exchange rate for the Apr - 1.5 May - 1.9 Jun - 1.2 Jul - 1.7 when we run the YTD balances for the period JUL what will take as Exchange rat…Sanjana Ravihara 23 views 1 comment 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close
-
Historical Rates Query - UrgentSummary: Historical Rates Query - Urgent Content (required): We have uploaded historical rates for March-2023 and April-2023 with RollForward as "No" and submitted "Tran… -
Export mode Replace in Data Management does not zerolize YTD valuesSummary: Export mode Replace in Data Management does not zerolize YTD values when there is no line of data for a given POV Content (required): We noticed that exporting …MCV 193 views 8 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
Parent Entity Ownership % being smaller than Child Entity %Hello all! How do you all deal with the situation in which the Parent entity has a smaller percentage of participation than its children entities?Example: [Parent]Entity…Guido Zanella 44 views 2 comments 0 points Most recent by Mukesh Chughani Financial Consolidation and Close -
FCCS_110 rule to load 0 in place of #missingSummary: Need to write a config consol rule to replace #missing values with 0 Content (required): DSO application. I'm running into a variant of the issue where an accou…SAW23321 343 views 20 comments 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close
-
Consolidation - which ledger need to upload Historical RatesSummary: Consolidation - which ledger need to upload Historical Rates Content (required): Business case: Ledger 1: GBP Ledger - Transactions in GBP. Ledger 2: Created Re…Kumar 57 34 views 1 comment 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close
-
Is it Possible to apply PMIN %age on Company A taken from Company B using Configurable CalculationSummary: We have a case where i need to compute NCI on Profit of Company A based on the PMIN %age in Company B. Is it possible or we have to write custom calculation scr…Jai Prakash 24 views 1 comment 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close -
HFM : Translations for RE AdjustmentsContent (required): Hello All, I entered some amount in RE Adjustment in Entity Currency, and ran the consolidation (since the translation also happening in consolidatio…Ram Kashyap 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCC: Mezzanine parent account under FCCS_Total Balance SheetSummary: Hello, We wanted to create a custom parent member as Mezzanine under FCCS_Total Balance Sheet & Sibling of FCCS_Total Liabilities like in the below screenshot. …
-
FCC: Delete parents account and the Consolidation status for Prior periodsSummary: We wanted to move a few level 0 accounts to another parent and delete the old parent account members. My question is, do we need to re-run the consolidation for…
-
How to apply CICTA behavior for historical accounts on some entities and CTA for other entities?Summary: Integrated Entities - Historical Rates - Translation Behavior Content (required): We have a client which has integrated entities. These entities have non-moneta…Hema Vaidyanathan 43 views 1 comment 1 point Most recent by Pavan-Oracle Financial Consolidation and Close
-
Business RulesSummary Business Rule executionContent In the EPM TRCS application, Business Rules are pre-defined for execution and no custom rules can be scripted. For instance, for B…