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

Oracle Planning and Budgeting Cloud Service (PBCS)

Posted on July 3rd, 2015 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle Planning and Budgeting Cloud ServiceOracle Planning and Budgeting Cloud Service (PBCS) is a subscription-based, planning and budgeting solution built for, and deployed on Oracle’s Cloud platform .

This was first EPM application available in the Cloud .

It delivers instant value and greater productivity for business planners, analysts, modelers and decision makers across all lines of business of an enterprise. Users interact through a Web 2.0 or Microsoft Office interface to model, plan, and report.

Oracle Planning and Budgeting Cloud Service is built to scale and perform using industry-standard Oracle Cloud infrastructure and is architecturally proven to solve simple to complex requirements and use cases across multiple industries.

Customers are paying for one service per month, not for multiple products. So, we don’t need to call out Essbase, Calc Mgr, Financial Reporting, etc.

Its functionality mirrors the latest functional feature set of Hyperion Planning on-premises and delivers those features in a Cloud friendly fashion, but still you can

All the infrastructure, reporting, and data management components to use Hyperion Planning are included as part of the Oracle Planning and Budgeting Cloud Service. This includes the powerful web based and MS Office based capabilities.

Currently product have limitaion for additional Planning content (i.e., Workforce Planning, Capital Asset Planning, Project Financial Planning) thats is planned in furure releases.

dgreybarrowPBCS INTEGRATE WITH OTHER SYSTEMS

  • Data and metadata can be integrated into Oracle Planning and Budgeting Cloud Service using its data management capabilities (also known as Financial Data Management/FDMEE by Hyperion customers) which provides drill through capabilities for various sources like EBS, SAP, Peoplesoft and JD Edwards.
  • Integration is enabled using flat files, and the data load process can be automated.
  • Moreover , PBCS integrate with BI repositories like OBIEE (BIFS).
    • PBCS has a data export feature which can be used to export the data into any external BI repository.
    • This export process can be automated to generate periodic outflows

dgreybarrowKEY FEATURES

  • Multi-dimensional / multi-user planning with a powerful business rules engine
  • Flexible workflow and plan management capabilities
  • Comprehensive Microsoft Office integration
  • Easy to use web interface
  • Seamless creation of reports and dashboards
  • Proven and scalable architecture
  • Robust integration with ERP systems and other sources
  • Full set of administrative tools for application management
  • Cloud-based deployment model with subscription-based pricing

dgreybarrowKEY BENEFITS

  • Deploy quickly with no internal IT hardware or software requirements
  • Reduce budgeting and planning cycles by weeks or months
  • Improve forecast accuracy
  • Appeal to a wider user community through an intuitive web user interface
  • Leverage existing user competencies with Microsoft Office integration
  • Integrate planning and management reporting seamlessly
  • Reduce cost of ownership through superior application deployment, management tools and packaged data integration

dgreybarrowOPTIONS FOR EXISTING CUSTOMER

Existing customers on Hyperion Planning on and above 11.1.2.1 can migrate to the initial R13.2 release of PBCS, which is an offshoot of the current Hyperion Planning R11.1.2.3 on-premise offering. Customers will use their Lifecycle Management capabilities within on-premise applications to export their current R11.1.2.1
application and then import them into PBCS R13.2.

But , if you have release older than R11.1.2.1 they will need to upgrade on premise to R11.1.2.1 and then migrate from there onto PBCS.

dgreybarrowPRICING

  • PBCS is a new subscription based product offering .List Price start with $120 per user per month (min of 10 users) for all customers with a 12 month minimum subscription.

Thats note

  • If you are using UPK , then this will be included within PBCS subscription offering.
  • Full Use Essbase - PBCS comes included with reporting and archival cube building capability. Native Essbase is not available as a Cloud Service now

dgreybarrowFEATURES ARE DIFFERENT BETWEEN 'ON PREMISE' PLANNING AND 'PBCS'

Here are quick comprasion of features avaiable in two senarios.

 

 

TOOL

Hyperion Planning

Planning and Budgeting Cloud Service(PBCS)

EPM Architect (EPMA)

Can be used for Planning

PBCS does not use EPMA

Financial Data Management
Enterprise Edition (FDM EE)

Drill back capability available
through adapters

Drill back capability available to all sources supported by FDM through flat files using the Data Management features within PBCS.

Data Relationship Management(DRM)

