Hall 2 of the FCCS EPM Cloud Study Tour

Metadata Gallery

The architecture of truth in FCCS. Every dimension, hierarchy, member property, and intercompany profile that drives consolidation logic for GlobalMerge Corp's multi-currency ownership structure.

8 Dimensions Hierarchies & Alt Rollups ICP Framework Metadata Refresh & SC Status GlobalMerge Corp Case Lab + Exam
🗂️ What Is FCCS Metadata?
The skeleton of every consolidation application

In Oracle FCCS (Financial Consolidation and Close Service), metadata is the structural definition of your application — the dimensions, members, hierarchies, aliases, attributes, and consolidation rules that FCCS uses to know how to aggregate, eliminate, and translate data.

Unlike a general-purpose EPM cube where you build whatever dimensions you like, FCCS ships with a fixed set of eight system dimensions that map directly to consolidation concepts: Entity, Account, Scenario, Year, Period, View, ICP, and Movement. Some dimensions allow custom members; others are partially locked. Understanding which is which — and why — is a cornerstone exam topic.

🔑 Core Principle

Metadata is not just structure — it encodes business logic. The consolidation method (Full/Proportional/Equity), ownership percentage, elimination behaviour, and currency translation rules are all stored as member properties within the metadata.

📦 The Eight Core Dimensions
System-defined dimensions in every FCCS application
Entity
Legal entities, business units, and geographic nodes. Defines the consolidation hierarchy and stores currency, method, and ownership properties.
Custom members ✓ · ICP source
Account
Chart of accounts — P&L, Balance Sheet, Flow, Supplemental. Account type drives sign logic and translation rate (historical vs. current vs. average).
Custom members ✓ · Account type required
Scenario
Actual, Budget, Forecast etc. Each scenario carries a default frequency, start year/period, and translation override option.
Custom members ✓ · Translation method per scenario
Year
Fiscal years defined at application creation. FY2020–FY2030 is typical. Fixed range; requires admin action to extend.
System-generated · Application setting
Period
Monthly periods (Jan–Dec) plus system periods: Prior, First, Q1–Q4. Period frequency is set per application and cannot be changed post-creation.
System members + custom sub-periods
View
YTD (Year-to-Date), Periodic, and QTD. Controls how period-to-date calculations are derived. You cannot add or remove View members.
Fixed 3 members · No custom additions
ICP
Intercompany Partner dimension. System auto-populates ICP members from Entity leaf nodes. ICP_Entities is the system parent for all entity-mirrored ICP members.
Auto-populated from Entity · + custom
Movement
Tracks roll-forward of Balance Sheet items: OpeningBalance, Additions, Disposals, ClosingBalance. Required for multi-period flow analysis.
System members · Custom members ✓
🔄 Intercompany Partner (ICP) Dimension
The elimination engine's address book

ICP is the dimension that makes intercompany elimination possible. When an entity records a transaction with another entity in the group, it tags the balance with the partner's ICP code. FCCS then matches those paired balances and eliminates them during consolidation.

⚠️ Key Rule — ICP vs. Non-ICP Accounts

Not every account needs ICP tagging. In FCCS you set the IsICP property on an Account member to Y or N. Only ICP-enabled accounts can carry an ICP partner code. Typical ICP accounts: Intercompany Receivables, Payables, Revenue from affiliates, Expenses to affiliates.

The system creates a matching ICP member for every base (leaf) entity. So for GlobalMerge Corp's structure, the ICP dimension automatically contains:

▸ ICP_Total
▸ ICP_Entities system
ICP_GlobalMerge parent — no transactions
ICP_BritEdge leaf
ICP_DeutschWerk leaf
ICP_AsiaLink leaf
ICP_NovaTech leaf
ICP_[None] external / third party
💡 ICP_[None] vs ICP_Entities

ICP_[None] is used when a transaction has no intercompany partner — i.e. it's with a third party. You must always intersect ICP-enabled accounts with either a specific partner or ICP_[None]; leaving it blank causes a data load error.

🌐 GlobalMerge Corp — Entity Hierarchy
Ownership structure driving consolidation methods

GlobalMerge Corp is the UK-based holding company. Below it sit four operating subsidiaries across different jurisdictions and ownership levels — each requiring a different consolidation treatment.

GlobalMerge Corp Top Parent · USD reporting
BritEdge Ltd GBP · 100%Full Consolidation
Shares in BritEdge: 100 of 100
DeutschWerk GmbH EUR · 80%Full Consolidation
Shares in DeutschWerk: 80 of 100
Non-controlling Interest: 20%
AsiaLink Pte Ltd SGD · 50% JVProportional
Joint venture — neither partner controls
NovaTech Inc USD · 30%Equity Method
Significant influence; not a subsidiary
📌 Why the Method Matters for Metadata

