OracleAppsBlog

Tuesday, May 12, 2009

SURVEY - Reporting from Oracle E-Business Suite

Reporting from Oracle EBS is an important and current issue, so it would be great if you can share your views on what’s good and bad and any tips via the survey that Simon Tomey has set up.

Simon’s going to the UKOUG EBS Financials SIG in May to help with a workshop on this, so it would be tremendous to get your views, so we can have a discussion with some bite.  Moreover I think we will all find the results of interest. If you’re not currently working with an organisation, please complete the survey from the perspective of the organisation that you last worked for. 

Take part in the Oracle E-Business Suite Reporting Survey

The results of the survey will be published on this blog.

Saturday, August 23, 2008

Batch Invoice Uploads into Oracle Payables

MS Excel to load invoice batches to Oracle Payables! Even Oracle ADI doesn’t do that, in fact few 3rd-party products do. What to do? Do as Kevin Ellis has done, develop your own in-house invoice batch interface. And if that isn’t enough to pique your interest, how about an interface for keeping your chart of accounts current between production legacy and Oracle systems? He has done that too and he has shared all in this comprehensive ORAtips cover story, discussing custom concurrent program and UNIX shell script development, Oracle Applications set-up and end-user considerations. 

Download White Paper on Invoice Uploads into Oracle Payables

This article was originally published by Klee Associates, Inc., publishers of JDEtips and SAPtips. For training, consulting, and articles on JD Edwards or SAP, please visit their websites: www.JDEtips.com and www.SAPtips.com.

Friday, August 15, 2008

Introduction to Oracle User Productivity Kit (UPK)

Oracle’s User Productivity Kit is perhaps one of the less well known of the Software Products on the price list, however just a brief consideration of its name indicates that it may be of considerable value to organisations. We invest significant money and resources in the purchase and implementation of software applications but do we realise, in practice, the levels of productivity that we would like to have and that will bring the full return on our investment? 

Information from the industry analysts tells us that most of the problems relating to application implementations are, in fact, user related. Butler Group recently reported that 70 percent of CRM implementations fail, and a Gartner study also found that approximately 55 percent of all CRM projects fail to meet software customers’ expectations. 

In his article on why CRM projects fail, Rajiv Chaudhry, a leading analyst, quotes: “You can design the best process in the world, and back it with the latest and greatest technology, but if your people don’t buy into the project, it won’t work.”

User acceptance isn’t the only problem affecting project success; there is also the very basic problem of user competence to use and get the best out of the system. According to Meta Group, 76% of Users have a failing or substandard understanding of new systems software. 

Well here is UPK, something that claims to be a productivity kit for our users. Does it do what it says on the tin? Will it help us address these user productivity issues? If so, it is something that we should give attention to? Let’s open the kit and see what is inside and how it can help us. 

UPK is a software tool that can capture all the steps in a system process. It records every keystroke, every click of the mouse, each menu option chosen and each button pressed. All this is done in the UPK Recorder by going through the transaction and pressing “printscreen” after every user action. From this, without any further effort from the developer, UPK builds a number of valuable outputs. 

The most significant of these is the UPK Player Package. This is an HTML based simulation of the application process that operates in 4 modes. 

See-It Mode is an automated simulation of the process that can act as a demonstration of the system. It is valuable in the change and communication activity, to demonstrate the system. Usually the final system is not available and access to it is not practical at roadshows and other events. The See-It mode simulation can be played from a USB stick on any laptop with Internet Explorer running. It can therefore be easily taken on the road to demonstrate the system in its most favourable light. 

Because UPK uses a discrete recorder, it only captures the intended and necessary user actions and therefore can play back the transaction with absolute precision and no user errors, mouse jitters or other extraneous elements that can detract from the demonstration. Presenting the application in a clear and uncomplicated way, in a demonstration that can be repeated with absolute certainty every time, is important to the users first view of the new system. You do not get a second chance to make a first impression.

Try-It Mode is also a simulation of the application, but this time the user must interact with the simulation, completing all the actions required rather than watching it run unattended. This mode is most valuable in training; in the classroom or in a self-service learning context. Try-It Mode guides the users through the process, telling them what action to take and highlighting the area on screen where the action is to be performed, at every step through the transaction. 

