OracleAppsDBAKK1

Monday, March 18, 2024

Example Manual Migration of Oracle E-Business Suite Release 12.2 with Oracle Database 19c to Oracle Base Database Service DB Systems

Example Manual Migration of Oracle E-Business Suite Release 12.2 with Oracle Database 19c to Oracle Base Database Service DB Systems (Doc ID 2743151.1)

12.2 E-Business Suite - How To Clean Up a Rapid Install Failure and Restart a Fresh Install

To resolve the issue test the following steps in a development instance and migrate accordingly:

As there is no rapidwiz -restart option available with 12.2, if the installation fails perform the following steps to clean up a failed installation:

1. Restart the server or make sure to kill ALL oracle and applmgr processes.
2. Backup and then delete the /tmp directory.
3. Backup and then delete the oraInventory directory.
4. Backup and then delete BEA under installation user $HOME.
5. Backup and then delete the install directory- Database / Application Base directory
6. Ensure the correct oraInventory is present and run rapidwiz again to start installation.

Ref 2091880.22

Thursday, March 7, 2024

Useful E-Business Suite 12.2 Documents

Latest 12.2 19c Documentation !
Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c Note 2552181.1
Using Oracle E-Business Suite Release 12.2 with a Database Tier Only Platform on Oracle 19c Note 2615883.1
Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19c Note 2554156.1
Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Logical Host Names Note 2617788.1
Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Physical Host Names Note 2617787.1
Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 Note 2530665.1

12.1 19c Documentation:
Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c Note 2580629.1
Export/Import Process for Oracle E-Business Suite Release 12.1 Database Instances Using Oracle Database 19c Note 2615617.1
Business Continuity for Oracle E-Business Suite Release 12.1 on Oracle Database 19c Using Physical Host Names Note 2567091.1
Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.1 Note 2530680.1
Integrating Oracle E-Business Suite Release 12.1 with Oracle Database Vault 19c Note 2648854.1

Start Here !
Oracle E-Business Suite Release 12.2 Information Center Note 1581299.1
Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started, and Go-Live Checklist Note 1585857.1
Oracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap Note 1934915.1

Media Packs (edelivery)
here

How To Download Oracle E-Business Suite Software From Oracle Software Delivery Cloud Note 2065104.1

12.2 Documentation
http://docs.oracle.com/cd/E26401_01/index.htm Always use this Web Library as it contains the most recent versions of the documentation
Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1 Very Important!. Read this before/during/after upgrade/install (contains checksums)

EBS 12.2 Stage Creation Information
R12.2: How To Create the Stage In Preparation For Installation Note 1596433.1
See the official installation guide for information on creating the EBS 12.2 stage

StartCD 51 is now released ! (LATEST) See Patch 22066363 and the Blog Announcement here
Important StartCD 48, 49, & 50 Information: Resolving Domain Deployment Issues When Installing Oracle E-Business Suite Release 12.2 here

Important: New Connection Handling Fixes (improves performance) Blog Announcement here

new Changing Hostnames, IP address or looking for Admin Server high availability?
Configuring Oracle E-Business Suite Release 12.x Using Logical Host Names Note 1968231.1
Blog Announcement here

11.2.0.4 News - Oracle Database 11g Release 2 Version 11.2.0.4 is NOW certified on some platforms for 12.2 - Tip, 11.2.0.4 DB often means less one off-patches and less less one-off conflicts

Oracle E-Business Suite In Oracle Cloud
Getting Started with Oracle E-Business Suite in Oracle Cloud Note 2066260.1
Getting Started with Oracle Application Management Pack (AMP) for Oracle E-Business Suite, Release 12.1.0.4.0 Note 1954099.1
Migrating an Existing Oracle E-Business Suite Installation to Oracle Cloud here
Creating a New Oracle E-Business Suite Installation in Oracle Cloud here
Creating an Oracle E-Business Suite Development Environment in Oracle Cloud here
Using Automated Provisioning of Oracle E-Business Suite in Oracle Cloud here

