OracleAppsBlog

Saturday, August 28, 2004

Oracle OpenWorld - London Conference

I’ll be attending Oracle OpenWorld London and this post contains details of the sessions I will be attending and preparing write ups on.

I’m moving to the UK permanently on the 5th of September and was lucky enough get a Full Conference Complementary Pass for Oracle OpenWorld London, which is running at the ExCel Centre from the 6th - 8th of September 2004. I’ll spend my first 3 days in the UK having job interviews and also attending OpenWorld which is a rather nice way to spend my first days there. If any readers would be interested in meeting at the conference and chatting then fire a mail my way.

I’m hoping to provide comprehensive coverage of the conference on this blog by preparing write ups on the presentations and uploading some pictures and video clips - time permitting. I’m planning to take a look at a lot of the new features and products on offer in Oracle Applications, like 11i10 (11.5.10), Internal Controls Manager (ICM), Enterprise Planning and Budgeting (EPB) and Daily Business Intelligence (DBI). For the first time in my life, I’ve used the conference schedule builder provided on the OpenWorld web site to ascertain which presentations I would like to attend as I’ve decided to try and be a bit more organised this time around. My programme is looking as follows: -

Monday 6th September 2004

• Keynote: Utility Computing - are we there yet? - John Manley, Director, Application Services Department, HP Laboratories Bristol and Peter Hindle, Enterprise Solutions, Business Manager, HP UK
• Session 7648: Financials Best Practices - Steve Miranda, Oracle Corporation
• Session 7646: Increasing Control: Centrally Managing Statutory Requirements and Corporate Policy Compliance - Michelle Maden and Olivier Arthus, Oracle Corporation

Tuesday 7th September 2004

• Keynote: Protecting Your Assets: While Spending Less and Storing More - Tim Pitcher, Vice President, Northern Europe & Middle East, Network Appliance, Inc.
• Session 7606: Beyond E-Government - Iain Campbell and Ian Watmore, Oracle Corporation.
• Session 7396: Lean Asset Lifecycle Management - Robert Brown, Georg Reindl and Kenneth Mitchell, Oracle Corporation
• Session 7226: Customer Data Hub and Oracle Information Architecture (OIA) - Steve Miranda, Oracle Corporation
• Session 7995: Oracle Application Implementation Methodology (AIM) and EMC Proven Solutions - David Clarke, EMC Corporation

Wednesday 8th September 2004

• Keynote: Transformation of Industry through Technology - Tom Garrison, Director of Enterprise Marketing, Intel EMEA
• Session 7650: General Ledger: Improve the Transparency and Auditability of Your Corporation - Rob Zwiebach, Oracle Corporation
• Session 7652: Revenue and Receivables Management: Instill Strong Corporate and Fiscal Discipline - Fred Studer, Oracle Corporation

Mmm… I notice Larry is not giving a keynote, he must be going sailing

Friday, August 27, 2004

University of Florida ERP Implementation - Bridges

This post contains a review of the University of Florida Bridges site which contains some useful documentation and training material on the implementation of Enterprise Systems.

The University of Florida has a really good site called "Bridges" which provides documentation and training material relating to the implementation of systems in their organisation.

According to their site: -

UF Bridges is a multi-year project to replace the University’s current computer systems with new Web-based, integrated systems that provide real-time information and improve university business processes. This is known as an Enterprise Resource Planning (ERP) solution. The University purchased ERP software from PeopleSoft for its financial, human resources, payroll and student administration functions, and enterprise data warehouse and reporting functions from Cognos (a PeopleSoft partner).

Although the solutions being implemented at this University are not Oracle Applications related I thought the site would be helpful for the following reasons: -

1. It provides some good examples of the type of documentation and training material that should be prepared when implementing Enterprise Systems.
2. The documentation and training material will provide readers with a good understanding of the business processes for each of the functional areas within an organisation (e.g. Finance, HRMS)
3. There are various presentations available that give an idea of the issues that one needs to think about when implementing ERP systems.
4. The site provides a good example of how to effectively manage the knowledge gained in an organisation as a result of such an implementation.

The training section is probably the most useful area of this site. It provides instructions guides, classroom training presentations and handouts, classes on video and web tutorials which cover the following functional areas: -

