A day in the life of an Oracle Applications Consultant

Enterprise Planning & Budgeting (EPB)

Tuesday, October 12, 2004

Oracle Enterprise Planning and Budgeting exists next to Public Sector Budgeting

Oracle Enterprise Planning and Budgeting is released and is the successor of the Financial analyzer and the Sales analyzer. According to the frequently asked questions, there is still room for a PSB implementation.

Does EPB replace Oracle Public Sector Budgeting (PSB)?

No. The initial release of EPB is a generic product and does not include some of the Public Sector market specific features (i.e. Position Budgeting, Integration with HR Position Control, Posting Budget Journals and Budget Revision) available in PSB.

Will a future version of EPB support PSB features?

The strategic direction of EPB is to provide industry templates and extensions on top of the generic functionality. For the Public Sector market the extensions will leverage Public Sector market specific features (i.e. Position Budgeting, Integration with HR Position Control, Posting Budget Journals and Budget Revision) available in PSB today. This will be achieved by tightly integrating EPB and PSB to provide a comprehensive Planning, Budgeting, Analysis and Reporting solution for the Public Sector market.

We have bought PSB but not yet implemented. Should we implement?

PSB currently incorporates line item-based budgeting and position-based budgeting. If you are planning to incorporate PSB for position-based budgeting as part of your HR and GL implementation, and are going to leverage the two way integration between both (HR for position budgeting, and GL for budget journals and budget revisions), then you should continue with PSB. If your requirements are more around line item based budgeting, long range planning, and complex analysis then you may want to evaluate EPB to see if there is a fit.

Wednesday, August 11, 2004

Improving the Transparency and Auditability of your Corporation with Oracle E-Business Suite

This post reviews a presentation given at the Oracle OpenWorld Melbourne 2004 Conference by Folia Grace, Product Director, Enterprise Resource Planning, Oracle Corporation.

This presentation, entitled Improve the Transparency and Auditability of your Corporation (2.10MB), attracted my interest primarily because it had some information on Enterprise Planning Budgeting which I understand is destined to replace Oracle Financial Analyzer (OFA). The presentation begins by outlining what transparency and auditability involves, namely: -

  • Auditability of Financial Results
  • Auditability of the Process underlying those results
  • Clarity of results and processes to all stakeholders:
    • Owners
    • Customers
    • Suppliers
    • Employees

It states that having access to information is not what’s most important, it’s whether the information is useful that counts. The main portion of the presentation relates to how you can use Oracle Applications to improve efficiency, control and data transparency. Efficiency is achieved by the Oracle Information Architecture which has the following characteristics: -


Unified Data Model

The Unified Data Model provides a single definition of customers, suppliers, partners, employees, and business events. This single source of truth, throughout the organisation, means that the information customers use to make decisions is accurate and timely.


Global means that all data, worldwide, are consolidated into a single instance. The Oracle E-Business Suite handles multiple currencies, languages and different security needs of different countries. This means that costs are reduced, by consolidation of data centre’s and data administration, and the quality of the information is improved.

The presenter goes on to highlight how Controls are improved by using: -

  • the Interface Data Transformer (IDT)
  • Business Events
  • the Currency Rates Manager
  • the Global Intercompany System and
  • Journal Approvals workflow

Data Transparency is said to be achieved by the following Oracle Reporting and Analysis Tools: -

  • Daily Operational Management Reporting - DBI: Pre-built role-based BI portal pages and management reports, drill-downs, simplified architecture
  • Financial Reporting and Analysis - EPB, FSG: Integrated Financial Reporting and Analysis with drill-down.
  • Planning, Budgeting and Forecasting - EPB: Streamlined enterprise planning and budgeting, on-going performance monitoring

The Key Benefits of Enterprise Planning and Budgeting are stated as: -

  • Fully integrated financial reporting, analysis, consolidation, planning, budgeting, and forecasting processes
  • ‘Real-time’ post from GL
  • Advanced multi-dimensional, multi-level reporting UI in html and export in Excel
  • Easy reporting with different hierarchy versions
  • Full drilldown to source transaction details

The presentation has some nice EPB screen shots which is the first time I have actually seen what the application might look like - until now all I’ve heard was the usual marketing talk. I wonder how easy it is to get it working. I would be interested in receiving any comments from readers and authors that relate to EPB, especially those who might be involved in the early adopter or beta programme for this particular product.