The consolidation method is stored as a member property on the Entity (PCON% = percentage consolidation). FCCS reads this property at runtime. Full = 100% of assets/liabilities + NCI elimination. Proportional = only the owned % flows through. Equity = single-line investment only; no line-by-line aggregation.

📊 Account Types & Translation Rates
How account metadata governs currency translation
Account Type Examples Translation Rate Sign Behaviour
ASSET Cash, Receivables, PPE Closing Rate Debit increases
LIABILITY Payables, Debt, Provisions Closing Rate Credit increases
EQUITY Share Capital, Retained Earnings Historical Rate Credit increases
REVENUE Sales, Other Income Average Rate Credit increases
EXPENSE COGS, Opex, D&A Average Rate Debit increases
FLOW Cash Flow movements Depends on sub-type Net flow
CURRENCYRATE USD, EUR, GBP exchange rates N/A — stores rates N/A
GROUPLABEL Subtotal headers only N/A — calculated Sum of children
🌲 Hierarchies & Alternate Rollups
Primary vs. alternate hierarchies in Entity and Account dimensions

FCCS supports alternate hierarchies (also called alternate rollups) within a dimension. A member can appear in multiple hierarchies simultaneously — this is called shared membership. The primary hierarchy determines the default aggregation path; alternate hierarchies enable reporting cuts such as region, product line, or legal vs. management structure.

⚠️ Exam Trap — Shared vs. Duplicate

A shared member is the same physical member appearing in two hierarchy branches. Data is stored once; the member just rolls up in two places. A duplicate member (not supported in FCCS base dimensions) would be two distinct members with the same name — FCCS does not allow this in the Entity dimension.

🔀 Entity Alternate Hierarchies — GlobalMerge Corp

Beyond the legal ownership hierarchy, GlobalMerge uses two alternate rollups in the Entity dimension for management reporting:

Primary Hierarchy — Legal Structure
GlobalMerge Corp
BritEdge Ltd 100%
DeutschWerk GmbH 80%
AsiaLink Pte Ltd 50% JV
NovaTech Inc 30% Equity
Alternate Hierarchy 1 — Geographic Rollup
GeoTotal
EMEA
BritEdge Ltd shared
DeutschWerk GmbH shared
APAC
AsiaLink Pte Ltd shared
Americas
NovaTech Inc shared
Alternate Hierarchy 2 — Currency Group
CurrencyTotal
GBP_Entities
BritEdge Ltd shared
EUR_Entities
DeutschWerk GmbH shared
SGD_Entities
AsiaLink Pte Ltd shared
USD_Entities
NovaTech Inc shared
🏷️ Key Member Properties
Properties stored on Entity and Account members that drive logic
Property Dimension Values Effect
DefaultCurrency Entity GBP, EUR, SGD, USD… Sets the entity's local currency for data entry and translation
PCON% Entity 0–100 Consolidation percentage; drives proportional aggregation
POWN% Entity 0–100 Ownership %; used for equity pickup and NCI calculation
Method Entity Consolidate / Equity / Proportional / None Determines which consolidation logic FCCS applies
IsICP Account Y / N Enables intercompany partner tagging on this account
AccountType Account Asset/Liability/Equity/Revenue/Expense/Flow Governs sign logic and default translation rate type
DataStorageType All dims Store / Dynamic Calc / Never Share Controls whether data is physically stored or calculated on-the-fly
Alias All dims String (language tables) Display labels in forms and reports; does not affect storage
Custom Attributes Entity, Account User-defined Enables filtering, smart lists, and supplemental grouping
🔃 Metadata Refresh & System Check (SC) Status
What happens after you modify metadata — and what to watch for

Any time you add, edit, or delete members, hierarchies, or member properties in the Metadata screen, FCCS marks the application as needing a Metadata Refresh. Until the refresh completes, the application may show stale data or refuse to run consolidations.

⚡ Metadata Refresh — Key Behaviours

Refresh is triggered from Application > Consolidation > Refresh. It rebuilds all dimension caches, rebuilds the dynamic calc script, and invalidates any stored data that is now structurally inconsistent.

A refresh does not delete existing data — but data at deleted members becomes inaccessible. Members can be disabled ("hidden") without a data-destructive refresh cycle.

SC Status After Metadata Refresh

