Requisition Wizard

 “The Requisition Wizard tool has provided us with a cost effective and efficient way to process hundreds and thousands of requisition lines in minutes instead of hours and days. The flexibility and usability of the MS Excel based tool has provided us with an effective way to manage our RFQ/Quote/REQ and PO process within 1 spreadsheet per Renovation Project..."

Brian Lezak
Oracle Procurement Lead – The Red Roof Inn Project
02 Works Consultant

Requisition Wizard is an Excel based front-end for the Oracle Requisition Interface. It simplifies and speeds up the process of entering Requisitions into Oracle Purchasing, while providing in-built validation to ensure accuracy.

The program contains all the validation and defaulting rules of the Oracle forms plus the Template and bulk-loader capabilities made possible by our popular spreadsheet model. You can download existing data from Oracle as the basis for your new Requisition, and employ all the usual features of Excel to help prepare your data.

Benefits

  • Increases productivity and accuracy
  • Fast, easy to use and flexible
  • Harnesses the full power of Microsoft Excel to make Requisition data entry tasks a breeze
  • Configures itself to your system set up
  • Easy to customize
  • Cuts down data entry time
  • Eliminates re-keying errors
  • Robust integration between Excel and Oracle
  • Close to zero implementation effort

Features

  • Optional Data Entry forms, which include data validation and full List of Values capability
  • Can use formulas in place of values
  • Customize your view of some LOV items to restrict usage
  • Use multiple sheets and even operate on sheets in other workbooks
  • Download template, requisition, quotation or purchase order information into your worksheet
  • Sourcing options available to keep data input to a minimum
  • Load one, a selected range, or all Requisition Lines on the worksheet
  • Delete individual Requisition Lines, Distributions or Batches from the interface tables based on the Interface ID and Dist ID column values
  • Submit Requisition Import from the toolbar and refresh the upload status with Oracle's messages

    • This product uses the standard Requisition Interface tables. Installation can be performed in minutes by your DBA.

    Compatible with Microsoft Excel 2000 and later versions, on any operating system.  Connects to Oracle E-Business Suite from Release 11i onwards, on any platform.