A day in the life of an Oracle Applications Consultant


Tuesday, July 13, 2004

New Oracle Process Manufacturing, Discrete Manufacturing and Enterprise Asset Management Contributor

This post contains details of a new author who has joined OracleAppsBlog and will be blogging under the Process Manufacturing, Discrete Manufacturing and Enterprise Asset Management Categories

Lokesh Tayal who is working as the Head of an Oracle Applications Group in one of the largest corporate houses in Dubai, is joining OracleAppsBlog. He will be blogging under the categories of Process Manufacturing, Discrete Manufacturing and Enterprise Asset Management. Lokesh and his team are implementing Oracle E-Business suite in nine group companies. Previously, he has worked with one of the largest Oracle Apps practices in the Asia Pacific.

Lokesh has rich experience in Oracle Enterprise Asset Management (eAM), Oracle Process Manufacturing (OPM), Discrete Manufacturing, Supply Chain and Project Management and has been working with Oracle Apps for the last seven years. He has been focusing on Oracle eAM for the past two years. Lokesh is a member of the Oracle eAM Customer Advisory Board and actively participates in defining this products future enhancements. He has implemented Oracle Apps in the Telecoms, Airline, Fast Moving Consumer Goods (FMCG), Real Estate, Metal and Plastic Manufacturing Sectors. You can read Lokeshes membership profile here or if you’re a member you can e-mail Lokesh via the profile e-mail console.

I wanted to welcome Lokesh to the Blog and introduce him to all the other members. I am sure his experience will add some interesting and useful content to the blog.

Friday, July 09, 2004

DataLoad - a tool to facilitate system data migration

This post discusses the DataLoad Software - a tool that will assist you in application data migration.

In the early days of my present occupation, namely Oracle ERP Consultant, I was introduced to the DataLoad utility. I can’t remember who introduced me to the tool but I owe them a big thankyou. I have subsequently used it on every single implementation I have been involved in for the past 3 years and am sure I will continue to make use of it in the future. I was able to learn DataLoad incredibly quickly as it is very easy to use. In a former life I was a BaaN consultant, I only wish I had been introduced to this product then as DataLoad can work on any application that accepts inputs from a keyboard or mouse. DataLoad comes in two versions, namely Classic and Professional. Up until now I’ve managed to get by using the Classic version which is free but on my most recent implementation we had some fairly heavy duty data loads to perform and so decided to buy Professional. The differences between the two version are outlined on the DataLoad site. According to the DataLoad site: -

“DataLoad loads data into any application running in Windows, and contains extra functionality for loading data and setup into Oracle Applications.

DataLoad loads data through the forms. This means the data is indistinguishable from that entered by users. To load data using DataLoad you setup DataLoad to load into the forms and the forms load the data into your system. This non-technical approach means the load can be built and run by non-technical users, and by not having to write conventional interfaces into the database a huge amount of time and money can be saved”.

Essentially there are two types of data that one needs to think about when it comes to Enterprise Applications - master data and transactional data. Examples of Master Data are Customer or Supplier information whilst transactional data might consist of sales or purchase invoices. In the instance of Oracle Applications a further data type (which is essentially master data) can be outlined, namely Application Object Library (AOL) or Setup Data such as profile options and flexfield definitions.

Loading data of any type into your application from DataLoad Classic is a three step process: -

1. Obtain your data in Electronic Format (e.g text file, excel file)

2. Copy or Import the data into a DataLoad template.

3. Load the data in to your application from the DataLoad template.

The key to success is designing your DataLoad template in ways that ensures a smooth load of your data. The DataLoad template will be used to load your data by simulating the keystrokes and mouse clicks that you would normally use to capture the data manually. An example of what a DataLoad template looks like is as follows: -

DataLoad Template Example (for loading the Accounting Calendar)

An example of a DataLoad Template for loading the Accounting Calendar

For Oracle Applications users, Pre-Built Spreadsheets or templates can be downloaded from the DataLoad web site for each module - the obvious benefit here is you will save time by not having to build your own templates. The pre-built templates can also be edited and I find it best to start out with a pre-built template and modify it, rather than building a template from scratch.

Obviously DataLoad is not the only way to migrate or load data into your applications. Each alternative means of data migration should be carefully considered and the pros and cons established (the Accenture presentation mentioned below provides a good comparison of the alternatives). Where necessary a cost benefit analysis may need to be prepared.