Using Try-It Mode is of great benefit for training, as the same exercise can be trained over and over without the risk of altering the data in the system and causing subsequent operations to fail. It can make the classroom training much more efficient, as when the users are doing the exercises the system is helping them with guidance, freeing the instructor and making the whole exercise more efficient. In addition, it is not necessary to cover every transaction that the user will need during the classroom course, as once users have become familiar with the concept of using UPK for learning, they will be happy to learn further transactions on their own. 

One of the difficulties with large training rollouts is that there may be a time gap between the classroom training session and the users’ first time to use the processes after go-live. When UPK is readily available on the system, this ceases to be a problem because they can refresh their knowledge using Try-It mode in UPK. 

But how do we know if our users are really learning the system? This is where the third mode of the UPK Player Package comes in. Know-It mode allows the user to go through the process without the on screen guidance. Instead, the system tracks their actions, warning when they stray off course (the system is smart enough to allow alternative ways of navigating the system, such as using the mouse to negotiate the menus or the keyboard shortcut). If the user makes further incorrect attempts, Know-It mode will give more remediation, eventually completing the step for the user. The rub for the user is that at every incorrect action their score is reduced, potentially causing them to fail the test. 

The system has usage tracking as standard so it is possible to see which users are making use of the system, in which modes and, if they are using Know-it mode, what their scores were. 

The fourth mode of the UPK Player Package is Do-It Mode. This is for Performance Support rather than training. In this mode the user is working on the live application and UPK is hovering in the lower right of their screen, providing visual instruction, in the form of a small video simulation, and written instructions guiding them step by step as they perform their work on the live system. 

This Do-It mode performance support is instantly accessible from the application help menu or a Smart-Help button on the browser. It is context sensitive and, by recognising the screen that the user is on, will offer only the appropriate help for that step of the process. 

When users are shown Do-it Mode as part of a Change and Communication event, or in the classroom, it significantly increases confidence in their ability to use the system and, as a consequence, they are much more positive about the introduction of the new system. 

It is, of course, important to provide users with more information than just how to follow the steps of the transaction. UPK provides many facilities to include a wealth of other information in the simulations. Information and explanations can be included at every step of the process. This can be achieved by incorporating additional material or by linking to pre-existing material. For example, on an i-Expenses screen it may be useful to link to the organisation’s travel policy or to some relevant section of it. 

Incorporating this information is the work of a UPK development team. UPK content development is a skilled job where, in addition to recording the process flow, the best and most relevant support information is linked in at every step. 

From the above you can see how the UPK Player Package can improve user productivity and reduce project risk significantly, if used in an experienced and intelligent way. However, UPK does more than it says on the tin. As well as improving user productivity, it can significantly improve project team productivity. This is because all the information recorded and linked in is extremely valuable across the project lifecycle when output in other appropriate forms. 

UPK can directly output Business Process Documents, which are a specification of the transaction. These can, in many cases, be a requirement for compliance and a critical part of the system specification that is often overlooked in a busy project implementation, or created retrospectively as an after thought. 

UPK can also output Test Scripts, either to support UAT or the System testing activity. It can generate scripts ready to be input directly to HP Quality Centre. 

Finally, UPK can output Instructor manuals, student guides and quick reference cards directly from the same single recording exercise. The efficiency that can be gained across the project is obvious in terms of a single recording and development exercise supporting so many project activities. UPK could be financially justified on the generation of test scripts alone for a medium to large implementation. 

I have sought to show that UPK not only does what is promised, but in fact brings many more benefits if used early in the project, and across the project lifecycle. It addresses the most critical and often neglected areas of user acceptance and user competence. 

Like all powerful software tools, it is best used by experienced developers who know how to set up and manage a content development project and how to create good quality UPK content. 

About Larmer Brown Consulting

Thanks to Larmer Brown Consulting for allowing this article to be posted on the Blog. Larmer Brown’s primary business objective is to help organisations realise the desired business benefit from their enterprise applications, through successful User Adoption Programmes. They facilitate the Change and Communication, User Acceptance Testing, Training and Support activities. Our approach is based on Global Knowledge’s OnDemand Personal Navigator (ODPN) platform, which is also marketed under the name User Productivity Kit (UPK), by Oracle, and Computer Associates Proficiency Accelerator (CAPA), by Computer Associates. 

