A day in the life of an Oracle Applications Consultant

Wednesday, July 07, 2004

Oracle Applications Magazines

This post contains details of the various Oracle Applications Magazines that are in production.

Having consulted in Oracle Applications for the past 3 years I am always keen to read any articles and papers I can get my hands on relating to Oracle Apps. I also write quite a few articles myself so obviously I was keen to find magazines to write for. In this post I’ve tried to mention only those mags that have a functional or non-technical orientation.

Oracle Scene

Scene is the Official Magazine of the UK Oracle User Group (UKOUG). It is produced quarterly and has a circulation of about 1,600. They accept articles from any region or continent in the categories of Business and Management, Applications and Technical (DBA and Developer). If you would like to share an interesting implementation experience or impart some knowledge that may benefit other users, then please visit the links below. Should your article be accepted for publication you will be sent a complimentary issue of the magazine. The Magazine is produced on a quarterly basis and is free if you are a member of the UKOUG. The User Group offers an annual subscription for additional copies of Oracle Scene to all members and nominated contacts for £20.00 each, and to Non Members for £40.00.

OAUG Insight

This is the official magazine of the Oracle Applications User Group. It is produced on a quarterly basis and in order to receive it you will need to be a member of the OAUG. As far as I know the magazine accepts unsolicited articles - you just need to contact the editor.


This is a quarterly publication which always makes a good read, especially if you need to keep up with what’s happening in the Oracle World. The content is more high level and tends to contain a lot of marketing material since it is an official publication of Oracle. Unfortunately they do not accept unsolicited articles, however, it is free! You can read it online, access magazine archives or subscribe to Profit here

If any readers know of any other Oracle


Magazines that are in production, drop me a mail or add the details as a comment to this post.

Monday, July 05, 2004

Upcoming Oracle Conferences and Events July 2004 - December 2004

This post contains details of various Oracle Applications Conferences and Events taking place in the next 6 months.

Oracle OpenWorld

I spoke at Appsworld both this year and last year and have to say that as a speaker it’s one of the best conferences to attend - they treat you really well (you have your own speaker lounge) and the numbers attending the presentations are high (+/-150, depending on the topic). Oracle has decided to merge AppsWorld (which has more of a functional focus) and OracleWorld (which has previously had a rather technical orientation) in to an event called Oracle OpenWorld. This means that Oracle OpenWorld should be the ideal IT conference to attend for any prospective or existing Oracle users, be they technical or functional. If you don’t manage to attend the events in person you can always visit OpenWorld Online to take a look at keynotes, sessions, photo galleries and online demos. Details of the individual events are as follows: -

Melbourne 7th - 9th July 2004, Melbourne Convention Centre

According to Oracle: -

“Oracle OpenWorld, Melbourne 2004, is Australasia’s premier conference and exhibition for business decision-makers, IT management, line of business managers and Oracle users. Designed for Oracle customers and partners, and for all leading organisations in Australia and New Zealand with enterprise information management needs”.

Shanghai 19th - 22nd July 2004, Shanghai International Convention Centre

According to Oracle: -

“Oracle OpenWorld is the premier Oracle conference and exhibition for business decision-makers, IT management, and line of business managers and users. OpenWorld is a unique program that allows you to gain insights from Oracle management, product development, Oracle customers, and industry experts all during one week this July in Shanghai, China”.

Seoul 1st - 2nd September 2004, Coex Convention Centre

London 6th - 8th September 2004, Excel Conference Centre

The site states: -

“Join us this September as Oracle launches the Oracle OpenWorld European conference series in London, England. The Oracle OpenWorld conference and exhibitions are designed for both business and IT professionals and will provide you with key information and strategies to help you improve processes and manage your most critical information assets”.

Amsterdam 22nd - 24th September 2004, Amsterdam RAI

Milan 28th - 30th September 2004, Fiera Milano Congressi

Munich 5th - 7th October 2004, ICM - Internationales Congress Centre Munchen

Sao Paolo 26th - 28th October 2004, Transamerica Expo Centre

Mumbai 1st - 3rd November 2004, The Hilton Towers

San Fransisco 5th - 9th December 2004, Moscone Centre

According to the site: -

“OracleWorld, the world’s largest conference and exhibition dedicated to Oracle technology and Oracle AppsWorld, the world’s largest conference dedicated to Oracle E-Business Suite applications are joining together in San Francisco this December to create a new conference called Oracle OpenWorld.

By joining the two conferences Oracle will be able to present the complete Oracle story - Oracle’s Information Architecture. Oracle Information Architecture provides secure access to your most critical information assets and allows for you to know more about your customers so you can make the right business decisions at the right time”.

Oracle Applications User Group (OAUG)

Connection Point 2004 - The point of contact September 12 - 15, 2004 Walt Disney World Swan and Dolphin Hotel Orlando, Florida, USA

According to the site: -

“OAUG Connection Point 2004 — The Point of Contact will provide you with an unparalleled educational and networking environment and will be attended by users of Oracle applications who are seeking to maximize their knowledge, experience and understanding of the applications that they use to run their businesses.

OAUG Connection Point 2004 will feature multiple tracks and more than 200 sessions that will provide the latest information on how to:

  • Increase your quality of service.
  • Strengthen your architecture for maximum performance.
  • Minimize IT cost”.

