Oracle EBS Licensing · Independent Advisory · Customisation Risk Guide

Customised Database Technology – Oracle EBS: Identifying Full-Use Licence Triggers

Oracle E-Business Suite includes restricted-use database and middleware licences at no extra cost. But certain customisations, even seemingly small ones, can void that benefit and trigger full-use licensing requirements worth hundreds of thousands of dollars. This guide shows ITAM professionals how to identify, assess, and mitigate these risks.

Book a Confidential Call Oracle Advisory Services
Call us: +1 (239) 402-7397
$47,500
Oracle DB EE Per-Processor List Price: Triggered by Schema Customisations
3 Levels
Oracle's Customisation Tiers: From Zero Risk to Full-Use Requirement
$380K+
Potential Cost for 8-Core Server When Restricted-Use DB Licence Is Voided
22%
Annual Support on Top: Backdated From First Use if Discovered in Audit
Oracle Knowledge Hub Oracle EBS Licensing Guide Customised Database Technology: Full-Use Triggers

This guide is part of the Oracle EBS Licensing Guide series. Related EBS guides include EBS Licensing Basics, Licensing Oracle EBS Modules & Suites, and EBS Licence Compliance Checklist.

Customising an Oracle E-Business Suite (EBS) environment can deliver significant business value, but it can also generate hidden licensing costs that dwarf the original development effort. Oracle includes database and middleware licences with EBS, but only for restricted use. Cross that line, and you may be required to purchase full-use licences for Oracle Database Enterprise Edition and Oracle WebLogic Server at list prices that can reach hundreds of thousands of dollars.

This article explains how customised database technology in Oracle EBS can inadvertently violate licence rules, what to look out for, and how ITAM professionals can identify and mitigate these risks in global enterprises.

Understanding Oracle EBS's Included Technology Stack

Oracle EBS is bundled with essential technology components, the Oracle Database and Oracle WebLogic Server (middleware), under a restricted-use licence. When you purchase Oracle EBS application licences, you do not separately pay for a full Oracle Database or WebLogic licence to run them. Oracle provides these as part of the deal, but with strict conditions attached.

The included database and middleware licences can only be used to support the EBS applications you licensed. In practice, this is a significant cost benefit: you get the database engine and application server needed to run EBS without purchasing full-use licences upfront. However, the restriction is clear: using the database or middleware for anything beyond standard EBS is not permitted under the restricted-use grant.

Think of the included Oracle Database and middleware as EBS-only infrastructure. They are powerful tools given to you, but only to run standard EBS functionality. Any use beyond that scope, no matter how minor ("We already have an Oracle DB here, let us add another schema for a small app..."), can void the restricted-use benefit and trigger full-use licensing costs.

ComponentIncluded With EBS?RestrictionFull-Use List Price
Oracle Database EEYes (restricted use)EBS data only. No custom schemas or non-EBS applications.~$47,500/processor
Oracle WebLogic ServerYes (restricted use)EBS application tier only. No custom apps or third-party deployments.~$25,000-$50,000/processor
Oracle BI PublisherYes (limited)Standard EBS reports against EBS data only.Varies (per user or per processor)
Oracle Forms / ReportsYes (restricted use)EBS-delivered forms and reports only.Included in WebLogic full-use licence

Customisation Levels and Their Licence Impact

Oracle's EBS licensing policy defines three levels of customisation, each with increasing licence requirements. Understanding which category your organisation's changes fall into is critical for compliance.

Customisation LevelExamplesLicensing Impact
Level 1: No Modifications (out-of-the-box)Deploy EBS as delivered with no custom code or schema changes. Use standard Oracle-provided configuration options.No additional licences needed. Restricted-use DB and middleware cover all EBS usage.
Level 2: UI/Logic Extensions (reports, forms, Java code within EBS)Creating custom reports, altering forms, adding minor Java business logic using Oracle's extension tools (OAF, Forms Personalisation).Full middleware licence required. You must licence Oracle WebLogic for all users or processors. Database remains restricted use.
Level 3: Database Customisations (schema changes)Adding new tables, custom triggers, stored procedures, or an extra schema inside the EBS database for additional functionality.Full Oracle Database EE licence AND full middleware licence required. The "free" benefit is entirely voided.

Even moderate customisations escalate licence needs. Simply developing a custom workflow or report can force you to purchase an Oracle middleware licence (which was otherwise free under EBS). And if you go deeper and modify the database schema itself, the cost jumps dramatically. You effectively convert your "free" EBS database into a fully licensable Oracle Database instance. Oracle treats customised database technology in EBS as if you installed a separate Oracle product, and prices it accordingly.