Supported through flat files and
EPMA.

Supported through flat files and automation to PBCS

Essbase ASO

ASO is part of Hyperion
Planning and needs to be
separately licensed

ASO is part of PBCS application and included in the pricing.

Reporting

Financial Reports is part of
Hyperion Planning license

Financial Reports is part of PBCS subscription.

Smart View

Smart View for Office is part of
Hyperion Planning license

Smart View for Office is included in PBCS subscription

Other

Oracle Data Integration, flat
files, and Excel extracts

Flat files, and Excel extracts

dgreybarrow FURTHER READING

Posted in Hyperion, Oracle Cloud * | No Comments »

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

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

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

Posted in Hyperion | No Comments »

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

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

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

Posted in Hyperion | No Comments »

R12.2 : Transforming EBS Financials with Fusion Accounting Hub

Posted on December 5th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In R12.2 , there is one important enhancement which transform EBS Financials with Fusion Accounting Hub.

The Oracle Fusion Accounting Hub provides integration for the Oracle General Ledger .

This new enhamcement in term of integration provides you with the opportunity to leverage the Oracle Fusion Accounting Hub with minimal implementation effort and without disruption to your current financial management processes.

You can continue to use Oracle E-Business applications without disruption and you can also continue to account for transactions in Oracle General Ledger without changing their accounting treatments.

Integration between the Oracle Fusion Accounting Hub and Oracle General Ledger includes the ability to transfer full or incremental period balances to the Fusion General Ledger.

You can convert charts of account values and accounting period information to align with Fusion ledger configurations. You can also drill from the summary information posted in the Fusion Accounting Hub back to the Oracle E-Business Suite (EBS).

Integration with the Fusion Accounting Hub enables users to leverage new fusion general ledger capabilities, such as embedded ESSBASE (Extended Spreadsheet DataBASE) integration with real-time analytics, on-line slice-and-dice account analysis, making it easier to run boardroom financial reports, helping generate the boardroom financial reports with great ease.

Posted in Hyperion, R12 | No Comments »

Oracle Hyperion Tax Provision (HTP)

Posted on October 4th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle Hyperion Tax Provision is a comprehensive, easy-to-use global tax provision solution that is purpose built for the automation of the accounting for income tax process. The Software is designed by tax users for tax users, and leverages the existing finance data and processes without impacting finance’s current financial close procedures.

The solution addresses both IFRS and US GAAP requirements, and includes tax maintenance wizards that are designed to be easily maintained by the tax department. Since Oracle Hyperion Tax Provision is architected on top of the Oracle Hyperion Financial Management (HFM) platform, both finance and tax can realize significant efficiencies in training both the casual and power users involved in the tax reporting process (e.g. regional controllers around the world and power users in the tax department).

Tax Provision calculates your company’s global tax provision, effective tax rate, and deferred tax for tax provisioning purposes. The application is designed to comply with the standards for accounting for income taxes under US GAAP ASC740 and IFRS IAS12.

Those who are not accounting background , can understand

A Tax Provision is…

  • a quarterly and annual disclosure (10Q & 10K)
  • a key part of the Financial Close
  • required for US GAAP & IFRS

Donot get confused with As Tax Provision is NOT…

  • a tax return
  • a requirement for the IRS (US), HMR&C (UK),
  • or other revenue agencies…

To summarize, The new Module encompasses all stages of the corporate tax provision process:

  • A tax provision calculation engine that addresses US GAAP, IFRS, and statutory tax reporting
  • A web-based tax package and integrated workflow for global data collection
  • Integrated with Oracle Hyperion Financial Managment, the solution that is based on the same technology trusted by thousands of corporate finance organizations.
  • An easy-to-use wizard for automation of tax differences
  • A comprehensive suite of tax reports for the consolidated tax provision - including the tax disclosure
  • Reconciliation of the tax accounts to the accounting data, and generation of the tax journal entry
  • A return-to-accrual process that integrates and enhances the tax compliance process
  • Configurable supplemental schedules to address unique data collection and calculation requirements

Why this software care about Tax?

  1. The Tax Provision is very material number
  2. It is a key part of the Financial Close (e.g. same value proposition)
  3. Replacing Excel
  4. The tax department is a new audience
  5. The Hyperion solution can have a material impact

