June 19, 2007

Solution Key for 1Z0-222 Purchasing Fundamentals 11i Mini-Mock Test

Please find below solution key for 1Z0-222 Purchasing Fundamentals 11i Mini Mock Test.To measure your preparedness for the OCP exam, please review number of questions you have correctly answered.

Based on the difficulty of the mock test questions, here'a a scale to measure your performance:
More than 21 correct answers: Why are you delaying taking the exam?
17-21 correct answers: A revision or two and you are ready for the exam
12-17 correct answers: Not ready for prime time yet
Less than 12 correct answers: Practice makes perfect. Scale your efforts even higher



=====================================================================
1Z0-222 Purchasing Fundamentals 11i Mini-Mock Test Solution Key
=====================================================================

Question #1: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: 3-Duplicates a requisition
[b] Withdraw: 5-Retracts a requisition from its position
[c] Receive: 4-Performs receiving
[d] Cancel: 1-Nullifies a requisition
[e] Resubmit: 2-Submits a requisition again

Question #2:Which are not one of the options to designate a supplier site use:
[c] Secondary Pay
[d] Procurement


Question #3:Choose the correct sequence of steps for the step-by-step checkout: 1-Notes 2-Delivery 3-Approvers 4-Review & submit 5-Shopping cart 6-Billing
[c] 5-2-6-1-3-4

Question #4:Select the critieria needed for requisitions that have automatically created blanket release:
[b] release must be within the limits of the agreement
[c] source agreement must still be active
[e] source items from a single supplier must use a single BPA


Question #5:Potential Duplicate Suppliers can be identified by which of the following methods:
[b] Perform a Find or query on the supplier name
[d] Review the Supplier Audit Report
[e] Submit the 1099 Suppliers Exception Report


Question #6: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

Question #7:Match the PO document security level with their description (e.g. c-2, d-1 etc)
[a] Private: 4-Only the document owner and subsequent approvers can access the document
[b] Purchasing: 3-Only the document owner, subsequent approvers, and individuals defined as buyers can access the document
[c] Hierarchy: 1- Only the document owner, subsequent approvers, and individuals above the document owner in the security hierarchy can access the document
[d] Public: 2-All system users can access the document


Question #8: Reason for having realms in iProcurement home page is to:
[c] limit the view of the requester



Question #9: By using the shop supplier sites option in iProcurement home page, you can:
[c] directly shop for items from a supplier web site
[d] search the external catalogs
[e] select the item you want to buy