About the Author

Peter McClintock is Director of Services for Larmer Brown Consulting, UPK Training and Project Specialists. He has worked in the Projects, Consulting and Training business for over 20 years. He can be contacted on services@larmerbrown.com

Tags

del.icio.us: brown, consulting, HP, kit, larmer, oracle, productivity, Quality, tutor, UPK, user,
technorati: brown, consulting, HP, kit, larmer, oracle, productivity, Quality, tutor, UPK, user,

Wednesday, August 13, 2008

BI Publisher Webinar

Simon Tomey of BeLife will be running a Webinar for BI Publisher at the following dates and times: -

• Thursday 21st August 2008 @ 7:00 PM - 8:00 PM GMT - Register Here
• Thursday 28th August 2008 @ 7:00 AM - 8:00 AM GMT - Register Here

A short description of the webinar:

Oracle XML/BI publisher is possibly the richest new piece of functionality in E-business suite and certainly the easiest to implement. It means you can forget the text based reports you have been struggling with and delight your users with clean attractively formatted documents and spreadsheets.

This series of webinars will include some ‘quick wins’ and the steps to building and customising great XML output. Simon will demonstrate how to:

• implement the templates which already exist in your system
• convert GL reports to produce clean MS Excel output
• build templates to create documents and spreadsheets (such as dunning letters, customer open balance letters, remittance advices and listings). 
• include tables, logos, pictures, headers and footers, first and last page only content, and conditional statements (e.g. if..then). 
• Apply some tricks (e.g. getting different XML reports from the same output file)

The first in this series of presentations will cover the seven steps to producing a BI publisher report using a very simple example. I recommend you download the slides from Simon’s presentation. 

Audio Services will be provided for the following countries and it is essential that for this particular webinar you can access the audio services. 

• Australia
• Austria
• Belgium
• France
• Germany
• Ireland
• Italy
• Netherlands
• New Zealand
• Spain
• Switzerland
• United States

Hence when you have registered and are given the conference call number, please check to ensure that you can actually dial that number. If, for example, you live in India and would like to make use of the audio features you would have to dial in to the conference using a U.S. number. Using VOIP services such as skype for the audio is not ideal as you may experience some network latency, in most instances you will be better off using a landline or mobile to access the conference audio. 

Please also note that the webinar allows up to 25 panelists for the audio, a panelist being someone who can have a two way conversation with the presenter. Anyone who is not a panelist will only have the ability to listen to the presenter. When signing up please let me know if you would like to be a panelist. As there is a limit to the number of panelists the option to be a panelist will be awarded on a first come first served basis. 

Note: If you’re unable to attend the webinar live or cannot utilise the audio facilities (as a result of your country not being included in the list of countries above) a recording of the session will be available for subsequent download and playback.

Thursday, April 17, 2008

Integrating Financial Management with Project Management using EcoSys Financial Manager

Recently I been working with a company called Ecosys Management to learn and implement one of their products, EcoSys Financial Manager. According to their site: -

EcoSys Financial Manager (FM) is a web based enterprise project financial management system. Project financial management involves all aspects of managing and monitoring the flow of funds from the organization into discrete initiatives, programs, projects, and ongoing operations. These discrete efforts execute and should align to strategic objectives and priorities. The project financial management cycle encompasses long range planning, fiscal period budgeting, forecasting, spending requests, allocations, performance measurement, controls, closeouts, and adjustments.

Large organizations need to be agile and responsive - financial processes and workflows need to flow top down and bottom up. Finance and Accounting needs to reconcile information flowing in both directions: down from executives responsible for strategic planning and up from the people in the field who are close to the work required. 

EcoSys FM successfully bridges corporate strategic planning and project financial management for our customers in a varied range of industries. Particularly if you are looking to integrate project management with financial management, EcoSys FM is a proven solution in organizations using Primavera and other enterprise project management systems. 

If you’re interested in learning a bit more then download this EcoSys Financial Manager Presentation. If you’re potentially interested in implementing this product in your organisation then contact EcoSys

Tags

del.icio.us: ecosys, financial, management, manager , oracle, primavera, projects,
technorati: ecosys, financial, management, manager , oracle, primavera, projects,