• Enterprise Reporting
• Finance


• Overviews
• Core User
• Customer Relations
• General Ledger/Budgets
• Purchasing and Payables


• Requisitions
• Change Requests
• Receiving
• Vouchers
• Procurement Card (PCard)
• Sponsored Programs
• Travel and Expense
• Human Resource Management Systems


• Hiring


• Staff, OPS and Student Positions
• Faculty Positions
• Position and Job Actions
• Distributions and Pay
• Reporting Time
• Using Leave
• Approving Time and Leave
• Workflow

Within the training section there are also some really good Project Presentations. Highlights are as follows: -

• An Introduction to ERP and the Changing Landscape at UF
• Project Management, IT and ERP - Mike Conlon, Director of Data Infrastructure
• Entering Time Worked and Leave in PeopleSoft HRMS - A Time & Labor Overview
• ERP at the University of Florida - Mike Conlon, Director of Data Infrastructure

Thursday, August 26, 2004

Value sets and input values

The configuration for input values is enriched with value sets. Some tests revealed the power and the actual limitations on FP G.

The first value set I created was one with table validation. It worked right away. Also the value set feature to show a description, but to store an id, worked fine. Additional columns with descriptions in the value set definition, although, were not shown in the element entry screen and the BEE screen.

The element entry values API doesn’t check against the value set validation.

More complex value sets (eg: referencing each other via :$FLEX$.) were not accepted as valid value sets within the input value screen.

Even when not all value set features are operational at the moment at input value level, this functionality is very useful to present the end user an dynamic list of values.

Tuesday, August 24, 2004

Oracle Partner Feature - IT Convergence

This post contains a review of the IT Convergence web site and highlights some useful downloads they have.

I recently came across the IT Convergence web site where they have some useful white papers to download. IT Convergence is an Oracle Partner and according to their site: -

IT Convergence is an e-Business consulting firm. We provide an entire range of services from initial business analysis and project planning, to full suite implementation and staff augmentation. We offer complete solutions for the implementation, upgrade, or customization of Enterprise Resource Planning systems. To help you manage the entire applications lifecycle, IT Convergence offers customized training for every skill level—given on-site, in a classroom, or remotely via the Internet. Our remote support services can assist your company with all types of technical and functional needs.

We put intensive effort in selecting only the best consultants to deliver superior services. We support the development of their skills through training and special courses, enabling consistent performance on the job. Our people bring years of experience working for top companies in numerous industries, including Finance, Manufacturing, Pharmaceuticals, Higher Education, Government, Telecommunications, and Semiconductor.

The company has it’s headquarters in California and has offices in the following locations worldwide: -

• Madison, USA
• New York, USA
• Chicago, USA
• Mexico
• Singapore
• Philippines
• Buenos Aires, Argentina
• London, UK
• Shanghai, China

Highlights of Oracle white papers you can download from this site are as follows: -

• Accounts Payable Reports for: -


• Accountings & Postings (497KB) - Ruthe Grigsby, Oracle Functional Financials Consultant
• Income Tax Forms (741KB) - Ruthe Grigsby, Oracle Functional Financials Consultant
• Invoices (1.62MB) - Ruthe Grigsby, Oracle Functional Financials Consultant
• Invoice Taxes (234KB) - Ruthe Grigsby, Oracle Functional Financials Consultant
• Key Indicators (841KB) - Ruthe Grigsby, Oracle Functional Financials Consultant
• Suppliers (435KB) - Ruthe Grigsby, Oracle Functional Financials Consultant
• Internet Time Overview (1.20MB) - Ruthe Grigsby, Oracle Functional Financials Consultant
• Going beyond Oracle HRMS (555KB) - Gil Aguirre, Oracle Consultant
• Achieving Business Improvement with Oracle Applications (246KB) - Thomas Owens, Practice Manager
• Complying with Sarbanes-Oxley Act of 2002 (45KB)
• Key Success Factors When Managing an Oracle Applications Implementation (235KB) - Diego Antozzi
• Challenges of Implementing Human Resources in Latin America (159KB) - Cesar Ortiz (Spanish version also available)
• Challenges of Implementing Financials in Latin America (93KB) - Ignacio Diez Martinez O’Cadiz (Spanish version also available)
• Oracle Collaboration Suite: Analysis and Recommendations (109KB) - Jesse Grittner
• Embarking on a Configure to Order Journey (183KB) - Oscar Villalvazo, Senior Principal Consultant
• Business Process Outsourcing: Risks and Rewards (108KB) - Jesse Grittner
• Handling Requisitions without Order Management (94KB) - Nagesh Kelkar, Principal Consultant
• Implementing Oracle Applications in Brazil (197KB) - Jussara Oliveira (Portuguese version also available)
• Choosing a Hosting Provider: Suggestions and Solutions (150KB) - Jesse Grittner
• Considerations for Oracle Implementations in China (103KB) - Peter Lai

