Oracle E-Business Suite Data Retention on OCI

May 28, 2024 | 5 minute read
Karthik Sidireddy
Principal Cloud Architect
Sudipta Kumar Panigrahi
Principal cloud Architect
Mark Beadle
Consulting Technical Manager
Maulik Modi
Enterprise Cloud Architect
Text Size 100%:

Introducing the Oracle Cloud Infrastructure (OCI) Data Retention Platform for Oracle E-Business Suite (EBS)! Enterprises are going through a tremendous transformation with existing enterprise resource planning (ERP) systems moving to software-as-a-service (SaaS) platforms or switching ERP systems but needing data retention of retiring ERP system for regulatory and compliance needs.

If you’ve been feeling overwhelmed by the recent shift to SaaS implementations, moving EBS to OCI, moving to another ERP, or are looking to retain your existing EBS historical data, this is the solution you've been waiting for! Take control of your EBS data retention with the OCI Data Retention Platform for Oracle E-Business Suite.

Our EBS Data Retention Platform offering

With this exciting offering, you can rest easy knowing that your data retention for EBS needs are addressed and continue to have secure access to the EBS data whenever you need to fulfill those crucial audits, regulatory, and compliance requirements. Imagine being able to migrate your entire EBS Database solution onto OCI, keeping it in a handy read-only state, all while enjoying secure, easy to use prebuilt reports. The reports are presented with ease through the low-code or no-code development framework of APEX, along with single-sign-on (SSO) access for APEX integrated with built-in OCI Identity and Access Management (IAM) capabilities. If you’re using EBS Database version or higher and EBS Application versions, 12.1.3, or 12.2.X, this offering can meet your needs!

OCI Data Retention Platform: A package solution to archive historical app data to OCI using Autonomous Database Serverless Shared and APEX.
Figure 1: OCI Data Retention Platform Offering

As part of this offering, the Oracle Consulting Services team delivers the following services:

  • EBS Database migration: The entire Oracle EBS Database is migrated onto OCI Autonomous Database Serverless with Autonomous Data Warehouse-Shared, residing in a private end point, making the EBS data both easily accessible and secure. 
  • Setup of EBS control plane: The default integrated low-code application development platform, Oracle Oracle Application Express (APEX), that comes with OCI Autonomous Database produces prebuilt screens that provide read-only Oracle EBS pages with a user-friendly presentation layer. Currently, the prebuilt Oracle EBS modules reports available include payable invoices, general ledger, cash management, receivables, iProcurement, iExpenses, human resources, payroll, fixed assets, and projects.
Prebuilt reports for EBS modules in EBS Data Retention.
Figure 2: Prebuilt reports for EBS modules
  • Comprehensive migration of other systems of record: The external attachments, such as those residing outside the Oracle EBS Database like Markview, WebCenter, and file storage, also form an important part of the EBS reporting system. Whether they’re weblinks, text files, documents, PDFs, or images, these attachments are analyzed and securely migrated into OCI Object Storage buckets and tightly integrated to the attachments within the APEX EBS reports.
  • Reporting: EBS reports through APEX interface retrieval supports the segregation of EBS data for multiple organizations.
Example APEX reports on a lookup interface.
Figure 3: Prebuilt APEX reports on a lookup interface


Key features and highlights

This solution offers the following benefits:

  • Low-maintenance: Oracle Autonomous Database serverless technology is used as the target database for retaining the EBS data and meeting cutting-edge expectations like automated backups, automated patching, automatic upgrades, and autotuning without human intervention.
  • Low costs: Customers can optimize resource usage by utilizing the on-demand capability of autonomous databases, enabling them to start and stop the database, which helps to manage and reduce costs, as needed to generate reports for auditing purposes. 
  • No license or support fees: The customers isn’t required to pay their existing yearly license and support fees for the retiring EBS database and application. They’re moving away from the license and support model to an Autonomous Data Warehouse Serverless subscription model in which customers pay only for CPUs and storage that are consumed.
  • Compliance needs through the EBS reports interface: A preconfigured, fully managed, secure Oracle APEX EBS report helps meet compliance and regulatory needs.
  • Secure user access: Secure APEX user login for accessing EBS reports is accomplished through SSO using the built-in IAM capabilities within OCI and allowing users with role-based access to the required APEX-EBS modules.
  • Open data framework: Standard interface capabilities and data extraction tools are provided to enable customers to import and extract application data. They can configure the data extraction tools to extract whatever information that the organization requires and in numerous formats, including XML, CSV, PDF, and Excel.  
Benefits of the OCI Data Retention Platform for EBS, including financial, availability, database security, and EBS reports interface.
Figure 4: Benefits of OCI Data Retention Platform for EBS


Entry to lowering other costs and risks

Customers who use the EBS Data Retention Platform in OCI for their EBS data retention and reporting can use it as a starting point to have wider strategic discussions around lowering costs and lowering risks. You might have other workloads like analytics, operational reporting, AI and machine learning (ML), predictive analytics, and a host of other solutions that OCI offers. OCI helps customer lower costs and lower risks,  Thousands of organizations rely on OCI to run their mission-critical, enterprise workloads, with many reporting cost savings of up to 60%, with solutions like flex infrastructure, lower storage, and egress costs. The OCI Data Retention Platform for Oracle E-Business Suite is a starting point to several other workloads and solutions running in OCI.

With this offering, you can easily access your historical data whenever you need it, retain your data securely, and fulfill those essential audit requirements with ease. If you're interested in getting started or want to learn more, contact one of the authors! We can't wait to help you begin your journey to securing your EBS data.

The following authors can work with you to make your journey of securing EBS Data to Oracle Cloud Infrastructure painless and easy! (The information, views, and opinions presented by the authors are solely theirs and are for general information only. These do not constitute any responsibility and/or liability by Oracle EBS Product and My Oracle Support teams.)

Karthik Sidireddy

Principal Cloud Architect

Sudipta Kumar Panigrahi

Principal cloud Architect

Sudipta is Principal Cloud Architect based in India with 14 years of Expirience in Oracle Technology

Mark Beadle

Consulting Technical Manager

Maulik Modi

Enterprise Cloud Architect

Previous Post

Oracle deploys zero-touch updates for Oracle Enterprise Identity Management Suite (V24.2.1)

Pavana Jain | 2 min read

Next Post

Deploying an HPC cluster with RDMA network on OCI OKE and File Storage service mount

Ainura Djumagulov | 7 min read