Frequently Asked Questions

Common questions about ERPStudio, security, and deployment.

What is ERPStudio?

+

ERPStudio is an operations platform for Oracle ERP Cloud. It provides tools to build reports, query and load data, automate integrations, monitor processes, and maintain compliance — all powered by AI and secured by your existing Oracle credential vault.

What Oracle modules does ERPStudio support?

+

ERPStudio works with all Oracle Fusion Cloud modules including Financials, Procurement, Projects, Supply Chain, and HCM. It connects through Oracle's standard REST APIs, SOAP web services, BI Publisher, and Enterprise Scheduler.

How does the AI agent work?

+

The agent is trained on over 272,000 Oracle documents — REST API specifications, SOAP service definitions, database schemas, and BI Publisher data models. When you describe a task, it searches this knowledge base, determines the right approach, and executes through secure MCP (Model Context Protocol) servers connected to your Oracle environment.

Does ERPStudio store my Oracle credentials?

+

No. Your Oracle credentials remain in your OCI Vault. ERPStudio fetches them at runtime, holds them in memory only during execution, then discards them. Credentials are never written to disk, logged, or transmitted outside the execution context.

What is the environment pipeline?

+

ERPStudio supports separate Oracle environments — typically Dev, Test, UAT, and Production. Each has its own isolated MCP server with its own vault credentials. Work is promoted through these stages with approval gates. Dev environments allow direct execution; production always requires human approval.

Can ERPStudio replace our integration platform?

+

For many common Oracle integration patterns — data extraction, transformation, loading, and scheduled reporting — yes. ERPStudio provides a flow builder with step-by-step orchestration, cron scheduling, error handling, and webhook support. For complex multi-system enterprise service bus patterns, a dedicated integration platform may still be appropriate.

What about compliance and audit requirements?

+

Every action in ERPStudio is logged — tool calls, data changes, approvals, user sessions. The audit trail is immutable and exportable for SOX, ISAE 3402, and other compliance frameworks. Role-based access control ensures separation of duties between requesters, operators, approvers, and administrators.

How is ERPStudio deployed?

+

The platform runs on globally distributed edge infrastructure with automatic scaling. MCP execution servers can run on our managed infrastructure or be deployed within your own network perimeter. Both models maintain the same zero-trust credential architecture.

What happens during Oracle quarterly updates?

+

ERPStudio's AI knowledge base is updated with each Oracle release. Because the agent searches current documentation before acting, it adapts to API changes automatically. Existing automations should be validated against your test environment after each Oracle update — ERPStudio's pipeline makes this straightforward.

How do users interact with ERPStudio?

+

Business users submit requests (tickets) describing what they need — no Oracle knowledge required. Operators work those requests through the AI agent. Technical users can directly use the REST browser, FBDI loader, and flow builder. Everything is accessible through a web interface.

What data does ERPStudio process?

+

ERPStudio processes the data you explicitly query or load through your Oracle environment. The AI agent sees Oracle API responses during execution. Conversation history is stored for session continuity. No Oracle data is used for model training.

Is there a per-message or per-transaction fee?

+

No. ERPStudio uses a subscription model. There are no per-message fees, no per-API-call charges, and no minimum commitments on integration volume.