R12 – Upgrade Overview

This is a my personal log of changes from 11i to R12.

It is my intent to go through core financials in R12 as an internal project in order to make a structured approach to new features and changes in the new release.

So the notes below only applies to core Financials modules in scope.

This should prove useful when working with 11i based customers and consultants.

The Upgrade User Guide is not very detailed and when you look closer into each module you will realise the changes made are much more significant than stated.

This will have a major impact on businesses upgrading from 11i as not only are there many changes to the user interface but even more so are the changes to many of the maintenance forms where the underlying data model has changed completely. This will also have a major implications on any customisations or interfaces made.

Modules in scope in alphabetical order – module id:

General Changes

Obsolete Modules

  • Global Accounting Engine – AX – replaced by Subledger Accounting functionality
    AX always seemed to be a workaround rather than a core element of the architecture – so a great step forward.
  • iPayments – replaced by Payments functionality

Oracle Applications Framework – OAF

There seems to be a shift towards the Oracle Applications Framework – OAF based web forms from the professional java based client. In general this is good as the java client only was supported by a limited amount of browsers. However I have already had a few problems with the OAF buttons in various browsers like Google Chrome – so there may still be compatibility issues ahead. Always test and re-test.

Architecture Changes

  • TCA is now the container for all organisations and people in OA with the inclusion of suppliers, banks, employees and internal organisations.
    No more need to link suppliers to customers and data conversions has been simplified.
  • XML Publisher is becoming the core output tool weather it is reporting, business intelligence or external communication.
    This will enable non-technical people to make simple custom reports.
  • Multi-org security managed by security profiles instead of one organisation per responsibility.
    A great functionality for shared services centres.
  • MRC functionality now replaced by Reporting Currencies so rather than maintaining dual set of books it is now reported from one ledger only.
  • Subledger Accounting – both replaces Global Accounting Engine but also provides a single approach to GL posting from all subledgers.
    This should sort out all the custom reporting needs to verify and reconcile accounting from various modules. I have had loads of fun with the AP AE tables and can’t wait to see them go.