You can also download a presentation they delivered at an Outsourcing SIG meeting held at Appsworld in January 2004 entitled Choosing a Hosting Provider - Suggestions and Solutions (269KB) by Oscar Villalvazo, ISS Practice Manager.

Monday, August 23, 2004

ExpressionEngine Rocks!

This post contains details of my recent upgrade to ExpressionEngine v1.1 and contains the reasons why I decided to go with EE as my blogging software.

I’ve just successfully completed my upgrade to ExpressionEngine (EE) v.1.1 which went really smoothly. From the front end readers won’t notice much difference but those who are authors will notice quite a few changes in the back end. I’ve also recently added to the site a plugin which allows readers to use HTML tags in their comments.

I have to say that I really like the EE product and believe it is the best available blogging software available right now. I was recently asked why I chose to go with EE as opposed to Moveable Type or other types of blogging software available. Very simply put, in my mind EE is the best blogging software available right now for running the type of blog that I have established - below I’ve provided the background as to how I made this decision.

Background to the establishment of OracleAppsBlog

My first effort at developing an online web presence was my home page at richardbyrom.com. Having established this site and after monitoring my log files for quite some time I realised that I was not getting as much traffic as I expected. A bit of investigation in to how I could increase my traffic and exposure on the Internet made it clear to me that I was going to have to produce good content and update that content on a regular basis. At this point in time my home page was really what we in the IT industry call brochureware i.e. it just had a bit of information about me, some good links and various white papers, articles and presentations but wasn’t really interactive in any way. I then came across Mark Rittmans site and realised that I could do something similar with an Oracle Applications orientation.

I decided that if I was going to do the blog thing that I would do it properly so I bought a few books on blogging and investigated all the possible software packages I could use. Initially I wanted to integrate the blog into my home page but then decided to have a dedicated site for it. My investigations as to what types of software I should use led me to believe that there were really only two software packages worth considering, namely Moveable Type and pMachine. One of the other things I decided when I started up the blog is that I would purchase the best software available no matter what the cost (within reason). I’ve always believed in purchasing quality products even if you have to pay a bit more. Hence, I purchased both Moveable Type and pMachine’s big brother ExpressionEngine as by this stage I was wanting to establish two blogs, one for my Oracle Applications work and another one related to web design. My intention was to use ExpressionEngine for OracleAppsBlog and Moveable Type for WebDesignBlog. Firstly, I established OracleAppsBlog and have to say that the site has taken off quite well. At this point in time I have 159 members and in the last month my daily statistical averages were 3850 hits, 3387 page views and 412 visitors. About a month after establishing OracleAppsBlog I started up WebDesignBlog and wanted to use Moveable Type for this. After struggling to get it set up (ExpressionEngine set up was much easier) I finally managed to get the site operational. After playing around with Moveable Type and looking at it’s features for about a day I decided to bin it (US$150 down the drain) and use ExpressionEngine to set up the site (went and bought another EE license). My primary reasons for doing this were as follows. Firstly, Moveable Types capability to act as a community oriented blog seemed to be very limited when compared to EE. With both of my blogs I wanted to have other people participating as authors and also to be able to join as members and correspond with each other. Secondly, the category management features in Moveable Type again did not match up with those of EE. For both of my blogs I wanted to have a number of different categories and to have the capability to create parent and child relationships between the categories. i.e. have main categories and sub categories within the main categories. EE provides you with the ability to create an unlimited number of levels of categories, otherwise referred to as nested category trees. Thirdly, Moveable Type provided very limited blacklist features. EE allows you to blacklist by URL, portions of a URL, IP address or User Agent whereas Moveable Type only allows you to block an IP.