Monday, April 14, 2008

Oracle Reports using BI Publisher

I’m currently working as an associate consultant with an organisation called BeLife Ltd. We are interested in showing organisations how they can transform their Oracle Reports using BI Publisher (formerly XML Publisher) and would like to offer a free 1 hour demonstration of this product to anyone that’s interested. 

BI Publisher is standard Oracle Financials integrated functionality, but it is only used by a few organisations. Recent feedback suggested that this is because organisations just don’t know how to start with using BI Publisher even though users are eager to experience the benefits. We’d like to show you in an hour how you can get started. 

We can show you how to use BI Publisher to generate:

• Remittance Advices
• Dunning Letters and Customer Statements
• General Ledger Reports for downloading direct to Excel, including grouping and formulae (sums, average, maximum, minimums)
• Management information reports with tables, graphs and conditional formatting.

Whether you’re a super user, end user or implementor if you’re interested in potentially using this reporting tool or know of anyone that may be interested in a demonstration please contact me at this e-mail address.

Update:This demonstration will be run as a webinar. Details of the first part of a series of BI Publisher webinars are outlined here.

Tags

del.icio.us: belife, bi, business+intelligence , oracle, publisher, xml,
technorati: belife, bi, business+intelligence , oracle, publisher, xml,

Thursday, April 03, 2008

Contractors - LinkedIn and Oracle Community Groups

I recently created an Oracle Contractors Group on LinkedIn as well as on the Oracle Community. The purpose of these groups is to create a network for contractors to talk to each other as well as discuss and refer work opportunities. If you’re interested in joining sign up to the LinkedIn group and I’ll approve your membership. To join the Oracle Community Contractors Group simply sign up to the community and add yourself to the group.  

Tags

del.icio.us: community, contractors, groups, linkedin, network, oracle, social,
technorati: community, contractors, groups, linkedin, network, oracle, social,

Oracle Community - the Social Network for Oracle People

Recently I joined the Oracle Community Social Networking site. It’s the brainchild of Eddie Awad and uses the Ning Platform. The site offers the following features and tools: -

• Blogging
• Chat
• Forums
• Gadgets
• Groups
• Photos
• Videos

Certainly there are plenty of Oracle blogs and forums around as well as social networks. What I like about this site is all of these services are offered together in one place and are integrated with each other. They’re all also totally focused on one thing - Oracle. Pay the site a visit and if you like what you see sign up and connect with myself and all the other Oracle Users within the network.

Tags

del.icio.us: community, eddie.awad, network, ning, oracle, social,
technorati: community, eddie.awad, network, ning, oracle, social,

Thursday, March 13, 2008

Oracle Financials Technical Interview Questions and Score Sheet

Over the last few years I’ve been involved in interviewing a number of Oracle Financials Consultants and have also in the past been sitting on the other side of the desk as an interviewee. The last time I conducted an interview it was more technical in nature and I decided to came up with a list of questions to ask the interviewee. These questions were focused along the lines of people, process and technology and I thought I would write a blog entry with the questions as I’m sure it will be useful for interviewers and interviewee’s alike.

In addition to the questions I also developed a score sheet utilising the Kepner Tregoe decision making methodology, an approach I learnt when doing my Masters in Business Leadership (MBL). This score sheet allows the interviewer to develop an objective means of evaluating the answers to interview questions rather than a subjective one and can be modified to suit a number of different scenarios. I haven’t included any answers to the questions as in many cases there is no right answer, I prefer to see if someone understands the concepts and can explain them well. Having said that, if any one wants to come up with a suggested answer sheet I will gladly append it to the questions listing. Hopefully this question listing and score sheet will provide readers with a baseline/guideline that can be used in any type of interview.

• Download Oracle Financials Technical Interview Questions
• Download Oracle Financials Technical Interview Score Sheet

Technology Questions

General Ledger

• Explain the organisational concepts of business group, set of books, legal entity, operating unit and inventory organization and the hierarchical structure relating to these.
• What are the three C’s in relation to a set of books? 
• Explain the difference between a key flexfield and descriptive flexfield
• What is the difference between a cross validation rule and a security rule? 
• What is a value set and what are the different types of value sets that you will find within Oracle?

Accounts Payable

