Consolidation
Discussion List
-
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 61 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 101 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 372 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 61 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 51 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 31 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 21 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 191 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 41 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 341 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 31 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 21 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 11 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 41 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… -
What's New in Oracle Cloud EPM Release 23.05Summary: Learn about what's new in Oracle Cloud EPM Release 23.05. Content (required): Please refer to the May 2023 What’s New guide to understand the new features inclu…Laura Ferris-Oracle 61 views 1 comment 1 point Most recent by Pavan-Oracle Financial Consolidation and Close