Lastly and perhaps most important, I paid the same price for Moveable Type and ExpressionEngine and my perception was that for what I was paying ExpressionEngine provided a lot more features and hence gave me much better value for money. I recently read a much more detailed and comprehensive comparison of pMachine and Moveable Type at this site. The authors findings correspond to most of what I have said here although he takes a more holistic view than I have. The only problem I have ever had with ExpressionEngine was paying for it as they use PayPal which is not supported here in Africa and doesn’t seem to be supported in any "developing" or third world nations. However, they do offer alternative means of payment and you can always make an arrangement with them to use these.

Running this blog has been most enjoyable and I have found it is a very effective way to consolidate my existing knowledge gained in the years I’ve been an IT consultant. It’s been said that to learn you must teach and certainly this is what happens when you blog. Having established OracleAppsBlog and seeing it take off so well has made me wish that I had started something like this years ago (whether is was offline or online). If you are a professional in any industry I believe it’s imperative to document what you are learning at each stage of your career lifecycle. It’s particularly important to document problems encountered and how these were resolved as this will not only help you but also other people. Obviously, writing about your own personal experiences and learnings is also beneficial - that’s one of my future project’s!

Sunday, August 22, 2004

Export data directly to Excel by configuring the MIME Type Profile Option

This post outlines how to export your Oracle Applications data directly to Excel by configuring a profile option.

Typically when choosing to export the results of a query or search in Oracle you will choose the File > Export option on the Oracle Applications menu. The data you desire to be exported will by default be exported as a tsv (tab separated values) file which can easily be read using notepad or wordpad. Should you wish to, this file can also easily be imported into Excel by opening the file from within Microsoft Excel and simply clicking Finish when the text import wizard appears.

On a couple of Oracle Applications systems that I worked on I noticed that choosing the File > Export was exporting the results directly to an Excel spreadsheet embedded within a browser. This can often be a better route to take than exporting into a tsv file and then importing into Excel. Subsequent investigation as to why various systems I worked on behaved differently when executing file export revealed that this behaviour is largely controlled by the MIME Type profile option and the parameters that are specified herein.

At this point I believe it’s appropriate to define what MIME is so that readers can understand exactly what they are doing when configuring this profile option. According to Webopedia.com the definition of MIME is as follows: -

Short for Multipurpose Internet Mail Extensions, a specification for formatting non-ASCII messages so that they can be sent over the Internet. Many e-mail clients now support MIME, which enables them to send and receive graphics, audio, and video files via the Internet mail system. In addition, MIME supports messages in character sets other than ASCII. In addition to e-mail applications, Web browsers also support various MIME types. This enables the browser to display or output files that are not in HTML format.

Essentially MIME ensures that there is an association between a non-ASCII file and the application that is needed to read it. In our particular instance, within the MIME Type profile option we need to specify a parameter that will tell our default browser to open the file in Excel, Word or another application you would like to see the results in. By default the MIME type profile option has the following parameter: text/tab-separated-values. Changing this value to application/excel or application/winword will result in any export of query results in Oracle being sent directly to Excel or Word respectively. The value of the second portion of this parameter (in this instance excel or winword) depends on what command you need to execute in Windows to run either of these applications. You can determine this by looking at what command you run to open an XLS (Excel) file or DOC (Word) file in Windows. In Windows Explorer, on the file menu, choose Tools > Folder Options > File Types Tab, select the DOC or XLS extension and then click on Advanced. Following on from this, click on the Open Action and then select Edit...The name of the command to run the application associated with this file type will be specified in the Application: box.

As a final test as to whether you have determined the correct command that needs to be used to run Excel or Word, from the Windows Start button choose Run and then type in the command (in this intance excel or winword) and click OK. Your Word or Excel application should run.

Friday, August 20, 2004

The Strategic Enterprise Planning Solution (STEPS) at the University of Alabama

This post contains a review of the the Strategic Enterprise Planning Solution (STEPS) site which documents an Oracle ERP implementation undertaken at the University of Alabama.