• Describe the Key Configuration decisions you would need to undertake when implementing the Accounts Payable module.
• Briefly describe the Supplier Invoice to Payment process within Oracle.

Accounts Receivable

• Describe the Key Configuration decisions you would need to undertake when implementing the Accounts Receivable module.
• Briefly describe/draw the Customer Invoice to Cash process within Oracle
• Describe the Key difference in setting up accounting for Accounts Receivable and Accounts Payable
• What happens when you have a receipt in Oracle that can’t be applied to an invoice?

Fixed Assets

• Describe the key configuration decisions you would need to undertake when implementing the fixed assets module.
• Briefly describe/draw the asset additions process within Oracle.

Cash Management

• Describe the key configuration decisions you would need to undertake when implementing the cash management module.
• Outline the Statement to Reconciliation process within Oracle with particular reference to the different options you might want to consider when reconciling.

All Modules

Describe/draw the sequence of events you would undertake in closing the various financials modules.

People Questions

• Draw a typical structure relating to project implementation and describe the role each person would play within a project.
• Describe how to implement an effective training strategy within an implementation – include the timing of training relative to the project lifecycle.
• Within an implementation describe a Change Management strategy that you would put in place.

Process Questions

• Describe/draw the main phases of an implementation lifecycle and the key milestones and deliverables within each of these phases.
• Describe the key differences between a process and work instruction
• Within a project describe the different test phases that you might go through and what level of testing would be undertaken.
• Describe a typical process you would implement for managing Change Requests and Bug requests within your organization.

Tags

del.icio.us: financials, interview, kepner+tregoe, MBL, oracle, questions, technical,
technorati: financials, interview, kepner+tregoe, MBL, oracle, questions, technical,

Friday, February 22, 2008

Oracle Mix - bringing Web 2.0 to the Enterprise

Last year I attended the UKOUG 2007 which was a good opportunity to catch up on what’s happening in the Oracle World. At the Applications Keynote presentation given by Jesper Andersen I first heard about Oracle Mix, one of the initiatives Oracle has undertaken to bring Enterprises into the Web 2.0 space, a concept now dubbed Enterprise 2.0

Oracle Mix was built by Oracle AppsLab in collaboration with ThoughtWorks. I see it as one of Oracle’s first attempts at a FaceBook or MySpace equivalent for its customers, partners, developers and employees. The Oracle Mix strapline is Our Business is all about you, our Customers. Its purpose is stated as giving everyone a voice to help shape the future of Oracle together. Here’s what Oracle says you can do with Mix: -

Share Ideas.
Let us know how we can improve our products or how we do business. See an idea you like, vote on it or add your comments.
Join Groups.
Get together with others around products, industries, or more. Can’t find a group you like? Start one!
Network.
Connect with other customers and get to know Oracle experts in your product area or industry.
Get Answers.
Got a tough question, ask it. Feeling bright? Help someone and answer a question.
Share and Learn.
Learn about best practices for your product and check out new ideas being discussed by the community. Share your experiences with others through posting ideas or answering questions.

I have to say I like the way Oracle is starting to embrace Web 2.0. When I first started blogging several years ago, there were very few Oracle Bloggers around and the community was fairly fragmented and disorganised. Now it seems that with all of the collaboration and social networking tools around I’m able to interact more effectively with my Oracle peers. Apart from Oracle building effective web applications for the Oracle Community they’re also demonstrating Enterprise 2.0 leadership by building services into their applications that have Web 2.0 features and characteristics. I look forward to seeing how the community and applications grow and metamorphasise in the future.

Tags

del.icio.us: enterprise2.0, mix, oracle, web2.0,
technorati: enterprise2.0, mix, oracle, web2.0,

Wednesday, February 06, 2008

UK Oracle Apps Contractors, Consultants and Blogger Meetup in London

Next week we’re having a UK Oracle Apps Contractors, Consultants and Blogger Meetup at the Tapas Brindisa in London. If you fit into any of those categories and would be interested in coming along and meeting myself and other Oracle Apps Fans for a drink and chat then please join us at 7pm on the 13th February 2008. 

The event was initiated by Simon Tomey of BeLife and I’ll be joining in along with some of his colleagues and friends. Although its a social I’ll be there with my laptop and internet connection so we can always do some techy stuff.

