Oracle EPM Financial Consolidation and Planning

Summary

Perficient’s Data App for Oracle Enterprise Performance Management (EPM) facilitates the importing and data modeling of Oracle Financial Consolidation and Close Cloud Service, and Oracle Planning and Budgeting Cloud Service data in Incorta. This app also enables drilldowns from Oracle EPM financial summaries to ERP sourced transaction details.

Keys benefits

This solution provides an integrated dynamic reporting across both Oracle EPM and ERP sourced data sets. Perficient’s Incorta data app leverages the Incorta EPM Connector to not only import EPM metadata and data into Incorta, but also model it together with ERP sourced detail transactions, such as General Ledger Account Balances, Journal Lines and Sales Invoices. The coexistence of EPM and ERP data sets in Incorta enhances financial reporting by providing richer insights across several financial applications.

Mash up EPM data with data from other systems like ERP, Sales, etc…
Drill down from EPM summaries to journals and transaction level details
Reconcile EPM summaries against various source systems

Extensibility

There are various use cases that this data app helps address. Depending on the source ERP system(s) and the application modules in question, this app is extensible to accommodate different sources and types of ERP transactions. Following are examples of use cases:

Drill down from EPM consolidated account balances sourced from Oracle Financial Consolidation and Close to ERP application specific General Ledger balances and journals. The Incorta semantic modeling layer covers multiple ERP source applications together with the consolidated EPM financial results. Consequently, one can drill down from a consolidated EPM Account balance to reconcile it against GL balances and journals sourced from one or more source ERP systems. With Incorta’s scalability to handle billions of rows, there are no limitations when it comes to reconciling EPM account summaries to ERP General Ledger journal lines consisting of large data volumes.
Compare actual sales from ERP receivables to EPM budgets and forecasts maintained in Oracle Planning and Budgeting. Often times there is a need to track revenue or spending performance on a more frequent basis than what is maintained in the EPM Planning application. With the Incorta blueprint, we are able to track sales performance in comparison to plans defined in EPM, on a near-real time basis. The Incorta model provides a comparative analysis of up to the hour actuals, sourced from one or more ERP systems, with respect to various planning scenarios defined in EPM.
Obtain deeper insights by drilling down from EPM financial summaries into more granular levels of detail that only exist in the source ERP systems. While financial information maintained in Oracle EPM provides a high-level view of financial performance results, it doesn’t cover a detailed analysis of various aspects of the business, such as customer specific characteristics or Item/SKU level of detail. Perficient’s Incorta-based dashboard solution offers seamless navigation from an EPM financial summary to transaction level detail sourced from ERP sub-ledgers. For example, when comparing income variance to plans and forecasts, you will be able to drill down to invoice details to identify drivers of profitability on a granular level. For instance, this will help identify which product or service offerings, or what groups of customers contribute to your revenue and margin.