A day in the life of an Oracle Applications Consultant


Thursday, August 19, 2004

Oracle User Group Feature - the New Zealand Oracle User Group (NZOUG)

This post contains a review of the New Zealand Oracle User Group Website and also highlights key presentations and white papers from their 2004 conference which are available for download.

According to their site,

The New Zealand Oracle Users Group was founded in 1989. In our early years we were part of the Australia New Zealand Oracle User Group (ANZORA). But in 1997 we decided to sever the ties with Australia and we are now a separate group.

This group is for all Oracle users and is a forum to share ideas and interests. We are always open to new ideas about how we can improve the NZOUG so please email through your ideas to a member of the committee.

The most recent User Group conference ran from 25-27 May 2004 and papers were presented according to the streams of Executive, Applications, Technology and Training. I’ve taken a brief look at some of the papers that are available for download and the quality seems to be quite good. As and when I get a chance to take a detailed look, I will write up a detailed review on this site. Highlights from the applications section are as follows: -

Thanks to Gilbert Leblanc (who has an Oracle ERP Blog in French) for pointing me in the direction of this site.

Thursday, August 12, 2004

UK Oracle User Group Conference Agenda now available

This post contains a link to the UK Oracle User Group (UKOUG) Conference agenda and highlights the key presentations that an Apps consultant might want to attend.

At this site you can read the detailed Agenda for the UK Oracle User Group Conference which is taking place at the Birmingham International Conference Centre (ICC) from the 1st - 3rd of November 2004. The site lists the presentations by categories of Applications, Business and Management, Oracle Partner, Technology Other, Technology DBA, Technology RAC/Grid and Keynotes. You can also read the presentation abstracts as well as create a personalised conference agenda. If you’re planning to attend, mail me and we can make a plan to meet and chat.

Personally I will be delivering two papers, the details of which are as follows: -

Session Title:

Audit Considerations for your 11i implementation.


1st November 15:55 PM, for 45 minutes.

Presentation Abstract:

In any ERP implementation, review and audit is an inevitable part of the implementation process. This is particularly true today with the enactment of the Sarbanes-Oxley Act of 2002 and other worldwide initiatives to enhance corporate governance. This presentation identifies how to implement 11i in a manner that meets the control requirements of your auditors, both internal and external. Initially I will examine the reasons for auditing such systems and will then look at common problems encountered during audit and review exercises. In answer to the problems experienced the high level Oracle solution will be outlined and we will then take a look at specific auditing and review features embedded in the 11i E-Business Suite.

Session Title:

The beauty of Oracle’s web enabled applications.


2nd November 9:00 AM, for 60 minutes.

Presentation Abstract:

Demand for web services is growing and Oracle has adapted to and even pre-empted this requirement by web enabling their entire range of software. This presentation highlights what web offerings are available for Oracle Applications Desktop Integrator (ADI), Oracle Financial Analyzer (OFA) and Oracle Discoverer. It will also explore how these products interact with each other to provide sophisticated query, analysis and reporting functionality on organisational information.

The architecture of these web solutions will be discussed followed by the steps involved in setting up and configuring the web interface for each of these products.

Lastly, the single sign on functionality will be examined.

Conference Presentation Highlights

I’ve highlighted some of the presentations that you might want to attend if you are an Apps consultant with a functional orientation like myself. Most of these presentations are from the Applications and Business & Management categories. At the moment it represents my shortlist although it will obviously have to become a lot shorter. I intend to be doing write-ups and reviews on this blog for all the presentations I will be attending. Looks like it will be frantic on Monday and Tuesday whilst things will slow down on Wednesday on the functional side. If any readers are attending and would like to also contribute to this blog presentation reviews and comments I would very much appreciate this. I’m also going to try and get some of the presenter’s to publish their papers on this site so hopefully I will have fairly comprehensive coverage of the conference.


Monday 1st November 2004
  • Approvals Management Within Your Enterprise - Bill Kerr, Oracle Corporation
  • Automating Integration with your Supply Chain/Trading Partners - Adam Boczkowski, Reuters
  • Catalogue Content - experiences and the way forward - Andrew Douglas, Oracle
  • Oracle Tutor in a Multi Lingual Environment - Jay Dunford, Sopra Group
  • Completing the paperless buy to pay process - Anthony Woods, Edenbrook
  • Why IT Projects Fail – and How to Avoid It - Sten Vesterli, scott/tiger
  • Developing Advanced Business Intelligence Applications with Oracle OLAP
  • Oracle Configurator - Ravindra Vitankar, Capgemini UK PLc
  • Big IT Projects - Christopher Frost, EDS
  • e-procurement in the 21st Century: A case study - Catherine Murphy, Version One Limited
  • Quote Management Systems using Oracle Quoting - Kirit Goyal, GE Capital
  • Converting Data Conversion – Minimising risks and costs - Sarah Keeling, Edenbrook
  • Leverage features of Encumbrance Accounting in Oracle e-Business Suite - Tarun Wasan, Accenture
  • How do I cut and paste that into Excel? - Simon Goldsmith, Edenbrook
  • Set Up a Successful Reporting Solution with Oracle Discoverer & Other Tools - Evan Schulz, Noetix Corporation
  • Bespoke Oracle eBusiness Suite – Unnecessary evil or a way to real business benefits? - Kevin Saunders, Freelance


