Where do you want to go today?
Download
Home
Tips & Tricks
Download
Schedule
Subscribe
Motivation
Personal
Links
Contact
About me

 


 

Herewith some free videos, papers, presentations and supporting workings for various conferences I have presented at and publications I have written for. To download, right hand click over the text "PDF", "PPT", "OTHER" or the "DOWNLOAD" button and choose "Save Target As...." All the links and videos on this page should be working so if you have any problems please don't hesitate to contact me.

Oracle Training Videos

Note: In order to view these videos you will need to complete this easy and small installation of the TechSmith Screen Capture Codec tscc.exe (169KB)

Setting up and using the Excel Interface for Public Sector Budgeting -  Duration 10 minutes

Produced by Richard Byrom - January 2004

Download Excel Interface for PSB Training Video

(7.56MB)

Tips on exporting your Oracle Apps reports to Excel - Duration 10 minutes

Produced by Richard Byrom - January 2004

Download Oracle Apps Export training video

(9.51MB)

Oracle and ERP related Implementation Documentation

Generic Oracle Applications Implementation Project Plan

This plan prepared in Microsoft Project should provide any parties interested in implementing Oracle Applications with a framework for doing so. It contains the detailed tasks involved and lists the associated resources that may be needed. The Work Breakdown Structure (WBS) codes tie back in to the Oracle AIM documents that should be prepared for each task and phase. 

Download Generic Oracle Applications Implementation Project Plan

(653KB)

Oracle Applications Chart of Accounts Template

This template gives an example of the flexfield or segment structures one needs to create when designing a Chart of Accounts in Oracle Applications. It also illustrates the types of values that should populate the segments as well as the hierarchies and cross validation rules that ought to be created.

Download Oracle Applications Chart of Accounts Template

(166KB)

 

Oracle R11 Test Scripts

Download Oracle R11 Financials test scripts here. Since I've hunted high and low on the internet for R11i scripts I would appreciate anyone sharing such scripts with me so that I can put them on my site for download by other interested consultants. Or, should you decide to update the R11 ones placed here with the new navigation paths and processes, then please send the updates my way.

Note on using these documents    

These scripts were prepared using the layout of the TE040 Test Scripts template in Oracle AIM. Therefore, you need ensure that you set your macro security to low when opening these documents as this will allow various auto open macros to run that add an Oracle AIM menu to the standard Word menu. The AIM menu allows you to make mass changes to the test scripts document. Whilst in the test script documents you can view hidden text which contains instructions on how to fill in the document by selecting Tools > Options > View (Tab) and under the "formatting marks" section check/uncheck the hidden text check box to display/hide the hidden text. 

 
Fixed Assets (size - 392KB)

Download Oracle Fixed Assets Test Scripts

Cash Management  (uploading 1st April 2005)
General Ledger (uploading 1st April 2005)
Accounts Receivable (uploading 8th April 2005)
Accounts Payable (uploading 15th April 2005)

Oracle Enterprise Resource Planning (ERP) Presentations

It's month end, now comes the reconciliation crunch!  

Atlanta Oracle Applications User Group, Georgia, USA, 19 November 2004

  PPT (4.30MB) OTHER

The beauty of Oracle's web enabled Applications  

UKOUG Birmingham, England, 2nd November 2004

  PPT (621KB)  

Audit Considerations for your 11i implementation  

UKOUG Birmingham, England, 1st November 2004

  PPT (1.07MB)  

Keys to Building Effective Property Management Solutions  

UKOUG Financials Special Interest Group (SIG) - London, England, 14 September 2004

  PPT (1.35MB)  

Overview of Student Management System Components

University of Botswana ERP workshop, Gaborone, Botswana, 24th April 2004

  PPT (0.35MB)  

ERP Implementation Fundamentals

University of Botswana ERP workshop, Gaborone, Botswana, 24th April 2004

  PPT (0.43MB)  

Take the pain out of Public Sector Budgeting implementation setups

Appsworld San Diego, California, USA, 26-29 January 2004

 

PPT (889KB)

OTHER (0.20MB)

It's month end, now comes the reconciliation crunch!

Appsworld San Diego, California, USA, 26-29 January 2004

 

PPT (4.05MB)

OTHER

Designing an effective Chart of Accounts Structure with Oracle Applications

SAOUG Sun City, South Africa, 6-8 October 2003

PDF (0.53MB)

PPT

(0.78MB)

OTHER (1.13MB)

Audit Considerations for your 11i implementation