If you need any further information don’t hesitate to contact me. I’ve also created an event in Yahoo’s upcoming calendar tool so that you can automatically add the details to whatever calendar software or application you are using or let us know whether you plan to attend. 

Tags

del.icio.us: apps, blogger, consultants, contractors, london, meetup, oracle, tapas.brindisa, UK, upcoming, yahoo ,
technorati: apps, blogger, consultants, contractors, london, meetup, oracle, tapas.brindisa, UK, upcoming, yahoo ,

Friday, February 01, 2008

Oracle Applications EBS on a Laptop, Desktop or Server for 11i or R12

A couple of years back I used to have my own Oracle E-Business Suite setup on a laptop, now I’m looking at doing this again but this time I want to bypass the installation and setup effort. Certainly the online 11i and R12 Vision instances that Solution Beacon provide you with are useful but having your own Oracle Applications instance allows you to play with other Oracle software like Workflow, Discoverer and Applications Desktop Integrator (ADI). It also helps in situations where you don’t have internet access. With that in mind I’ve done some investigation and discovered two independent providers of this type of service/product in the UK.  

The first provider is James Ball Consulting who provides what are called small architectures. According to his site:

Every administrator knows that the most effective way to get to grips with new technology is to sit down with the software to practice, experiment and explore. Building and experimenting with new Oracle software is something we have been doing for a long time and this series of small architectures is built from that acquired knowledge and designed to allow administrators to familiarise themselves a new system on hardware which mirrors a large production system without the associated costs.

To make the learning experience as realistic and useful as possible we keep the systems as ‘real’ as we can without introducing excessive cost and taking up valuable desk space. This is achieved by using low-cost mini-ITX hardware and commodity networking equipment to model much larger Oracle system within a small footprint. All systems run Oracle Enterprise Linux so that, for administrators running any type of Unix, tasks such as scripting, maintenance and management are kept as close to the product environment as possible. The end result is that the administrator has a system which is: small, fast, reliable and realistic at an affordable price.

Essentially James will build you a mini Server on which you can have your Oracle Apps Instance. He provides the following types of architectures and can also build according to your unique requirements:

Single Node Database Server 10g Architecture.

This system allows a DBA or Developer to have a dedicated Oracle 10g database environment on the desktop for evaluation and testing of new Oracle software. The system consists of one node built with Oracle Enterprise Linux and networking kit to attach a desktop PC or laptop.

Single Node e-Business Suite Release 12 Architecture

This system allows the Apps DBA, Developer or Functional Consultant to learn and explore new features and setup without effecting production or test environments. The system consists of single node server with fast network links for connecting a laptop or desktop.

Two Node e-Business Suite Release 12 Architecture

An extension of the single node system, this architecture allows the administrator to explore a realistic two-node installation of the Release 12 e-Business Suite and all of the associated setup. The system consists of an application server node and a database server node with networking equipment to connect the nodes and a desktop or laptop PC as illustrated below.

The second provider is Richard Fieldhouse of AppsDBA who has the following products on offer:

11i Laptop / R12 Laptop

The all new product from AppsDBA.co.uk. This product has been designed for use by the business/home user who wishes to get up to speed with the Oracle 11i or R12 e-Business Suite. This product is especially useful to new users to the Oracle e-Business Suite, and give a good platform to learn or expand your current knowledge.

11i Desktop

The beauty of the “11i Desktop” is that you can sit it at home (on the network supplied) and run the Oracle e-Business Suite from any PC or Laptop, however connected to your network (wireless etc.).

Richard also offers a Release 12 Server, R12 DIY Optionand R12 Virtual Machine (VM). He can also build Oracle EBS laptops according to your unique requirements.

Both James and Richard are providing these products/services for under £1,000 which is quite reasonable in my opinion. Having mentioned providers in the United Kingdom I’m interested to hear from readers if there are any other worldwide providers that I should give a mention. I’m sure US providers might be able to provide a cheaper product/service given the cost of hardware and labour in their country is lower than here in the UK. Please add a comment or send me an e-mail if you know of other providers that reader might be interested in knowing about.

Tags

del.icio.us: 11i, applications, desktop, ebs, laptop, oracle, R12 , server,
technorati: 11i, applications, desktop, ebs, laptop, oracle, R12 , server,

