Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

What is Oracle/Hyperion Financial Data Quality Management (FDM)?

Posted on December 26th, 2014 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Financial data quality management is a business issue, and is defined as the practice by which companies can effectively and consistently combine the following four factors:

  • Financial data collection and transformation
  • Repeatable financial processes
  • Internal controls
  • Audit trails

dgreybarrowWhat is Oracle/Hyperion Financial Data Quality Management (FDM)?

Oracle Hyperion Financial Data Quality Management, is an out-of-the-box data transformation tool that feeds source-level financial data to consolidation, reporting, planning, and analytical applications.

More than a data translation tool, FDM is a packaged application for Financial Data movement from any data source to any Hyperion application provides these Purpose:

  • Mapping and validation tool for financial data
  • Adapters for data loads to HFM, Essbase/Planning etc.
  • Increased Transparency (interface, drillback, Controls, reports)
  • Operated by Business users rather than IT
  • SOX Compliance

FDM provides a uniform data collection process for all reporting units within an organization.

FDM features adapters that enable it to integrate with Oracle’s Hyperion Enterprise , Oracle Hyperion Financial Management, Fusion Edition (Financial Management), Oracle Essbase (Essbase), and Oracle Hyperion Planning, Fusion Edition (Planning).

FDM can also be used to load data into other financial consolidation and analytical applications.

This was originally developed by Upstream Software, Financial Data Quality Management was intended to be a business user’s ETL tool for data management and data quality management and product .The product grew in popularity with organizations’ increased requirements for tools that promoted SOX compliance.In 2006, Hyperion acquired Upstream and branded the product as Hyperion Financial Data Quality Management.

dgreybarrow End User Process

The basic FDM process includes six steps:

  1. Import source data : get data from text files, databases, GL systems
  2. Validate source data against mapping tables : 5 types of mappings, browse target metadata and guided process to manage “Kickouts”, ensure
    100% mapping quality, check reports
  3. Export source data to a target system :integration with target system via 1 click
  4. Consolidate target system data :drill-back within FDM to review mappings, drill-through from/to other systems
  5. Validate target system data :Financial controls, activity logs, reports
  6. Review and validate internal financial control : Provides user-friendly, guided processes

dgreybarrowFDM Architecture

A typical Architecture of FDM can be best understood as:

FDM Architecture

dgreybarrow Strengths / features /Benefits

  • A central repository that contains all source data
  • Drill Down and Drill Through audit trails
  • Archiving of source files, error logs, and load files
  • An internal control assessment and certification feature that facilitates compliance with sections 302 and 404 of the Sarbanes-Oxley Act
  • Corporate-wide process monitoring
  • Import of source data from any formatted text file or data source
  • Multiple dimension mapping and validating
  • Data validation and quality evaluation
  • Error identification and notification
  • Consolidation of target system data
  • Validation of and reporting on target system data

dgreybarrowKey Features

  • Guided workflow interface
  • Complete data validations and error checking
  • Automated data mapping and loading
  • Prepackaged system adapters
  • Detailed audit reviews and reconciliations
  • Support for standard file formats as well as direct connections to transaction systems

dgreybarrowManaging Hyperion FDM Applications :Key Components

FDM includes two primary products, a Windows client (Workbench) and a Web client .

FDM Workbench is a Windows client that can be installed on a PC or on a terminal server. Workbench provides access to the application setup, integration, and development features of FDM and should be used only by administrators.

FDM Workbench basic functionality:

  • Systems integration
  • Script creation and maintenance
  • Report creation and maintenance
  • Application importing and exporting
  • Batch processor setup and monitoring

Web Client :The FDM Web client consists of four components:

  1. Web server :The components enable users to access FDM applications from the Internet or from a corporate intranet. The Web-based interface provides access to all end-user features and most administrator features of FDM.
  2. Application Server :FDM Application Server enables FDM to execute resource-intensive tasks on one or more application servers, instead of on the Web server
  3. Load Balance Manager :FDM Load Balance Manager enables FDM to manage the application servers that execute resource-intensive tasks. Installing Load Balance Manager on the first application server is recommended.
  4. Task Manager :FDM Task Manager runs scheduled tasks (FDM scripts) at specified intervals (daily, weekly, or monthly). You can also use Task Manager to add, modify, and delete tasks.

dgreybarrowWhere the data stores in the FDM application?

Each FDM Application contains four directories. 1) inbox 2) outbox 3) data 4) reports.

These are the directories which stores the data.

dgreybarrow Adapters

The FDM Adapter Suite includes the following adapters:

Data Extract (Tax), Hyperion Enterprise, ERPI, Essbase, Pull (DataMart), and Strategic Finance. The Hyperion Financial Management adapter is no longer installed during the FDM installation process. The Financial Management and SAP Integration adapters are available as separate downloads. The adapter for Oracle E-Business Suite is no longer included in the FDM adapter suite. Use the ERP Integration adapter to integrate FDM with Oracle E-Business Suite Financials.

This supports

  • Supported ERP Systems
  • EBS 11i and 12.x
  • PSFT 9.0, 9.1 (9.2 in progress)
  • PSFT HCM 9.0, 9.1
  • Fusion Financials GL 11.1.2 and 11.1.3
  • JDE 9.0 and 9.1 with tools 9.1
  • SAP 4.6c, 4.7 and ECC 6.0 3+
  • SAP BW 7.0+
  • Open Interface Adapter

dgreybarrowWhat is in FDM Enterprise Edition [ FDMEE]

  • Install and configure has been simplified
  • Automatically configured for file based loads
  • Individual Adapter configuration not required
  • Targets natively supported
  • Client components no longer needed (Workbench
  • Built on Fusion Middleware Technology
  • Integrated with the Workspace
  • Fully integrated with shared services
  • Can do full configuration via Web
  • Excel is no longer needed on the server
Related Posts

Posted in Hyperion | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.