top of page

Greatly improve Oracle data entry with Excel

API Wizard - Purchase Orders Fusion 01.png

Over 300 ready-to-go Excel Loaders

for Oracle Fusion Cloud Apps and Oracle EBS

Users save significant time and effort

Key API Wizard Capabilities

Data Entry

Data Maintenance


Data Accuracy

Duplication Avoidance

Pre-validation Engine

Transformation Engine

Character Cleansing

Security and Control

Audit Trail



Pre-Built Processes


Process Builder

Excel interface to enter data into Oracle.  Simple, powerful, efficient.

Fast and easy. Scalable from one to hundreds of thousands of records.

Extract data from Oracle into Excel with sophisticated filters/options.

Ensures data is accurate, provides real-time error messages.

Superior data duplication avoidance, including fuzzy logic analysis.

Seamlessly integrates business rule validations.

Easily transform data during entry and update.

Remove unwanted characters, such as spaces, tabs, etc.

Follows EBS, DB, and Cloud security and allows more granular control.

Advanced auditing options which provide far more detail than Oracle.

Allows additional control over who can enter / approve data changes.

Sophisticated compression technology for absolute fastest loading.

Over 300+ pre-built Loaders for common business processes.

Sophisticated authoring tool to build Loaders for any need.

With over 300 Excel tools, API Wizard is the most comprehensive solution for Oracle

API Wizard is fast

and accurate

What is the cost of bad data?

Gartner indicates that the average financial impact of poor data quality is $9.7 - 14.2 million per year per organization (Jan 9, 2017).

IBM says bad data costs $3.1 trillion per year, across the United States (IBM 2016).

Experian says, on average, 32% of U.S. company data is bad (Experian 2013).

API Wizard provides data accuracy, validation, and duplication avoidance tools that are much more sophisticated than anything Oracle provides.  When using API Wizard, you'll not only process your data faster but it will also be more accurate, which provides significant additional value to the enterprise.

Learn more

Data processing videos
Process List Image with updated message.

Watch the videos below to learn more about API Wizard

These videos are examples, there are thousands of processes you can perform in API Wizard!

Anchor Data Loading Videos

Vendor Site Update

This is a very simple example of using API Wizard for a granular, purpose built process.  API Wizard offers the flexibility to have simple Loaders like this or more full-functionality Loaders depending on your process requirements.

In Oracle, vendor site updates are super-tedious, forcing users to go in an out of vendors, change tabs, use the mouse repeatedly for each record to change.   In this example, see how quickly a vendor site update can be made across a large number of vendor sites in API Wizard!

Enable/Disable GL Code Combinations

In this example, see how we can query up a range of code combinations and then enable or disable them.  Working with a large range of combinations is quick and easy in API Wizard.  Compare this to the Oracle form, which doesn't provide a useful way to filter just the accounts you need to updated, only shows a few accounts at a time, and forces you to click and tab multiple times!  In Oracle forms, it's a painful and tedious process.  In API Wizard, it's a breeze.

Fixed Asset Adjustments

In this video, two use cases are presented.  The first is a simple example of just making changes to a couple of fields.  The second is a more involved use case using a Loader which has dozens of fields.  In both examples, an extraction report is used to pull existing asset info out of Oracle to make the adjustment process even easier!

Other common Fixed Asset processes performed in API Wizard are Additions, Mass Additions, Retirements, Reinstatements, Transfers, Unplanned Depreciation, and more!  Best of all, they are all super easy to use!

Create/Update Suppliers and Supplier Sites

Need an easy way to create and maintain Suppliers and Supplier Sites?  Here it is!  API Wizard makes supplier and supplier site creation and maintenance a breeze.  

In the Oracle forms, this is one of the most tedious processes.  The form layout is confusing, there are many tabs, each with sub-tabs.  It creates a data entry nightmare.  In API Wizard, it's super-simple!!!

Organizations find this process so useful, it often leads to a data cleanup that wasn't possible before API Wizard.

Inventory Items and BOMs

In this example, we will first use API Wizard to create Items (there are tons of options here but that's for another video) and then use those items that we just created to create a new BOM.  

The Item process is so much easier than working in Oracle forms (where you have to pick an inventory org, drill into a form with a dozen tabs).  The BOM process is also vastly superior to Oracle forms, particularly if you have BOMs with more than just a few components, which get unwieldy in Oracle but are easy to work with in API Wizard.

Item Min/Max Update

This example shows how easy it is to make item updates across a range of items and inventory orgs.  In this example, we are updating Min and Max but you can update whichever fields you want and as many or as few fields as you want.  Common mass updates we see customers make are to Default Buyer (when a buyer leaves), item accounting, min/max and other planning fields, descriptive flexfields, item descriptions, and more! 

What ever you need to update, you can do it drastically faster and easier than you can with the Oracle forms!

Create and Update EBS Responsibilities

API Wizard makes working with Oracle EBS user and responsibility functions much easier than working in Oracle forms.  IT help desks can reset Oracle passwords without having the bother of logging into the Oracle forms (a several minute ordeal in and of itself). 


Easily add, activate, or inactivate users and responsibilities.  

Don't let your IT team members be data entry clerks, give them a tool that makes this tedious work easy!

Customer (Vaisala) Testimonial

In this customer testimonial, Vaisala, an environmental and industrial measurement product manufacturer based in Finland, describes the benefits their organization receives using API Wizard and details how they initially started with a 5-user license and a handful of processes and later upgraded to an enterprise license and implemented a global rollout of API Wizard for several Oracle business processes.  

Bill of Materials

If there is a more tedious process in Oracle, we're not sure what it is.  The standard Oracle form only shows 7 components of a BOM at a time, which makes it virtually useless for anything but very simple BOMs.  With API Wizard, working with BOMs, even large ones with hundreds or thousands of components, is ridiculously easy.

This video demonstrates the use of an extraction report used both when updating an existing BOM as well as using an existing BOM as a template for creating a new BOM.  

Customer Testimonial - Sleepy's

In this Customer Testimonial, Sleepy's, one of the world's leading mattress providers, discusses the significant improvements that API Wizard has made to their organization.

Additionally, Sleepy's highlights how easy to use API Wizard is, as well as the outstanding support they received from the API Wizard staff, which helped Sleepy's solve multiple Oracle challenges across the enterprise.

Looking for a different process?  There are thousands of things you can do in API Wizard. 

Attend a demo or webinar to see your specific areas of interest.

Schedule a demo

There are many other things you can do with API Wizard

The samples on this page are meant to provide a high-level overview of what API Wizard can do.  This is a very small subset of API Wizard's functionality.

With over a hundred pre-built processes and thousands of APIs which API Wizard can work with, chances are it can do whatever you want!  

Schedule a demo to see any Oracle process performed better, faster, and more accurately using API Wizard.

Get in touch

bottom of page