Wednesday, January 30, 2008

Oracle Financials Applications Consulting

I recently came across the Oracle Financial Applications Consulting site and thought I would give it a mention since there’s some downloads on the site which I believe would be useful to readers. The about section of the site has the following to say about the founder:

The Orafinapps was formed by Daniel North in 2005 to provide Oracle Financials consulting services and solutions. The business has recently been rebranded in order to emphasise its core skills and to provide a strong platform to attract new business and share skills, tools and experiences with others in the Oracle Financials community

Daniel is a principal level ex-Oracle UK consultant with an Accounting & Finance degree and considerable experience of large multi-country projects over the last 10 years of implementing Oracle Financials. 

He is a skilled and effective applications consultant, who brings with him a great deal of international experience, strong communication skills with the drive and enthusiasm to get results quickly. He has continually demonstrated his ability to adapt to new and challenging environments whilst maintaining consistently high standards of professionalism.

 Daniel offers services in the following areas:

• Health Checks and Audits
• Support
• Training
• Consulting

The sites Knowledge Base has a number of downloads which are categorised as follows:

Oracle Financials Implementation and User Guides

A collection of Oracle Financials related material used for implemetation and training purposes. Current sub categories include the following:

• FSG Reporting
  • FSG User Manual
  • FSG Training
  • FSG Report Writing Guidelines and Strategy
  • FSG Overview spreadsheet
  • Links to FSG SQL scripts
  • FSG Hits and Tips such as writing continental Europe style balance sheets
• Accounting for Currency - General Ledger currency information surrounding the treatment of foreign currency and the handling of revaluations and translations. 
• Country Specific Localization Guides - A collection of country specific setup documents, solution proposals and user guides.

A collection of Oracle Financials Tools

Oracle Financials Project Plans, Scope Documentations, Functional, Configuration Documents, Dataload Classic .dld files & Dataload Professional Files .fld

• Project Management Tools
• Go Live Criteria Check List Go/No Go
• Oracle Financials Consultant Interview Questions

The Largest Collection of Free Oracle Financials Scripts on the Internet

The scripts can be downloaded and used  free of charge subject to the following:

• All scripts have been written for use on Oracle R11i ( 11.5.5 to 11.5.10 ) although untested they may work on other verstions and should be run using a tool such as TOAD or similar. 
• They should be submitted with read only sql account under the APPS schema. 
• Always run scripts first on a test system after taking a full system back and only run them in a production system once you have tested and undertaken your own peer review.

Scripts are available in the following areas: -

• System Administrator SQL Scripts
• Concurrent Request Running Times
• Users of a concurrent request including parameters
• General Ledger SQL Scripts
• GL : ADI Opening Balances
• GL : Autopost Definitions
• GL : CoA Parent Accounts
• GL : CoA Segment Qualifiers
• GL : CoA Structure
• GL : CoA Values
• GL : Code Combinations
• GL : Consolidation Mapping
• GL : Cross Validation Rules (CVR) Line Detail, Summary Overview & Common Configuration Errors
• GL : Distinct accounts by GL Source
• GL : Entered Currency by Month
• GL : FSG Reports. Column Sets, Row Sets, Content Sets, Row Orders
• GL : GL Interface snapshot across books & GL Interface Details
• GL : Journal Lines including Reference fields
• GL : Journal Category & Source Combinations Used
• GL : Journal Headers & Batches
• GL : Journal Line based Trial Balance
• GL : Mass Allocation Formula
• GL : Period Statuses
• GL : Security Rule Assignments & Security Rule Definitions
• GL : Set of Books configuration
• GL : Summary Account Template
• GL : Trial Balance from GL Balances
• DataLoad .dld SQL Scripts

Includes the following Dataload scripts that output data in a .dld dataload classic format to extract configuration from one environment to load into the next using dataload classic. This eliminates the need to manually review and update you .dld spreadsheets and files.

• Dataload .dld GL Cross Validation Rules
• Dataload Professional .fld : Daily Rates load
• GL : Mass Allocation Migration Script in Dataload Professional FLD format
• GL : Mass Allocation Rule Migration Script in Dataload Classic Format

Tags