You can also “Optimize your Oracle Applications with OAUG eLearning - efficient, effective education in an onsite environment.”

I spoke at Connection Point 2003 and have to say that this was certainly one of the best Oracle Conferences I’ve been to. From a user perspective there are a vast number of presentations and training sessions to attend. From a speaker perspective it’s nice to have a large audience to speak to - had 250 people at my training session.

United Kingdom Oracle User Group (UKOUG)

Birmingham 1st - 3rd November 2004, International Convention Centre (ICC)

The theme of the conference this year is this year is “Striking the right note with Oracle”. According to their site: -

“This year UKOUG 2004 will be having a musical theme. A harmonious group is really only the sum of its constituent parts. The ability of the players and the instruments they use, along with the coordination of a conductor combine to make a product that others desire. A company cannot survive without the knowledge and skills of it’s staff, who come together to create a greater understanding Oracle”.

I spoke at this conference in 2002. It’s a really good conference to attend but the orientation of the conference is more technical than functional - they have 1 day functional and 2 day technical. Hopefully as E-Business Suite gains momentum there will be more functional content.

South African Oracle User Group (SAOUG)

Sun City 17th - 19th October 2004

The theme of the conference this year is “Delivering to the CIO’s agenda”.

I spoke at this conference in 2003, like the UKOUG it is very technically orientated. Living right next door to South Africa I’ve come to know the market there a bit and have to say that the conferences technical orientation is related to the market being that way. There’s not very much going on with Oracle Apps in South Africa - that is when compared to the database/technical side. Decided to give the conference a miss this year as I’m intending to move to the UK in September.

In Closing…..

As far as I know the call for papers is closed for all of these conferences. I submitted papers for Oracle Openworld London, Amsterdam and Milan as well as for Connection Point 2004 and the UKOUG in Birmingham. All my papers were rejected for Connection Point 2004 so I guess it wasn’t meant to be :-(

I would be interested in getting conference “evaluations” from any attendess or speakers so please make any useful comments or assessments on this post. In addition to this, if you happen to be attending any one of these conferences and would like to blog about your daily experiences at a conference then let me know.

Friday, July 02, 2004

Better Corporate Governance with Oracle Internal Controls Manager

This post discusses the Oracle Internal Controls Manager, a new product by Oracle that is intended to help organisations meet the requirements of the Sarbanes Oxley Act of 2002 and International Accounting Standards (IAS).

Product Features and Capabilities

Oracle Internal Controls Manager is a comprehensive tool for executives, controllers, internal audit departments, and public accounting firms to use to document and test internal controls and monitor ongoing compliance.

The benefits of utilising the Oracle Internal Controls Manager are listed as 3 fold: -

  1. More efficient internal control testing
    • Audit Program office/project management
    • Risk assessment questionnaires
    • Confidential feedback mechanism
    • Reviewing reconciliation status of all subsystems
    • Reviewing policy compliance
  2. Higher Certainty in your Risk Assessment
    • Internal audit system is part of your operational system – this ensures accurate, real time business information.
    • Risk library and associated controls developed by Oracle working with world leaders in Audit and Risk Assurance.
  3. Lower external audit verification costs
  4. Internal control manager ensures internal & external auditors understand your business systems risks and associated controls, hence reducing time taken to understand the system and saving you money.


At this point in time the Internal Controls Manager does not even come with release 11.5.9 of Oracle E-Business Suite. After first hearing and reading about this product I e-mailed Nigel King, Senior Development Director at Oracle Corporation to find out how I could install it. He informed me that ICM is currently on control hold so that they can understand where it is being sold. I subsequently discovered that there are two minipacks available on Metalink, but you will need to have a password to access them. Because I work for an Oracle Partner I raised a TAR and explained that I would like to download the patches so that we could test this product as there were some interested clients - after doing this Oracle gave me the passwords. The patches no.‘s for product code AMW (the Oracle Internal Controls Manager Product Code) are as follows: -

  • Minipack A - 2972149
  • Minipack B - 3232451

I tried installing Mini Pack A on an 11.5.9 instance, however, the list of pre-requisites was so long and these pre-requisites also have pre-requisites! Eventually I got bored and started working on the many other things I have on my list of things to do. I’m sure I will continue this activity at some stage so I can at least be able to write a realistic assessment of the products capabilities. In the mean time I’m hoping this information will be useful to someone and would be interested to here from other parties who have actually used the product.

Additional Information

The Oracle Corporate Governance Page has a variety of presentations, white papers and videos that you can take a look at. It also mentions the high level Oracle Corporate Governance solution "slogan". According to the page "Only Oracle offers complete, integrated business intelligence and analytics that provide your management team with continuous, current, customized information about every aspect of your business-from finance and human resources to supply chain and marketing. Find out how Oracle can help you improve your business operations in the areas critical to good Corporate Governance: 

  • Visibility - Access timely, relevant, accurate information across your organization 
  • Control - Centralize and secure policies, processes, and procedures 
  • Efficiency - Roll up and reconcile data quickly and accurately while eliminating administrative overhead".

Presentations and White Papers

Page 4 of 4 pages ‹ First  < 2 3 4