Hyperion Tax Provision provides the tax department with the same strong data collection and management tools that the finance department is accustomed to. By providing the tax department with the same platform as is used by the finance department, the coordination between the two departments improves the financial close process, since the financial close cannot be complete without the tax close.You can get further details at Oracle site .

Installing Hyperion Tax Provision
The Hyperion Tax Provision requires, at minimum, Hyperion Financial Management Release 11.1.2.2 with Patch Set Update: 11.1.2.2.303.

Posted in Emerging Technologies, Hyperion | No Comments »

Introduction :Oracle Hyperion Tax Provision

Posted on September 23rd, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Until now, there was no easy way to integrate the tax provision with the financial consolidation. But, this all changes with the introduction of Hyperion Tax Provision. Hyperion Tax Provision represents the first in a series of products to better integrate tax reporting into the broader financial reporting process.

An integrated system for the Tax & Finance close means that you are leveraging your exiting investment & reducing risk - Hyperion Tax Provision leverages your existing investment in HFM and the Financial Close Suite by using the same tools for data collection, consolidation, and reporting to bring you an integrated Tax Provision solution.

arrow Hyperion Tax Provision is a comprehensive solution for the global consolidated tax provision.

This includes:

  • Data Collection:
    • Automated – any data that can be sourced from HFM, the general ledger, or sub-ledgers can be automatically available to the tax provision
    • Manual - The solutions includes a suite of web forms to collect tax provision details (incl. Current Tax, Temporary Difference Rollforward, tax losses & credits,etc)
  • Tax Provision Calculation:
    • Addressing both IFRS and US GAAP
    • Federal, State/Provincial, & International
  • Tax Reporting
    • Suite of out-of-box tax reports (incl. Current Tax, Deferred Tax, Effective Tax Rate Reconciliation, etc)
    • This also includes the same great reporting tools used by finance (such as Smart View & Financial Reporting)

arrowHFM & HTP Solutions - Architecture

Here is HFM & HTP solutioning Architecture .

HTP Solution

arrowMajor Key Benefits for HFM Customers

  • Increased Automation & Efficiencies:
    • Leverage the same data assurance process
    • Use the same chart of accounts & legal entity hierarchie
    • As much as 70% of the Tax Provision can be automated
  • Stronger Internal Controls
    • Closer alignment with the finance data & process
  • End to end auditable process
    • Improved Analysis & Reporting: resulting in better risk analysis and tax planning
    • Excel, Web Reports and Drill-through to G/L

In Nutshell the use of HFM for tax provision ensures that the Tax & Accounting Close are coordinated & efficient.

Bringing finance and tax together results in unparalleled Transparency & Reporting. The same reporting tools that you already use for financial reporting are now available for analysis of the Tax Provision.

Posted in Hyperion | No Comments »

Getting Started with DRM

Posted on January 13th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

DRM is a master data management tool used to administer hierarchies, attributes, and metadata used by various types of applications.

The DRM tool can act as a centralized enterprise hierarchy management solution serving a wide range of downstream BI, EPM, ERP, operational, and other systems.

Common applications of the DRM tool include management of GL chart of accounts,customer and employee attributes, and product information .

Oracle Hyperion Data Relationship Management (DRM), Fusion Edition functions as a master data management solution where reporting structures are maintained, analyzed, and validated before moving throughout the enterprise. Data Relationship Management does the following:

  • Manages business entities, hierarchies, attributes, and mappings across multiple systems.
  • Validates data relationships and calculates attribute values using business rules.
  • Enforces referential integrity across all subscribing systems and hierarchies.
  • Enables you to create and manage alternate views.
  • Merges independent data sets from different sources and combines them into a master set.
  • Maintains historical versions for comparative reporting and analysis.
  • Tracks all hierarchy and attribute changes with a full-featured audit log.
  • Can serve as the main point-of-entry to update subscribing systems or be used subsequently for reconciliation and analysis.

You can use Data Relationship Management to manage charts of accounts segment values and hierarchies for Oracle General Ledger.

You can create new segment values, edit their properties, and maintain hierarchies using DRM. This information can be synchronized to one or more general ledger instances using a concurrent request program in the Oracle E-Business Suite.

DRM can integrate with other systems, Oracle or non-Oracle systems. The simplest way to let flow the data in between systems is by Import/Export.

Export can be done to a flat file or a database table where as import can be done via flat file. Additionally, customization can be done through API to perform the same.

