API Wizard
The Oracle and Oracle EBS Productivity Platform
To see API Wizard in action, attend one of our webinars!
Speak to our experts about how API Wizard can significantly streamline data processing, improve reporting, and solve those pesky Oracle EBS challenges.

API Wizard provides a tremendous time savings to users by turning Microsoft Excel into the ultimate data entry, updating, and reporting platform for Oracle EBS.  Work that takes hours in Oracle can be reduced to minutes.   It also radically cuts development time for IT by providing the only tool in the market that works with public APIs and open interfaces with no programming, meaning you can configure rather than code and deploy awesome solutions in minutes.

API Wizard is a major breakthrough in how organizations work with Oracle.  The value proposition of API Wizard for users is based on time savings, improved accuracy, and better access to Oracle information.  The value proposition for IT is based on time savings, configuring rather than coding, giving users a better way to work with Oracle data, and reducing the ongoing IT support burden by providing solutions that don't require complex code.

API Wizard makes Oracle work easier and faster,  while improving accuracy and access to information.

Data entry in Oracle can be too slow and tedious.  Reporting tools don't always give you the information you need, in the way you need it.  Development cycles can be long and expensive.

API Wizard solves the Oracle inefficiency challenge once and for all by providing a better and more powerful way to create, update, and report on Oracle data using Excel as the user interface. 

Our customers use API Wizard to improve processes across Oracle, including day-to-day tasks, periodic tasks, and special projects.   API Wizard allows you to create, update, or report on transactional, master, or setup data.

API Wizard is the only tool in the market combining data entry and reporting using Microsoft Excel.

See an API Wizard demo (click link above) to see how it can help save you and your company time and money while improving your overall experience with Oracle.

API Wizard makes Oracle better!

A partial list of ways you can use API Wizard:
  • Receipt (cash) application
  • Creit/Debit Memos
  • Disputes
  • Applying/releiving holds
  • Supplier entry and updates
  • Supplier site entry and updates
  • Customer entry and updates
  • Customer address entry/updates
  • Bank entry/updates
  • Bank Statements
  • Payment batches
  • OM Orders
  • OM Quotes
  • OM Returns
  • Purchase Orders
  • Blanket POs
  • Receipts
  • Requisitions
  • Inventory item maintenance
  • Material Transactions
  • Replenishments
  • Physical inventory updates
  • Payroll
  • Project Transactions
  • Project Budgets
  • Time and expense
  • IB Transactions
  • Contracts
  • Sales leads
  • Sales reps
  • Commission (comp) plans
  • Comp Rate tables
  • Comp formulas
  • Comp expressions
  • Comp adjustments
  • Comp manual orders
  • Journal Entries
  • GL Accounts
  • User management
  • Value set values
  • GL Accounts
  • User management
  • Value set values
  • Journal Entries
  • Project Entry
  • Project Maintenance
  • HR Applicants
  • HR People
  • HR Employees
  • HR Assignments
  • Organizations
  • Business units
  • Legal entities
  • Operating units
  • Marketing campaigns
  • Comp workbench
  • Assets - creation/changes
  • Asset Retirements
  • Asset Transfers
  • Master lease agreements
  • Vendor lease agreements
  • Lease contracts
  • Lease maintenance
  • Collections
  • Credit Requests
  • Trading community
  • BOMs
  • BOM security rules
  • BOM Imploder/Exlpoder
  • Item Costs
  • Manufacturing routing
  • Service charges
  • Service Contracts
  • Warehouse mgmt
  • Catalogs
  • On-hand inventory balance
  • Pick release / wave
  • Transfer reservations
  • Inventory lots
  • Item categories
  • Item Types
  • Territories

This is just a small sample of what API Wizard can do.  With 2500+ APIs in R12, plus the ability to work with your internal APIs, it's virtually unlimited.  Whatever your requirement, you can solve it with API Wizard -- in minutes and without programming!

API Wizard is the only product of its class, unifying data entry, data updating, and reporting efficiency in a single enterprise application.


    API Wizard is the only product in the Oracle and Oracle EBS market which combines data entry, data updating, and reporting in a Microsoft Excel environment.  An enterprise-class product, API Wizard provides a single, unified platform for all of your Oracle work, providing the same efficient and user-friendly interface to anyone in the organization.  API Wizard's next-generation GUI based Integrated Development Environment gives IT a powerful but easy-to-use tool, while providing centralized control and following Oracle's development and security standards.

    API Wizard Data Entry and Updating

    It's a major breakthrough in how organizations work with Oracle.  Oracle forms are too slow and cumbersome, forcing you to tab through fields you don't use or navigate through menus and sub-menus.  Entering even a small amount of data can be time-consuming and tedious.  With API Wizard, you can perform the same exact process in Excel in a fraction of the time it currently takes, with the ability to easily process many records at a time in an environment that is streamlined for how you use Oracle.

    API Wizard works in every Oracle EBS module and with nearly any Oracle EBS processing, leveraging Oracle's huge inventory of public APIs and open interfaces. In R12 there are 2500+ public APIs. In R11.5.9/11.5.10 there are 1500+ public APIs.  API Wizard can also work with your custom APIs and third-party APIs.  The API Wizard productivity platform lets you perform essentially any business process from within Microsoft Excel.

    Learn more about data entry and updating

    API Wizard Reporting

    API Wizard allows you to report on 'live' data in Excel.  This is not an extract of data from Oracle which becomes static once it's in Excel, this is live, dynamic reporting which can be used across the EBS!  You can drilldown between reports, use reports to drive pivot tables, graphs, and complex analysis.  When you want to refresh your data, it just takes a click of the mouse.  It's a powerful and sophisticated reporting environment for Oracle.  API Wizard's reporting is also completely integrated with the data entry and updating functionality and can be used to extract data before updating and loading back into Oracle.

    Learn more about API Wizard reporting

    API Wizard Integrated Development Environment

    API Wizard provides a next-generation Integrated Development Environment (IDE) which allows IT to configure, rather than code, and build Excel based productivity solutions (for data entry, updating, and reporting) in minutes.  API Wizard dynamically works with Oracle's public APIs, open interfaces, as well as your custom or third-party APIs.  Work that would take days and require a formal SDLC process can be performed through a GUI configuration in minutes.  It helps IT get their work done faster and provide better, more economical, and more robust solutions.

    Learn more about using API Wizard as an IDE

    Why API Wizard?

    API Wizard is the only product that solves data entry, data updating, and reporting problems across the entire Oracle EBS, every module and business process, in one enterprise tool.  It combines the best of Oracle and Excel to save significant hours for your people and to help them make faster, well-informed decisions.

    Before they learned about and embraced API Wizard, our customers, like most Oracle shops, cobbled together a patchwork of different approaches to try and manage data processing pain.  After working with API Wizard, they’ve found it to be the solution that addresses all their needs, leading to standardization and simplification.

    Take a look at API Wizard and you’ll see how it can save time and effort for your people.  It’s the fastest and easiest way to get your data in and out of Oracle.

    Learn more:

    API Wizard has so much functionality, the best way to learn about how API Wizard can help your organization is to schedule a demo. An API Wizard demo takes about 40 minutes plus time for your questions.  See for yourself why our customers wouldn't think of going back to the old, tedious ways of working with Oracle.  Schedule a demo!