Tuesday 2nd November 2004
  • Managing E-Business Suite Configuration and Environments - Andy Harriss, Compelsysao
  • Achievable No PO No Pay – I don’t believe you! - David Golding, Edenbrook
  • HRMS Administration using Web ADI - Alison Venner, Compelsysao
  • Advanced Pricing : some business examples - Mike Turner, Unilog Ltd
  • Breaking Down The Functional Barriers: Shared Data At The Heart Of ERP - Marcus Glover, Vodafone plc
  • ORACLE TREASURY 11.5.9 – Real Implementation Experience - Mark Skilton, Edenbrook
  • Why Oracle Process Manufacturing? - Gary Figgins, Sopra Group Ltd
  • Linux in the Enterprise - James Morle, Scale Abilities Ltd
  • Oracle Integration
  • Enterprise Planning & Budgeting (EPB) - The Real Deal - Ian Hayman, inGroup
  • VAT Reporting - Tom King, Unilog
  • Does Oracle Financials Really Provide Business Intelligence? - Gary Horrocks, Teamsolve Ltd
  • Thales Missile Electronics eliminates profit erosion with Mestec’s Manufacturing Execution System - Jeremy Harford, Mestec Ltd
  • Oracle’s Enterprise Project Management Solution - Jim Snelson, Oracle Corporation UK
  • Automate Intrastat reporting with Inventory Movement Statistics - Shelly-Ann Scott, Deloitte Consulting

Now here’s an interesting one - Midge Ure of Ultravox (an 80’s band) will be giving a motivational talk. I just bought the Ultravox Greatest hit’s CD for US$6.50 at our local music store (about a third of the normal price) so I’ll definitely be making an effort to attend this presentation.


Wednesday 3rd November 2004
  • Custom Reports Vs. Discoverer Queries - Identifying the appropriate reporting tool - Louise Shaw, Edenbrook Solutions Ltd
  • CPM - Dream or reality - Jon Page, Oracle
  • Oracle Balanced Scorecard – From Monitoring to Management - Chris Hett, Fujitsu

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.

Tuesday, July 27, 2004

Oracle OpenWorld in Shanghai, China - presentations and white papers now available

This post takes a look at the key areas covered in the Oracle OpenWorld China conference and also reviews the presentations and white papers delivered for some of the Oracle E-Business Suite 11i Tracks. There were more than 150 sessions going on at the conference so there’s no shortage of reading material.

The Oracle OpenWorld China conference came to a close last week and the presentations and white papers are now available for download in PPT and Word format (nice for those who like to copy and paste). Most of the areas presented on were not really Apps related but for those that were, I will be preparing a review of some of the presentations during the week. The following is a list of the solution areas presented on as well as the number of presentations for each area: -

  • Security and Identity Management - 4
  • High Availability - 11
  • Performance and Scalability - 31
  • Management - 35
  • Content Management and Collaboration - 8
  • Business Intelligence - 21
  • Portals and Wireless - 9
  • Linux - 5
  • Integration and Web Services - 9
  • Application Development - 22
  • Corporate Governance - 9
  • Small and Mid-Size Business - 6
  • Corporate Performance Management - 7
  • On Demand - 4

Sunday, July 25, 2004

New Oracle Presentations from the OpenWorld Conference in Melbourne

After a bit of a wait it now seems that the Oracle OpenWorld Melbourne Presentations are now available in pdf format (sorry to those people who like copying and pasting). This post lists the key areas covered and also reviews the presentations delivered for some of the Oracle E-Business Suite 11i Tracks.

You can download presentations for the Oracle OpenWorld Australia and New Zealand Conference here. According to the site: -

There were over 100 Sessions to choose from over the course of the OpenWorld conference. They were delivered via 10 concurrent Tracks - focussing on Oracle’s entire range of business solutions and technologies.

Following is a complete listing of all the tracks as well as some personal reviews I have prepared: -

Keynote Presentations

Charles Phillips presentation on Creating Corporate Value - Information Matters contains a short but interesting look at Oracle’s financial performance. I was interested to see that Oracle Applications Sales have grown by 4% in the last 12 months. The competitors didn’t do so well - SAP (-6%), Peoplesoft (-17%), Siebel (-31%). The only software company beating Oracle’s operating profit margins is Microsoft. I must be in the right business - at least for now anyway! The session goes on to discuss the Oracle Strategy a large component of which seems to be helping organizations Standardize IT in the following areas: -

  • Processes 
  • Data
  • Architecture
  • Infrastructure