The System Check (SC) runs automatically after every metadata refresh and is also available on-demand. It validates structural integrity and reports status per entity-scenario-period intersection.

OK 1 — OK No issues; ready to consolidate
Impacted 6 — Impacted Metadata change invalidated data; reconsolidate
Needs Translation 3 — Needs Translation Exchange rates changed; retranslation required
Locked 10 — Locked Period locked by admin; no further input
No Data 4 — No Data No input data submitted for this entity/period
Matched 5 — Matched IC balances reconcile within tolerance
Unmatched 7 — Unmatched IC mismatch exceeds tolerance; blocks elimination
Consolidated 2 — Consolidated Consolidation run successfully completed
⚠️ After Metadata Refresh — GlobalMerge Scenario

If an admin adds a new Account member (e.g., IC_Revenue_AsiaLink) and runs a refresh, all entities that have already consolidated in the current period will flip from status 2 (Consolidated) to status 6 (Impacted). The admin must notify the consolidation team to re-run the consolidation process.

AsiaLink (50% JV, SGD) would additionally show 3 (Needs Translation) if any FX rates were updated as part of the metadata package refresh.

📄 Metadata Load File — Format Reference
EPM Automate / Data Management file format for metadata import

Metadata is loaded via a .csv or .xlsx file through the FCCS Metadata Editor UI, or automated via EPM Automate commands. The header row defines property columns; rows below represent individual members.

// Entity metadata CSV — excerpt for GlobalMerge Corp structure MemberName,Parent,Alias,DefaultCurrency,PCON%,POWN%,Method,IsICP GlobalMerge,Entity,GlobalMerge Corp,USD,100,100,Consolidate,N BritEdge,GlobalMerge,BritEdge Ltd,GBP,100,100,Consolidate,Y DeutschWerk,GlobalMerge,DeutschWerk GmbH,EUR,100,80,Consolidate,Y AsiaLink,GlobalMerge,AsiaLink Pte Ltd,SGD,50,50,Proportional,Y NovaTech,GlobalMerge,NovaTech Inc,USD,0,30,Equity,N
💡 PCON% vs POWN% — DeutschWerk Example

DeutschWerk has POWN% = 80 (we own 80%) but PCON% = 100 (we consolidate 100% of its balances — full consolidation method). The 20% NCI is then separately calculated and posted as an elimination. This is the key distinction: POWN governs equity and NCI calc; PCON governs how much data flows into the consolidated numbers before eliminations.

🔬 Lab Overview
Hands-on metadata configuration for GlobalMerge Corp

In this lab you will build the complete metadata structure for GlobalMerge Corp from scratch using the FCCS Metadata screen. You'll configure Entity members with ownership properties, tag ICP-enabled accounts, define an alternate geographic hierarchy, and observe how SC status changes after each metadata refresh cycle.

🧰 Prerequisites

Access to an FCCS sandbox application · Service Administrator role · Navigator > Application > Consolidation open in a separate tab · GlobalMerge_Metadata_v1.csv available in your EPM Automate workspace

1️⃣ Exercise 1 — Load Entity Metadata
Estimated time: 15 minutes
  1. 01 Navigate to Application > Overview > Dimensions and select the Entity dimension.
  2. 02 Click Import and upload GlobalMerge_Metadata_v1.csv. Select Update existing members mode.
  3. 03 After import completes, verify all four subsidiaries appear under GlobalMerge in the hierarchy pane. Confirm DefaultCurrency values: BritEdge=GBP, DeutschWerk=EUR, AsiaLink=SGD, NovaTech=USD.
  4. 04 Check PCON% vs POWN% for each entity. DeutschWerk should have PCON=100, POWN=80. AsiaLink should have both PCON=50, POWN=50. NovaTech should have PCON=0, POWN=30.
  5. 05 Click Refresh Database and wait for the job to complete. Note the timestamp.
✅ Expected Outcome

All four entity members appear correctly. ICP dimension auto-populates with ICP_BritEdge, ICP_DeutschWerk, ICP_AsiaLink, ICP_NovaTech under ICP_Entities. SC Status for all entities in the current open period shows 6 (Impacted) — because the metadata refresh invalidated any previously consolidated data.