I was rather pleased to stumble across the Strategic Planning and Enterprise Solutions (STEPS) site at the University of Alabama (UAB) the other day. It has loads of documentation and information pertaining to an implementation they are undergoing in the areas of Oracle Financials and Human Resource Management System (HRMS).

According to their site: -

UAB’s vision for a new administrative computing system at UAB has reached a major milestone with the implementation of Oracle Human Resources (HR) applications on January 20, 2004. The Finance implementation has been delayed to October 2004. By exploring these pages, you will gain knowledge about the STEPS Project and the new Oracle system.

Oracle HR

According to this section of the site: -

A suite of Oracle HR modules are being implemented for the management of all UAB personnel. The advantage of the new system is the creation of an integrated information environment, and improvement in the quality of human resources data, thereby providing better HR services to individuals.

Data currently viewed in the Human Resource System (HURS) will be found using the ACT form (screen) in Oracle. Several paper processes will be replaced with new electronic processes, such as new hire appointments, salary reclassifications, and effort reporting.

Specific features of the new system include a web-based self-service environment for all employees and an electronic administrative processing environment for staff to conduct day-to-day business. Also, seven-digit employee numbers will replace social security numbers as a means of identifying UAB employees.

HR modules to be implemented as part of the STEPS project are:

• Core Human Resources Management
• Advanced Benefits
• Payroll and Time and Labor
• Labor Distribution and Effort Reporting

This area of the site also discusses self service and you can download a copy of the new HR Organizational Hierarchy codes.

Oracle Finance

According to this section of the site: -

UAB is preparing to replace its existing financial accounting system (EFS) with the Oracle Financials suite of applications to create an integrated information environment that is web based and flexible to handle future growth. With the implementation of the Oracle system, UAB will have a new Oracle General Ledger accounting structure and a new Oracle Grants accounting structure.

Data currently viewed in FAS will be found in Oracle and transactions currently processed using EFS will be processed using Oracle. What are currently called “account numbers” in FAS will be referred to as “account strings” in Oracle and the format of these account strings differs from the current account numbers. Prior to implementation, a “cross-walk table” will be provided matching FAS account numbers to Oracle account strings where possible. Also, the object codes will change from a four-digit to a seven-digit number. The new Oracle object codes can be viewed from this site.

Finance modules to implemented as part of the STEPS project are:

• General Ledger
• Purchasing
• Accounts Payable
• Grants/Plant Accounting
• Accounts Receivable (for Sponsored Projects only)

This section of the site has a variety of documents and presentations you can download that relate to the new Oracle General Ledger accounting structure and Oracle Grants accounting structure. Briefly stated, the new chart of accounts will contain six segments as follows: -

• Account - Identifies primary activity for which money is being spent (7 digits) 
• SubAccount - An account can be broken down to track one or more activities, tasks, time periods, or allocations (3 digits)
• Balancing - Indicates the level at which UAB chooses to carry a balance sheet, whether for internal or external purposes (9 digits)
• Organization - Identifies the organizational unit with which has primary fiscal responsibility for the Account String (9 digits)
• Future - Reserved to meet future requirements (4 digits)
• Object Code - Categorizes the nature of the dollars as a specific type of revenue, expense, asset, etc. (7 digits)

The new Grants Accounting segment structure is as follows: -

• Project – The work performed (6 digits)
• Task – Further breakdown of work performed under project (5 digits)
• Award – Funding source (7 digits)
• Organization – Type of string, and University vs Hospital (2 digits)
• Expenditure Type – Similar to GL Object Code (7 numeric digits plus description - 30 maximum segment length)

Oracle Training

Under this section of the site you will find course descriptions, online course manuals and online simulation courses (training videos). Online course manuals are available for the following modules: -

• Finance
• Navigation
• ACT (Appoint, Change and Terminate)
• TEL(Time, Entry and Labour)
• Self Service

The online simulations are quite good for those who are just starting to earn Oracle Applications. The following simulations are available: -

• Oracle Navigation
• Human Resources


• Appoint, Change, Terminate (ACT)
• Workflow Approvals
• View HR Data
• TEL (Time, Entry and Labour)
• Self Service

End User Readiness

