Oracle Fusion SQL and BI Publisher.
One modern workspace.
Explore Fusion metadata, build and validate SQL, execute queries, and publish BI Publisher assets from one secure workspace.
Registration and email verification required.
Core Capabilities
Everything Oracle Fusion reporting needs
Write and Execute SQL
Author, validate and run Oracle Fusion SQL from a focused Query Studio workspace.
Browse Fusion Metadata
Search queryable objects, inspect columns and relationships, and open views in Query Studio.
Publish to BI Publisher
Create data models and reports, then run saved BI Publisher reports from Analytics Studio.
Organize Saved Queries
Keep reusable SQL organized by workspace and module for quick access.
Validate Against Metadata
Check SQL against the Fusion metadata catalog before publishing or sharing.
Run Saved Reports
Execute saved BI Publisher reports, review parameters, and retrieve results.
How It Works
Five steps to production reports
Connect
Securely connect to your Oracle Fusion Cloud instance
Explore
Browse Fusion views and columns with full catalog search
Build SQL
Write SQL with intelligent validation against metadata
Execute
Validate and execute queries with parameter support
Publish
Publish data models and reports to BI Publisher
Product
Everything you need for Oracle Fusion SQL and BI Publisher
Move from metadata discovery to SQL execution and BI Publisher reporting in one focused workspace.
Write and execute Oracle Fusion SQL
Author SQL in Query Studio, validate it, run it against Oracle Fusion, and review results without leaving the workspace.
Browse the Fusion metadata catalog
Search queryable Fusion objects, inspect columns and relationships, and open selected objects directly in Query Studio.
Run saved BI Publisher reports
Manage saved reports, review report parameters, execute reports against Oracle Fusion and retrieve results from PRISM.
Security
Designed for enterprise security
PRISM is built with security at every layer — from encrypted credentials to isolated tenant data.
User-Private Connections
Each user's Oracle Fusion credentials are scoped and access-controlled.
Encrypted Credentials
All stored credentials are protected with industry-standard encryption.
Tenant Data Isolation
Complete data isolation between organizations in the Cloud edition.
Role-Based Access
Users access only the resources assigned to their role.
Secure BI Publisher Integration
Direct integration with Oracle BI Publisher over HTTPS.
Editions
Deploy your way
Choose the deployment model that fits your organization.
PRISM Cloud
Managed browser-based workspace. Start with a free 30-day trial — no infrastructure to manage.
PRISM Enterprise
Private or self-hosted deployment for organizations requiring greater infrastructure control.
PRISM Desktop
Single-user local edition for individual developers. Currently under development.
Coming SoonReady to get started?
Start your free 30-day Cloud trial and explore how PRISM streamlines Oracle Fusion reporting.