Multi-entity consolidation, intercompany eliminations, OMB A-136 reporting — built from live multi-agency federal deployments covering enterprise consolidation at scale.
▶ User:
"Set up FCCS consolidation hierarchy — 6 component agencies roll up to enterprise parent"
// Agent Actions
1 Creates FCCS Entity dimension hierarchy: 6 component agencies as child entities under Enterprise Consolidated parent
2 Configures consolidation ownership percentages (100% for all government entities) and consolidation method
3 Maps each component's Oracle EBS Ledger to its FCCS Entity for data load via FDMEE/Data Management
4 Sets up Account dimension with OMB A-136 financial statement line mapping (Balance Sheet, Statement of Net Cost)
🔗 Oracle Action:
Creates FCCS Entity hierarchy, Account mappings, Data Source configurations, and FDMEE load rules for all 6 components
✅
6-entity consolidation hierarchy live in 1 day — all component Oracle EBS ledgers mapped to FCCS entities, ready for first consolidation run.
▶ User:
"Run March 2026 consolidation for all component entities — load balances, run eliminations, generate consolidated trial balance"
// Agent Actions
1 Triggers FDMEE data load for all 6 entities — pulls March actuals from each component's Oracle EBS GL
2 Executes consolidation: runs intercompany matching, auto-generates elimination journal entries for matched pairs
3 Flags unmatched intercompany transactions for manual review; identifies top 5 discrepancies by dollar amount
4 Runs consolidated trial balance and generates OMB A-136 Balance Sheet and Statement of Net Cost
🔗 Oracle Action:
Runs FCCS Consolidate process across all entities, auto-posts elimination journals, generates consolidated financial statements
✅
Consolidated financials complete in 2 hours vs. 5 days — all 6 entities loaded, intercompany eliminations posted, OMB A-136 statements ready for CFO review.
▶ User:
"Set up intercompany eliminations between two component agencies — $180M in reimbursable agreements that need to net to zero at consolidated level"
// Agent Actions
1 Identifies intercompany account pairs: Component A receivable (USSGL 1310) ↔ Component B payable (USSGL 2110) on reimbursable agreements
2 Creates FCCS Intercompany Matching rules: matches Component A Entity + Account 1310 against Component B Entity + Account 2110
3 Configures auto-elimination journal: debit Component B payable, credit Component A receivable at consolidation level
4 Sets up tolerance threshold ($50K) — transactions within tolerance auto-eliminate, above threshold flagged for review
🔗 Oracle Action:
Creates FCCS Intercompany Rules, configures matching account pairs, sets tolerance thresholds, activates auto-elimination journals
✅
$180M intercompany eliminations fully automated — reimbursable agreements net to zero at consolidated level every month, manual matching eliminated.
▶ User:
"Onboard new component agency to FCCS — they're moving to the enterprise consolidated close process starting Q3"
// Agent Actions
1 Creates new entity in FCCS hierarchy as child of Enterprise Consolidated; configures ownership and consolidation method
2 Maps new entity Oracle EBS Chart of Accounts to FCCS Account dimension — handles any custom account codes
3 Configures FDMEE data load for new EBS ledger including USSGL account mapping and period alignment
4 Sets up entity-specific intercompany rules for existing reimbursable agreements with other components
🔗 Oracle Action:
Adds new entity to FCCS hierarchy, creates COA mapping, configures FDMEE load, updates consolidation script to include new entity
✅
New entity fully onboarded to FCCS in 2 days — first consolidation run includes new data, intercompany eliminations active, CFO sign-off workflow configured.
▶ User:
"March close is complete — route consolidated financials to component CFOs for certification, then to enterprise CFO for final sign-off"
// Agent Actions
1 Locks March data for all 6 component entities — prevents further adjustments after certification begins
2 Routes certification task to each component CFO via FCCS workflow — all in parallel
3 Generates entity-level certification package: trial balance, intercompany reconciliation, and variance commentary
4 After all component certifications received, routes consolidated package to enterprise CFO for final OMB A-136 sign-off
🔗 Oracle Action:
Locks FCCS entities, activates approval workflow, generates certification reports, creates audit trail with e-signature timestamps
✅
All CFO certifications routed and tracked in 30 minutes — full audit trail with timestamp, comments, and e-signature for every entity; CFO package auto-assembled.
▶ User:
"Reconcile consolidated FCCS balances to GTAS submissions — identify any components where FCCS and GTAS are out of sync"
// Agent Actions
1 Extracts FCCS consolidated trial balance by entity and USSGL account for the period
2 Compares against GTAS submission data for each TAS — identifies account-level variances
3 Traces variances to source: timing differences (GTAS submitted before FCCS close), elimination entries not in GTAS, or genuine errors
🔗 Oracle Action:
Runs FCCS tie-out report against GTAS extract; flags entity-level variances by USSGL account and TAS
✅
FCCS-to-GTAS reconciliation complete in 1 hour — all entities reconciled, variance reasons documented, any errors traced to source journal with Oracle transaction ID.