DRM is also an Analytical Master Data Management tool. It allows creation of an enterprise view of analytical dimensions, reporting structures, performance measures and their related attributes.

DRM can also be considered a change management tool, as it is often used to facilitate the combination of disparate General Ledgers, product mappings, customer data sets, and other business information.

Mergers and acquisitions are frequently reliant on DRM to enable different systems to be able to communicate with each other.

DRM enables organizational consistency, managed change and becomes the foundation for any technology project

Posted in Hyperion, MDM, Oracle Receivable | No Comments »

Oracle R12 : Hierarchy Manager Limitations

Posted on January 11th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

arrow-up-3 Account Hierarchy Manager in GL

Account Hierarchy Manager is fully integrated with Oracle General Ledger. With this you can create and manage values and hierarchies for your Accounting Flexfields using the Account Hierarchy Manager just as you can in General Ledger.

All changes made in Account Hierarchy Manager are reflected in GL upon saving and your entire chart of accounts is available in Account Hierarchy Manager.

Working with account structures and hierarchies in Account Hierarchy Manager is easy and intuitive because of the graphical interface. In addition, performing what-if manipulations for account structures is a simple process using the Account Hierarchy Manager.

You can:

  • Graphically create, maintain, and review account structure hierarchies.
  • Define new parent and child segment values, as well as change parent/child dependencies.
  • Create new rollup groups from the Account Hierarchy Manager and have your changes reflected automatically in both the Key Segment Values and Rollup Groups windows.

arrow-up-3 Oracle R12 – Hierarchy Manager Limitations

Oracle Release 12 in its standard form supports a repository for master data in the form of segment values.

Oracle Hierarchy Manager does not cater to maintenance of multiple forms of hierarchies within a CoA Segment

Integration with non-financial systems not possible and hence the flexibility to report on multiple business scenario’s for non financial \ MIS data not possible, therefore no flexibility to version hierarchies for ‘What-if’ analysis

arrow-up-3 Oracle DRM solution

Oracle DRM manages the core / alternate hierarchies and acts as source of hierarchies for downstream systems. Next post will be focus on Oracle DRM solution.

Posted in Hyperion, Oracle Receivable | No Comments »

What is Oracle Hyperion’s Data Relationship Management (DRM) Tool?

Posted on February 14th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

What you expect from a Financial / Analytical MDM Products.

In simple way, it should Provides:

  • Consistency of measures across all systems and all business units
  • Streamlined consolidation and quick financial close
  • Support for operational flexibility
  • Rapid financial rationalization
  • Ability to view structure changes during modeling
  • Provide a historical perspective

Oracle Hyperion DRM

Oracle's Hyperion Data Relationship Management (previously known as Hyperion Master Data Management) provides enterprises a solution to build consistency within master data assets despite endless changes within the underlying transactional and analytical systems.

Specifically, Hyperion DRM provides the industry's first data model-agnostic master data management solution built to enable financial and analytical master data management in dynamic, fast-changing business environments

  • Financial MDM
    Create an enterprise view of financial chart of accounts, cost centers and legal entities with a view to govern on-going financial management and consolidation based on consistent definitions of financial and reporting structures across general ledger systems, financial consolidation, planning and budgeting systems.
  • Analytical MDM
    Create an enterprise view of analytical dimensions, reporting structures, performance measures and their related attributes and hierarchies using Hyperion DRM's data model-agnostic foundation. Construct departmental perspectives that bear referential integrity and consistency with master data constructs based on validations and business rules that enforce enterprise governance policies. Synchronize master data with downstream systems including BI/EPM systems, data warehouses and data marts to gain trustworthy insight.

Key Features

  • Enterprise master data lifecycle & change management
  • Cross-functional views reconciled to master record
  • Automatic attribute management with business rules
  • Drag-and-drop hierarchy management
  • Referential integrity with synchronized records
  • API for integrating changes with operational systems
  • Comprehensive import, blend, and export functions
  • Flexible versioning and modeling capabilities

Key benefits

  • Save time and resources spent reconciling reports and measures across business units
  • Reduce or eliminate errors in data flow between operational and analytical systems
  • Maintain data integrity across divisions and systems
  • Empower users to easily make data changes
  • Minimize manual IT data maintenance tasks
  • Perform reliable what-if scenarios and impact analyses
  • Ensure consistent corporate definitions and metrics across the business

Posted in Hyperion | No Comments »

Page 1 of 11