Here you will find the specifications for a Desktop PC which needs to run Oracle Applications. There is also a Go-Live Checklist which is designed to ensure that users are prepared for utilising Oracle Applications.

Oracle Access

Here you will find a listing of End User responsibilities for Oracle HRMS at the University. For each responsibility a summary of access areas is documented. If a user does not have access to the system the appropriate forms are made available to apply for access.

Oracle Workflow

Here you will find a workflow presentation given at a STEPS workflow officer meeting.

Lastly, you should also consider visiting the Universities IT department.

OracleAppsBlog Site Maintenance - Upgrading to ExpressionEngine v1.1

This post contains details of scheduled downtime on OracleAppsBlog to perform an upgrade to ExpressionEngine v1.1.

I will be taking this site down for scheduled maintenance and an upgrade to ExpressionEngine v1.1 (presently I’m using the first release v1.0) on Sunday 22nd August at 2pm GMT. The site should be down for a maximum of 1 hour since I understand the upgrade is fairly easy to perform. I’m excited about this update as there are over 70 new features and enhancements in the new release and I hope this will provide readers with a richer blogging experience. You can see a list of the new features introduced in ExpressionEngine v1.1 here on the pMachine web site.

Thursday, August 19, 2004

Oracle ERP implementation - the Douglas Omaha Enterprise Resource System (DOERS)

This post contains a review of the Douglas Omaha Enterprise Resource System (DOERS) site and highlights useful documentation which can be downloaded. 

Last week I came across a really good site documenting an Oracle ERP implementation at the City of Omaha which has been named the Douglas Omaha Enterprise Resource Systems (DOERS). According to their site and related documentation: -

The City of Omaha, Douglas County, and the Omaha Douglas Public Building Commission are participants in a joint implementation of Oracle HRMS application suite, a project called DOERS (Douglas Omaha Enterprise Resource System). The DOERS project is a phased implementation and Oracle HRMS is Phase 3 of the total project.Phase 2, which includes Inventory, Grants Management, Projects and Public Sector Budgeting, began in early 2002. Phase 1, involving the Oracle Core Financials, began in early 2001 and includes General Ledger, Receivables, Payables, Fixed Assets, Cash Management, Purchasing and iProcurement.

Following is a summary and analysis of key areas of the site: -

HRMS

According to this section of the site: -

The City/County DOERS project continues building an Oracle Solution to integrate HR, Payroll, and Benefit functions with the new Oracle Financial modules. This initiative falls under the DOERS project umbrella specifically called Phase 3. This Phase of the Oracle implementation also named HRMS for Oracle’s Human Resource Management System has been made significant progress. Douglas County and the Omaha Building Commission went live on version 11.5.5 in January of 2004. Due to the complexity of this phase and limited resource availability the Go Live date for the City has been pushed back.

Here you will find two very good documents to download, namely the RD.020 documents for Human Resources and Benefits. The RD.020 Current Business Requirements is an Oracle AIM (Applications Implementation Methodology) document which is designed to identify and document current business processes and requirements. This document often incorporates a questionairre and is completed during the Definition phase of a project.

Inquiry and Reports

Contains business forms, chart of accounts and end user documentation and training material for Accounts Receivable, Accounts Payable and General Ledger.

Chart of Accounts

Here you can download the latest Chart of Accounts which is structured according to the following segments: -

• Funds
• Orgs
• Activities
• Assets
• Liabilities
• Fund Balance
• Expense
• Revenues

Current Practices

Here you will find the RD.020 documents for the various modules implemented in each phase of the project.

Future Processes

Contains the RD.030 documents for the following future processes: -

• Payables
• Purchasing
• General Ledger
• Fixed Assets
• Accounts Receivable
• Grants and Projects

The RD.030 document is an Oracle AIM document which is used to establish a process and mapping summary for your organisation. It is normally completed within the Operations Analysis phase of the project lifecycle. In this task, you create the repository for key project findings and decisions that occur during the process and functional requirements gathering activities. 

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: -