Planning
Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started, and Go-Live Checklist Note 1585857.1
Which Oracle E-Business Suite Release Should You Target: 12.1 or 12.2? Note 1592197.1
Oracle E-Business Suite Release 12.2: Upgrade Sizing and Best Practices Note 1597531.1
EBS File Comparison Report [VIDEO] Note 1446430.1
11i - 12 EBS Data Model Comparison Report Overview Note 1290886.1 Object definition changes for 12.2
Oracle E-Business Suite Upgrades and Platform Migration Note 1377213.1
See the installation guide for sizing and managed server recommendations
Oracle E-Business Suite Release 12.1 and 12.2 Transfer of Information (TOI) Online Training Note 807319.1
Choosing a Shared File System for Oracle E-Business Suite here
EBS ATG Seed Data Comparison Report Note 1327399.1

new Application Tier Platform Migration with Oracle E-Business Suite Release 12.2 Note 2048954.1 Blog announcement here

new Getting Started with Oracle E-Business Suite in Oracle Cloud <2066260.1>

Reducing Upgrade Downtime
Best Practices for Minimizing Oracle E-Business Suite Release 12 Upgrade Downtime Note 1581549.1
Udayan and Samer's presentation at OOW provides a summary of methods in reducing upgrade downtime: Here
Express Diagnosis of Oracle E-Business Suite Release 12 Upgrade Performance Issues Note 1583752.1

Upgrade Advisors
Upgrade Advisor: E-Business Suite (EBS) 11i Upgrade to 12.2 Note 1614508.1
Upgrade Advisor: E-Business Suite (EBS) Upgrade from 12.0/12.1 to 12.2.x Note 1593640.1

Database 19c

Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c Note 2552181.1
Using Oracle E-Business Suite Release 12.2 with a Database Tier Only Platform on Oracle 19c Note 2615883.1
Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Logical Host Names Note 2617788.1
Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Physical Host Names Note 2617787.1

Database Preparation
Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade Note 1349240.1
Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite Note 1147107.1 resource for database patch conflicts
Database Initialization Parameters for Oracle E-Business Suite Release 12 Note 396009.1 Contains 12.2 specific settings
Oracle E-Business Suite Release 11i & R12 Patches Required with Oracle Database 11g Release 2 (11.2.0) on Exadata Note 1392527.1
Interoperability Notes E-Business Suite Release 12.2 with Database 11g Release 2 Note 1623879.1
Interoperability Notes Oracle EBS 12.2 with Oracle Database 12c Release 1 Note 1926201.1
Installing Oracle Applications Suite 12.2.2 on RAC and 2 AppsTiers with Shared APPL_TOP and ASM (external, non-Oracle)..here
How to use the My Oracle Support Conflict Checker Tool [Video] Note 1091294.1
Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 11.2 Note 1613716.1
Checks and Potential Issues Installing EBS R12.2 on RAC Cluster using Rapid Install Note 1595139.1
Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Release 2 and Later Physical Standby Database Note 1070033.1
Using Oracle 11g Release 2 Real Application Clusters and Automatic storage management with Oracle E-Business Suite Release 12.2 Note 1453213.1
Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12.2 Note 1585296.1
Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and Oracle Databases 11g and 12c (12.1.0.1 and 12.1.0.2) Note 1944539.1
Oracle Active Data Guard 11.2.0.4 Certified with EBS 12.2.3 here
Using Oracle Database In-Memory with Oracle E-Business Suite Note 2025309.1, Blog announcement here
Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database Note 1963472.1
Transportable Databases for EBS Release12.2 Note 2011169.1
Transportable Database 12c Certified for EBS 12.2 Database Migration here
Oracle Data Guard 11.2.0.4 Certified with EBS 12.2 here
Should EBS Customers Use Database 12.1.0.2 or 12.1.01? here
Oracle Data Guard 11.2.0.4 with RAC Certified with EBS 12.2 here

