May 29, 2007
Sam shares his test taking experience with blog readers worldwide:
" - concepts, utilities, install and maintain manuals are quite sufficient for the exam prep
- one will need real hands-on experience to answer most of the questions
- a good percentage of the questions were based or real-life case studies
- use OAM regularly to understand the flow through the various screens and its options
- this was one thing which caught me on blindspot,since I try to get things done via scripts
- shared appl_top, merging patches and diagnosing AD workers were some topics questioned"
May 28, 2007
Today I reviewed the map and found that we had visitors from all the six continents in the last seven days!
Thank you very much Africa, Asia, Australia, Europe, North America and South America for viewing the blog and making this page a true global platform of information sharing!
May 26, 2007
Vikas S. wrote to me to share the good news and with test prep tips for fellow blog readers:
" I got a lot of support from the blog and even it was inspiring that so many persons are working towards one goal of becoming an OCP. I really thank you for your efforts.
I wish to share my experience for the AP exam. I studied from student guides as it my experience that exam content is derived heavily from the student guide. For topics like Withholding tax, Invoice Tax and Credit Card and Expense reports, I studied for additional information from the User Guide.
Even though the exam website mentions that total number of questions to be 62 but for the exam I took there were only 57 total questions asked. Thankfully, the scenario based questions were just 25-30% and remaining were straight forward questions, with 2-3 options to select.
Some of the topics that were source of the questions were as follows:
- Quick Invoices
- Standard Invoices
- Payment batches,
- Quick and manual payments
- Expense report import
- Purpose of special calendar
- Purpose of invoice validation
- Period close activities
- Forms where various accounts are setup
- Automatic offset payables options
- Bank account setup
- Pre-requisites for running Create Mass Additions"
Please keep writing and sharing the news of your 11i OCP success!
May 25, 2007
"I have cleared my exam... It was definitely not as easy as I thought so. Most of the questions demanding very specific answers. Some of the areas to focus are : Consolidation including translation, Mass Allocation and Financial Statement Generators.
Some of the questions related to the following:
- things one can do from consolidation workbench with specific emphasis on the sequence of steps.
- basic GL setups required for a new company, including what important information one would request the company to provide so that one can setup a conference room pilot instance.
- security rules to answer some scenario based questions.
- where does one make Budget Journals mandatory for the company.
- how many set of books will be needed by a company having offices in Asia, EMEA and America. Calendar for Asia and EMEA are the same. COA is same for all countires. There are 2 countries in Asia, 3 in EMEA in 2 in Americas.
- questions on auto reversal.
- what currencies are enabled after installing the application (answer: USD, by default. All others need to be enabled as per implementation requirement)"
Some tips for future test takers: " Essentially one should plan for only one minute per question. Need to keep track of time every 5 or 10 or 15 minutes intervals based on your comfort to track time and attempt all the questions"
May 24, 2007
Challenge yourself and post your answers on the blog comments. The answers would be published at the end of every week to provide sufficient time to the hundreds of test takers attempting the mini-mock tests. Best of Luck!
1Z0-222 Purchasing Fundamentals 11i Mini-Mock Test Number of Questions: 25 Time: 30 mins
Match the requisition status navigation buttons in the requisition status tabbed page with ther functions (e.g. a-1, b-2 etc)
[a] Copy to Cart
1-Nullifies a requisition
2-Submits a requisition again
3-Duplicates a requisition
5-Retracts a requisition from its position
Which are not one of the options to designate a supplier site use:
[b] Primary Pay
[c] Secondary Pay
[e] Procurement Card
[f] RFQ Only
Choose the correct sequence of steps for the step-by-step checkout:
4-Review & submit
Select the critieria needed for requisitions that have automatically created blanket release:
[a] requisition line must be already reflected in a PO
[b] release must be within the limits of the agreement
[c]source agreement must still be active
[d] requisition line must be either closed or cancelled
[e] source items from a single supplier must use a single BPA
Potential Duplicate Suppliers can be identified by which of the following methods:
[a] Running a Purchasing Intelligence Report
[b] Perform a Find or query on the supplier name
[c] Review the New Suppliers Listing Report
[d] Review the Supplier Audit Report
[e] Submit the 1099 Suppliers Exception Report
Approval group comprise of include/exclude and amount limit criteria for the following Object Types: [a] Document Total, Account Range, Item Range, Item Category Range, and Location
[b] Amount Total, Account Range, Item Range, Item Category Range, and Organization
[c] Document Total, Account Range, Item Range, Item Catalog Range, and Operating Unit
[d] Security Level, Account Range, Item Range, Item Category Range, and Location
Match the PO document security level with their description (e.g. c-2, d-1 etc)
1- Only the document owner, subsequent approvers, and individuals above the document owner in the security hierarchy can access the document
2-All system users can access the document
3-Only the document owner, subsequent approvers, and individuals defined as buyers can access the document.
4-Only the document owner and subsequent approvers can access the document
Reason for having realms in iProcurement home page is to:
[a] allow for easy maintenance
[b] manage catalogs into categories
[c] limit the view of the requester
[d] map supplier catalogs to Oracle catalogs
By using the shop supplier sites option in iProcurement home page, you can:
[a] browse internal categories
[b] save items in the public lists
[c] directly shop for items from a supplier web site
[d] search the external catalogs
[e] select the item you want to buy
Select the features of the sourcing rules:
[a] sourcing rules are defined in Oracle Inventory
[b] preferred invoices and purchase orders are specified
[c] replenishment sources for an organization are specified
[d] primary supplier item number is linked with internal item number
[e] sourcing rules are defined in Oracle Purchasing
[f] preferred suppliers, distributors and manufacturers are specified
Select the functions of an imported catalog:
[a] ordering an item that is seldom required
[b] including items that are priced dynamically
[c] ordering a service billed by quantity or a fixed rate
[d] ordering items below 1000 dollars
[e] ordering items that are not present in the internal catalog
[f] ordering only for bulk items
Identify the functions of an internal catalog
[a] encourages maverick buying
[b] offers quick information search
[c] discourages spend control
[d] provides accurate product description
[e] eases ordering of items
[f] can be independently used by the staff
[g] offers multilevel search
Identify when an information template is used:
[a] when item must only be sent to the address in the My Profile page
[b] when an item has unique information each time it is requested
[c] when the item can be part of the ASL
[d] when an item is placed into the requisition pool
Select the features of Approved Supplier Lists:
[a] eliminates redundant sourcing efforts
[b] assigns and stores statuses to item/invoice combinations
[c] includes information about all suppliers with business statuses
[d] assigns and stores statuses to item/supplier site combinations
[e] links items to suppliers
[f] prevents problem replication in multiple organization
[g] provides immediate procurement visibility
[h] is optional
Select the features of a shopping cart in iProcurement:
[a] can be accessed using the shopping cart hyperlink
[b] can save any number of items
[c] contains all the items that you have selected after checkout
[d] clears the item contents after checkout
[e] saves recently added items at the top of the list
[f] automatically recalculates the requisition total
Automatic PO creation process allows for the following:
[a] Previous goods and services to be reordered in a touchless process
[b] New items to be processed from the requisition pool by the buyer
[c] Goods to be manually approved and processed by the buyers
[d] Items to be ordered from non-catalog requests
Identify the advantages of using Oracle iProcurement and iSupplier Portal
[a] Centralized sourcing, approval routings and payments
[b] Suppliers can evaluate buyers
[c] Suppliers can review their own information
[d] Centralized requisition and receiving process
[e] Paperless flow through entire procurement cycle
[f] All functions performed through Internet browser
Select the benefits of having a BPA:
[a] Allows a long-term supplier agreement
[b] Grants multiple suppliers for a single agreement
[c] Used when rigid delivery schedules are required
[d] Identifies effective date and end date of the agreement
[e] Allows inspection of the item quantity
[f] Documents the characteristics and prices of the items
Match the setup to the corresponding Options form window (e.g. a-1, b-2 etc)
[a] Use Multiple Currencies
[b] Next Automatic Number for Supplier Numbering
[c] Requisition Numbering
[d] Receipt Routing method
Match the accounts with the form where it is defined (e.g. a-1, b-2 etc):
[a] Clearing Account
[b] AP Liability Account
[c] Rounding Account
[d] AP Accrual Account
Match the Requisition type to their description (e.g. a-1, b-2 etc):
[a] Urgent requisition
[b] Emergency requisition
[c] Catalog requisition
[d] Non-catalog requisition
1- Used to order items unavailable in the product catalog
2- Used to order items from the unified catalog
3- They appear prioritized in the requisition pool
4- They reserve PO number prior to
Match Approval Level (2, 3 or 4-way) can be defined in which of the following windows:
[a] Purchasing Options
[b] Receiving Options
[c] Supplier window
[d] Item window
[e] PO Shipments window
[f] User preference window
Arrange the period close processes in the correct order (e.g. 1-a, 2-c, 3-d etc)
[a] Process period-end receipt accruals
[b] Review Uninvoiced Receipts report
[c] Post all receipts
[d] Process remaining inventory transactions
[e] Run Accrual Rebuild Reconciliation Report
[f] Write off accrued transactions as necessary
[g] Close the purchasing period
[h] Create manual journal entry for write-offs
Which of the following modules are part of Oracle's Advanced Procurement solution:
[a] Oracle iProcurement
[b] Oracle iSupplier Portal
[c] Oracle Purchasing
[d] Oracle Property Manager
[e] Oracle Sourcing
[f] Oracle Procurement Contracts
[g] Oracle Lease Management
Match the receipt processing method with its description (e.g. a-1, b-2, c-3 etc):
[a] Unordered receipt
[b] Standard receipt
[c] Cascade receipt
[d] Express receipt
1-Receive items when you do not know the corresponding PO number
2-Recieve using one receipt of multiple shipments of the same item
3-Recieve one line at a time
4-Receive multiple lines at a time, e.g. entire PO
Click Here For The Solution Key
May 23, 2007
Here's his feedback:
" Took the beta exam last year, so I don’t know which questions they put into the real exam.
Also I did not prepare for the exam because I had to take the exam only two weeks after I signed up". He added, "In the beta exam the following subjects were important - shared appl_top, merged patching and directory structure when installing EBS 11.5.10. Study the admin guides mentioned on the exam content site".
In case you are writing or have written the 1Z0-233 exam, please share your experiences with other blog readers worldwide. Please e-mail me directly at email@example.com
May 22, 2007
Swarna M. has passed 1Z0-200, 1Z0-211 and 1Z0-212 to be declared as Oracle 11i Certified Professional Consultant, Payables a.k.a. 11i OCP. Heartiest congratulations to Swarna M. and others who have achieved their certification. Swarna M. shares 11i OCP test taking experiences:
" The 11i General Ledger Fundamentals exam (1Zo-211) had nearly 90% of the questions based on scenarios
- question on setups
- questions on Multi-Org
- questions on Intercompany
- questions on setups based on Consolidation
- questions were really lengthy and one required lot of time to read through and understand
- need to really race against time
- user guide and tutor documents were helpful
- believe test takers need some hand on experience to qualify
The 11i Payables Fundamentals exam (1Z0-212) was a lot easier and had lot of time to answer
- about 60% were based on scenarios while 40% were direct
- questions based on setup options
- questions on which accounts are setup in which forms
- questions on period close
- questions on how accounting happens
- recommend that one should review the setups
- user guide and tutor docs were helpful"
Please write to the blog author and share your success story.
May 21, 2007
Here are some tips from Alexey's e-mail:
- questions were from all topics of the Oracle Tutor document, so studying only the Labs are not enough....
- there were many questions about Items, Transactions, Controls, Cycle Counts
- only few about Forecasts, Physical Inventory, Kanban qne ATP
- almost all questions with multi-choices have more than one correct answers
- most questions have several sentences of description, so one needs time to understand what is question about....there were even 2 questions with information on 2 pages!
- there were many scenario based question on what you should to do or what will be the next step in the situation"
Many congratulations to the ever increasing number of successful OCP candidates!
Please write in if you have passed all the exams in a specific track to be announced as one of the world's first OCP. This blog would like to feature each one of you and your success.
May 20, 2007
- exam was fully based on the appplication of fundamentals
- 90% of the questions were was scenario based with some straight forward questions too
- question on steps to be followed to implement approval hierarchies
- question on setups
- question on workflow
- questions on iSupplier, iProcurement
- question on which accounts are defined in which forms"
May 16, 2007
He shares his exam experiences with blog readers worldwide:
" More than 80% of the questions had multiple correct answers which makes it very difficult to score....
Here are some of the topics that I encountered:
- based on a business scenario was asked to select which type of purchase orders would be created
- ways to send PO to suppliers without third-party software
- questions on sourcing
- question on receiving inventory
- question on pay on receipt functionality
- question on line types in requisitions
- steps for setting up position hierarchy
- scenario based question on receiving tolerance and invoice tolerance
- what fields need to be same for requisition line consolidation
- question on purchase price variance
- where are receiving options are defined
- how requisition can be deleted
- scenario based question on item class
- questions on direct and hierarchy method of approval routing
- question on conditions will make RFQ required profile option raise warning
- quesiton on item attributes that would prevent creation of a PO (e.g. item not active, not purchasable etc.)
- question on quantity rounding
- scenario where amount in payables clearing account is increasing
- form where receiving clearing account is defined............"
Many thanks for the tips.
This would surely be helpful for future test takers.
Hopefully, other blog readers would follow suit and share their test-taking experiences.
May 14, 2007
Many candidates had appeared for 1Z1-231 Implement Oracle Workflow 11i and 1Z1-232 Oracle 11i System Administration exams which are now available as separate Oracle Certified Expert certification. Oracle has taken the praise-worthy decision to provide free exam vouchers against each of the exams (1Z1-231 and/or 1Z1-232) that one appeared, irrespective of whether one passed the exam or not!
A free voucher would allow one to take an exam in the Oracle 11i Applications Database Administrator path at no cost, if one chooses to pursue this path. Of course, if one passed the beta exam, then one will receive the appropriate Oracle Certified Expert Program success kit in the mail soon. Well, the blog author is eagerly waiting for his success kit to arrive!
May 11, 2007
The mail network would be clogged with these documents. Also, it would infringe the CSI agreement since the patches are password protected and available only for download to licensed customers or partners.
Here's a quick reference of the patches relevant to each 11i OCP exam:
1Z0-200 11i E-Business Suite Essentials for Implementers - 4098726
1Z0-211 Oracle General Ledger 11i Fundamentals - 4578040
1Z0-212 Oracle Payables 11i Fundamentals - 4928633
1Z0-213 Oracle Receivables 11i Fundamentals - 5234582
1Z0-222 Oracle Purchasing 11i Fundamentals - 4578110
1Z0-221 Oracle Inventory Management 11i Fundamentals - 4578057
1Z0-223 Oracle Order Management 11i Fundamentals - 5234582, 5234682, 4141031
1Z0-231 Impement Oracle Workflow 11i - 5234642
1Z0-232 Oracle 11i Systems Administrator - 4578043
1Z0-233 Oracle 11i Install, Patch and Maintain Applications - No Tutor docs found
May 9, 2007
"For the past 2 years I have been working pimarily on Order Management. For the Inventory OCP exam, I had studied from the Tutor documents and the user guide.
One thing is very important which I felt after taking the test was that one should complete all the hands on practice mentioned in the Tutor documents.
One should also try lots of possible combinations possible while doing the lab excercises to see what functionality is available and even what errors one encounters.
Most of the questionss were scenario based and asked about how one should go about implementing when a business requirement is mentioned. For example - ABC company wants to do something in Oracle Inventory in a certain way? Which of the following solutions is best suited for it? There were four to six choices to select from".
Many congratulations to Arup S. and others who have been successful in their respective OCP tests. Please share your test taking experiences and sample questions with our readers.
May 8, 2007
OPN members are entitled to a 25% discount without the above mentioned limit. To request discount vouchers, send an email at least 5 business days prior to one's potential exam date, to one of the email ids:firstname.lastname@example.org (for EMEA region) and email@example.com (for rest of the world)
Email Subject: 25% or 100% Voucher Discount Request
OPN PIN Number
Employee Name (Format as First Last Name)
Prometric Testing ID Number (Required only if one has completed at least one OCP exam)
Date of Planned Exam Appointment
Exam Title and Number (Since one has not scheduled the exam appointment, include the planned exam number and title.
Exam Location (including country, details of exam centers can be found at www.prometric.com)
May 5, 2007
Please find below his test taking experience that I reproduce almost verbatim:
" I took the GL OCP exam last week and passed!
Basically almost all the questions are scenario-based and makes you think if folks without implementation experience would be at a slight disadvantage. Some of the topics that the questions covered were as follows:
Summary accounts - around 3 questions
Set of books related - around 4 questions
Multiple reporting currency - around 3 questions
Elimination sets in consolidations - around 3 questions
Profile options relating to consolidations
Order of closing the various modules
Using summary accounts in mass allocations
Budget and budget organizations
Various questions giving requirements and asking whether they can be satisfied by the Oracle GL or not. None of the questions are straight forward "Yes" or "No" answers. Mostly, they give a one or two paragraph scenario and ask you to find the right answer from the multiple answers. A lot of the questions will test your knowledge of more than one area of the GL. For eg. there were questions which combined your knowledge of SOB, MRC and document sequencing".
Finally, there was a piece of advice for the blog author too!
" Lastly, I think you are doing a good job by creating this OCP blog but I do have to point out that the GL practice questions you have on your blog are too simple and straightforward compared to what you will face in the actual exam !!"
Heartiest congratulations to Balaji and numerous blog readers from all across the world who have tamed the OCP & OCE dragons recently.
May 4, 2007
I must confess that new readers might find it difficult searching for relevant information like a 'needle in the haystack'.
Please use the search feature on the top left-hand corner.
Enter your search keyword and click on the 'SEARCH BLOG' button
All the posts with the keyword one entered would then be displayed.
May 3, 2007
Congratulations to all our blog readers worldwide for this achievement. Please continue to visit us daily and leave useful comments on the blog.
Once again may I please request blog readers to share their 11i OCP test taking experiences. One may e-mail me directly at firstname.lastname@example.org with sample questions** and tips for future test takers. I promise to acknowledge all contributions!
(** As per OCP exam code of ethics one may not share actual questions but similar nature of questions may be shared as pointers)