Keith Kellogg’s presentation on Oracle’s Perspective on Homeland Security gives a nice high level view of the

Oracle E-Security Suite

solution bundle.

The presentation I like the most was by John Wookey on the Information Driven Organization. Firstly it ask’s the question, what defines the information driven organization - to which the answer is: -

  • Alignment - encourage behaviour that supports organizational objectives through communication, consistency and incentives.
  • Effectiveness - drive enerprise information and enterprise business processes into every aspect of your business.
  • Collaberation - coordinate processes across direct, partner, supplier and online channels through distributed access, integrated processes and shared information.

He then defines the Oracle Solution for the Information Driven Organization by outlining the key features of the new 11i release (namely 11i.10 or 11.5.10) which are: -

  • Integrated Business Driven Intelligence
  • Continued Aggressive product extensions
  • Best in Proven Technology
  • Broad Industry Investments
  • Opening of the E-Business Suite: -
    • Integration Services
    • Customer Data Hub

The presentation outlines Oracle Solutions for Specific Industries and then goes on to explain the three paths to higher quality information, which are: -

  1. Full E-Business Suite right away - best information, lowest cost.
  2. E-Business Suite with Integration to Legacy Apps - More graceful on-ramp to E-Business Suite.
  3. Data Hub - Retain Legacy Apps; benefit from single data model.

I like the presentation because although it does mention Oracle Specific Solutions, it gives a good idea of what organizations are trying to achieve and how IT is helping them meet their business goals.

Oracle Database 10g - Tracks A & B

Oracle Application Server 10g and Application Development - Tracks A & B

Oracle Collaboration Suite Track

Business Intelligence & Data Warehousing Track

Enterprise Resource Management - (Oracle E-Business Suite 11i) - Tracks A & B

Certainly the best presentation in this category was The Enterprise Iceberg - a hidden resource or a hazard to business by John Julian. The presentation relates to the University Systems Project (named Themis) undertaken at the University of Melbourne. It’s quite a lengthy presentation but makes good reading and will provide you with a really good understanding of all aspects of ERP implementation. The presentation begins with a project overview and states why the University needed to change. One of the strong points of the presentation is that it clearly outlines the hardware and software architecture being used. A comprehensive listing of all the costs involved as well as the quantifiable benefits is also given. Lastly, the presentation mentions how you can avoid implementation disaster and goes on to mention several good books that you can read relating to enterprise systems implementations.

A presentation I was certainly interested in reading was E-Business Suite Special Edition - benefits for small and medium sized enterprises. Oracle E-Business Suite Special Edition is Oracle’s Packaged Solution for midsize businesses. Key features are: -

  • Pre-configured E-Business Suite 11i modules (packaged but tailorable)
  • Rapid, fixed price, fixed scope implementation
  • Ready to expand when you are 

The presentation contains a case study for Sunny Queen (Pty) Ltd - the largest egg supplier in Queensland. I’m hoping at a later point to try and provide readers with a bit more information on this release, in the mean time you can read more about E-Business Suite Special Edition at this Oracle Page

Another presentation of interest was Leadership in Leasing by Brett Kennedy. The presentation discussed the leasing industry in Australia, the leasing lifecycle and the platform and then finally took a look at the Oracle Lease Management Solution. I was interested in the presentation primarily because I didn’t realise Oracle had a solution for Lease Management. After reading the presentation it became clear to me that this was only released in 11.5.8. The presentation states Oracle’s commitment to leasing as follows: -

  • First Production Release 11.5.8, Dec 2002
    • Joint Development with GE
  • Current Release 11.5.9
    • New functionality - syndications, asset terminations. Multi-GAAP
  • Australian Launch of Lease Management, Feb 2004
    • Local Training, Implementation and Support Capability
  • Next Major Release 11.5.10, due mid 2004
  • Significant Resources
    • Effort has been underway since 1999
    • Deep Leasing Experience on Oracle Development Team
    • Many Enhancements to Existing Products
    • Significant Investment by Oracle Consulting and Partners Since Inception

I liked the Value Proposition slide which had an interesting “graph” and states: -

A lease management solution delivers significant profitability improvement, through cost reduction and better operational control, scale economies for future growth and reductions in the cost of capital.

The presentation also clearly outlines the lease business flows.

I was interested to see the screen shots of the Oracle Lease Management solution as most of the interface seem to be web based (using Java Server Pages - JSP’s) which makes me think that Oracle is moving more towards a web based solution than using forms. The very last section of the presentation also has some cool looking Oracle Discoverer reports.

Customer Relationship Management - (Oracle E-Business Suite 11i) Track

Supply Chain Management - (Oracle E-Business Suite 11i) Track

Page 6 of 7 pages ‹ First  < 4 5 6 7 >