Level 3 cost example. An 8-core server (4 processors after Core Factor 0.5): ~$190K DB + ~$100K-$200K WebLogic + 22%/year support on both. This was $0 under restricted use.

Database Modifications: When a "Free" Database Becomes Costly

Many enterprises enhance Oracle EBS by adding fields, tables, or triggers to tailor the system to business needs. While this can deliver functional benefits, it crosses a licensing red line when done in the EBS database itself.

Oracle's policy is explicit: if you add or modify any objects in the Oracle EBS database schema, a table, column, stored procedure, or trigger, you are no longer just using EBS. You are altering Oracle's database structure. This triggers the requirement for a full-use Oracle Database Enterprise Edition licence, along with the associated middleware licence for the application tier.

Real-world scenario: custom project management module triggers six-figure audit finding. A global enterprise developed a custom project management module, creating new tables and triggers in the EBS database to integrate with EBS Financials. The team assumed this was an efficient use of the existing system. During a routine Oracle audit, the custom tables were flagged. Oracle determined the company was using the database for custom applications beyond EBS. Audit finding: $380,000+ in unbudgeted licence costs, for a module that cost $50K to develop.

Oracle Database Enterprise Edition licences run ~$47,500 per processor at list price, and enterprises typically run EBS on multi-processor servers. An 8-core server (using Oracle's standard Core Factor of 0.5 for Intel/AMD) requires 4 processor licences: 4 x $47,500 = $190,000 just for the database. Add WebLogic full-use licensing and 22% annual support on both, and the total easily exceeds $380,000, costs that had been entirely avoided under the restricted-use grant.

ScenarioDB Licence CostWebLogic CostAnnual Support
Restricted use (no customisation)$0$0$0
After Level 3 customisation (16-core Intel server, CF 0.5 = 8 processors)$380,000$200,000$127,600/year
Avoid embedding standalone apps in the EBS database. If your business needs custom database tables or applications, deploy them on a separate Oracle database instance (with its own licence) rather than piggybacking on the EBS database. This keeps the EBS restricted-use licence intact.
Assess schema changes upfront. Before adding any table or trigger in EBS, involve your licence management team. Weigh the cost of a full-use licence against the benefits of customisation. In many cases, alternative solutions exist that do not violate EBS licence terms.

Middleware Extensions: Hidden Triggers for Full-Use Licences

Oracle EBS relies on Oracle's middleware (Oracle WebLogic Server) to run forms, reports, and application logic. Oracle includes a limited-use licence of this middleware for EBS's own needs. But using the EBS application server for anything other than its intended purpose is another licensing landmine.

ScenarioRisk LevelWhy It Triggers Full-Use
Custom Java app on EBS WebLogicHighDeploying a custom .war/.ear application on the EBS WebLogic domain means the middleware is hosting non-EBS software.
Third-party integration on EBS app serverHighAdding third-party applications (ETL tools, portals, connectors) to the EBS WebLogic for integration convenience.
BI Publisher accessing non-EBS dataMedium-HighUsing EBS-included BI Publisher to pull data from non-EBS sources or heavily customised schemas beyond standard EBS data.
Custom web services on EBS middlewareMediumExposing custom REST/SOAP services from the EBS WebLogic that serve non-EBS consumers.
Custom reports using new DB objectsMediumReports built on custom tables (not standard EBS objects) may trigger both middleware and database full-use requirements.

Real-world scenario: retailer's "stack share" strategy backfires in audit. A large retailer using Oracle EBS decided to host a custom employee portal application on the same Oracle WebLogic Server that runs EBS, reasoning it would save infrastructure costs. Oracle's auditors discovered the shared deployment. The finding: the embedded WebLogic licence is only for EBS modules, not an employee portal. The retailer had to obtain a full WebLogic Suite licence for the environment and pay licence fees retroactively. Result: $200K+ in WebLogic licensing costs. The supposed savings of consolidating apps evaporated instantly.

BI Publisher: a commonly overlooked trigger. Oracle BI Publisher is included with EBS in a limited capacity, to run standard EBS reports or slightly modified reports against the EBS schema. If you use BI Publisher on the EBS server to access any non-EBS data source or a heavily customised schema, Oracle requires a full-use BI Publisher licence. These smaller "middleware triggers" are easy to overlook but are equally subject to audit findings.

Keep EBS middleware dedicated. Treat the EBS application server like a silo: it should host only Oracle EBS-related applications and services. Set up a separate middleware server for custom apps, even if they could technically coexist.
Review integrations carefully. If you are integrating EBS with other systems, use supported integration points (interface tables, APIs) rather than deploying new components inside the EBS tech stack. This prevents accidentally turning a limited-use component into a full-use scenario.

Identifying Customisations and Compliance Risks

How can ITAM professionals proactively identify where customised database technology in Oracle EBS might be breaking the rules? Early identification is critical. Here is a step-by-step approach to find and address risky customisations in an enterprise EBS environment.

1

Inventory the EBS database schemas. Work with your DBAs to list all schemas and custom objects in the EBS Oracle Database. Compare them against a vanilla EBS installation or Oracle's documentation. Red flag: any schema or table that did not come with EBS (especially ones prefixed differently than standard EBS modules) indicates a custom extension that may trigger full-use licensing.

2

Scan for custom triggers and procedures. Check for custom triggers on EBS tables or stored procedures/packages that integrate with external systems. A trigger that writes to an external table or calls an external application indicates the EBS database is being used for non-EBS operations, a Level 3 customisation.

3

Review WebLogic deployments. Have your middleware administrator list all applications and services deployed on the Oracle WebLogic/Application Server that hosts EBS. Ensure every deployment is an Oracle-provided EBS component or officially supported add-on. Red flag: custom .ear or .war applications in the EBS domain.

4

Check for unlicensed modules or BI tools. Run Oracle's LMS scripts or EBS usage reports to verify whether any modules are active without licences, or if BI Publisher is accessing non-EBS data. Sometimes enabling an unlicensed EBS module or using an included tool beyond its limits also violates terms.

5

Interview developers and architects. Talk to the teams that built extensions or reports. It is common to find well-meaning developers who added a few tables or deployed a small integration in EBS without realising the licensing implications. Human intelligence complements your technical scans.

What Oracle's auditors check. During an audit, Oracle may request a dump of all database users/schemas on the EBS instance or inspect the WebLogic console for additional deployments. If ITAM has this information ready and has addressed any issues (either by licensing or removing the customisation), the organisation is in a far stronger position. It is always better to find and fix a potential compliance gap before Oracle does.

Recommendations for ITAM Professionals

#RecommendationWhy It Matters
1Document your EBS environmentKeep an up-to-date record of all customisations, integrations, and extensions. Enables quick compliance assessment and is invaluable during audits.
2Educate your teamTrain developers and system architects on Oracle's EBS licensing rules. Even seemingly harmless changes (adding a trigger, deploying a small app on WebLogic) can have significant consequences.
3Segregate custom applicationsDeploy any non-EBS application or database schema on separate, fully licensed Oracle platforms. Avoids commingling that voids the restricted-use benefit.
4Leverage Oracle-provided toolsUse Oracle's LMS audit scripts regularly to check usage. Shows extra schemas or unauthorised usage, giving you time to correct course before Oracle audits.
5Review contracts and policiesRegularly revisit your Oracle EBS licensing agreement and Oracle's official policy documents. Understanding the fine print helps enforce internal compliance.
6Plan before you customiseInvolve ITAM before green-lighting significant EBS customisations. A cost-benefit analysis that includes full-use licensing costs may change the decision entirely.
7Consider Oracle's approvalIf a customisation is critical, negotiate with Oracle for a special licence or amendment. Getting terms in writing avoids ambiguity during future audits.
8Archive audit trailsMaintain logs and evidence of how EBS is being used. If you remove a customisation, record that action. Demonstrates historical diligence in audit.
9Use reporting instances carefullyIf you create a read-only reporting database by copying EBS data, it likely needs its own licence. Data warehouses or clones decoupled from EBS are not covered by restricted use.
10Engage independent expertsOracle licensing is complex. An objective review before an audit or major project can save huge fees. A small advisory cost can prevent six- or seven-figure compliance penalties.

Action Checklist: 5 Steps to Take Now

1. Audit your EBS database now. Conduct an internal audit of the Oracle EBS database. List all non-standard schemas, custom tables, and database links. If you find objects that should not be there, decide whether to remove them or budget for proper licensing.
2. Inspect the application server. Examine the Oracle EBS application server (WebLogic). Check what is deployed. Remove any unauthorised applications or move them to a separate server. Ensure only EBS-related services are running on the EBS middleware instance.
3. Validate usage against entitlements. Cross-check enabled EBS modules and components against your Oracle licence entitlements. For each active module or feature (including BI Publisher and integrations), confirm that you have a licence or that it is included. If something is active without the necessary entitlement, deactivate it or obtain the required licence.
4. Update policies and communicate. Update your internal IT policies to include Oracle EBS customisation guidelines. Clearly state that no changes to the EBS database or middleware should be made without a review of the potential licensing impact. Communicate this policy to all relevant IT staff and project managers.
5. Schedule regular compliance reviews. Set a regular cadence (quarterly or biannually) to review Oracle EBS usage. This should include ITAM professionals, DBAs, and application owners. Regular reviews catch any drift in usage before it becomes a bigger issue.

Frequently Asked Questions

We added a few custom tables in an Oracle EBS module for reporting. Do we need a full Oracle Database licence?
+

If those tables reside in the Oracle EBS database schema (or any schema on the EBS database instance), yes. Oracle considers this a database modification, a Level 3 customisation. According to Oracle's policy, schema changes require a full-use database licence (and potentially a full middleware licence as well). It is safer to move those tables to a separate database instance with its own licence, or verify with Oracle if an exception exists in your specific contract (which is rare). The cost difference between a separate small database and voiding the restricted-use benefit on your entire EBS environment is enormous.

Can we use the Oracle EBS database for other applications if we own Oracle database licences elsewhere?
+

Not under the EBS included licence. The EBS database that comes with your application is strictly tied to EBS usage. Even if your company owns other Oracle DB licences, those do not automatically cover using the EBS instance for other apps. You would need to explicitly licence the EBS database server for full use if you run any additional applications on it. Treat the EBS-provided database as off-limits for other purposes unless you convert it to a fully licensed environment, which means purchasing DB EE licences for all processors on that server.

Is creating custom reports or using BI Publisher within EBS safe from a licensing perspective?
+

Basic custom reports that use only EBS data are generally fine. Oracle provides tools like BI Publisher with EBS for that purpose. However, if you create complex reports or new BI Publisher reports that pull in external data or utilise new database objects you added, that crosses into full-use territory for BI Publisher or the database. Always ensure your reports only access allowed data sources. Even for custom reports, Oracle requires that you licence Oracle WebLogic if you have built custom Java programs or complex forms. Stick to Oracle's extension frameworks and standard EBS data to stay safe.

What happens if Oracle audits us and finds we violated these rules?
+

Oracle's Licence Management Services will issue a formal report of non-compliance. You would then be expected to purchase the necessary licences (Database EE, WebLogic Server) for the environments in question, potentially at list price, plus back-support fees for the entire period of unlicensed use. In some cases Oracle may require an immediate true-up. It can be an expensive lesson, often costing hundreds of thousands or millions of dollars in large environments. Having documentation that shows you identified and remediated issues before the audit strengthens your negotiating position significantly.

Can we negotiate with Oracle if we need to customise beyond the standard scope?
+

It is worth trying. If you know in advance that a project will require extending EBS significantly, you can negotiate an arrangement with Oracle. This could involve adding the necessary technical licences to your agreement at a discount, or obtaining an amendment that grants specific rights for a defined scope of customisation. Oracle is generally strict on policy, but they may work with you commercially if it means selling additional licences. Always get any such agreement in writing. An independent advisor like Redress Compliance can help benchmark pricing and negotiate favourable terms.

How does Oracle's Core Factor Table affect the cost of full-use database licensing?
+

Oracle's processor-based licensing uses the Core Factor Table to convert physical CPU cores into licensable "processors." Intel and AMD chips typically have a core factor of 0.5, meaning two physical cores equal one processor licence. For example, a server with 16 Intel cores requires 8 processor licences (16 x 0.5). At $47,500 per processor for DB EE, that is $380,000 in database licences alone. When evaluating the cost impact of voiding your restricted-use licence, always apply the correct core factor for your hardware.

Does migrating EBS to the cloud change these restricted-use rules?
+

The restricted-use rules apply regardless of where EBS runs: on-premises, in OCI, or on AWS/Azure. If you run EBS on AWS EC2, the included restricted-use DB and WebLogic licences still apply, and the same customisation restrictions remain in force. Cloud migration does not reset or relax these licensing terms. Cloud deployments can make compliance more complex because Oracle's licensing in virtualised and cloud environments has additional rules around vCPU counting.

Related Resources

Service
Oracle Licence Management
Service
Oracle Audit Defence
Service
Oracle Contract Negotiation
Service
Oracle ULA Optimisation
Service
Third-Party Support Advisory
Service
Pay-When-We-Save
Knowledge Hub
Oracle Knowledge Hub
Consultation
Book a Meeting
FF

Fredrik Filipsson

Co-Founder & Oracle Advisory Lead, Redress Compliance

Over 20 years of enterprise software licensing expertise, including two decades working directly for IBM, SAP, and Oracle. Has advised hundreds of Fortune 500 organisations on Oracle licensing compliance, cost optimisation, and contract negotiations, including complex EBS technology licensing assessments, customisation risk analysis, and audit defence engagements involving restricted-use database and middleware violations.

← Back to Oracle Knowledge Hub