Database 12c *NEW*
Using Oracle 12c Release 1 (12.1) Real Application Clusters with Oracle E-Business Suite Release R12.2 Note 1626606.1
Using TDE Column Encryption with Oracle E-Business Suite Release 12.2 Note 1585696.1
Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12.2 on Oracle Database 12c Release 1 (12.1.0) Note 1926686.1
Export/Import Process for Oracle EBS 12.2 Using Oracle Database 12c Release 1 Note 1926203.1
Using Oracle EBS 12.2 with a Database Tier Only Platform on Oracle Database 12c Release 1 Note 1926202.1
Blog Announcement here 12.1.0.1
Blog Announcement here 12.1.0.2
Using Transportable Tablespaces to Migrate Oracle EBS Release 12.2 Using Oracle Database 12.1.0 Note 2157661.1

Business Continuity for Oracle E-Business Suite Release 12.2 using Virtual Hosts with Oracle 12c Physical Standby Database (Doc ID 2088692.1)Business Continuity for Oracle E-Business Suite Release 12.2 Using Logical Host Names with an Oracle 12c Physical Standby Database (Doc ID 2246690.1)

Operating System Preparation

Oracle VM Virtual Appliance for Oracle E-Business Suite Deployment Guide, Release 12.2.6 Note 2254565.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for IBM AIX on Power Systems (64-bit) Note 1330703.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 Note 1330701.1 Save Time! ...try the Pre-Install RPM, available for Linux 5 and 6
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Oracle Solaris on SPARC (64-bit) Note 1330702.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for HP-UX Itanium Note 1330704.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Microsoft Windows x64 (64-bit) Note 1330706.1
Oracle E-Business Suite Technology Stack Release Notes for Release 12.2 Note 1376618.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for HP-UX Itanium Note 1330704.1
Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.3 Note 1620448.1
Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.4 Note 1928303.1
Certified Oracle Solaris and SPARC Virtualization and Partitioning Technologies for Oracle E-Business Suite Note 1234632.1
REDHAT6 - 12.2.2 Rapid Install Preinstall Checks Note 1588970.1
EBS 12.2 now certified on Oracle Linux 7 and Red Hat Enterprise Linux 7 - Blog announcement here

new ANNOUNCEMENT: Oracle E-Business Suite Release 12.2 certified with Linux Containers (LXC). For more information see the announcement here

Rapid Install and Stage
MD5 Checksums for R12.2 Rapid Install Media Note 1505510.1
RDA - Health Check / Validation Engine Guide Note 250262.1
Checks and Potential Issues Installing EBS R12.2 on RAC Cluster using Rapid Install Note 1595139.1
R12.1 and 12.2 Oracle E-Business Suite Preinstall Patches Report [Video] Note 1448102.2
Understanding and Managing Licensing Options in Oracle E-Business Suite Note 1639705.1

Release Notes
Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1 contains database patch checker steps and checksums
Oracle E-Business Suite Technology Stack and Applications DBA Release Notes for Release 12.2.3 Note 1606170.1
Oracle Application Framework Release Notes for Release 12.2.3 Note 1593782.1
Oracle E-Business Suite Product Specific Release Notes, Release 12.2.4 Note 1903217.1

Upgrade Performance
Express Diagnosis of Oracle E-Business Suite Release 12 Upgrade Performance Issues Note 1583752.1
Best Practices for Minimizing Oracle E-Business Suite Release 12.1.3 and 12.2.n Upgrade Downtime Note 1581549.1

Online Enablement
Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 Note 1531121.1

CPU and Security Related Information
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2014) Note 1605340.1
Secure Configuration Guide for Oracle E-Business Suite Release 12 Note 403537.1
Release 12.2 Flexfield Value Set Security Documentation Update for Patch 17305947:R12.FND.C Note 1589204.1
Sensitive Administrative Pages in Oracle E-Business Suite Note 1334930.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (July 2014) Note 1668237.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (October 2014) Note 1923805.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2015) Note 1954250.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (April 2015) Note 1986100.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (July 2015) Note 2013117.1

Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (October 2015) Note 2051000.1

new Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2016) Note 2072202.1

Oracle E-Business Suite Release 12 Critical Patch Update Knowledge Document (January 2019) Note 2480398.1

Oracle E-Business Suite Release 12 Critical Patch Update Knowledge Document (April 2019) Note 2514102.1

Identifying the Latest Critical Patch Update for Oracle E-Business Suite Release 12 Note 2484000.1

Oracle E-Business Suite Security Guide here

Secure Oracle E-Business Suite with SSL, TLS, SHA-2, and Stronger Cipher Suites Note 2063486.1

Security Configuration and Auditing Scripts for Oracle E-Business Suite Note 2069190.1

FAQ's
Oracle E-Business Suite Release 12.2: Online Patching FAQ Note 1583902.1

AD and TXK C Delta Patches (AD and TXK C Delta 11 are the latest patches Patch 26834480 (R12.AD.C.Delta.11) Patch 28840822 (R12.TXK.C.Delta.11))

AD and TXK C Delta 11

Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.11 and R12.TXK.C.Delta.11 Note 2527995.1

AD and TXK C Delta 10

Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.10 and R12.TXK.C.Delta.10 Note 2295390.1

AD and TXK C Delta 9

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1

Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.9 and R12.TXK.C.Delta.9 Note 2233485.1

AD and TXK C Delta 8

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1

AD and TXK C Delta 7
Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 Note 2033780.1
Applying A Non-Current Version of the AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1903052.1
Blog Announcement here

AD and TXK C Delta 7 Bundle 2
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1
Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 Note 2033780.1
Blog Announcement here

AD and TXK C Delta 6
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1
Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 Note 1983782.1
Applying A Non-Current Version of the AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1903052.1
Blog Announcement here

AD and TXK C Delta 5

Oracle E-Business Suite Technology Stack and Applications DBA Release Notes for R12.TXK.C.Delta.5 and R12.AD.C.Delta.5 Note 1644660.1
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1
E-Business Suite RUP, AD and TXK RUP Information, Release 12.2 Note 1583092.1
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes Note 1594274.1
Oracle E-Business Suite Release 12.2: Validations Performed By the adop Online Patching Utility Note 1678355.1
Oracle E-Business Suite Release 12.2: Suite-Wide Rollup and AD/TXK Delta Information Note 1583092.1
Oracle E-Business Suite Release 12.2:Now Available - Essential Bundle Fixes for AD Delta 5 and TXK Delta 5 Note 1934471.1
Blog announcement here

AD and TXK C Delta 4
Oracle E-Business Suite Technology Stack and Applications DBA Release Notes for R12.TXK.C.Delta.4 and R12.AD.C.Delta.4 Note 1624423.1
Applying A Non-Current Version of the AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1903052.1
E-Business Suite RUP, AD and TXK RUP Information, Release 12.2 Note 1583092.1
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes Note 1594274.1
Oracle E-Business Suite Release 12.2: Now Available - Essential Consolidated Rollup Patches for AD Delta 4 and TXK Delta 4 Note 1674784.1
Blog announcement here
Oracle E-Business Suite Release 12.2: Validations Performed By the adop Online Patching Utility Note 1678355.1

12.2.7

Note 2230783.1 - Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1)

12.2.6
Oracle E-Business Suite 12.2.6 Readme Note 2114016.1
EBS 12.2.6 Highlights video
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents Note 1302189.1
Oracle E-Business Suite Product Specific Release Notes, Release 12.2.5 Note 2114173.1

12.2.5
Blog announcement here
Oracle E-Business Suite 12.2.5 Readme Note 1983050.1
EBS 12.2.5 Highlights video here
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents Note 1302189.1
Oracle E-Business Suite Product Specific Release Notes, Release 12.2.5 Note 2049015.1