2️⃣ Exercise 2 — Configure Alternate Geographic Hierarchy
Estimated time: 20 minutes
  1. 01 In the Entity dimension editor, click Add Member and create three parent-only nodes: EMEA, APAC, Americas. Set DataStorageType = Label Only (no data stored).
  2. 02 Create a top-level parent GeoTotal with EMEA, APAC, Americas as children.
  3. 03 Add shared members of BritEdge and DeutschWerk under EMEA. Right-click each entity > Add Shared Member.
  4. 04 Add shared members: AsiaLink under APAC, NovaTech under Americas.
  5. 05 Confirm that shared members show a different icon (ghost/shared indicator) in the hierarchy. Refresh database.
  6. 06 Open a data form and verify that the GeoTotal hierarchy is available as an alternate row/column selection.
💡 Shared Member Behaviour

When you run a consolidation for GlobalMerge (primary hierarchy), the data also rolls up through GeoTotal automatically because the same physical data cells underlie both hierarchy paths. No extra consolidation run is needed for the alternate hierarchy.

3️⃣ Exercise 3 — ICP Account Setup & SC Status Walkthrough
Estimated time: 25 minutes
  1. 01 Navigate to the Account dimension. Locate IntercompanyReceivables and set IsICP = Y. Repeat for IntercompanyPayables, ICSales, ICExpenses.
  2. 02 Confirm that Cash, Revenue, and COGS have IsICP = N. These should never carry intercompany partner tags.
  3. 03 Run a metadata refresh. Navigate to Consolidation > System Check. Observe that all entities now show status 6 (Impacted).
  4. 04 Submit trial balance data for BritEdge (Actual, Jan-25). Set ICSales with partner ICP_DeutschWerk = GBP 500,000. Submit data for DeutschWerk: ICExpenses with partner ICP_BritEdge = EUR 580,000 (approx equal at spot rate).
  5. 05 Run IC Matching from the task flow. If the GBP/EUR difference is within tolerance (±0.5%), status should move to 5 (Matched). Run consolidation. Status moves to 2 (Consolidated).
  6. 06 As an admin, add a new Account member IC_Advisory_Fees with IsICP=Y. Refresh metadata. Observe that BritEdge and DeutschWerk flip back to 6 (Impacted).
🏆 Lab Challenge — AsiaLink Proportional

AsiaLink has PCON=50%. After consolidation, verify in the parent-level (GlobalMerge) data that only 50% of AsiaLink's balances appear. Check the Contribution member in the View dimension — it shows the entity's proportional share before parent adjustments. Compare this with BritEdge (PCON=100%) to cement the difference.

📝 Exam Preparation
Practise questions mapped to Oracle FCCS Certification objectives

These questions mirror the style, complexity, and trap-setting of the official Oracle FCCS Implementation Specialist examination. Each question covers metadata-related objectives. Click Reveal Answer after attempting each question.

Question 1 of 8 · Entity Dimension Properties
GlobalMerge Corp owns 80% of DeutschWerk GmbH. The administrator sets PCON% = 100 and POWN% = 80 on the DeutschWerk entity member. Which statement is correct?
  • AFCCS will consolidate only 80% of DeutschWerk's balances into GlobalMerge.
  • BFCCS will consolidate 100% of DeutschWerk's balances, and POWN% drives the NCI elimination calculation separately.
  • CPCON% and POWN% must always be set to the same value; setting them differently causes a metadata validation error.
  • DFCCS will apply the equity method because POWN% is less than 100%.
Correct: B. PCON% controls how much of the entity's data flows into the parent — 100% means Full Consolidation. POWN% controls ownership-based calculations like NCI (Non-Controlling Interest) eliminations and equity pickup. They can and often do differ for majority-owned subsidiaries.
Question 2 of 8 · ICP Dimension
Which of the following statements about the ICP dimension in FCCS is TRUE?
  • AThe ICP dimension must be manually populated with member names that match the Entity dimension.
  • BAny account can be used to record intercompany transactions regardless of the IsICP property.
  • CFCCS automatically creates ICP members from base (leaf) Entity members; parent entities do not generate ICP members.
  • DICP_[None] represents a third-party transaction partner and must be manually added to the ICP hierarchy.
Correct: C. FCCS auto-generates ICP members from leaf entities only — parent entities like GlobalMerge Corp do not get an ICP mirror member. ICP_[None] is a built-in system member (no manual creation required) and is used for external/third-party transactions. IsICP must be Y on the Account for a partner tag to be accepted.
Question 3 of 8 · Metadata Refresh & SC Status
After a metadata refresh that added new account members, an administrator notices that several entity-period intersections that were previously showing status "2 – Consolidated" now show status "6 – Impacted". What is the correct next action?
  • ARun a System Check to reset the status codes back to Consolidated automatically.
  • BDelete and re-enter all input data for the affected periods.
  • CRe-run the consolidation process for the affected entities and periods.
  • DReverse the metadata change and roll back to the prior metadata version to restore Consolidated status.
