Multi-entity consolidation, intercompany eliminations, OMB A-136 reporting. Built from a live DHS deployment covering 6 agency components.
▶ User:
"Set up FCCS consolidation hierarchy for DHS — 6 components (ICE, USCG, TSA, CBP, FEMA, Headquarters) roll up to DHS parent"
// Agent Actions
1 Creates FCCS Entity dimension hierarchy: ICE, USCG, TSA, CBP, FEMA, HQ as child entities under DHS 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 DHS components
✅
DHS 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 DHS 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
✅
DHS 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 USCG and HQ — they have $180M in reimbursable agreements that need to net to zero at DHS level"
// Agent Actions
1 Identifies intercompany account pairs: USCG receivable (USSGL 1310) ↔ HQ payable (USSGL 2110) on reimbursable agreements
2 Creates FCCS Intercompany Matching rules: matches USCG Entity + Account 1310 against HQ Entity + Account 2110
3 Configures auto-elimination journal: debit HQ payable, credit USCG receivable at DHS 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
✅
USCG-HQ $180M intercompany eliminations fully automated — reimbursable agreements net to zero at DHS consolidated level every month, manual matching eliminated.
▶ User:
"Onboard Cybersecurity and Infrastructure Security Agency (CISA) to FCCS — they're moving to the DHS consolidated close process starting Q3"
// Agent Actions
1 Creates CISA entity in FCCS hierarchy as child of DHS Consolidated; configures ownership and consolidation method
2 Maps CISA Oracle EBS Chart of Accounts to DHS FCCS Account dimension — handles any custom account codes
3 Configures FDMEE data load for CISA EBS ledger including USSGL account mapping and period alignment
4 Sets up CISA-specific intercompany rules for existing reimbursable agreements with ICE and CBP
🔗 Oracle Action:
Adds CISA to FCCS Entity hierarchy, creates COA mapping, configures FDMEE load, updates consolidation script to include CISA
✅
CISA fully onboarded to DHS FCCS in 2 days — first consolidation run includes CISA data, intercompany eliminations with ICE and CBP active, CFO sign-off workflow configured.
▶ User:
"March close is complete — route consolidated financials to component CFOs for certification, then to DHS 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: ICE, USCG, TSA, CBP, FEMA, HQ in parallel
3 Generates entity-level certification package: trial balance, intercompany reconciliation, and variance commentary
4 After all 6 component certifications received, routes consolidated package to DHS 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 6 CFO certifications routed and tracked in 30 minutes — full audit trail with timestamp, comments, and e-signature for every entity; DHS CFO package auto-assembled.
▶ User:
"Reconcile DHS 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 DHS 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 6 DHS entities reconciled, variance reasons documented, any errors traced to source journal with Oracle transaction ID.