API Wizard FAQ, Your Questions Answered
Have Questions? We’ve Got Answers
Explore answers to common questions about using API Wizard with Oracle EBS and Oracle Fusion Cloud — from compatibility and installation to licensing and support.
General Questions
What is API Wizard?
API Wizard is a software company that offers a suite of Excel tools that integrate directly with Oracle Fusion Cloud and Oracle EBS. These tools enable secure, real-time data uploads, bulk data changes and reporting.
What ERP systems does API Wizard support?
Who typically uses API Wizard?
Technical & Installation
How is API Wizard installed?
For Fusion Cloud, the product is delivered as an Excel addin and is simply enabled within Excel (no install required).
For Oracle EBS, there is both an Excel addin and a server-side installation, which takes only a few minutes to deploy.
How long does it take to go live?
Most customers are live in 1–3 days. Cloud-only clients may be up within hours.
Is API Wizard secure?
Yes. API Wizard adheres to all Oracle security rules and roles and works over encrypted communications with no data leaving the customer environment.
Does it support SSO (Single Sign-On)?
Yes, we support SSO for both Fusion Cloud and EBS.
Functionality
Can API Wizard handle attachments?
What types of validations are included?
All standard Oracle validations are included plus the ability to add additional validations for business-specific rules.
Does it support custom fields like DFFs?
Yes. API Wizard templates can include DFFs, EFFs, and other client- specific fields, validated and uploaded securely.
Is it compatible with Oracle patches or upgrades?
Yes. API Wizard works dynamically with Oracle’s integration layer and automatically adjusts to Oracle patches and upgrades.
Licensing & Support
How is API Wizard licensed?
Flexible licensing based on number of users and modules. We offer enterprise and named-user models. Trials are available for evaluation.
Do you offer free trials?
Yes — we offer full-featured trial access for qualified prospects. Reach out to request your personalized setup.
What support is included?
API Wizard licenses include full-time support which can be accessed via phone, email, or web-based portal. Additional support for onboarding and enhancements can be added.
Is training available?
Yes. We offer user training, admin guides, onboarding sessions, and knowledgebase access.
Additional FAQs
Can I restrict which users have access to specific loaders or modules?
Yes. API Wizard allows role-based access control. Admins can define which users see which templates, modules, or Oracle responsibilities — ensuring compliance and separation of duties.
What happens if an upload fails? Can I review error logs?
Yes. All failed uploads return detailed error messages within Excel. API Wizard logs each transaction, showing what failed, why, and where — so users can correct issues and retry immediately.
Can I use API Wizard for mass updates as well as inserts?
Yes. API Wizard supports inserts, updates, and in some cases, deletions (where Oracle APIs allow it). This makes it ideal for data corrections, cleanups, and periodic updates.
Does API Wizard support multi-language environments?
Yes. The user interface and data templates can be customized to support multiple languages, and it respects Oracle NLS settings for number/date formats and labels.
Can API Wizard work in environments with custom Oracle APIs or personalizations?
Yes. In fact, API Wizard is commonly used to extend standard Oracle APIs, incorporate custom PL/SQL procedures (EBS), and work with custom tables (both Cloud and EBS). We also support tailored templates for custom business logic.
Does API Wizard work with Oracle’s REST APIs for Cloud?
Yes. For Oracle Fusion Cloud, API Wizard uses REST and SOAP APIs natively, depending on the module. It can be configured to use standard or custom endpoints securely.
What is the difference between API Wizard and Oracle's ADFdi or FBDI?
Unlike ADFdi and FBDI, API Wizard provides a governed Excel interface with real-time validations, template versioning, attachments, and user-level audit logs — reducing errors and improving productivity. (See comparison page)
Can I automate recurring data loads using API Wizard?
Yes. API Wizard supports automation for data creation, updating, and report execution.
How are upgrades to API Wizard handled?
API Wizard upgrades are lightweight and backward-compatible. We provide updated templates or server-side patches with minimal downtime. Cloud clients can opt into auto-updates.
Is API Wizard compatible with Citrix or remote desktop environments?
Yes. Many of our clients run API Wizard within Citrix, RDP, or VDI environments. We provide installation guidance for shared workspaces and multi-user setups.
Expert-Level and Strategic FAQs
Can API Wizard be used in a shared services environment with multiple business units or legal entities?
Yes. API Wizard is designed for shared services and supports data segregation by BU, Ledger, LE, and even region or country. You can configure templates and access rights accordingly.
Can I use API Wizard in a hybrid EBS + Cloud Oracle environment?
Yes. We support both Oracle EBS (11i/R12) and Oracle Fusion Cloud. If you’re transitioning, we can provide loaders that work across both systems during parallel runs and phased migrations.
How customizable are the Excel templates?
Highly customizable. You can add, remove, rename columns, include conditional logic, restrict LOVs, and even embed Excel formulas — without impacting Oracle validations or upload logic.
What kind of training is available for API Wizard?
We offer user onboarding, admin training, recorded tutorials, template design workshops, and live support during rollout. Most teams need minimal training due to the intuitive Excel interface.
Can API Wizard be deployed in a government or highly regulated industry?
Yes. We serve clients in defense, public sector, banking, and healthcare. Our on-prem deployment architecture ensures no data leaves your environment and supports strict access policies.
How does API Wizard handle rollback or undo for uploaded data?
While API Wizard ensures pre-validation, you can use its update capability to reverse or end-date records. In some cases, where Oracle allows, data can also be deleted.
Can multiple users upload data at the same time using API Wizard?
Yes. Our architecture supports concurrent multi-user access. Each session is authenticated and independent, with separate log files and upload queues to Oracle.
How is licensing impacted if we scale to more users or BUs?
Our licensing model scales flexibly. You can start with a core team and expand as needed — with volume discounts and enterprise options for large user bases or multi-entity environments.
What support is available outside business hours or internationally?
We offer global support coverage, with optional SLA-based priority support for clients with operations across time zones. Emergency escalation paths are also available.
Didn’t find what you were looking for?
Use the links below or reach out directly — we’re here to help.