Home Training Provisioning Oracle EBS R12.2.11 on OCI

Provisioning Oracle EBS R12.2.11 on Oracle Cloud Infrastructure

🎬 8 Video Lessons 🖥 Hands-On Walkthrough ⬇ 26 Downloadable Files 📄 Course Documentation Included

A complete, practitioner-built walkthrough for provisioning a single-node Oracle E-Business Suite R12.2.11 instance on Oracle Cloud Infrastructure. Built from a real deployment, this course walks through every step — from creating an OCI account and configuring a Virtual Cloud Network to generating SSH key pairs and establishing connectivity to your running EBS instance. Includes all shell scripts, SQL scripts, and API payloads used in the actual deployment.

▶ Start Course

What You'll Learn

Understand OCI's core infrastructure services
Create and configure an OCI account and tenancy
Design and deploy a Virtual Cloud Network (VCN)
Organize resources using OCI compartments
Generate and manage SSH key pairs for instance access
Select the correct Oracle EBS compute image
Configure compute instance shape, storage, and networking
Validate instance settings before launch
Establish SSH connectivity to a running EBS instance
Use shell scripts to start and stop Oracle Applications

Course Overview

Section 1 — Overview of Oracle Cloud Infrastructure (30 min)

Before provisioning your EBS instance, this section builds the foundational OCI knowledge you need. Three focused subtopics cover cloud computing fundamentals, OCI's core service catalog, and the enterprise-grade advantages OCI brings to Oracle EBS deployments.

Subtopic 1 — Introduction to Cloud Computing

Covers the three cloud service models — Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS) — and how each applies to Oracle EBS. Reviews public, private, and hybrid deployment models with their trade-offs. Discusses the key advantages of cloud adoption (scalability, cost flexibility, global reach) alongside common challenges (data security, compliance, connectivity).

Subtopic 2 — Core Features of Oracle Cloud Infrastructure

A tour of OCI's primary service areas relevant to an EBS deployment:

Compute: Virtual Machines, Bare Metal instances, Container services, and OCI compute shapes — choosing the right shape for EBS
Storage: Block Storage (boot and data volumes), Object Storage (backups), and File Storage (shared file systems)
Networking: Virtual Cloud Networks (VCN), subnets, VPNs, Internet Gateways, and Load Balancers
Database: Autonomous Database, Oracle DB on VMs/Bare Metal, and Exadata Cloud Service options

Subtopic 3 — Benefits of OCI for Enterprise EBS

Why OCI is the recommended platform for Oracle EBS deployments:

Scalability: Resize compute and storage on demand without downtime
Performance & Reliability: High-throughput networking and SLA-backed uptime
Security & Compliance: Encryption at rest and in transit, IAM policies, GDPR and HIPAA support
Cost-Effectiveness: Pay-as-you-go pricing, free tier availability, no upfront infrastructure cost
Innovation & Integration: Native AI/ML services, IoT support, and deep Oracle application integration

Course Curriculum — 8 Lessons

1
Create an OCI AccountSign up for Oracle Cloud, configure your tenancy, and verify your account settings.
2
Create a CompartmentOrganize your OCI resources into a logical compartment for the EBS deployment.
3
Create a Virtual Cloud Network (VCN)Configure the VCN, subnets, internet gateway, and security lists for EBS connectivity.
4
Create an SSH Key PairGenerate public/private SSH key pairs required for secure instance access.
5
Create an Instance — Select ImageNavigate the OCI Marketplace and select the correct Oracle EBS R12.2.11 compute image.
6
Create an Instance — Configure InstanceSet the compute shape, assign the VCN and subnet, attach the SSH key, and configure storage.
7
Create an Instance — Validate SettingsReview all instance configuration settings before launching the provisioning process.
8
Create an Instance — Establish SSH ConnectivityConnect to the running EBS instance via SSH and verify Oracle Applications services are running.

Downloadable Course Materials

All scripts and configuration files used in this course are available for download. These are sourced from a real OCI deployment of Oracle EBS R12.2.11.

📚 Course Documentation
📄 Section 1 — Overview of Oracle Cloud Infrastructure.docx Download
📕 Provision a New Oracle EBS Installation on a Single Node on OCI (Doc ID 2764690.1).pdf Download
📝 API to Create User and Add Responsibility.txt Download
🔧 Shell Scripts
⚙️ startOraApps.sh — Start Oracle Applications services Download
⚙️ stopOraApps.sh — Stop Oracle Applications services Download
⚙️ clearPersistence.sh — Clear Oracle persistence cache Download
⚙️ Environment Configuration Files
🗂 appl.env — Oracle Applications environment variables Download
🗂 apps.env — APPS schema environment variables Download
🗂 db.env — Database environment variables Download
🗂 ias.env — Oracle iAS environment variables Download
🗂 OracleApplications — Oracle Applications runtime config Download
🗃 SQL Scripts
💾 WDCCreateUserScript.sql — Create Oracle FND user Download
💾 WDCCreateEmployeeScript.sql — Create HR employee record Download
💾 WDCCreateEmployeeAssignmentScript.sql — Employee assignment Download
💾 WDCCreateEmployeeSupervisorScript.sql — Supervisor assignment Download
💾 WDCCreateUserResp.sql — Assign responsibilities to user Download
💾 CreateUserAccountQuery.sql — Query user account status Download
💾 tai_add_responsibility.sql — Add responsibility via TAI API Download
💾 tai_update_fnduser.sql — Update FND user via TAI API Download
💾 Encrypt Functions.sql — Oracle password encryption functions Download
🌐 REST API Payloads (JSON)
📋 CreateEBSUser.json — REST payload to create EBS user Download
📋 CreateFNDUser.json — REST payload to create FND user Download
📋 CreateEmployeeResponse.json — Employee creation response Download
📋 UpdateEmployeeAssignment1.json — Employee assignment update (1) Download
📋 UpdateEmployeeAssignment2.json — Employee assignment update (2) Download
📦 PL/SQL Package
🔷 xxtaiint.pls — TAI integration PL/SQL package specification Download

Prerequisites

Oracle Cloud account (free tier supported)
Basic familiarity with Oracle EBS concepts
SSH client installed (PuTTY or terminal)
Web browser access to OCI Console