Oracle Fusion EPM FCCS Techno-Functional Consultant

Role & responsibilities

• Configure and maintain FCCS application setup including dimensions (Entity, Account, Scenario, Movement, Consolidation), metadata, hierarchies, and member properties. • Design and implement consolidation rules, intercompany eliminations, currency translation, and ownership management within FCCS. • Build and maintain calculation rules and business rules using Calculation Manager / Groovy scripting for consolidation adjustments. • Develop and manage Data Management (FDMEE) / Data Integration mappings to load actuals, budgets, and other data from source ERP systems (e.g., Oracle Fusion GL, SAP, JD Edwards) into FCCS. • Configure Smart View, Financial Reporting Studio, and Management Reports for financial statement reporting and variance analysis. • Support period-close activities including journal entries, Supplemental Data Manager (SDM) configuration, and Task Manager workflows. • Use EPM Automate and REST APIs to automate data loads, application refresh, and Lifecycle Management (LCM) migrations. • Collaborate with finance stakeholders to gather requirements, document functional specifications, and translate them into technical configurations. • Perform unit testing, support UAT, resolve defects, and prepare functional and technical documentation. • Provide production support during month-end and quarter-end close cycles and troubleshoot data or calculation issues. • Assist with periodic patch/update testing and assess the impact of new FCCS releases.

Preferred candidate profile

3-5 years of overall experience in Oracle EPM Cloud applications, including hands-on FCCS configuration and support. • Strong understanding of consolidation accounting concepts: intercompany eliminations, minority interest, currency translation adjustments (CTA), and ownership management.

• Hands-on experience with FCCS application administration: dimension building, metadata management, security and access provisioning, forms, and task lists. • Proficiency in Calculation Manager and Groovy scripting for custom business rules. • Experience with Data Management (FDMEE) / Data Integration for source-to-target data mapping and validation. • Working knowledge of Smart View, Financial Reporting Studio, and Management Reporting for report design. • Familiarity with the EPM Automate utility and REST APIs for automation and Lifecycle Management. • Exposure to Account Reconciliation Cloud Service (ARCS) and Tax Reporting Cloud Service (TRCS) integration is an advantage. • Strong SQL and data analysis skills for troubleshooting data load and calculation issues. • Good understanding of US GAAP/IFRS consolidation and statutory reporting requirements.