Question #10: Select the features of the sourcing rules:
[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


Question #11: Select the functions of an imported catalog:
[a] ordering an item that is seldom required
[b] including items that are priced dynamically
[e] ordering items that are not present in the internal catalog

Question #12: Identify the functions of an internal catalog
[b] offers quick information search
[d] provides accurate product description
[e] eases ordering of items
[f] can be independently used by the staff
[g] offers multilevel search


Question #13: Identify when an information template is used:
[b] when an item has unique information each time it is requested


Question #14: 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


Question #15: 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

[d] clears the item contents after checkout
[f] automatically recalculates the requisition total


Question #16: Automatic PO creation process allows for the following:
[a] Previous goods and services to be reordered in a touchless process


Question #17: Identify the advantages of using Oracle iProcurement and iSupplier Portal
[a] Centralized sourcing, approval routings and payments
[c] Suppliers can review their own information
[e] Paperless flow through entire procurement cycle
[f] All functions performed through Internet browser


Question #18: Select the benefits of having a BPA:
[a] Allows a long-term supplier agreement
[d] Identifies effective date and end date of the agreement
[f] Documents the characteristics and prices of the items


Question #19: Match the setup to the corresponding Options form window (e.g. a-1, b-2 etc)
[a] Use Multiple Currencies: 3-Payables Option
[b] Next Automatic Number for Supplier Numbering: 4-Financials Option
[c] Requisition Numbering: 1-Purchasing Option
[d] Receipt Routing method: 2-Receiving Option

Question #20: Match the accounts with the form where it is defined (e.g. a-1, b-2 etc):
[a] Clearing Account: 2-Receiving Option
[b] AP Liability Account: 3-Financials Option
[c] Rounding Account:4-Payables Option
[d] AP Accrual Account: 1-Purchasing Option

Question #21: Match the Requisition type to their description (e.g. a-1, b-2 etc):
[a] Urgent requisition: 3- They appear prioritized in the requisition pool
[b] Emergency requisition:4- They reserve PO number prior to its creation
[c] Catalog requisition: 2- Used to order items from the unified catalog
[d] Non-catalog requisition:1- Used to order items unavailable in the product catalog


Question #22: Match Approval Level (2, 3 or 4-way) can be defined in which of the following windows:
[a] Purchasing Options
[c] Supplier window
[d] Item window
[e] PO Shipments window


Question #23: Arrange the period close processes in the correct order (e.g. 1-a, 2-c, 3-d etc)
1- [c] Post all receipts
2- [b] Review Uninvoiced Receipts report
3- [a] Process period-end receipt accruals
4- [g] Close the purchasing period
5- [d] Process remaining inventory transactions
6- [e] Run Accrual Rebuild Reconciliation Report
7- [f] Write off accrued transactions as necessary
8- [h] Create manual journal entry for write-offs

Question #24: Which of the following modules are part of Oracle's Advanced Procurement solution:
[a] Oracle iProcurement
[b] Oracle iSupplier Portal
[c] Oracle Purchasing
[e] Oracle Sourcing
[f] Oracle Procurement Contracts



Question #25:Match the receipt processing method with its description (e.g. a-1, b-2, c-3 etc):

[a] Unordered receipt: 1-Receive items when you do not know the corresponding PO number
[b] Standard receipt: 3-Recieve one line at a time
[c] Cascade receipt: 2-Recieve using one receipt of multiple shipments of the same item
[d] Express: 4-Receive multiple lines at a time, e.g. entire PO

June 17, 2007

Solution Key for 1Z0-211 General Ledger Fundamentals Mini Mock Test

Blog readers who are appearing for the 1Z0-211 General Ledger Fundamentals 11i exam must have found the mini-mock test interesting. Here's the solution key to the mock test. One needs to have scored 80% or more correct answers in this mock test to be reasonably confident of a successful attempt for the actual OCP exam. Best of Luck!

Question #1: Select the tasks that one would do for Revaluation
[b] Check the status of the foreign currency receivable and post it to the appropriate account
[d] Define an unrealized loss or gain account before running revaluation
[e] Define a revaluation rate for each currency by period before running revalutation
[f] Revaluate the B/S accounts that are denominated in a foreign currency as per SFAS 52 US
[g] Post the JEs

Question #2: Sequence the steps of the budget accouting cycle (e.g. 1-A, 2-B)
1-B: Define Budget Period
2-C: Enter Budget Amounts
3-E: Review and Correct Budgets
4-A: Freeze Budgets
5-D: Report on Budgets

Question #3: Which profile option descriptions are not correct?
[c] Journals: Find Approver Method specifies whether preparers can approve their journal batches
[f] Journals: Allow preparer approval specifies the default preparer for the journal approval process

Question #4: Which steps would you perform for currency conversion?
[a] Use spot, corporate, user, EMU fixed or user-defined conversion rate to assign to a rate
[c] Define the daily rates to convert the entered foreign currency to a functional currency
[d] Specifiy a foreign currency, conversion rate and conversion rate type to display the daily rates[e] Enter daily rates after defining conversion rate types


Question #5: Which setup steps would you follow for configuring journal approval functionality?
[a] Define authorization limits for employees in journal authorization limits window
[b] Enable jounral approval, specify journal sources, and create approval hierarchy
[d] Setup workflow and set GL profile options

Question #6: Select the tasks to be performed for Translation
[a] Translate actual and budget balances from functional to foreign currencies
[b] Enable average balance processing to translate average and standard balances
[c] Re-enter the period-end and period-average exchange rates for which you want to retranslate
[d] Use account or net activity to translate historic rates
[f] Perform retranslation if you post additional JEs

Question #7: Which of the following are not features of the Budget Wizard?
[a] Facilitates simple data entry and modeling only in a connected environment
[c] Requires you to justify or explain your budget using external documentation

Question #8: Which of the following is true for a Budget Organization?
[a] Allows one to freeze budget of an organization even if the work on data of other budget organizations is not over
[c] One can identify budgets that exceed control limits
[e] One can inquire and report on data
[f] One can divide the budget of an organization into different budget ranges
[g] One can perform top-down budgeting

Question #9: Which of the following is not a true statement regarding Multi-currency feature
[d] Comprises only a single SOB
[e] Translates foreign currency financials statements and reports

Question #10: Which among the following can be a Journal Entry Source?
[a] Inventory
[b] Projects
[d] Work in Process
[f] Cost Management
[g] Fixed Assets

Question #11: A company has the following account segments and values - Company: (01 - US and 02 - CAD), Department: (101- East and 102- West), Account: (4000- Parent Value, 4001- Revenue Prod A, 4002- Revenue Prod B), and Rollup Group = Revenue To create summary accounts to reflect total revenue for each company, all departments, what summary template needs to be defined?
[d] D-T-Revenue

Question #12: Which of the following are wizards provided as part of Applications Desktop Integrator (ADI)?
[b] Analysis Wizard
[c] Budget Wizard
[d] Report Wizard
[e] Journal Wizard


Question #13: Choose valid period statuses for an accounting period
[b] Closed
[c] Future Enterable
[e] Open
[f] Permanently Closed

Question #14: Which among the following is not a recurring journal type?
[c] Basic

Question #15: Which tasks can be performed using the Consolidation Workbench?
[b] Transfer data of multiple subsidiaries simultaneously to the parent SOB by consolidating balances
[c] Create consolidation mappings to consolidate a subsidary SOB with the parent SOB


June 16, 2007

Oracle 11i OCP E-Business Course Waiver Ends

For those who completed Oracle 11i OCP certification on one or more tracks by May 31, 2007 the E-Business Suite Hands-On Course Requirement was waived

One must submit the Hands On Course Requirement Waiver Form by July 31, 2007. Please go to the Hands On Course Requirement Form for submission.

For those who are yet to complete the certification, please review the the list of approved courses for Financials and Supply Chain OCP tracks:
11i Advanced Pricing Fundamentals
11i Advanced Supply Chain Planning Fundamentals
11i Asset Management
Fundamentals
11i Balanced Scorecard
11i Bills of Material and Engineering Fundamentals
11i Demand Planning Fundamentals
11i eBusiness Suite Essentials for Implementers
11i Enterprise Asset Management Fundamentals
11i General Ledger Management Fundamentals
11i Implement & Use Cash Management **
11i Implement Configurator
11i Implement Daily Business Intelligence
11i Implement Internal Controls Manager
11i Inventory Management Fundamentals
11i iProcurement Fundamentals
11i Oracle Warehouse Management Fundamentals
11i Order to Cash Fundamentals
11i Payables Fundamentals
11i Project Billing Fundamentals
11i Project Costing Fundamentals
11i Project Foundation Fundamentals
11i Project Management Fundamentals
11i Purchasing Fundamentals Ed 1
11i Oracle Receivables Fundamentals

Most of the above courses are of 3 to 5 day duration.
The one marked with "**" is a one day course for those who want to fulfill the critieria and also be easy on their wallet!

June 6, 2007

More Tips for 1Z0-233 Oracle 11i Install, Patch and Maintain Applications exam

One of our blog readers, Austine K., recently wrote the 1Z0-233 Oracle 11i Install, Patch and Maintain Applications exam successfully. Many congratulations!
Austine shares exam experiences with blog readers worldwide:
"
I appeared for the exam last week and passed it quite comfortably...
- need to mention that i've had substatial exposure to Oracle 11i which came in handy
- agree with the other reviewers that most of the exam questions are scenario based
- questions were asked on the following:
shared appl_top,
Rapid Clone and cloning procedure
Patching and patch management
- a big area to concentrate on is to know your navigation around the OAM pages
- OAM scripts, their purposes and where they reside.
- all in all, i think the exam was a very balanced one and well crafted
- one may get wary of the long scenario based questions, with exhibits and the 'Choose all that
apply' kind of questions that are time consuming but hey, they turn out to be the easiest questions. Trust me."

June 3, 2007

Blog Reader Authors Oracle Metalink Note

On Oracle Metalink, a new feature has been introduced called "The Customer Knowledge Exchange" which provides a channel for customers to showcase their expertise and to share their knowledge about Oracle products.
One of our regular blog readers, Patrick G, happened to read the April 4, 2007 posting - "Win $5000 in prizes from Oracle Metalink" and decided to try his luck!
Read Metalink Note ID: Note:423540.1 on "How We Changed the User Interface of Internet Expense to Accommodate our Corporate Look and Feel"
Many congratulations to Patrick for being featured on Oracle Metalink.

Our OCP blog community is very proud of your achievement and recognition.
Let Patrick have the last word: "Who says reading your blog does not pay" !

June 1, 2007

Mini Mock Test for 1Z0-211 General Ledger Fundamentals 11i

It's time again to offer another mini mock test to blog readers worldwide!
This time the questions relate to 1Z0-211 General Ledger Fundamentals 11i exam that one has to take to qualify as OCP for the Oracle 11i Financials Consultant track.


The actual test would have about 75 questions to be answered in 90 minutes. I have provided 15 questions for the mini mock test. If one wants to time the test, take about 15 to 20 minutes to answer the questions, not more.

Question #1: Select the tasks that one would do for Revaluation
[a] Specify the square of the period-end rate as the revaluation rate
[b] Check the status of the foreign currency receivable and post it to the appropriate account
[c] Reverse the journal at the end of the next period
[d] Define an unrealized loss or gain account before running revaluation
[e] Define a revaluation rate for each currency by period before running revalutation
[f] Revaluate the B/S accounts that are denominated in a foreign currency as per SFAS 52 US
[g] Post the JEs

Question #2: Sequence the steps of the budget accouting cycle (e.g. 1-A, 2-B)
A: Freeze Budgets
B: Define Budget Period
C: Enter Budget Amounts
D: Report on Budgets
E: Review and Correct Budgets

Question #3: Which profile option descriptions are not correct?
[a] Journals: Default category option specifies the default category for manual JEs
[b] Journals: Enable Prior Period Notification notifies when you enter a journal for a prior period
[c] Journals: Find Approver Method specifies whether preparers can approve their journal batches
[d] Journals: Allow multiple exchange rates option enables multiple conversion rates within a JE
[e] Journals: Mix Statistical and Monetary option allows you to enter statistical and monetary amounts in same line
[f] Journals: Allow preparer approval specifies the default preparer for the journal approval process
[g]Journals: Override Reversal Method option enables you to override the specified default reveral method

Question #4: Which steps would you perform for currency conversion?
[a] Use spot, corporate, user, EMU fixed or user-defined conversion rate to assign to a rate
[b] Calculate inverse rates from the entered rate
[c] Define the daily rates to convert the entered foreign currency to a functional currency
[d] Specifiy a foreign currency, conversion rate and conversion rate type to display the daily rates
[e] Enter daily rates after definimg conversion rate types
[f] Enter daily rates before entering currency

Question #5: Which setup steps would you follow for configuring journal approval functionality?
[a] Define authorization limits for employees in journal authorization limits window
[b] Enable jounral approval, specify journal sources, and create approval hierarchy
[c] Configure journal approval process in Oracle GL
[d] Setup workflow and set GL profile options

Question #6: Select the tasks to be performed for Translation
[a] Translate actual and budget balances from functional to foreign currencies
[b] Enable average balance processing to translate average and standard balances
[c] Re-enter the period-end and period-average exchange rates for which you want to retranslate
[d] Use account or net activity to translate historic rates
[e] Define historic rates after running translation
[f] Perform retranslation if you post additional JEs
[g] Run translation before completing journal activity for the period

Question #7: Which of the following are not features of the Budget Wizard?
[a] Facilitates simple data entry and modeling only in a connected environment
[b] Automatically builds a budget spreadsheet based on the budget and budget organizations setup
[c] Requires you to justify or explain your budget using external documentation
[d] Allows entering new budget balances manually, use budget rules, or use formulas and models
[e] Automatically calculates budget amounts using formula
[f] Enables downloading existing budget balances from Oracle GL or to create a new budget

Question #8: Which of the following is true for a Budget Organization?
[a] Allows one to freeze budget of an organization even if the work on data of other budget organizations is not over
[b] One can setup separate budget organizations for different account ranges
[c] One can identify budgets that exceed control limits
[d] Requires deleting all account assignments if you want to delete budget organizations
[e] One can inquire and report on data
[f] One can divide the budget of an organization into different budget ranges
[g] One can perform top-down budgeting

Question #9: Which is of the following is not a true statement regarding Multi-currency feature
[a] Can enter transactions and report in any currency
[b] Enables one to perform remeasurement and revaluation
[c] One can perform currency conversion online and in real time
[d] Comprises only a single SOB
[e] Translates foregin currency financials statements and reports
[f] One can review entered, converted and translated balances
[g] Uses MRC for processing transactions

Question #10: Which among the following can be a Journal Entry Source?
[a] Inventory
[b] Projects
[c] Service Contracts
[d] Work in Process
[e] Order Management
[f] Cost Management
[g] Fixed Assets

Question #11: A company has the following account segments and values - Company: (01 - US and 02 - CAD), Department: (101- East and 102- West), Account: (4000- Parent Value, 4001- Revenue Prod A, 4002- Revenue Prod B), and Rollup Group = Revenue To create summary accounts to reflect total revenue for each company, all departments, what summary template needs to be defined?
[a] T-D-Revenue
[b] D-D-4000
[c] T-T-Revenue
[d] D-T-Revenue
[e] D-T-4000

Question #12: Which of the following are wizards provided as part of Applications Desktop Integrator (ADI)?
[a] Revenue Wizard
[b] Analysis Wizard
[c] Budget Wizard
[d] Report Wizard
[e] Journal Wizard
[f] Account Wizard

Question #13: Choose valid period statuses for an accounting period
[a] Not Opened
[b] Closed
[c] Future Enterable
[d] Partially Closed
[e] Open
[f] Permanently Closed

Question #14: Which among the following is not a recurring journal type?
[a] Standard
[b] Formula
[c] Basic
[d] Skeleton

Question #15: Which tasks can be performed using the Consolidation Workbench?
[a] Track changes in account balances of parent SOB
[b] Transfer data of multiple subsidiaries simultaneously to the parent SOB by consolidating balances
[c] Create consolidation mappings to consolidate a subsidary SOB with the parent SOB
[d] Create consolidation sets to transfer multiple transactions of a subsidiary in a single step

Enjoy the practice!

Click Here For The Solution Key