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 an Excel-based loader that integrates directly with Oracle EBS and Oracle Fusion Cloud. It enables secure, real-time data uploads — with validations, audit trails, and attachment support.
What ERP systems does API Wizard support?
Who typically uses API Wizard?
Technical & Installation
How is API Wizard installed?
API Wizard is delivered as an Excel add-in (XLA or VSTO file) and a small Oracle-side component (installed on your EBS or integrated via REST/SOAP APIs for Cloud). The setup is fast and doesn’t require significant system downtime.
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. It uses your Oracle credentials and honors Oracle’s data access rules, responsibilities, and business unit scopes. Data never leaves your system unless otherwise configured.
Does it support SSO (Single Sign-On)?
Functionality
Can API Wizard handle attachments?
What types of validations are included?
Validations include LOVs, dependent values, required fields, custom logic, and Oracle system checks (e.g., valid chart of accounts, periods, item categories).
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. Because we connect via supported Oracle APIs (PL/SQL or Cloud REST), updates to Oracle typically do not break our templates.
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?
All licenses include email + ticket-based support. Premium plans can include SLAs, onboarding help, and priority enhancements.
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 or incorporate custom PL/SQL procedures. We 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. While API Wizard is Excel-first, it also supports automation scripts (optional add-on) for recurring loads like FX rates, budget imports, or project tasks.
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 option 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, if errors slip through, you can use its update/delete templates (where Oracle permits) to reverse records. You can also audit uploads for precise rollback paths.
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.