January 31, 2009
January 30, 2009
- Full-time students learning Oracle - Oracle certification credentials may lead to a job opportunity in an organization using Oracle or implementing for other corporates. Certification may decide what you would be doing for the rest of your career.
- Beginner or Intermediate level professionals - Oracle certification credentials improve promotion and growth opportunities within or outside the organization. Certification confirms your expertise gained on the job.
- Expert or Advanced level professionals - Oracle Expert credential provide the unique opportunity to specialize in an area of your expertise. For example, if you are a DBA look for OCE RAC Certification. Participate in beta exams for new releases and technologies. Be the first to be certified in the track. Oracle certification thus provides a continued validation of your superior skill set as an expert. For engagements involving these new releases, the experts or advanced level professionals are always in great demand and availability is scarce.
Has Oracle certification guided your career path?
Share your anecdotes as comments to this blog post.
January 29, 2009
For those who missed out on writing these beta exams, there are more R12 beta exams that are available for just over seventy days. The two and a half months time window should be adequate to prepare especially for the 'C-B-S' genre of questions asked in the beta exams.
However, this is not the time to procrastinate and postpone preparing for the R12 beta exams by yet another week. Establish a review schedule and follow it as part of a daily routine in an earnest manner. Perfection consists not in doing extraordinary things, but in doing ordinary things extraordinarily well. Now, more than ever, it will be a test of your will power to stick to the certification plan. Successful candidates are those who understand the importance of being earnest.
January 28, 2009
January 27, 2009
As you prepare to go out to 'battle' at your nearest Prometric test center, it is time to forewarn you about the 'Three Musketeers' whom you shall encounter. The 'Three Musketeers' are three types of questions which stump most candidates. Allow me to illustrate the three little men (not so cherubic like the picture alongside) that would cause you a little heartburn during your testing window.
C2s - Consulting Conundrum or Complex Consulting: These are questions that ask you "How to make it work?" The question may relate to configuration and setup as well as steps for transaction processing. For technical exams, this may involve writing or arranging the code in the correct order. Questions have multiple choices (sometimes up to seven choices!) and one has to select the correct answer set - usually two or more options need to be chosen to get full credit.
B2s - Brilliant Brainstorming or Business Breakthrough: These are questions that ask you "How to provide a solution?" Usually a mini case study is presented with relevant and not so relevant facts and figures. One has to architect and/or configure a solution and use the several alternatives among the multiple choices to arrive at the correct answer. Similar to the C2s, usually two or more options need to be chosen to get full credit. These questions consume a lot of minutes so proper time management is required to have adequate window to answer these questions.
S2s - Support Situation or Service Successfully: These are questions that ask you "Why is it not working?" Based on a problem statement one has to study the alternatives and eliminate the correct setups, configuration or codes and identify the incorrect ones. For once, 'wrong is right' here. Similar to C2s and B2s, usually two or more options need to be chosen to get full credit.
The C-B-S network would indeed test your skills and expertise to its limits. It all depends on your performance when it matters whether you will be a hit, a rock star or be just hit or get rocked. Oracle certification exams are increasingly moving away from Rs - Recall and Record or M2s - Memorize and Mark type of questions. Even if one has the urge to consult the illegal pass-guaranteed question banks, the M-R-I (M2s-R2s-Initiative) would only give you a headache (in more ways than one!). This MRI is not worth the scan!
January 26, 2009
The beta exams started around January 2008 and had a long shelf life of about 13 months. While one cannot complain of the extended beta testing opportunity, it is only now that the critical mass of the candidates for these tests are being reached, perhaps thanks in no small measure to this blog and the beta exam challenge!
The expiration date on the two beta exams is just four days away. For those candidates who are taking the beta exams this week, we wish them the very best of luck and hope they have a long shelf life as EBS R12 Certified Experts.
The solution key to the Nano9s for EBS R12 INV, PO, OM is provided below. The correct answers are shown in bold and italics
January 25, 2009
Allow me to take this opportunity to wish them: Xin Nian Kuai Le!
Wishing everyone a very prosperous year ahead: Gong Xi Fa Cai!
In this 'Year of the Ox' let us all resolve to be dependable, calm, methodical, patient, hardworking, ambitious, conventional, steady, modest, logical, resolute and tenacious like the ox.
For one, I am quite bullish about all of you reaching your Oracle certification goals this year!
We shall resume our regular blog post from tomorrow starting with Nano9s on both 1Z1-225 and 1Z1-226 exams that are being retired at the end of the month. We shall also publish the answers to the last Nano9s on R12 INV-PO-OM.
January 24, 2009
The offerings are most likely to be similar to the Live Virtual Class (LVC) offered by Oracle University.
Read about the third party e-learning sites by clicking here
Online Apps DBA Blog offers DBA training for 11i and R12. This courses are available via web conference and hosted on weekends or late evening with hands on exercises. For a complete list of courses offered, please click here
There are several training providers who provide R12 training at their education centers. Perhaps it be worthwhile for certification candidates (and profitable for the training providers) if these classes are also made available as web classes since web conferencing and application sharing on the web has improved by leaps and bounds over the last two years.
Have you attended any web class? Please share your experiences as a comment on this blog post.
January 23, 2009
The authors have done a commendable job for creating an easy-to-read conversational style of writing. At times it just feels that you are an audience member listening one of the popular Solution Beacon workshops. Each new feature is illustrated with screenshots that makes it easier to understand the concepts.
The authors of this little paperback treasure tome of 250 odd pages include the Who's Who of the Oracle universe including the "Upgrade Guru" John Stouffer, "Workflow Wizard" Karen Brownfield, "Security Savant " Randy Giefer and R12 experts Alfredo Pantaleon, Lance Reedy, Montella , Susan Behn, Paul Cyphers, John Faucher, Daryl Geryol, Chuck Kennedy, Rob McMillen, Naren Thota, Lon White, Alyssa Johnson and Anthony Della-Croce.
January 22, 2009
- Weird Tale #1: One can buy Oracle Student Guides online without attending Oracle University courses! The site is probably not an authorized one since each guide sells for $19.95 only while the courses cost hundreds of dollars. Since, we do not encourage nor condone such copyright violations please do not ask for the link. However, I want to post this item so that Oracle University notices and takes appropriate action.
- Weird Tale #2: One can 'pass' the Oracle Certification exam even without writing the exam. Someone else will write the exam for you. The 'service' provider takes this absurdity to its limit by asking buyers to be patient while they search for the next 'available' (sic!) testing centre. Since we only encourage you to write the exam and not someone else to write for you, please do not ask for the link. However, I want to post this item so that Oracle Certification Progam notices and takes appropriate action.
- Weird Tale #3: A famous auction site is hosting sellers who are selling certification exam questions for less than ten dollars where the seller claims it to be the 'latest' (sic!) one. Since we only encourage our readers to try the Nano9s practice tests (which are NOT actual exam questions but just questions for practice) and win Apple iPod Nanos, please do not ask for the link. However, I want to post this item so that Oracle Certification Progam notices and takes appropriate action.
- Weird Tale #4: One of our blog readers buys the 'latest' question bank - unsuspectingly and innocently one presumes - to cram both the questions and answers before writing the exam. To his (un)pleasant surprise, the exam questions at the testing center were not the same as the 'latest' question set promised by the online seller. Needless to say, Oracle Corporation benefited from additional revenue as an exam retake was required.
- Weird Tale #5: One of our blog readers buys the 'latest' question bank - unsuspectingly and innocently one presumes - to simulate the test center conditions as close as possible. This time he has studied enough to know the correct answers to most of the questions. After the 'practice' test, he checks his answer and finds that many answers in the (un)helpful test guide are wrong! He writes to the OCP Advisor to find the correct answers!
Have you heard of weird tales like the ones I shared with you? I wish none of the above stories were true! Believe it or not!
January 21, 2009
Conferences offer 4-5 days of education sessions covering a wide range of topics unlike instructor-led sessions where it is focused on a specific technology or application module. One also gets to visit the vendor booths and see demonstrations of latest Oracle solutions. Conferences are also a great way to network and make friends with fellow members of the Oracle community.
Today, I attended a one day conference hosted by the Northern California Oracle Applications User Group. There was a cornucopia of great presentations - too many of them and too less time to attend as many must-see sessions overlapped. Please visit the presentation archives and download the presentations to review at your leisure.
Did you attend a memorable Oracle related presentation lately? Please share with us what you learned from it? Did you apply the knowledge at work already?
January 20, 2009
Try to imagine you taking your first parachute jump. There is not much of a chance of a 'do-over' if the parachute fails to open before your hit the ground!
Planning for the one and a half or two hours exam duration is an important part of your overall preparation. Using the exam content guide, do a quick analysis of the duration of the exam and number of questions asked. For example, let's take a 90 minute exam with 72 questions. That translates to an average time of 75 seconds to answer each question.
Here are five test taking tips to implement for your next certification exam:
- Spend less than a minute on the fixed length questions (those that are multiple choice - single answer). Preserve your time for the longer case study based questions
- Check the box for 'Mark for Review' when you are not confident about the answer. Review the answers after you have completed one round of browsing and answering all questions
- For case study based questions, scan the case study to get the highlights. Make sure to understand the context of the problem at hand and then, quickly move on to scanning the questions. While scanning make mental notes remember which sections of the case study you should focus on. The goal is to avoid having to study and analyze material that is not completely relevant because time allotment to complete the entire exam is limited.
- Budget your time. A good thumb rule is to answer at least 25% of fixed length and short answer (multiple choice - multiple answer) questions in the first 25% of alloted time (18-19 questions in the first 23 minutes, as per our example). A good progress is completing 75% of the questions in 75% of alloted time (i.e. 54-56 questions in 65-70 minutes)
- If you finish before the alloted time and there are still some questions that are unanswered and you are not sure about the answer, make an attempt to answer all questions. An unanswered question is always incorrect. There is a probability of your best guess being the correct answer.
January 19, 2009
OUKC offers subscriptions which are called 'passports' for accessing the online content. OUKC Technology Passport topics covering Database Administration, Performance, Tuning, Backup, Recovery, Real Application Clusters, Streams, and Oracle Enterprise Manager. OUKC Applications Passport includes topics covering Oracle E-Business Suite, PeopleSoft Enterprise, JD Edwards Enterprise One and World, Siebel, Demantra and G-Log products.
There is an option for Free Trial membership. This gives you access to a selection of complete OUKC courses chosen to provide a sampling of the learning styles employed and of the wide range of online courses that are available when you purchase an OUKC Passport One Year Membership. The one year membership provides access to all the paid courses.
For Oracle employees and Oracle partners, access to OUKC is free with ability to enroll to all the content (This conclusion is based on my past access to OUKC using oracle.com e-mail and oracle partner e-mail respectively and as an OUKC user since 2001). Oracle partner employees need to enter their OPN number in their profile and then login through the subscriptions link.
Visit this goldmine and discover the rich treasures of certification study material that are so generously available.
January 18, 2009
The comment led me to think about the compelling reasons for hiring a candidate who is certified.
So here are seven reasons that I could think on my keyboard (similar to thinking on my feet I guess).
- Certification benchmarks and validates qualification - the unknown angel who is walking in is certified by an independent body of his / her potential ability
- New hires hit the ground running - the on-boarding to on-time delivery phase is minimal with certified individuals having all-round knowledge about the subject
- Reduces support costs - exposed to the entire product feature and functionality during certification, probability of using standard features instead of workarounds and customizations reduce support costs in the long run
- Increases competitive edge - the 'edge' spurs teams both internally to compete amongst themselves to perform better as well as externally to deliver as promised
- Improves project delivery and team performance - Several industry studies have confirmed that certified individuals help in enhancing the team performance by several notches.
- "Bird of the same feather" phenomenon - experts network amongst each other ("flock together") and spending days troubleshooting issues or brainstorming fixes, often this informal collaboration produces quicker results. Certified professionals are the right breed for show time.
- A self-fulfilling prophecy - It is a good PR to hire Oracle Certified Professionals. Sooner than later, the perceived promise to deliver is translated to excellent feedback from your IT customers. As a hiring manager, it is definitely a good day when you get an e-mail full of praise ending "You've made an excellent hire!"
Hire Oracle Certificated Professionals and build a winning team!
January 17, 2009
Please express your support or opposition to either of the viewpoints using the comments window of this blog post.
January 16, 2009
For those certified professionals still thinking whether to write a beta exam or not, here is a quick analysis of the cost savings.
Let's assume the bridge exams are not available and one is taking the production exams. So for a EBS 11i OCP to get certified on a R12 track, the minimum cost would be US $320. This consists of $125 for 1Z0-204 exam and $195 for any of EBS R12 combo exams.
By taking the a beta exam at a cost of only US $50, the savings is a whopping 84% . Now that is what is called a real deal!
During this gloomy economic weather, this is a certain measure that one should take in these uncertain times. Tell your fellow certified professionals about this savings opportunity. With this huge discount, no wonder we are making a big deal about it!
January 15, 2009
For those who are yet to meet this vivacious Oracle expert and OCP, please attend the Hostos Symposium where this angelic DBA would speak about "Seven Sins of Concurrency"
OCP Advisor (OCPA): Please share with us your background and professional experience.
Chen Shapira (CP): I studied Computer Science and Statistics in Tel Aviv University in Israel. I've been working in IT for over 10 years, and I did pretty much everything - development, system, storage and even management! In the last 4 years I've been a DBA for HP. This position involves lots of different systems, but most exciting is working with RAC systems and with streams.
OCPA: Which Oracle certification exams have you taken? How do you prepare for the certification exams and achieve such great success?
CP: I took OCA and OCP for 10g. I'm planning to upgrade to 11g this year and also take the RAC OCE. I took 3 weeks to study before each exam. About an hour a day, maybe a bit more on the weekend before the exam. I used Oracle 10g OCP Certification All-in-One Exam Guide to help me prepare, but I also relied heavily on Oracle's product documentation. Its important to remember that the test goes into a lot of details about the products, so it is quite challenging and even experienced DBAs must study for it seriously.
OCPA: Based on your certification experience, what is your advice, tips and suggestions for candidates preparing for the exam?
CP: I'm not one for "tips". If you read the study guide, practice on a real DB, answer all the practice test questions and sleep well before the exam, you'll probably do fine. However I have discussed about exam preparation on my blog. Click here to read how I prepared for the OCA exam and my click here about my notes about OCP exam.
OCPA: Oracle is constantly releasing new versions and technologies. How do you keep updated and upgrade your skills?
CP: Ah, this is a huge question! Catching up is difficult and I am not sure I manage to stay updated. I try to be involved in beta programs, I try to read the "new features" guide in the documentation and Arup Nanda's series on OTN. Reading blog helps a lot. The single most useful source of new features are my coworkers who frequently send an email saying "Hey! check this out!"
OCPA: Which Oracle technologies excite you most? What's your advice to Application DBAs for adopting these?
CP: Right now I'm most excited about Advanced Compression, because it gives such clear business benefits and it is also very easy to test and implement. I'm also very excited about Oracle's high availability features. RAC is getting better with each release, Data Guard is improving a lot. It is nice to see that Oracle is putting lots of effort into scalability and comes up with solutions that are both innovative and practical.
OCPA: You are also a very popular blogger. Please tell us what you blog about.
CP: I work as production DBA, so naturally I blog about production topics. Hence, my blog is called ProdLife. Mostly how things can go awfully wrong, how to prevent them from going wrong and how to solve problems after they already happened. Sometimes I even blog about things that go right.
OCPA: Can you please let us know one habit that has contributed most to your professional success?
CP: I read a lot. By a lot I mean at least two hours a day! So I know about new features and how they should work before I implement them and I know a lot of theory about how Oracle
database works. I also remember lots of random bits that "I've read somewhere" and turn out to be useful from time to time. I want to be able to say that my co-workers learned that I know everything and stopped arguing with me, but in fact, we argue all the time!
OCPA: As a small token of our appreciation, we shall be sending you one OCP Blog T-Shirt from the OCP Blog Gift Shop.
CP: Thanks for the thought-provoking questions! By the way, will you attend NoCoug Winter Conference? It's going to be at Oracle Redwood Shores Conference Center and and Tom Kyte is giving two presentations!
Thanks for the t-shirt. Any chance it will be pink?
January 14, 2009
- Discusses R12 Inventory exam content
- Discusses R12 Purchasing exam content
- Discusses R12 Order Management exam content
- Nano9s on 11i Order Management
- Nano9s on 11i Purchasing
- Oracle Tutor Patches for R12 Beta exams
There's no better way to test your exam preparedness than answering 9 questions every day as part of OCP Blog Nano9s series.
What's more - there is one Apple iPod Nano to be won!
Q#1: Which of the following statements are correct for a Receiving Process? *
Cannot correct receiving transaction errors
Can record returns to suppliers
Can match a delivery to a PO
Can define receiving tolerances at item level
Q#2: Which of the following data is transferred from Order Management to Inventory for a transaction? *
On-hand quantity information
Q#3: Which of the following functions can you perform from the Materials Workbench? *
Perform miscellaneous issues
Perform ship confirm
Perform move orders
Perform miscellaneous receipts
Q#4: Which of the following is true about MOAC? * MOAC = Multi Org Access Control
Always specify operating unit when you query a transaction
On the sales order form there is a new field for Operating Unit
Operating Unit is a view only field on Sales Order form
One cannot access multiple operating units within a single responsibility
Q#5: Internal Requisitions functionality is not working properly. Which are the probable causes? *
Item attribute Internal Order Allowed set to "No"
Receipt Routing for the shipping inventory organization set to "Standard"
PO:Legal Requisition Type is set to "Internal"
Source Type for Inventory attribute is set to "Yes"
Q#6: Which of the following is a PO: Document Security option? *
Q#7: If you use the control option of "Freeze" for a PO, which functions can you still perform? *
Add a line to the PO
Receive invoices against the PO
Match invoices against the PO
Close the PO
Q#8: Which is of the following statement is true about QP: Security Control profile option? *
Set this option to "Yes" enables Global box on Price list header
Newly created pricing entity gets automatically assigned to creating OU
Granting of privileges should be done after setting up this profile option
As a best practice, it should not be turned off if it is switched on
Q#9: Which of the following can be defined as the base unit of measure for Class=Area *
For answers, click here
January 13, 2009
The Oracle Applications Users Group (OAUG) is pleased to
inform you that your presentation, “14 Easy Steps to End-User Empowerment: Convert Custom Reports to BI Publisher,” has been accepted as a session at COLLABORATE 09 in Orlando, Florida, May 3-7, 2009.
Business Intelligence Publisher is now tightly integrated with Oracle E-Business Suite. This session would introduce end-users to fourteen easy steps for converting existing custom reports to its Business Intelligence Publisher avatar. Leverage the power of Business Intelligence Publisher to create reports with rich layout and graphics within minutes. This session would also provide information necessary to understand and support Business Intelligence Publisher reports. It is time for end-user empowerment!
January 12, 2009
January 11, 2009
January 10, 2009
There are indeed several Oracle list servers and online communities that have discussion forums and bulletin boards that discuss Oracle technologies including databases, middleware and individual application modules. Almost all of these forums are formally or informally moderated by Oracle experts who are Oracle ACE or ACE Directors. Rarely does a question posted on the forums go unanswered. A leading Oracle ACE has answered an astronomical 14,000 questions on Oracle Technology Network!
For the benefit of our readers, here is a listing of five such community forums.
- Oracle Technology Network Forums
- Oracle Support Community *
- OAUGNet and OAUGNet-DBA forums
- Oracle Wiki forum
- Oracle IT Toolbox
The list is an indicative one and not exhaustive by any means. Please list the discussion forums that you visit or nominate as the most popular in the comments section of this blog post.
Join the forums and subscribe to the discussion threads. Whatever be the time of the day or day of the week, there is an expert waiting to answer your questions on a topic you are preparing for the certification exams.
Help is just a click away!
January 9, 2009
The only problem is that one gets only a few days at Oracle University to make brief introductions with a group while attending one of the instructor-led courses. So how does one form study groups?
The solution here is courtesy the internet. There are several virtual study groups in existence. These are the Oracle community certification forums where certification candidates and certified experts discuss any and every certification topics.
For the benefit of our readers, here is a listing of five such community forums.
- Oracle Technology Network: Certification Forum
- Oracle Apps Blog: Training and Educational Services Forum
- IT Toolbox: Oracle Career Forum
- Oracle Mix: Certification Forum
- Linkedin: OCA/OCE/OCP/OCM Forum
January 8, 2009
January 7, 2009
R12 Inventory Exam Content
One of the most visible R12 new functionality is the the Professional Buyer's Workcenter. This is a new topic for the R12 exam. Sub-topics includes how to use the workcenter to manage requisitions, standard purchase orders and blanket purchase agreements as well as condct negotiations and supplier management.
January 6, 2009
For the Oracle EBS Professionals, knowledge about SQL is necessary for ad hoc queries, data extraction for reporting, alerts and even setups for table validated value sets, approval management engine, workflow and many more. Skill set requirements for today are more for a techno-functional expert. SQL and PL/SQL are still an useful weapon to have in one's arsenal. Notwithstanding the onslaught of XML and BI Publisher, a foundation in SQL would go a long way in situations such as troubleshooting.
The following Oracle University courses can be taken for the exam: Oracle Database 10g: Introduction to SQL OR Oracle Database 11g: Introduction to SQL OR Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II
The 1Z0-047 exam qualifies one for Oracle Database: SQL Certified Expert credentials or helps you in the quest for Oracle9i DBA OCA certification or Oracle PL/SQL Developer Certified Associate certification.
There are several exam study guides available for SQL exams. A exam preparation guide being released in May-June 2009 is the "Oracle Database SQL Expert Exam Guide" by the popular author April Wells.
In case you find it difficult to get access to a test database like Oracle EBS vision database or your organization's test database, may I recommended that you download Oracle Express Edition or Oracle XE from Oracle Technology Network (OTN). Oracle XE is one of the most popular downloads with its own mini database schema that you can practice on. Also one the other popular download on OTN is the SQL tool - Oracle SQL Developer.
Have you already taken the Oracle Database SQL Expert Exam? Please share your exam preparation and test taking experiences with our blog readers.