Related Presentations

The following presentations will provide you with further information on DataLoad: -

Data Migration in Oracle E-Business Suite (679KB) by Trond Steensnaes of Accenture at an OAUG Forum Meeting in Paris.

Thursday, July 08, 2004

The Financial Systems Project (FSP) - an Oracle Implementation and Upgrade

This post contains details of a Financials Systems Implementation and Upgrade that was undertaken at the University of Waterloo and contains links to the associated documentation.

The University of Waterloo undertook an Oracle Applications R10.5 Implementation in 1996 and Upgraded to R10.7 in1998. Although the implementation and upgrade was carried out some time ago I thought that the documentation provided on their site would still be useful to any potential implementors of Oracle Applications. According to their site: -

The May 1996 implementation of the Financial Systems Project (FSP) was motivated by the realization that UW’s Computer-based central accounting systems had many limitations and inefficiencies. Its mission has been: “To conduct a comprehensive review of financial processes leading to the development of an integrated, effective and efficient system for managing the financial affairs of the University”.

The December 1998 upgrade of the Financial System was motivated by the need to achieve year 2000 compliance within the application software.

The Financial System Project consists of the implementation of Oracle Government Financials (General Ledger, Accounts Payable and Purchasing modules) from ORACLE Corporation plus the custom extensions written to accomodate interfaces with other systems used on campus.

The Financial Systems Project site contains the following types of documentation: -

  • Upgrade Project Summary
  • Project Team Structure and Membership
  • Architectural Diagram
  • Information Security Policy and Standards
  • ORACLE Government Financials Security
  • Technical and Functional Documentation

Of particular interest to those involved in Chart of Accounts design will be the Accounting Flexfield Values portion of the site. Here the Chart of Accounts segments structure and associated values that populate the structure is outlined.

The Applications Technology “department” of the University should also be looked at. According to the site: -

“Applications Technology is responsible for the application software supporting the University’s information systems. This responsibility encompasses all aspects of the System Development Life Cycle; including business process and system analysis, design, acquisition, development, implementation, documentation, and ongoing maintenance. In particular, this includes responsibility for designing and evolving the corporate database. As systems move into production, this group cooperates with Client Services and Electronic Workplace to train users and provide them with access to systems, and with Production Support to commission systems and provide second-level support to ongoing production”.

On the Applications Technology site you will find details of ongoing projects at the University in the areas of Co-operative Education & Career Services (CECS), Financial Systems, Human Resources, Strategic Consulting and Student Information Systems.

I’m interested to know whether the University has upgraded to 11i. I’ve fired a mail their way to find this out and will update this post with any further information or documentation I obtain.

Wednesday, July 07, 2004

Oracle Applications User Group (OAUG) Connection Point 2004 Conference Sessions now available

This post contains details of what sessions will be taking place at the OAUG Connection Point 2004 Conference in Orlando, Florida

The OAUG has just released a listing of the training sessions, presentations and panel sessions that will be delivered at Connection Point 2004. According to the OAUG: -

“This year’s event schedule has been revised to afford you more advocacy, educational and networking opportunities! Don’t miss your opportunity to:

  • EXPERIENCE over 200 sessions, including presentations, Q & As, Panels, Workshops and training sessions.
  • DISCOVER complementary vendor products and services in the Exhibit Hall.
  • EXAMINE Applications and solutions in the Hands-on Demo Area.
  • INTERACT with Special Interest and Geographic User Group members.
  • OBTAIN CPE Credits for Financial and Human Resource track sessions”.

If you plan to attend the conference or are just interested in what topics are spoken on at the conference then read more on the sessions here.

Oracle Applications Newsletters

This post contains details of the various Oracle Applications Newsletters that can be downloaded.

Solution Beacon - an Oracle Partner in America has a really good quarterly newsletter which will keep you up to date with all the latest developments in 11i E-Business Suite. Download it here

Assist - an Oracle Partner in Australia has a number of quarterly newsletters that can be downloaded here. Unfortunately these don’t seem to have been updated since 2002, however, the newsletters going back to 1999 still have some interesting and useful information.

A variety of regular E-newsletters can be subscribed to at ITtoolbox and

If any readers know of any other good newsletters that have an Applications or Functional focus please send me a mail or add a comment to this post.

Page 43 of 48 pages ‹ First  < 41 42 43 44 45 >  Last ›