Case Study · Oracle EPM Practice
Oracle FCCS Consolidation & Statutory Reporting Solution
The Challenge
An investment management company needed a reliable, well-controlled consolidation and statutory reporting process. Notes to Account preparation, management report packs and consolidation adjustments were demanding and time-consuming to keep accurate and audit-ready across reporting cycles, with limited standardization in how data was mapped and validated.
The Solution
- Metadata design — built to support consolidation, Notes to Account and reporting requirements.
- Data forms and data mappings — for Notes to Account, management packs and statutory report packs.
- Configurable consolidation rules — including custom member formulas for Notes to Account.
- Validation and review cycles — CRP, KUT and UAT sessions to confirm the design met business needs.
Consultant Contribution
Anish Bagui, as Senior Consultant, contributed to the design and build of the solution — developing metadata, data forms and data mappings for Notes to Account and the management and statutory report packs, and building configurable consolidation rules and custom member formulas. He conducted CRP, KUT and UAT sessions with the business, prepared project documentation, and continued supporting the client through Hypercare after go-live.
The Outcome
- Consolidation, Notes to Account and statutory/management reporting standardized on Oracle FCCS.
- Configurable consolidation rules gave a consistent, repeatable close and reporting process.
- Business users validated the solution through CRP, KUT and UAT ahead of go-live.
- Support continued through Hypercare, with Anish retained on the account for post-go-live stabilization.
Anish and the team got our consolidation process sorted out fast. Notes to Account used to eat up days every close — now it's a lot more straightforward, and we know the numbers tie out. He was easy to work with through UAT and stuck around for us during Hypercare whenever we ran into issues.
Investment Management Company, UAE