12.2.4
Oracle E-Business Suite Release 12.2.4 Readme Note 1617458.1
Blog announcement here
R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents Note 1302189.1
New User Interface - Blog announcement here
New Simplified Home Page in EBS 12.2.4 - Blog announcement here
Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications Note 1927975.1

12.2.3
Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1
Oracle E-Business Suite Release 12.2.3 Readme Note 1586214.1
Applying the 12.2.3 AD and TXK Release Update Pack Note 1586217.1
E-Business Suite RUP, AD and TXK RUP Information, Release 12.2 Note 1583092.1
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes Note 1594274.1

12.2.2 *Not Recommended*
Oracle E-Business Suite Release 12.2.2 Readme Note 1506669.1
Applying the 12.2.2 AD and TXK Release Update Pack Note 1560906.1
Oracle E-Business Suite Technology Stack Release Notes for Release 12.2.2 Note 1376618.1
Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1

Cloning
Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone Note 1383621.1
Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone Note 1679270.1 RAC to RAC Cloning is now certified
Blog Announcement here
Cloning Oracle E-Business Suite Release 12.2 Environments integrated with Oracle Access Manager 11gR2 (11.1.2) and Oracle E-Business Suite AccessGate Note 1614793.1

Technology Stack
Enabling SSL in Oracle E-Business Suite Release 12.2 Note 1367293.1
Oracle E-Business Suite Release 12.2 Configuration in a DMZ Note 1375670.1
Using Load-Balancers with Oracle E-Business Suite Release 12.2 Note 1375686.1 contains information on WLS clustering
Using Forms Socket Mode with Oracle E-Business Suite Release 12 Note 384241.1
Using the Latest JDK 7.0 Update with Oracle E-Business Suite Release 12.2 Note 1530033.1
Using JDK 6.0 Latest Update with Oracle E-Business Suite Release 12.2 Note 1459546.1
Sharing The Application Tier File System in Oracle E-Business Suite Release 12.2 Note 1375769.1
Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12.2 see the Setup Guide
Upgrading Oracle Fusion Middleware WebTier of Oracle E-Business Suite Release 12.2 to the latest 11gR1 (11.1.1.x) PatchSet Note 1590356.1
Best Practices for Deploying EBS 12.2 on Oracle Database Appliance here
Business Continuity for Oracle E-Business Release 12.2 Using Oracle 11g Physical Standby Database Note 1491855.1
How To Change or Reset The WebLogic Administration Password In 12.2 E-Business Suite Note 1385751.1
R12.2 How To Re-attach Oracle Homes To The Central Inventory Note 1586607.1
JSP Page Handling and File Locations in Release 12.2 Note 1928874.1
Oracle E-Business Suite Release 12.2: Adding or Deleting 11gR2 Oracle RAC Nodes Note 1570554.1
Release 12.2 OHS configuration File maintenance Note 1676430.1 Oracle internal only

Oracle WebTier Utilities 11.1.1.9 Now Certified with EBS 12.2 announcement here

new Oracle Traffic Director 11g Integration with Oracle E-Business Suite Release 12.2 on Oracle Exalogic Note 2095072.1 Blog Announcement here

Performance and Tuning
Oracle E-Business Suite Recommended Performance Patches Note 244040.1
Oracle Fusion Middleware - Performance and Tuning for Oracle WebLogic Server 11g Release 1 (10.3.6) here

Framework
Oracle Application Framework Profile Options, Release 12.2.3 Note 1593843.1
Oracle Application Framework Development FAQ Release 12.2 Note 1455932.1
Oracle Application Framework Release Notes for Release 12.2.3 Note 1593782.1
Oracle Application Framework Release Notes for Release 12.2.4 Note 1676223.1
11i - 12.2 Oracle Application Framework Troubleshooting Guide Note 1496055.1

