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.

Oracle Partner Feature - Red Rock Consulting Group

This post contains a review of the Red Rock Consulting Group web site and highlights some useful downloads they have.

Recently I came across the Red Rock Consulting Group web site. Red Rock is an Oracle Certified Advantage Partner and according to their site: -

Red Rock Consulting is an innovative, dynamic and energetic consultancy formed to support clients who have chosen Oracle business solutions. Red Rock is the largest independent Oracle consulting firm in Australia and New Zealand, with a highly skilled and experienced pool of Oracle consultants across the Asia-Pacific region including offices in Sydney, Melbourne, Canberra and Auckland.

They have some really good white papers, articles and presentations which have been delivered at numerous Oracle Conferences and User Groups or featured in reputable Oracle Publications and Magazines. In particular, there’s quite a bit of information available on upgrades. Highlights are as follows: -




As an when I get the chance to take a detailed look at each of these articles, white papers and presentations I will prepare a write up for this site. In the mean time, happy downloading and reading. You should also consider subscribing to the Red Rock Newsletter entitled HotRocks.

If you are reading this post and you know of any really good partner sites where you can get useful information and downloads, then please add your comments.

Wednesday, August 18, 2004

Atlanta OAUG - August Meeting Agenda

This post contains details of the upcoming Atlanta Oracle Applications User Group (ATLOAUG) monthly meeting.

The next meeting of the Atlanta OAUG is scheduled to take place on Friday the 20th of August 2004 and you can find the Agenda here. Highlights are as follows

Presentation abstracts and descriptions relating to the highlights can be found on the User Group site where you can also register to attend. Registration is FREE so if you are in the vicinity you should make the most of this opportunity.

You can download historical presentations and white papers delivered at Atlanta Oracle Applications User Group Meetings from 1997 -2004 here - there’s certainly plenty of good material to take a look at. 😊

Other areas of interest on this site are the newsletters section where you can download/subscribe to their newsletter.

Saturday, August 14, 2004

UKOUG Financials Special Interest Group (SIG) Meeting

This post contains details of an upcoming UK Oracle User Group Financials Special Interest Group Meeting that I will be speaking at.

I’m moving to the UK on the 5th of September and am pleased to have been invited to speak at the next UKOUG Financials Special Interest Group (SIG) Meeting. If you or your organisation are UKOUG members, then come along to the meeting which is being held at the London Congress Centre on the 14th of September 2004. Details of my presentation are as follows: -

Session Title:

Keys to building effective Property Management solutions in 11i


  12:00 - 12:40

Presentation Abstract:

This presentation demonstrates how Oracle Property Manager provides a comprehensive real estate management solution which automates and enhances properties definition, space utilisation management and lease administration. It will highlight how Property Manager effectively supports lease execution from both the owner and leaseholder perspectives as well as how it integrates with Payables and Receivables. Also discussed will be key implementation considerations and the latest features introduced into the module.

The schedule for the day can be found here and other presentations on offer are as follows: -

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

Page 3 of 4 pages  < 1 2 3 4 >