New here?This is the operational companion to FCCS NCI Calculation: Backing Out the Non-Owned Portion. That piece explains where NCI comes from: the two seeded rulesets and the seven-component rollforward. This one is about proving it’s right. If you haven’t read it yet, start there; everything below assumes the mechanics.
The Validation Query
Smart View Layout
One rule before the layout: a dimension can appear on either the POV or an axis, never both. If you pin Movement in the POV and also put FCCS_OpeningBalance / FCCS_ClosingBalance in the rows, you’re asking the Movement dimension to hold two positions at once. Smart View will either reject the grid or silently collapse the axis. The members below are placed so each dimension lives in exactly one spot.
Grid 1: the NCI rollforward.
POV:
- Entity: [Subsidiary entity]
- Period: [Current month]
- Scenario: Actual
- Account:
FCCS_Minority Interest(single account, the NCI balance-sheet account; the Movement dimension is free for the rows)
On Currency: Parent Currency is a real member and a valid selection, but it’s a calculated one. The parent-currency amounts surface through the calculated Consolidation members, chiefly Contribution, so pinning it alongside those columns is redundant rather than wrong. The columns below carry the currency context: Entity Input holds the entity-currency input, while Proportion, Elimination and Contribution are calculated in parent currency. If your app pins Currency in the POV, pin the parent’s reporting currency (e.g. USD). Just don’t expect a separate Parent Currency column, because Contribution is it.
Rows (Movement dimension):
|
|
Columns (Consolidation dimension):
|
|
The rollforward reads down the Contribution column: FCCS_TotalOpeningBalance + FCCS_Mvmts_Total = FCCS_ClosingBalance (FCCS_TotalOpeningBalance is the opening plus any prior-period adjustments; with none posted, it’s just the opening balance). Note the hierarchy: FCCS_Movements is the parent of FCCS_ClosingBalance, which in turn parents the opening balances and FCCS_Mvmts_Total β so FCCS_Movements is not a movements total you can add to an opening balance. The two _Input rows are the ownership-change decomposition inside FCCS_Mvmts_Total; they’re shown for visibility, not added on top. The income, OCI and dividend legs also land under FCCS_Mvmts_Total, so the tie holds with them included. Grid 2 breaks those legs out individually.
Grid 2: the income and OCI legs, broken out. These are period-activity accounts, so retrieve them at activity level. Account on the rows, movement in the POV:
POV: Entity, Period, Scenario, Movement = FCCS_Mvmts_Total
Rows: Account = income accounts (base members of FCCS_Retained Earnings Current), FCCS_CTA, OCI accounts under FCCS_Other Reserves, dividends, equity movements (Common Stock, APIC; names vary, so map them to your metadata)
Columns: Entity Input Β· Proportion Β· Elimination Β· Contribution
Match the movement pin to your viewWhat a movement member returns depends on the view. In a periodic view, movement members return the period’s activity, so the P&L and OCI rows show this period’s income and OCI. In a YTD view, income statement accounts show year-to-date figures β FCCS doesn’t carry opening balances for income statement accounts, so there’s no opening-plus-movements structure to worry about on those rows; the YTD value is the activity to date.
FCCS_Mvmts_Totalis the total of the current period’s movements;FCCS_Mvmts_Subtotalis the same excluding FX. For the sharpest per-row check, pin the specific base movement instead: P&L and OCI revenue/expense accounts commonly land inFCCS_Mvmts_NetIncome, though the default movement is configurable per account.
Two checks. Per row, Entity Input Γ Consolidation % = Proportion, and Contribution is the parent’s consolidated result. That validates proportionalization. In aggregate, the in-scope income and OCI rows Γ Minority Interest % should equal the movement on FCCS_Minority Interest Income (income) and FCCS_Minority Interest (OCI). Note Contribution on the source rows is not the NCI share; NCI appears where the ruleset posts it, in the two FCCS_Minority Interest* accounts.
Rollforward Validation
| Check | Expected Result |
|---|---|
| Opening NCI + NI share + OCI share - dividends Β± contributions Β± ownership changes = Closing NCI | Rollforward ties |
NCI % Γ Subsidiary Net Income = NCI share in FCCS_Minority Interest Income |
Income split correct |
| NCI % Γ subsidiary equity = NCI balance in Contribution (proportionate share) | Equity split correct |
FCCS_Mvmts_Acquisitions_Input / FCCS_Mvmts_Disposals_Input reflect ownership changes |
Movements posted |
| NCI balance in Contribution β 0 (when ownership < 100%) | NCI recognized in the NCI accounts |
| NCI can be negative (deficit) for loss-making subsidiaries | No zero cap applied |
Common Errors
| Error | Cause | Fix |
|---|---|---|
| Rollforward off by CTA amount | NCI share of CTA not captured | Verify FCCS_CTA is in source scope of Net Income ruleset and CTA data is posted to the right account |
| NCI stuck at zero during losses | Pre-2010 IAS 27 treatment still applied | Remove any custom rule capping NCI at zero. Current standards require losses beyond zero |
| NCI share of NI incorrect | Stale ownership % after dilution | Update ownership % in Entity metadata. Check for subsidiary equity issuances to third parties |
| Ownership change not reflected | Movement not posted to FCCS_Mvmts_Acquisitions_Input / FCCS_Mvmts_Disposals_Input |
Post manual adjustment to the _Input members. Don’t post to the system members FCCS_Mvmts_Acquisitions/FCCS_Mvmts_Disposals (system clears them) |
| NCI missing from Contribution | Entity method not set to Subsidiary, or ownership = 100% | Verify Entity metadata: method = Subsidiary, ownership < 100% |
| OCI components not splitting to NCI | OCI posted to accounts outside ruleset source scope | Verify OCI accounts are base members of FCCS_Retained Earnings Current, FCCS_Other Reserves, or FCCS_CTA |
| Upstream eliminations misallocated | Downstream/upstream distinction not applied | Downstream (parent β sub) fully allocated to parent. Upstream (sub β parent) shared between parent and NCI at ownership % |
OCI split failure is silentThe “OCI components not splitting” trap fails silently β no error, no warning. Your only defense is verifying the metadata hierarchy.
Balance Sheet Check Caveat
The balance sheet check won’t catch NCI errors. Misstating NCI shifts amounts within equity, not between sections. The total stays right. The split is wrong. The rollforward is the only detector; run it every period.
Day 2 Maintenance
New Subsidiary with NCI: Setup Checklist
- Entity metadata: Set Consolidation Method = Subsidiary, Ownership % < 100%, parent in hierarchy
- Intercompany partner: Flag entity as
ICP_Entity_Yesso it exists in the Intercompany dimension asICP_<entity name> - Investment account: Post purchase price to
FCCS_Investment in Subwith ICP = new subsidiary. No Plug account (see Pillar 4) - Pre-acquisition equity transfer: Transfer current year pre-acquisition Retained Earnings from
FCCS_Retained Earnings CurrenttoFCCS_Retained Earnings Current - Pre Ownership Change(the exact seeded member name β dash before “Pre”, no hyphen inside “Pre Ownership Change”; Oracle’s ruleset pages print it without the dash, but the metadata name is the dashed one) so the Owner’s Equity ruleset eliminates it correctly - NCI measurement decision: The seeded rules produce proportionate share results. If you need fair value (full goodwill, required under US GAAP), configure custom rules using the later configurable-calc insertion points (e.g. FCCS_50 / FCCS_60)
- Validate: Run first consolidation. Check NCI rollforward ties from day one
Ownership Changes Mid-Year
For step acquisitions and partial disposals where control is retained, the process is the same in January or December: update Ownership % in Entity metadata, post any consideration to the investment account with correct ICP, run consolidation, verify NCI at the new Minority Interest %, and verify no P&L impact (adjust APIC).
One nuance for mid-year acquisitions: only post-acquisition income splits to NCI. Pre-acquisition Retained Earnings for the partial year must be transferred to FCCS_Retained Earnings Current - Pre Ownership Change so the Owner’s Equity ruleset eliminates it rather than splitting it to NCI.
For control loss or gain, the method change adds complexity. The Enhanced Organization by Period constraint (DSO storage profile + Ownership Management) is covered in the mechanics piece, FCCS NCI Calculation.
Year-End Close Prep
| Check | What to Verify |
|---|---|
| NCI rollforward | Walk each of the seven components from opening to closing |
| OCI allocation | All OCI accounts are base members of the three source accounts β CTA, defined benefit, cash flow hedges, PPE revaluation |
| Ownership percentages | Current for each period, especially after dilution events |
| Movement accounts | _Input members reflect ownership changes; no data stuck in system members |
| NCI deficit check | If subsidiary is loss-making, NCI can be negative β verify no zero cap |
| Multi-level NCI | Indirect NCI layers correctly cascaded through EPU |
Quick Reference
| What | Where | Why |
|---|---|---|
| NCI balance (equity) | FCCS_Minority Interest |
NCI in consolidated equity |
| NCI income (P&L) | FCCS_Minority Interest Income |
NCI share of subsidiary net income |
| Movement members | FCCS_Mvmts_*_Input = user; FCCS_Mvmts_* = system reserved |
Post manual adjustments to the _Input members only |
| Where NCI runs | Configurable Consolidations phase | After Proportionalization and Standard Eliminations |
| Custom rules | FCCS_50 (after Opening Balance) / FCCS_60 (Final Calculations) | Insertion points for fair value NCI and other custom logic |
| NCI measurement | Seeded rules produce proportionate share | Fair value requires custom configuration |
What’s Next
This companion sits alongside Pillar 6 of the eleven-pillar FCCS consolidation series. The mechanics live in FCCS NCI Calculation: Backing Out the Non-Owned Portion; this piece is the run-and-verify half.
Pillar 7: Acquisitions and Disposals picks up the full treatment Pillar 6 only touched from the NCI angle: PPA triggers, step acquisitions crossing control, loss of control, and the movement account infrastructure. Pillar 8: Equity Pickup covers the cascading mechanism behind indirect NCI in multi-level structures.
See also: Pillar 4: Investment Elimination Β· Pillar 5: Intercompany Eliminations Β· Pillar 7: Acquisitions and Disposals Β· Pillar 8: Equity Pickup
NCI isn’t hard because the accounting is complex. It’s hard because seven components move every period, the system automates most but not all of them, and the one you forget breaks the rollforward at 11 PM on close night.
Sources
- Oracle FCCS Documentation β Seeded Dimension Members
- Oracle FCCS Documentation β Seeded Consolidation Rules
- Oracle FCCS Documentation β Advanced Consolidation Rules
- Oracle FCCS Documentation β Movement Dimension
- Oracle FCCS Documentation β Enabling Enhanced Organization by Period
- PwC Viewpoint β Subsequent Measurement of NCI
- Deloitte DART β Attribution of Other Comprehensive Income
- Deloitte DART β Changes in Parent’s Ownership Interest