GlobalMerge Corp files consolidated financial statements under IFRS. It has subsidiaries in four countries, each running a different ERP — SAP in Germany, Oracle Financials in the UK, a local system in Singapore, and NetSuite for NovaTech. Every quarter, the group finance team used to do this: export trial balances from each system, paste into a master Excel file, manually translate currencies using that period's exchange rates, then manually eliminate intercompany transactions by matching invoices across entities.
What went wrong, every quarter: DeutschWerk GmbH invoiced BritEdge Ltd £420,000 for components. BritEdge recorded it as a purchase (COGS). DeutschWerk recorded it as revenue. In the consolidated P&L, that £420,000 appeared as both revenue and cost — inflating both sides of the group P&L. Finding and removing it manually, across four currencies, took two days and still produced restatements.
FCCS was purpose-built to automate exactly this — currency translation, intercompany elimination, ownership-weighted consolidation, and audit trail — in a controlled, governed cloud environment.
FCCS (Financial Consolidation & Close) — statutory consolidation, intercompany eliminations, currency translation, ownership management, legal entity reporting. The authoritative source of group financial results.
PBCS / EPBCS (Planning) — operational and financial planning, budgeting, forecasting. Data flows from PBCS into FCCS as the Actual scenario, not the other way around.
ARCS (Account Reconciliation) — reconciles sub-ledger balances to GL during the close process. Feeds certified balances into FCCS.
Narrative Reporting — takes FCCS consolidated results and wraps them in management commentary, disclosures, and board packs. The published output layer.
In GlobalMerge Corp's architecture: BritEdge's UK SAP sends a trial balance → FCCS ingests it via Data Management → FCCS consolidates with other entities → Narrative Reporting generates the IFRS group accounts.
The consolidation method applied to any entity is entirely determined by one number: the ownership percentage held by the parent. Everything else — what goes in the financial statements, which eliminations run, whether minority interest appears — flows from that single number.
| Ownership % | Control type | FCCS method | What appears in group financials | GlobalMerge example |
|---|---|---|---|---|
| 100% | Full control | Full consolidation | Every line item — revenue, costs, assets, liabilities — added 100%. All intercompany transactions eliminated. | BritEdge Ltd. Its entire P&L and balance sheet appear in GlobalMerge's group accounts. |
| >50% to <100% | Control with minority | Full + minority interest | 100% of assets/liabilities consolidated, but the minority share of net income and equity is carved out and disclosed separately. | DeutschWerk GmbH at 80%. Group includes 100% of DeutschWerk's revenue and costs. Discloses: "Non-controlling interest: 20% of DeutschWerk net income = €X". |
| 50% (JV) | Shared control | Equity method | A single line on the balance sheet: "Investment in JV = cost + share of cumulative profits". Share of net income appears as one line in P&L. No line-by-line consolidation. | AsiaLink Pte. GlobalMerge does not add AsiaLink's revenue or costs to group revenue/costs. Balance sheet shows "Investment in AsiaLink = $12.4m". P&L shows "Share of JV income = $1.1m". |
| <50% | No control | Equity method / Investment | Investment at cost on balance sheet. Share of net income if significant influence exists. Zero line items from this entity flow into group revenue, costs, or other P&L lines. | NovaTech Inc at 30%. Acquired mid-year. Only the investment carrying value and GlobalMerge's 30% share of NovaTech's post-acquisition net income appear in group accounts. |
The consolidation path question (Q3 on 1Z0-1081-25) asks which dimension combination FCCS uses: the certified answer is Currency → Account → Movement. But in a live implementation, you spend your time working through Entity, Consolidation, and Currency intersections — tracing where Entity Input data translates to Parent Currency, how Proportion and Contribution members populate, why an entity shows "Impacted" status. Both are true. They answer different questions. The exam tests the arithmetic path. Real work requires understanding the consolidation workflow.
Step 1 — Entity Input / Entity Currency: DeutschWerk's finance team loads their trial balance. Revenue = €5,000,000. This sits at DeutschWerk × Entity Input × EUR. Raw, untouched source data.
Step 2 — Translation to Parent Currency: FCCS applies the exchange rate (EUR → USD) and writes the translated result to DeutschWerk × Entity Input × USD. Revenue becomes $5,450,000 at a 1.09 rate.
Step 3 — Entity Total: FCCS_EntityTotal dynamically aggregates Entity Input and Entity Consolidation (zero at leaf entity level). Starting point for proportional calculations.
Step 4 — Proportion: FCCS applies ownership % = 80%. Proportion = $5,450,000 × 80% = $4,360,000. Written to DeutschWerk × FCCS_Proportion × USD.
Step 5 — Elimination: Intercompany balances between DeutschWerk and BritEdge are processed here. If DeutschWerk sold €420,000 of goods to BritEdge, that intercompany revenue is eliminated via the ICP dimension.
Step 6 — Contribution: Proportion + Elimination adjustments = the net amount DeutschWerk contributes to GlobalMerge's consolidated result. This Contribution rolls up to the parent entity.
The 20% minority interest is automatically derived as Entity Total minus Proportion = $5,450,000 × 20% = $1,090,000, disclosed separately in the group equity section.
"Metadata Administrator" is not a valid FCCS predefined role. It does not exist. The role required to access Dimension Management directly from within FCCS is Service Administrator. This appears in exam distractors precisely because it sounds plausible. There are exactly four predefined roles: Service Administrator, Power User, User, Viewer.
-
1
Access Oracle EPM Cloud via My Services. Navigate to Financial Consolidation and Close. Select
Actions → Create Application. Only a Service Administrator can execute this step. -
2
Configure the application name and time period. Name: GlobalMerge_PROD. Time period: choose between 12-month or 13-month. For GlobalMerge, 12-month (Jan–Dec) aligns with IFRS reporting calendar.Exam alert (Q2): Only 12-month and 13-month are available. No 14-month. No custom period count. The 13-month option exists for entities that use a period-13 for year-end audit adjustments — a genuine use case, not an Oracle quirk.
-
3
Enable Multi-Currency. Select Yes. Define base input currencies: GBP (BritEdge), EUR (DeutschWerk), SGD (AsiaLink), USD (NovaTech, GlobalMerge). Set USD as the group reporting currency.If Multi-Currency is not enabled here, the Currency dimension will not appear in the application at all. It cannot be added retroactively — this is a permanent architectural decision, not a settings change.
-
4
Enable Intercompany Data tracking. Select Yes — GlobalMerge has active intercompany transactions between BritEdge and DeutschWerk. This creates the Intercompany (ICP) dimension automatically, with ICP members generated for each entity tagged as an intercompany entity.
-
5
Enable Track Intercompany Elimination (optional but important for GlobalMerge). When enabled, this option causes FCCS to separate elimination values by Data Source — so you can report intercompany eliminations broken out by source system.Exam alert (Q4): This does NOT turn on intercompany eliminations. Eliminations run regardless. What this option adds is Data Source granularity in elimination reporting. The certified answer: "process will separate total elimination values by Data Source." The common wrong answer is "enables the application to perform intercompany eliminations" — that happens anyway.
-
6
Review system-generated dimensions. FCCS creates 11 system dimensions automatically. Navigate to
Application → Overview → Dimensionsto verify all 11 are present.
| Environment | Patch Day | Implication for the GlobalMerge Team |
|---|---|---|
| TEST | First Friday of month | Run regression tests on TEST over the following two weeks. Verify all consolidation rules, data loads, and reports still function correctly after the patch. |
| PROD | Third Friday of month | PROD is updated two weeks after TEST. If issues were found in TEST and not resolved before PROD patch day, raise a Service Request with Oracle immediately. |
GlobalMerge's Q1 close runs the third week of April. If Oracle's April PROD patch introduces a regression in the consolidation engine, the finance team is mid-close with a broken system. Service Administrators must track the patch calendar and run close simulations in TEST before every PROD patch window.
You have just been onboarded as the FCCS Service Administrator at GlobalMerge Corp. The previous admin left with minimal documentation. Your first task: create the production FCCS application from scratch and verify it is correctly configured before handing access to the group finance team for Q1 close.
The CFO has flagged one concern: last quarter, the group P&L showed inflated revenue because DeutschWerk's intercompany sales to BritEdge were not eliminated. She wants to see intercompany eliminations tracked by Data Source so the audit team can verify elimination entries separately from regular data loads.
NovaTech was acquired 30% mid-year. The equity method accounting for NovaTech must be configured, and the finance team needs a Viewer-only account for NovaTech's management team to see their contribution to group accounts.
- Create the application. Name: GlobalMerge_PROD. Time period: 12-month. Confirm only 12-month and 13-month are offered — if you see a 14-month option, something is wrong with your environment configuration.
- Enable Multi-Currency. Add entity currencies: GBP, EUR, SGD, USD. Set USD as the reporting currency. Navigate back to Dimensions after creation and confirm the Currency dimension appears. If it does not, multi-currency was not enabled.
- Enable Intercompany Data and Track IC Elimination. The CFO requires elimination tracking by Data Source. Confirm after application creation that FCCS_Intercompany Eliminations appears as a member in the Data Source dimension.
-
Verify the 11 system dimensions via
Application → Overview → Dimensions. All 11 must be present: Entity, Account, Movement, Consolidation, Currency, ICP, Data Source, Scenario, Year, Period, View. - Create user accounts. Group Finance Manager (Power User), BritEdge controller (User), DeutschWerk controller (User), External Auditor (Viewer), NovaTech management (Viewer). Do not assign anyone as Service Administrator except yourself and one backup.
- Validate role boundaries. Log in as the BritEdge controller (User). Attempt to navigate to Dimension Management. Confirm access is denied. Log back in as Service Administrator.
- Note the patch schedule. Check the current month's first and third Fridays. If Q1 close falls near a patch window, flag this to the CFO and plan a TEST regression run before the PROD patch.
Your colleague created a test application called GlobalMerge_UAT but forgot to enable Multi-Currency at creation time. The Currency dimension does not appear anywhere in the application. The DeutschWerk controller is trying to load EUR trial balance data but the currency intersection simply doesn't exist.
Question: Can you add the Currency dimension to an existing FCCS application after creation, or do you need to recreate the application from scratch?
Multi-Currency must be enabled at application creation. It cannot be added retroactively. GlobalMerge_UAT must be deleted and recreated with Multi-Currency enabled. This is exactly why the application creation checklist matters — skipping an option here has permanent consequences, not just a settings change.
- → DeutschWerk is owned at 80%. The group consolidates 100% of DeutschWerk's revenue and costs, then discloses minority interest. Why consolidate 100% rather than just 80%? What accounting principle drives this?
- → AsiaLink is a 50% JV — FCCS applies the equity method, so AsiaLink's revenue and costs never appear in GlobalMerge's P&L. But what if AsiaLink has a large intercompany transaction with BritEdge — does FCCS still need to eliminate it? Think carefully about what the equity method means for intercompany elimination logic.
- → NovaTech was acquired mid-year at 30%. How does FCCS handle partial-year consolidation? What does the opening balance look like for NovaTech in the Movement dimension in the acquisition period?
- → The consolidation path runs Currency → Account → Movement, but your day-to-day implementation work traces Entity → Consolidation → Currency intersections. These are not contradictory — draw out why both statements are correct and what each is actually describing.
- → Why does Oracle update TEST two weeks before PROD? What should a Service Administrator actually do in that two-week window, and what happens if they don't?
Questions progress from Recall → Application → Scenario. Click an option to reveal the answer and explanation. Use the score at the end to decide if you are ready to move to Hall 2.