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.
e-mail this article • Administration •Contracts •Community •Networks •Social • (0) Comments • Bookmark this to del.icio.us • Permalink
Oracle Community - the Social Network for Oracle People
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.
e-mail this article • Administration •Community •Social • (0) Comments • Bookmark this to del.icio.us • Permalink
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
- 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?
- 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.
- 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?
- 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.
- 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.
Describe/draw the sequence of events you would undertake in closing the various financials modules.
- 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.
- 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.
e-mail this article • Administration •Interviews •Jobs •Modules •Finance • (0) Comments • Bookmark this to del.icio.us • Permalink
Thursday, February 07, 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.
e-mail this article • Administration •Blogging •Contracts •Consulting •Events •Meetups • (1) Comments • Bookmark this to del.icio.us • Permalink
Saturday, February 02, 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.
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 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.
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.).
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.
e-mail this article • Administration •11i Vision Instance •12i Vision Instance • (15) Comments • Bookmark this to del.icio.us • Permalink