• Empower your Revenue Collection team using Oracle Receivables and External Payment Agencies - Brad Sayer, Principal Consultant, Asparona Ltd
• Upgrading to 11.5.9 - Sven Brabyn (Oracle DBA) and Lynne O’Donoghue (Financial Systems Manager), University of Canterbury
• Implementing iProcurement - The Real Story - Irene Griffith, Consultant, Asparona Ltd
• Are They Still Not Paying? Open their Cheque Books with Oracle Collections - Angela Chin and Greg Fookes, CGNZ Limited
• B2B Integration using Oracle XML Gateway - David Taylor, Co-Founder and Director, Asparona Ltd
• Streamlining the Procurement Pricing Process - Paul Willyams, Senior Manager, Deloitte
• SQL for End Users - Jeannie Dobney, Edu Source Pty Ltd
• Realising Supply Chain Benefits - Dr Geoff Cammell, Principal Consultant, Mi Services Group
• An Introduction to the Invoice Approval Workflow - Jeannie Dobney, Edu Source Pty Ltd
• Advanced Pricing Experiences - Frank Rossiter, Senior Consultant, Mi Services and Graham Perkinson, Business Systems Manager, Sellagence Ltd
• Working Effectively with Support & Using MetaLink - Dorothy Culpeper, Manager - Customer Care NZ, Oracle New Zealand Ltd
• Using Oracle Financial Analyzer to make budgeting easier - Sonia Emerson, Retail Accountant, The Warehouse Limited and Maman Baboe, Consultant, Asparona Limited
• Archiving and Accessing Oracle Financials Information - Diane Turner, Technical Architect and Sales Executive, ASSIST Pty Ltd
• 11i Integration - The Golden Rules - Helen Bucksey, Senior Consultant, Mi Services Group
• Reporting Options for Oracle Applications - Diane Turner, Technical Architect and Sales Executive, ASSIST Pty Ltd

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

Wednesday, August 18, 2004

Find an Oracle Partner using the PartnerNetwork’s Solutions Catalog

This post outlines how you can find and contact an Oracle Partner using the Oracle PartnerNetwork’s Solutions Catalog.

If you are looking for an Oracle Job or you are a prospective implementor of any Oracle Software, the Oracle PartnerNetwork’s Solutions Catalogue will provide you with easy access to information relating to Oracle Partners as well as their contact details. According to this site,

The Oracle PartnerNetwork’s Solutions Catalog is your gateway to Oracle Partner products and services worldwide. You will find that many of the world’s premier hardware, software, system integration, and services vendors are Oracle Partners.

There are 3 ways you can perform a search using this site. Firstly, you can perform a simple search which will return a maximum of 200 results. Secondly you can perform an advanced which will allow you to find Partner solutions by: -

• Keyword
• Partner Name
• Solution Name
• Membership Levels


• Certified Advantage Partner
• Certified Partner
• Member Partner
• Partner Categories


• Association
• Content Provider
• Education Provider
• Hardware and Infrastructure Vendor
• Independent Software Vendor (ISV)
• System Integrator
• Value Added Distributor (VAD)
• Value Added Reseller (VAR)
• Other
• Solution Availability (by country or region)
• Industries
• Oracle Products
• Database Versions
• Operating Systems

Lastly, you can Browse the solutions Catalog by the following categories: -

• Applications - Business
• Applications - Industry Specific
• Services - Consulting, Development and Integration
• Tools - Application and Web Development
• Tools - Infrastructure and Systems Management

If you are an Oracle Partner and have your login information handy, you can also update your profile from this site so that anyone trying to find you will be given relevant and up to date information about you or your organisation.

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: -

Whitepapers

• Tracking your assets
• Help yourself with Oracle Service
• Reporting in 11i
• Hunt Down and Harness those Upgrade Project Risks
• Multiple Organisations in Oracle Applications
• What is a Portal?
• The art of supporting Oracle Applications
• Practical Applications of Folder Tools and Report eXchange
• How iProcurement Stands Out From Oracle Purchasing
• From Simple Spreadsheets to Project Costing 11i, Vodafone Wins
• Two Roads to 11i - Upgrade Versus Re-implementation

Articles

• Archiving and Purging (You know you need to)
• Customer Spotlight – Australian Hearing
• Mass Maintenance
• Ten Quick Tips for your Upgrade
• Investment Value Assessment (IVA)

Presentations

• Portal Presentation
• Workflow in action- Oracle Purchasing
• GST and Oracle Applications
• GST BAS

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.