EOUG Noordwijk, Netherlands, 2-3 October 2003

PDF

(0.94MB) 

PPT (1.50MB)

 

It's month end, now comes the reconciliation crunch!

OAUG San Diego, California, USA, 14-17 September 2003

 

PPT (4.09MB)

OTHER

Designing an effective Chart of Accounts Structure with Oracle Applications

Appsworld San Diego, California, USA, 19-22 January 2003

 

PPT (0.56MB)

OTHER

(1.13MB)

Get more out of 11i, with Oracle ADI

Appsworld San Diego, California, USA, 19-22 January 2003

 

PPT (0.43MB)

 

It's month end, now comes the reconciliation crunch!

Appsworld San Diego, California, USA, 19-22 January 2003

PDF (121KB)

PPT (1.04MB)

OTHER

Designing an effective Chart of Accounts Structure with Oracle Applications

UKOUG Birmingham, England, 8-10 December 2002

 

PPT (0.66MB)

OTHER (1.13MB)

Discoverer Overview

Grant Thornton, Lusaka, Zambia, 9th June 2002

  PPT (1.35MB)  

Materials and Suppliers - Strategic Procurement

Enterprise Resource Planning Seminar, Gaborone, Botswana, 24th May 2002

  PPT (0.32MB)  

Interfacing with General Ledger

13th Cheque Payroll Seminar, Gaborone, Botswana, 12th December 2001

  PPT (0.36MB)  

Conference Paper Abstracts

UKOUG Birmingham, England, November 2004

Contains the 10 abstracts which I submitted for the 2004 conference  

Download Oracle Conference Paper Abstracts

(39KB)

SAOUG Sun City, South Africa, October 2003

Contains the 7 abstracts which I submitted for the 2003 conference  

Download Oracle Conference Paper Abstracts

(52KB)

 

Oracle White Papers and Articles

Setting Up and Using the General Ledger Account Hierarchy Manager     

Published in:

- Oracle Scene, Issue 19, Autumn 2004 

PDF

(127KB)

 

Setting up and using the Excel Interface for Public Sector Budgeting      

Published in:

- Oracle Scene, Issue 17, Spring 2004 

PDF

(194KB)

Video

(7.56MB)

Audit Considerations for your 11i implementation (short version - see longer version under presentations section) 

Published in: 

- OAUG Insight, Spring 2004

PDF

(366MB)

 

Tips on exporting your Oracle Apps reports to Excel

Published in: 

- Oracle Scene, Issue 16, Winter 2003

PDF

(1.33MB)

Video

(9.51MB)

Enhance your project documentation process with Oracle Applications Implementation Methodology (AIM)
Published in: 

- OAUG Insight, Fall 2003

- Oracle Scene, Issue 15, Fall 2003

- ITToolbox.com

- ORAFAQ.com

Download Oracle AIM Whitepaper

(100KB)

 

Get more out of 11i with Oracle Applications Desktop Integrator (ADI)
Published in: 

- Oracle Scene, Issue 13, Spring 2003

- ITToolbox.com

- ORAFAQ.com

Download Oracle ADI Whitepaper

(147KB)

 

It's month end, now comes the reconciliation crunch!
Published in:

- Oracle Scene, Issue 12, Winter 2002

Download Oracle ERP Reconciliation Whitepaper

(120KB)

 

Master of Business Administration (MBA) Assignments

In 2003 I completed my Masters in Business Leadership (MBL) with the University of South Africa (UNISA). Below are some of the assignments I prepared for the different modules undertaken.

Assignment 2: The CITY.ZA Network 

Managing Electronic Commerce 2002

Download Managing Electronic Commerce Assignment

(1.50MB)

How technology is helping organisations sustain competitive advantage through Strategic Purchasing

Publishable Article 2003

Download Publishable Article on Strategic Purchasing

(743KB)

Assignment 1: Microsoft, 1995

Strategy 2002

Download Microsoft Strategy Assignment

(275KB)

Assignment 2: D. U. Singer Hospital Products Corporation

Project Planning, Scheduling and Control 2002

Supporting Workings

Project Plan before leveling - mpp (291KB)

Project Plan after leveling - mpp (296KB)

Graphs and Schedules - xls (152KB)

Download Assignment on Project Scheduling, Planning and Control

(328KB)

Assignment 2: PlaceWare: Structuring a Xerox Technology Spin-off

Management of Technology 2002

Download Xerox Management of Technology Assignment

(0.27MB)

 

      Back Next