Managed Server Related Information
Managing Configuration of Oracle HTTP Server and Oacore, Oafm, Forms and Forms-c4ws Applications in Oracle E-Business Suite Release 12.2 Note 1905593.1
How To Install And Integrate Jrockit Mission Control With Ebusiness Suite 12.2 Note 1377695.1
ORACLE JRockit and Memory Consumption - Memory Leaks In Java Heap Note 1137239.1
Using Oracle Fusion Middleware Diagnostic Framework With Oracle E-Business Suite Release 12.2 Note 1428056.1 Thread dumps and incident capture
12.2 Debgging Managed Server Performance and Stability Note 1908444.1 Internal Only
Different ways to take thread dumps in WebLogic Server Note 1098691.1
Oracle E-Business Suite 12.2 Data Source Connection Pool Diagnostics Note 1940996.1

Patching
Oracle E-Business Suite 12.2 Patching Technology Components Guide Note 1355068.1
12.2: Running Maintenance Procedures During An Open Online Patching Cycle Note 1580108.1
List of features / programs disabled during online patching. See the Maintenance Guide 'Patching Procedures'
12.2: Functionality Disabled During An Online Patching Cycle Note 1586609.1
ADOP and Online Patching Quick Reference Guide for E-Business Suite 12.2 Note 1522734.1 Oracle internal only
Oracle E-Business Suite Release 12.2: Backup and Recovery Guidelines For Online Patching Cutover Note 1584097.1
Online Patching Troubleshooting Guidelines For Support Note 1642731.1 Oracle internal only
How To Automatically Set the Current Run Edition / File System for EBS 12.2 Note 1545584.1
Patching & Maintenance Advisor: E-Business Suite (EBS) R12.2 Note 1590494.1
How to Find E-Business Suite & E-Business Suite Technology Stack Patches Note 1633974.2
How to Restore An Abandoned Node in Oracle E-Business Suite Release 12.2 Note 1677498.1

Troubleshooting
12.2 Ebusiness Suite - Collecting Fusion Middleware Log Files Note 1362900.1
Rapid Install for E-Business Suite Release 12.2 Note 1378579.1 see appendix A for Rapid Install log file locations
Oracle Applications E-Business Suite 12.2 Fusion Middleware Log Files: Locate,View, and Control Note 1366187.1
Using Oracle Fusion Middleware Diagnostic Framework With Oracle E-Business Suite Release 12.2 Note 1428056.1
12.2 E-Business Suite - Collecting Online Patching and fs_clone Log Files Note 1542162.1 Oracle internal only
Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12.2 Note 1317697.1
Oracle E-Business Suite Release 12.2: Resolving Database PSU Conflicts Note 1665813.1 Oracle internal only
12.2 E-Business Suite - How To Enable FND: Debug / AF Logging When Login Is Not Possible Note 1563168.1
Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 Note 1901242.1
EBS 12.2 - Summary Of The Login Process And What To Expect When One Of The Components Fails Note 1984710.1

Mobile
Oracle Mobile Approvals for Oracle E-Business Suite Implementation Guide, Release 12.1 and Release 12.2 Note 1642423.1
Oracle E-Business Suite Mobile Apps Administrator’s Guide for Release 12.1 and Release 12.2 Note 1642431.1
Oracle E-Business Suite Mobile Apps, Release 12.1 and 12.2 Documentation Note 1641772.1
Mobile Web Applications (MWA) Troubleshooting Tips for Release 12 Mobile Web Applications Server Note 782162.1

Integrations
Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 11gR1 (11.1.1.5.0) using Oracle E-Business Suite AccessGate Note 1368292.1
Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12.2 Note 1380591.1
Using Oracle WebCenter 11.1.1 with Oracle E-Business Suite Release 12.2 Note 1332645.1
Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 11gR2 (11.1.2) using Oracle E-Business Suite AccessGate Note 1576425.1
Integrating Oracle E-Business Suite Release 12.2 with Oracle Internet Directory 11gR1 Note 1371932.1
R11i/R12.0/R12.1/R12.2 : Getting Started with Oracle Application Management Pack for Oracle E-Business Suite (AMP) Release 12.1.0.2.0 Note 1532970.1
Getting Started with Oracle Application Management Pack for Oracle E-Business Suite (AMP), Release 12.1.0.3.0 Note 1623105.1
Oracle E-Business Suite Integrated SOA Gateway Release Notes for Release 12.2 Note 1374577.1
Integrating Oracle E-Business Suite Release 12.2 with Oracle BPEL in Oracle SOA Suite 11g R1 Note 1584883.1

