Contact us at +1.415.901.7500 or

Oracle R12 & Shared Services – Your Questions Answered

Oracle R12 & Shared Services – Your Questions Answered

Well over 60 people attended last week’s Webcast “Oracle R12 Shared Services Centers: Best Practices for Business Success.” The Webcast lasted about 40 minutes, followed by about 15 minutes of questions and answers.

Unfortunately we did not have time to answer everyone’s question, but we are happy to share them with everyone now:

  • At very high level which Oracle processes can be part of shared service mainly if you’re focusing on it from a Projects perspective?

    In the Oracle Projects’ suite, Oracle R12 allows you to work with multiple Operating Units and also allowing you, on the billing side, to interface and work in Accounts Receivables with MOAC and Security.

  • Will the table structure of the database change in anyway, eg. will SQL scripts used in R11 be usable in R12 (bit more of a technical question)?

    In R12 many table structures have changed because of the MOAC and the new General Ledger structure. The old model remains there (meaning some views still work) but with respect to major changes such as vendors, which was moved into the Oracle TCA (Trading Community Architecture) model, and AP invoices with a new level (details), just to mention two, are very important table structure changes. This is an issue that needs to be thoroughly reviewed before you get started on a project.

    There’s more information at Oracle Support under the knowledge base for R12.

  • What will be the first step to start a reporting strategy for Shared Service Center?

    The first step will be to assess the existing systems that you’ll be incorporating into the scope of the reporting solution. This assessment will include identifying which tools will need to include at least 3 views: Analysts Users, Business Users and Executives/Managers

    Analysts Users: near real-time, summarized data, historical trending, drillable reports

    Business Users: operational reports, ad hoc query, real-time, detailed data.

    Executives/Managers: strategic, performance management, enterprise wide and analytics / KPIs

    Once you have defined this scope, you’ll evaluate tools and we recommend using existing tools in the market that is guaranteed to work with any Oracle E-Business Suite version change to metadata (or how the information is being stored.) This ensures that which makes your report run just like in the previous version.

In the event you missed the webcast, you can click here to download the Power Point from IT Convergence’s Oracle R12 Resources page.

If you’re interested in getting more information about Oracle R12 be sure to register for our next Webcast “Improving Security in Oracle Financials R12” and/or make plans to attend the workshops that IT Convergence and the OAUG are sponsoring “Preparing for an Oracle R12 Upgrade.”