Correct: C. Status 6 (Impacted) means the structural change has invalidated the stored consolidated results. The input data is intact — it does not need to be re-entered. Re-running consolidation will recalculate and re-store results against the new metadata structure, returning status to 2 (Consolidated).
Question 4 of 8 · Consolidation Method — AsiaLink
AsiaLink Pte Ltd is a 50/50 Joint Venture. GlobalMerge Corp uses the Proportional method (PCON% = 50). After consolidation, how much of AsiaLink's SGD 2,000,000 Revenue will appear in GlobalMerge's consolidated P&L (before currency translation)?
  • ASGD 2,000,000 — full revenue consolidation regardless of ownership.
  • BSGD 1,000,000 — proportional share (50%) of AsiaLink's revenue.
  • CSGD 0 — equity method means no line-by-line consolidation.
  • DSGD 600,000 — only the minority portion is eliminated.
Correct: B. Proportional consolidation (PCON = 50%) means exactly 50% of each line item flows into the parent. SGD 2,000,000 × 50% = SGD 1,000,000. This is then translated to USD using the Average Rate for Revenue accounts. No NCI posting is required under the proportional method.
Question 5 of 8 · Alternate Hierarchies
A user wants BritEdge Ltd to appear in both the primary Legal hierarchy under GlobalMerge Corp AND in an alternate Geographic hierarchy under EMEA. Which member type should the administrator create in the alternate hierarchy?
  • AA duplicate member with the same name but a different member ID.
  • BA shared member of BritEdge under the EMEA parent.
  • CA Label Only member named BritEdge_EMEA with no data storage.
  • DAn alias override mapping BritEdge to the EMEA node.
Correct: B. Shared members allow one physical member to appear in multiple hierarchy branches. Data is stored once and aggregates correctly through all hierarchies. FCCS supports shared members in the Entity dimension. Duplicate members (A) would cause data integrity issues and are not supported for system dimensions.
Question 6 of 8 · Account Types & Translation
DeutschWerk GmbH has Share Capital of EUR 5,000,000 recorded at the historical rate when it was issued. In FCCS, which Account Type property ensures this account is translated using the Historical Rate rather than the Closing Rate?
  • AASSET — Assets always use Historical Rate.
  • BEQUITY — Equity accounts default to Historical Rate translation.
  • CREVENUE — Revenue accounts are translated at Average Rate.
  • DFLOW — Flow accounts always use the Closing Rate.
Correct: B. EQUITY account type triggers Historical Rate (HR) translation. ASSET and LIABILITY types use Closing Rate (CR). REVENUE and EXPENSE use Average Rate (AR). The account type metadata property is how FCCS knows which exchange rate to apply — no custom rule is needed for standard translation behaviour.
Question 7 of 8 · View Dimension
Which statement correctly describes the View dimension in FCCS?
  • AAdministrators can add custom View members for quarterly reporting.
  • BThe View dimension has 5 fixed members: YTD, Periodic, QTD, MTD, Inception-to-Date.
  • CThe View dimension has exactly 3 system members (YTD, Periodic, QTD) and cannot be extended with custom members.
  • DThe View dimension is optional and can be removed from the application if not needed.
Correct: C. The View dimension in FCCS is fixed at three members: YTD (Year-to-Date), Periodic (single period), and QTD (Quarter-to-Date). You cannot add, remove, or rename View members. It is a required system dimension. This is a common exam question because candidates confuse FCCS's locked View dimension with the more flexible dimensions in HFM or PBCS.
Question 8 of 8 · NovaTech — Equity Method
NovaTech Inc has PCON% = 0 and POWN% = 30, with Method = Equity on its Entity member. After consolidation, what appears in GlobalMerge Corp's consolidated Balance Sheet in relation to NovaTech?
  • A30% of all NovaTech asset and liability balances aggregated line by line.
  • B100% of NovaTech's net assets, with a 70% NCI elimination.
  • CA single-line "Investment in NovaTech" equal to GlobalMerge's share of NovaTech's net assets (30% of net equity).
  • DNothing — PCON% = 0 means NovaTech is fully excluded from consolidated financials.
Correct: C. Equity Method (PCON = 0) means no line-by-line consolidation. Instead, a single investment line reflects GlobalMerge's proportionate share of NovaTech's net equity (30%). FCCS posts this to the "Investment in Subsidiaries" account. NovaTech's individual revenues, expenses, assets, and liabilities do not appear in the consolidated trial balance — only the investment value does.