Integrating Oracle E-Business Suite 12.2 with BPEL in SOA Suite 12c Note 1951625.1
Tutorial: Publishing EBS 12.2 PL/SQL APIs as REST Services here
Oracle Access Manager 11gR2 Patchset 3 (11.1.2.3.0) is now certified here
Using Application Management Suite With E-Business Suite 12.2 here

Overview of Single Sign-On Integration Options for Oracle E-Business Suite Note 1388152.1
Integrating Oracle E-Business Suite Release 12.2 with Oracle Unified Directory 11gR2 Note 2003483.1

Endeca/Oracle E-Business Suite Information Discovery

Oracle E-Business Suite Extensions for Oracle Endeca Globalization Guide, Release 12.2 V5 Note 1613997.1
Installing Oracle E-Business Suite Information Discovery, Release 12.2 V6 Note 1970071.1

Customizations
Deploying Customizations in Oracle E-Business Suite Release 12.2 Note 1577661.1
OA Framework - How to find the correct version of JDeveloper to use with E-Business Suite 11i or Release 12.x Note 416708.1
How To Add Classes To The Classpath In The 12.2 E-Business Suite File System Note 1331703.1
Creating a Custom Application in Oracle E-Business Suite Release 12.2 Note 1577707.1
Guidance for Integrating Custom and Third-Party Products With Oracle E-Business Suite Release 12.2 Note 1916149.1
How To De-register Custom Applications (Doc ID 2085355.1)
Preparing Your Customizations for EBS 12.2 here

Other
Oracle Web Applications Desktop Integrator Release Notes for Release 12.2 Note 1375758.1
Oracle E-Business Suite NLS Release Notes, Release 12.2 Note 1314621.1
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents Note 1302189.1
Oracle VM Templates for Oracle E-Business Suite for Exalogic Deployment Guide, Release 12.2.4 Note 1954255.1
Oracle Application Framework Release Notes for Release 12.2.2 Note 1300894.1
Oracle Application Framework Release Notes for Release 12.2.3 Note 1593782.1
Oracle XML Gateway Release Notes for Release 12.2 Note 1374575.1
Oracle XML Gateway Release Notes for Release 12.2.3 Note 1604864.1

Functional References
Oracle E-Business Suite Product Specific Release Notes, Release 12.2.2 Note 1585844.1

How to Receive Document Update Notifications from My Oracle Support

Review the following document to receive update notifications for this document:

Note 1541384.1 - How to Receive Document Update Notifications from My Oracle Support (Doc ID 1541384.1)

(Doc ID 1585889.1)

Loading data into Autonomous Data Warehouse using Datapump

Oracle introduced Autonomous Data warehouse over a year ago, and one of the most common questions that customers ask me is how they can move their data/schema's to ADW (Autonomous Data Warehouse) with minimal efforts. My answer to that is to use datapump, also known as expdp/impdp. ADW doesn't support traditional import and export, so you have to use datapump. Oracle suggests using schema and parallel as a parameter while using datapump. Use the parallel depending upon the number of OCPU that you have for your ADW instance. Oracle also suggests to exclude index, cluster, indextype, materialized_view, materialized_view_log, materialized_zonemap, db_link. This is done in order to save space and speed up the data load process. At present you can only use data_pump_dir as an option for directory. This is the default directory created in ADW. Also you don't have to worry about the performance of the database since ADW uses technologies like storage indexes, Machine learning, etc to achieve the optimal performance. You can use the file stored on Oracle Object Storage, Amazon S3 storage and Azure Blob Storage as your dumpfile location. I will be using Oracle Object storage in this article.

