Oracle Fusion EPM FCCS Techno-Functional Consultant

Arnold Consulting; Bengaluru; On-site; INR 1,200,000 - 2,500,000; Full time

Job summary

Arnold Consulting in Bengaluru seeks an experienced FCCS Administrator to configure and maintain Oracle EPM Cloud FCCS setups, including dimensions, hierarchies and member properties for accurate financial reporting.

The role focuses on consolidations, currency translation, intercompany rules, and data integration via FDMEE, Calculation Manager and Groovy scripting, with responsibilities across close cycles, testing and documentation.

Qualifications

• 3-5 years of overall experience with Oracle EPM Cloud FCCS configurations and support.
• Strong understanding of consolidation accounting: intercompany eliminations, CTA adjustments, ownership management.
• Hands-on FCCS administration: dimension building, metadata management, security provisioning, forms and task lists.
• Proficiency with Calculation Manager and Groovy scripting for custom business rules.
• Experience with FDMEE / Data Integration for source-to-target data mapping and validation.
• Familiarity with Smart View, Financial Reporting Studio, and Management Reporting tools.
• Knowledge of EPM Automate and REST APIs for automation and lifecycle management.

Responsibilities

• Configure FCCS dimensions, metadata, hierarchies and member properties.
• Design and implement consolidation rules, intercompany eliminations, currency translation and ownership management.
• Develop calculation rules and Groovy-based business rules for consolidation adjustments.
• Develop and manage FDMEE mappings to load actuals, budgets and data from ERP sources into FCCS.
• Configure Smart View and reporting studios for financial reporting and variance analysis.
• Support period-close activities including journal entries and SDM configuration.
• Use EPM Automate and REST APIs to automate data loads, refreshes and LCM migrations.
• Collaborate with finance stakeholders to gather requirements and translate into technical specs.
• Perform unit testing, support UAT and document both functional and technical specifications.
• Provide production support during month-end and quarter-end close cycles and troubleshoot issues.

Skills

FCCS configuration

Consolidation concepts

Intercompany eliminations

Currency translation

Groovy scripting

Calculation Manager

FDMEE / Data Integration

SQL data analysis

Tools

Calculation Manager

Groovy scripting

FDMEE

EPM Automate

Job description

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.