del.icio.us: applications, consulting, financials, functional, oracle,
technorati: applications, consulting, financials, functional, oracle,

Thursday, January 24, 2008

Oracle Business Accelerators (OBA) for E-Business Suite

Towards the end of last year I blogged about the Oracle Accelerate programme. The first step required to participate in the programme is to complete the Oracle Business Accelerators for Oracle E-Business Suite Accelerators Overview Course available on i-learning. The purpose of this course is to:

• Provide an overview of the Oracle Business Accelerators
• Familiarize you with the Accelerators Online Portal
• Mandatory for all users of Oracle Business Accelerators
• Gain Access to online portal after successful completion

According to the course, the goal of Oracle Business Accelerators (OBA) is to use industry targeted leading practice business flows to rapidly get to transaction testing and go live.

How do the Accelerators work?

1. Using the Accelerators Online Portal capture information from Customers and generate configuration instructions
2. Within E-Business Suite - download configuration instructions and load setups to instance

Essentially, Accelerators allow you to generate your systems configuration instructions based on a series of questions presented to the Customer that pertain to their industry. Once the configuration instructions are generated they can be loaded onto an Oracle instance to create the setups. In essence,  the setup of an Oracle instance is faster as there is now more automation involved. There are varying access levels for the accelerator online portal and these are outlined below. For each level courses have to be taken to gain access.

Level 1 Browse

This gives you access to the following:

• Datasheets
• Solution Footprint
• Process Models
• Sales Pitch
• Roles and Responsibilities
• Functionality Overview
• Industry Business Case
• Videos and FAQ
• Project Implementation Guide
• Setup Guide and Video
• Setup Tool Save Mode Off

To attain level 1 status the following courses have to be undertaken:

• Overview - 30 minutes
• How to Position - 30 minutes (optional)
• Industry Business Case - 30 minutes (optional)

Level 2 Browse

This gives you access to the following:

• Includes Level 1
• Implementation Guidelines
• Setup Questions
• Key Assumptions
• Testing Sequence
• Setup Tool Save Mode Off

To attain level 2 status the following courses have to be undertaken:

• Implementation Overview - 30 minutes

Level 3 “Project Workspace” (per industry)

This gives you access to the following:

• Includes Level 2
• Test Scripts
• Setup Tool Save Mode On

To attain level 3 status the following courses have to be undertaken:

• Implementation Details - 60 minutes
• Common Setups - 60 minutes
• Industry Implementation - 40 minutes (per Industry)

Setup Loader Utility for DBA’s

• No other levels included
• Setup Loader Utility is Mandatory for Setup Tool Downloads

To attain the loader utilities, the following course has to be undertaken:

• Installation Training for DBA’s - 60 minutes

Following successful completion of the Oracle Business Accelerators for Oracle E-Business Suite Accelerators Overview Course an assessment exam can be taken which gives you access to the Accelerators Online Portal. The exam is a 20 question exam for which the pass rate is 95%  i.e. 19 questions right. There doesn’t seem to be any time limit on the exam but it should really only you take you 20 minutes i.e. 1 minute per question. I managed to pass on the second attempt and my advice to anyone taking it is take notes on the overview course and have them as a reference point when writing the exam.

Tags

del.icio.us: accelerate, OBA, oracle,
technorati: accelerate, OBA, oracle,

Wednesday, January 16, 2008

Richard Byrom Consulting

Last year I left my permanent job and I am now going to be contracting as an Independent Oracle Applications Consultant and Solutions Architect. I’ve formed Richard Byrom consulting and the consulting tab on my site outlines the type of services I intend to provide which can broadly be categorised into the following areas: -

• Bids and Proposals
• Business Consulting and Analysis
• Information Technology (IT) Strategy
• Solutions Architecting
• Enterprise Resource Plannning (ERP) Implementations
• Writing and Presenting

I’m looking forward to this particular venture and am interested to see what its like working as an Independent contractor. I also see it as an opportunity to breath some life back into my blogs. If you’re interested in my services or want to talk to me about potentially working together then please don’t hesitate to contact me.

Tags

del.icio.us: applications, architect, byrom, consultant, consulting, IT, oracle, richard, RichardByrom, solutions,
technorati: applications, architect, byrom, consultant, consulting, IT, oracle, richard, RichardByrom, solutions,