We will be using the steps below to load data:

1) Export the schema of your current database using expdp

2) Upload the .dmp file to object storage

3) Create Authentication Token

4) Login into ADW using SQLPLUS

5) Create credentials in Autonomous Data Warehouse to connect to Object Storage

6) Run import using Datapump

7) Verify the import

Instead of writing more, let's show you how easy it is to do it.

Step 1 : Export the schema of your current database using expdp

Use the expdp on your current database to run export. Copy that dump file put it in a location from where you can upload it to object storage.

Step 2 : Upload the .dmp file to object storage.

In order to upload the .dmp file on object storage log in into your cloud console and click object storage:

Once in object storage, select the compartment that you want to use and create a bucket. I am going to use compartment "Liftandshift" and create bucket "LiftandShiftADW".

Bucket in Object Storage

Next click on the bucket and click upload to upload the .dmp file.

Upload .dmp file

At this point either you can use CLI (Command line Interface) or GUI (Graphic User interface) to upload the .dmp file. If your .dmp file is larger that 2Gib then you have to use CLI. I am going to use GUI since i have a small schema for the demonstration purpose.

Select the .dmp file that you want to upload to object storage and then click upload object.

Once you're done, your .dmp file will show up under objects in your Bucket Details Section

Step 3 : Create Authentication Token

Authentication Token will help us access Object Storage from Autonomous DB.

Under Governance and Administration Section, Click on Identity tab and go to users

Click on authorized user id and then click on Auth Token under resources on the left side to generate the Auth token.

Click Generate Token, give it a description, and then click Generate token again and it will create the token for you. Remember to save the token. Once the token is created and saved, you won't be able to retrieve it again.

You can click on the copy button and copy the token to a notepad. Remember to save the token because you will not be able to see the token again. Once done, you can hit the close button on the screen.

Step 4 : Login into ADW using SQLPLUS

Go to ADW homepage and click on the ADW database you have created.

Once in the database page click on DB Connection.

Click on the Download button to download the wallet. Once the zip file is downloaded, hit the close button.

Download the latest version of instant-client from Oracle website : https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

Unzip all the files in one location. I used the location "C:\instantclient\instantclient_18_3" on my system. Once unzipped you will be able to use sqlplus.exe and impdp.exe at that location. Also move the compressed wallet file to that location and unzip the file.

Next update the entries in the sqlnet.ora file and point it to the location of your wallet. I have changed mine to "C:\instantclient\instantclient_18_3" as shown below.

Test the connectivity using sqlplus.exe and make sure you are able to connect using the user-id admin.

Step 5: Create credentials in Autonomous Data Warehouse to connect to Object Storage

Use the below script to create credentials in ADW, and use the Authentication token created earlier as the password.

BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL(
credential_name => 'DEF_CRED_NAME',
username => 'oracleidentitycloudservice/ankur.saini@oracle.com',
password => '<password>' <------------ (Use Authentication token Value here instead of the password)
);
END;
/

Step 6 : Run import using Datapump

Since my ADW instance is built using 1 OCPU, I won't be using parallel as an option. I used the script below to run the import:

./impdp.exe admin/<Password>@liftandshift_high directory=data_pump_dir credential=def_cred_name dumpfile= https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/orasenatdoracledigital05/AnkurObject/hrapps.dmp exclude=index, cluster, indextype, materialized_view, materialized_view_log, materialized_zonemap, db_link

Step 7: Verify the import

You can see how easy it is to move the data to ADW, and that there is not a huge learning curve. Now you can be more productive and focus on your business.

Reference:

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data.html#GUID-297FE3E6-A823-4F98-AD50-959ED96E6969

https://blogs.oracle.com/datawarehousing/post/loading-data-into-autonomous-data-warehouse-using-datapump