Showing posts with label EBS. Show all posts
Showing posts with label EBS. Show all posts

Friday, April 12, 2024

Oracle E-Business Suite Release 12.2 System Schema Migration

In This Document

Section 1: Overview of the EBS System Schema

The Release 12.2 database architecture has been modernized by adoption of the Oracle E-Business Suite System Schema, EBS_SYSTEM. Prior to the introduction of the EBS_SYSTEM schema, Oracle E-Business Suite installed application objects in the Oracle Database SYS and SYSTEM schemas. Migration to the EBS System Schema obviates the need for any EBS-owned objects to reside in the SYS or SYSTEM schemas.

Key characteristics of the EBS System Schema include:

  • Creation of the EBS_SYSTEM schema and associated grant management is performed as follows:
    1. Creation of the EBS_SYSTEM schema and is performed by SYS running the adgrants.sql script (supplying the APPS account as the parameter) before applying the AD-TXK Delta 13 (or later) RUPs.
    2. Grants required by the APPS account are run automatically by the AD-TXK Delta 13 (or later) RUP installation process.
  • All EBS database objects that currently reside in the SYS or SYSTEM schemas are migrated to appropriate Oracle E-Business Suite schemas. Depending upon the EBS object type and function, the object is migrated to EBS_SYSTEMAPPS, or APPS_NE.

  • All Oracle E-Business Suite administration actions (such as running adop, adadmin and other utilities) are now performed by EBS_SYSTEM.

  • Access to the Oracle database SYS and SYSTEM and the Oracle database server operating system is no longer required for Oracle E-Business Suite system administrative functions.

  • If any grants need to be fixed after the AD-TXK Delta 13 (or later) RUPs are applied, refer to My Oracle Support Knowledge Document 2758993.1Managing Database Privileges in Oracle E-Business Suite Release 12.2 (Running adgrants.sql).

Key benefits of migrating to the EBS System Schema include support for the following features:

  • Public Oracle Database APIs
  • Least Privileges Model for database object access
  • Separation of Duties for administrators
  • Database service names for application tier database connections
  • Oracle Database Unified Auditing
  • Easier interoperability across Oracle Database releases

Diagram 1 - The modernized Oracle E-Business Suite database and its key features.

Modernized EBS Database

Each of these will be discussed in the subsections below. Be aware that numbering of the subsections is for ease of reference only, and is not intended to reflect any set order of importance.

1.1 Public Oracle Database APIs

As part of the Oracle E-Business Suite System Schema Migration, all Oracle E-Business Suite code is updated to map to public Oracle database dictionary objects and APIs. Utilizing public Oracle database APIs provides further capability to lock down EBS runtime accounts.

1.2 Least Privileges Model for Database Object Access

With the migration to the EBS_SYSTEM schema and usage of public Oracle Database APIs, runtime accounts may be constrained even further. As part of this feature, unnecessary privileges are revoked from Oracle E-Business Suite application accounts.

1.3 Separation of Duties for Administrators

Migration to the EBS_SYSTEM schema makes it possible to separate the role of the Oracle E-Business Suite system administrators from database administrators. All Oracle E-Business Suite administration actions (such as running adop, adadmin, and other utilities) will now prompt for the EBS_SYSTEM password instead of the SYSTEM password. Highly privileged operations that were previously run by the SYS or SYSTEM accounts are now run by EBS_SYSTEM.

Access to the Oracle database SYS and SYSTEM and the Oracle database server operating system is no longer required for Oracle E-Business Suite system administration functions. Database patching may be performed by the Oracle database administrator, and Oracle E-Business Suite patching may be performed by the Oracle E-Business Suite system administrator or applications database administrator (DBA).

The passwords for EBS_SYSTEM and SYSTEM must match until after the Completion Patch is successfully applied. Once the Completion Patch has been successfully applied, the password for EBS_SYSTEM should be changed to be different from the SYSTEM schema password.

1.4 Database Service Names for Application Tier Database Connections

As part of modernizing the Oracle E-Business Suite, connections from the Oracle E-Business Suite application tier to the Oracle E-Business Suite database are now performed using database service names.

1.5 Support for Oracle Database Unified Auditing

Once all requirements are met, Oracle E-Business Suite customers are now able to utilize Unified Auditing, the latest method for auditing an Oracle Database. With Unified Auditing, audit data is combined into a single audit trail.  A new schema, AUDSYS, is used for storing the Unified Audit Trail. Separation of duties is achieved with multiple database roles to audit configuration and view the audit data.

For additional information, refer to My Oracle Support Knowledge Document 2777404.1Enabling Unified Auditing in Oracle E-Business Suite Release 12.2 with Oracle Database 19c or 12c.

1.6 Streamline Database Directory Objects

Following migration to EBS System Schema (EBS_SYSTEM), the APPS schema will no longer have the ability to create database directory objects. Database directory objects are now created by the EBS_SYSTEM user.

The following four standard new database directory objects are created with the privileges shown:

Object NamePrivileges
EBS_LOG

Read/Write

EBS_TEMPRead/Write
EBS_INBOUNDRead
EBS_OUTBOUNDWrite

By default, the database directory objects are mapped to a temporary directory in the $ORACLE_HOME on the database tier file system. If a large number of files are written to this directory, your $ORACLE_HOME database tier file system may reach capacity: it is therefore recommended that you instead map the database directory objects to a secure location in a separate mount point from your $ORACLE_HOMEdatabase tier file system. For more information, refer to the Oracle Database documentation for your specific database release.

1.7 Interoperabilty Across Oracle Database Releases

Oracle E-Business Suite uptake of database releases will be made easier by EBS only referencing public database views and APIs.

Section 2: Requirements for Using the EBS System Schema

2.1 Prerequisites

To use the EBS System Schema, you need to be on Oracle E-Business Suite Release 12.2.3 or later.

2.2 Mandatory Patches and Steps

You must have available the following release update packs (RUPs) and other patches, ready to apply below in Section 3, in the order shown here.

  1. AD and TXK Delta 13 (or later) — Support for EBS System Schema Migration was introduced in the Oracle Applications DBA (AD) and Oracle E-Business Suite Technology Stack (TXK) Delta 13 release update packs. Earlier releases of AD and TXK included database objects owned by AD or TXK that resided in the Oracle Database SYS or SYSTEM schemas, and also included references to private Oracle database SYS or SYSTEM objects.

    With AD and TXK Delta 13 (or later), EBS database objects are migrated from SYS and SYSTEM into the EBS_SYSTEMAPPS, or APPS_NE schemas.  All relevant object references are updated to point to the migrated objects in the APPS or APPS_NE schemas.

    AD and TXK Delta 13 (or later) also update all code that previously referenced private Oracle Database SYS and SYSTEM objects, to reference Oracle Database approved public objects or public APIs instead.

  2. EBS Release 12.2.11 (or later), or EBS Releases 12.2.3 to 12.2.10 plus EBS System Schema Migration Consolidated Patch — Oracle E-Business Suite Releases 12.2.3 to 12.2.10 include EBS-owned database objects that reside in the database SYS or SYSTEM schemas, or reference database SYS or SYSTEM objects. The EBS System Schema Migration Consolidated Patch (also referred to as the Consolidated Patch) migrates these objects to the appropriate EBS schemas. Note that EBS Release 12.2.11 (and later) include the Consolidated Patch.

    Note: Oracle E-Business Suite Release 12.2.11 (and later) do not install EBS objects in the SYS or SYSTEM schemas, and therefore do not require the EBS System Schema Migration Consolidated Patch.

  3. Before proceeding with application of the final patch in Step 4, you must update any customizations that have been identified with mandatory compliance requirements. For guidance, refer to My Oracle Support Knowledge Document 1577661.1Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2.

  4. EBS System Schema Migration Completion Patch — Although it is possible to apply AD-TXK Delta 13 and the EBS System Schema Migration Consolidated Patch without applying the EBS System Schema Migration Completion Patch immediately afterwards, the migration is not finished until the Completion Patch has been applied. This patch drops AD, TXK, and EBS product code in the database SYS or SYSTEM schemas, and removes any final restricted references to database SYS or SYSTEM objects.

    Prior to applying the Completion Patch, you must apply the following prerequisite patches:
    • AD-TXK Delta 13 (or later)
    • Either the EBS Release 12.2.11 (or later) RUP or the EBS System Schema Migration Consolidated Patch

    The Completion Patch will fail to apply if you do not apply these patches first.

    Diagram 2 - The four major requirements for EBS System Schema Migration.

    Note: The principles shown in the diagram also apply to AD and TXK RUPs later than Delta 13.


    Requirements to Complete System Schema Migration

    Note: Until the Oracle E-Business Suite System Schema Migration Completion Patch (also referred to as the Completion Patch) has been applied, the EBS_SYSTEM and Oracle Database SYSTEM schema passwords must be identical. This requirement is for backward compatibility, until all EBS code has been migrated from the SYS or SYSTEM schemas. Diagram 3 depicts when the EBS_SYSTEM and SYSTEM passwords must be identical.

    Diagram 3 - The need for the EBS_SYSTEM and SYSTEM passwords to match.

    Note: The principles shown in the diagram also apply to AD and TXK RUPs later than Delta 13.

    EBS_SYSTEM and SYSTEM Passwords Must Match

    Note: After the Completion Patch has been applied, the EBS_SYSTEM and Oracle Database SYSTEM passwords can be different, and we recommend that they are. Diagram 4 depicts when it is recommended to update the EBS_SYSTEM and SYSTEM passwords to unique values.

    Diagram 4 - The need to update the EBS_SYSTEM and SYSTEM passwords to have unique (different) values.

    Note: The principles shown in the diagram also apply to AD and TXK RUPs later than Delta 13.

    Make EBS_SYSTEM and SYSTEM Passwords Unique

Section 3: Migrating to the EBS System Schema

Migration consists of several stages, as summarized below.

By performing the applicable steps in this section, you will:

  1. Apply the latest AD-TXK RUP.
  2. Either:
    • Apply the EBS Release 12.2.11 (or later) RUP.
      or:
    • If remaining on any EBS release from 12.2.3 to 12.2.10 inclusive, apply the EBS System Schema Migration Consolidated Patch.
  3. Update any customizations reported with mandatory compliance requirements for the EBS System Schema migration.
  4. Apply the EBS System Schema Migration Completion Patch.

3.1 Upgrade Oracle E-Business Suite to Release 12.2.3 or Later

If applicable, upgrade your Oracle E-Business Suite environment to at least Release 12.2.3. We highly recommend that you upgrade to the latest available EBS Release RUP. For more information, refer to My Oracle Support Knowledge Document 1320300.1Oracle E-Business Suite Release Notes, Release 12.2.

Refer to whichever of these books is relevant to you:

3.2 Apply Latest AD-TXK RUPs

Apply the latest release update packs for AD and TXK for Release 12.2, by following the instructions in My Oracle Support Knowledge Document 1617461.1Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2. AD and TXK introduced support for EBS System Schema Migration starting with R12.AD.C.Delta.13 and R12.TXK.C.Delta.13.

Note: Oracle strongly recommends that you always apply the latest version of the AD and TXK RUPs at the earliest opportunity.

3.3 Apply Either EBS Release 12.2.11 (or later), or Consolidated Patch for Releases 12.2.3 to 12.2.10

If you are are on an Oracle E-Business Suite release from 12.2.3 to 12.2.10 inclusive, we recommend upgrading to Release 12.2.11 by applying the EBS 12.2.11 (or later) RUP. If you are not currently planning to upgrade to Release 12.2.11 (or later), you must apply the EBS System Schema Migration Consolidated Patch, Patch 31817501. For instructions, refer to My Oracle Support Knowledge Document 2774309.1Applying the Oracle E-Business Suite Consolidated Patch for EBS System Schema Migration.

3.4 Remove Customization Dependencies on Database SYS or SYSTEM Objects

3.4.1 Mandatory Steps

Run the Oracle E-Business Suite System Schema Migration Compliance Checker report, ADSYSCC.sql, and remove or update any of your customizations that would give errors on running the EBS System Schema Migration Completion Patch. For detailed instructions, refer to My Oracle Support Knowledge Document 1577661.1Developing and Deploying Customizations in Oracle E-Business Suite Release 12.

3.4.2 Optional Steps

Run the Oracle E-Business Suite System Schema Migration Compliance Checker report, ADSYSCC.sql, and remove or update any of your customizations that are identified with mandatory compliance requirements and would result in invalid database objects for your customizations.

3.5 Apply EBS System Schema Migration Completion Patch

Before the Oracle E-Business Suite System Schema Migration Completion Patch ("Completion Patch") can be applied, all EBS code must have been migrated from the SYS or SYSTEM schemas to the APPS or APPS_NE schemas. To finish the migration process, the EBS System Schema Migration Completion Patch will drop all EBS code that resides in the SYS or SYSTEM accounts.

Consequently, before you apply the Completion Patch, any custom code that points to EBS-defined objects in Oracle Database system accounts must be updated to point to the appropriate migrated EBS-defined objects in EBS-defined schemas. Failure to do so will result in invalid database objects for your custom code.

Apply the Oracle E-Business Suite System Schema Migration Completion Patch (Patch 32573930) by following the steps below.

Note: If you have previously applied the Completion Patch as per the steps in this section, do not re-perform the steps.
  1. Source the run edition applications environment:

    UNIX:
  2. <INSTALL_BASE>/EBSapps.env run
    Windows:
    C:\> <INSTALL_BASE>\EBSapps.cmd run
  3. Before proceeding with application of the Completion Patch, perform a full adop cleanup by running the following command:
  4. adop phase=cleanup cleanup_mode=full
  5. Run the EBS System Schema Migration Compliance Checker, ADSYSCC.sql. When prompted, enter the APPS schema password.
    sqlplus <APPS schema name>@<TWO_TASK> @$AD_TOP/sql/ADSYSCC.sql
    This utility reports all violations of the EBS System Schema Migration Standards. Any EBS violations are fixed by both the EBS Release 12.2.11 (or later) RUP and the EBS System Schema Migration Consolidated Patch. If the report for your environment includes EBS violations after you have applied all mandatory patches (including the Completion Patch), you should log a service request with Oracle Support.

    You must fix any mandatory compliance violations listed in this report that are part of your custom code. For detailed instructions, refer to My Oracle Support Knowledge Document 1577661.1Developing and Deploying Customizations in Oracle E-Business Suite Release 12.

  6. Note: If you proceed with applying the Completion Patch when there are reported violations with custom code, you will have invalid database objects until your custom code is fixed.

    If after applying the completion patch there are reported violations with EBS code, log a service request with Oracle Support to obtain assistance.

  7. (Conditional) If you have integrated EBS with Oracle Database Vault, disable all existing Oracle Database Vault realms by navigating to the $FND_TOP/patch/115/sql directory and running the fnddbvstatus.sql script as follows:
    SQL> @fnddbvstatus.sql DISABLE
    For more information, refer to Appendix A, Management Scripts, in the following My Oracle Support knowledge documents:
    • Document 2131435.1Integrating Oracle E-Business Suite Release 12.2 with Oracle Database Vault 12c
    • Document 2617770.1, Integrating Oracle E-Business Suite Release 12.2 with Oracle Database Vault 19c

  8. Apply the Completion Patch by running the following adop command, as shown in this UNIX example:
  9. adop phase=apply patches=32573930 apply_mode=hotpatch options=forceapply,nocopyportion,nogenerateportion
    Note: You may encounter errors if you attempt to apply the Completion Patch and have specified different passwords for the EBS_SYSTEM and SYSTEM schemas.To apply the completion patch successfully, the SYSTEM and EBS_SYSTEM passwords must be the same.

  10. Run the adsysmigclnup.sql cleanup script on the database tier by performing substeps a to d below. This will drop AD objects from the SYS schema and revoke the associated privileges.

    1. Create <ORACLE_HOME>/appsutil/admin on the database server.

    2. Copy <AD_TOP>/patch/115/sql/adsysmigclnup.sql to the database tier <ORACLE_HOME>/appsutil/admin directory using the appropriate command for your system:

      UNIX:
    3. cp $AD_TOP/patch/115/sql/adsysmigclnup.sql $ORACLE_HOME/appsutil/admin
      Windows:
      C:\> copy %AD_TOP%\patch\115\sql\adsysmigclnup.sql %ORACLE_HOME%\appsutil\admin
    4. Set the environment to point to the $ORACLE_HOME on the database server.

    5. Note: If the database is multitenant, source using the following steps as applicable for your environment.

      UNIX:
      $ source $ORACLE_HOME/<CDB_NAME>_<NODE_NAME>.env
      export ORACLE_PDB_SID=<EBS_PDB_Name>
      Windows:
      C:\> %ORACLE_HOME%\<EBS_PDB_Name>_<NODE_NAME>.cmd
    6. Use SQL*Plus to run the cleanup script as follows.

      UNIX:
      sqlplus /nolog
      SQL> @$ORACLE_HOME/appsutil/admin/adsysmigclnup.sql <APPS schema name>
      Windows:
      C:\> sqlplus /nolog
      SQL> @%ORACLE_HOME%\appsutil\admin\adsysmigclnup.sql <APPS schema name>
      Note: If you find new invalid objects after performing the above steps, compile the invalid objects by running $ORACLE_HOME/rdbms/admin/utlrp.sql as the SYS user.

      Note: If you have Oracle Database Vault enabled, you may see an error message like the following in the report produced after the cleanup script runs:

      revoke READ on SYS.DUAL from "DVSYS" ERROR ORA-01031: insufficient privileges
      Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

      Such errors can be safely ignored.

    7. (Conditional) If you are using a multitenant database on UNIX and set ORACLE_PDB_SID in step c, you must unset it now:
      unset ORACLE_PDB_SID
  11. After you have applied the Completion Patch, you should change the EBS_SYSTEM password and SYSTEM passwords by running substeps a to c below. We recommend that you set the two passwords to unique values (i.e. different from each other).

    1. On the application tier, source the environment using the appropriate command for your system:

      UNIX:
      $ . <INSTALL_BASE>/EBSapps.env run
      Windows:
      C:\> <INSTALL_BASE>\EBSapps.cmd run
      Still on the application tier, change the EBS_SYSTEM schema password to be different from that of the SYSTEM schema password, and provide the new password only to DBAs who specifically require access to the SYSTEM account:
      sqlplus EBS_SYSTEM/<EBS_SYSTEM PASSWORD>
      SQL> alter user EBS_SYSTEM identified by <NEW PASSWORD>;
    2. On the database tier, set the environment using the appropriate command for your system:

      UNIX:
      . $ORACLE_HOME/<CDB SID>_<HOST>.env
      Windows:
      C:\> %ORACLE_HOME%\<CDB_SID>_<HOST>.cmd
    3. Still on the database tier, change the SYSTEM schema password, and provide the new password only to DBAs who specifically require access to the SYSTEM account.
    4. sqlplus SYSTEM/<SYSTEM PASSWORD>
      SQL> alter user SYSTEM identified by <NEW PASSWORD>
      ;
      Note: If your EBS instance is integrated with Oracle Database Vault, connect as the <DV_ACCTMGR> user instead of the SYSTEM user.


  12. Validate adop by performing substeps (a) and (b) below.

    1. Source the run edition applications environment.

      UNIX:
      $ . <INSTALL_BASE>/EBSapps.env run
      Windows:
      C:\> <INSTALL_BASE>\EBSapps.cmd run
    2. Run the command:
      adop -validate
  13. (Conditional) Integrate Oracle E-Business Suite with Oracle Database Vault using EBS_SYSTEM.

    If you have previously integrated EBS with Oracle Database Vault, follow subsection (a) below. If you have not previously performed such an integration but would like to do so now, follow subsection (b).

    1. Existing Integration with Oracle Database Vault

      1. Enable Oracle Database Vault by navigating to the $FND_TOP/patch/115/sql directory and running the following command:
        SQL> @fnddbvstatus.sql ENABLE
      2. Download and apply Patch 33267691:R12.AD.C.

      3. Follow Section 3: Integrate Oracle Database Vault with Oracle E-Business Suite Release 12.2 in My Oracle Support knowledge Document 2727580.1Integrating Oracle E-Business Suite Release 12.2 with Oracle Database Vault using EBS_SYSTEM.

    2. New Integration with Oracle Database Vault

      Follow the instructions in My Oracle Support Knowledge Document 2727580.1Integrating Oracle E-Business Suite Release 12.2 with Oracle Database Vault using EBS_SYSTEM

 Oracle E-Business Suite Release 12.2 System Schema Migration (Doc ID 2755875.1)

Tuesday, March 19, 2024

Important 12.2 Documents

10 References

This section lists the reference material that can be read to gain further knowledge in the various areas relevant to establishing a Maximum Availability Architecture for Oracle E-Business Suite, including the materials referenced to develop the processes described in this paper.

Database MAA:

Oracle Database High Availability Overview and Best Practices

Automatic Storage Management Administrator's Guide

Database Backup and Recovery User's Guide

 “Oracle Flashback Technology” in Oracle Database Concepts

Flashback Database Best Practices & Performance (Doc ID 565535.1)

“Using Edition Based Redefinition” in the Database Development Guide

Database Oracle Data Guard:

Data Guard Concepts and Administration

Data Guard Broker

Creating a Physical Standby using RMAN Duplicate (RAC or Non-RAC) (Doc ID 1617946.1)

Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and Oracle Database 19c (Doc ID 2608030.1)

Oracle Patch Assurance - Data Guard Standby-First Patch Apply (Doc ID 1265700.1)

Oracle Real Application Clusters (RAC):

Real Application Clusters Administration and Deployment Guide

Clusterware Administration and Deployment Guide

Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 (Doc ID 2530665.1)

Oracle RAC Rolling Install Process for the “Oracle JavaVM Component Database PSU” (OJVM PSU) Patches (Doc ID 2217053.1)

Oracle E-Business Suite MAA:

Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Logical Host Names (Doc ID 2617788.1)

Oracle E-Business Suite on Exadata Database Machine (White Paper)

Oracle Site Guard

Oracle E-Business Suite Parallel Concurrent Manager:

Configuring and Managing Oracle E-Business Suite Release 12.2.x Forms and Concurrent Processing for Oracle RAC (Doc ID 2029173.1)

How to Activate Parallel Concurrent Processing - Background Facts and Setup Steps (Doc ID 602899.1)

Concurrent Processing - Parallel Concurrent Processing Failover/Failback Expectations (Doc ID 271090.1)

Managing Concurrent Manager Log and Out Directories (Doc ID 1616827.1)

Concurrent Processing - Purge Concurrent Request and/or Manager Data Program (FNDCPPUR) (Doc ID 104282.1)

Concurrent Processing - Best Practices for Performance for Concurrent Managers in E-Business Suite (Doc ID 1057802.1)

Concurrent Processing - Product Information Center (PIC) (Doc ID 1304305.1)

Oracle E-Business Suite Configuration and Management:

Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)

Can The Primary Node Hosting the WLS Admin Server Failover To A 12.2 Slave Node, Migrating the Master WLS Admin Server To Another Machine (Doc ID 1986122.1)

Oracle Applications E-Business Suite 12.2 Fusion Middleware Log Files: Locate, View, and Control (Doc ID 1366187.1)

Managing Configuration of Oracle HTTP Server and Web Application Services in Oracle E-Business Suite Release 12.2 (Doc ID 1905593.1)

HTTP Server Is Either Slow Or Stops Responding When Installed On A NFS Mounted Drive [Doc ID 560853.1]

Using Load-Balancers with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 380489.1)

E-Business Suite 12.2 Detailed Steps To Change The R12.2 Default Port To 80 (Doc ID 2072420.1)

How to Change Applications Passwords using Applications Schema Password Change Utility (FNDCPASS or AFPASSWD) (Doc ID 437260.1)

Secure Configuration Guide for Oracle E-Business Suite Release 12 (Doc ID 403537.1)

R12.2 : How To Create, Update or Rebuild The Central Inventory For Oracle Applications E-Business Suite ? (Doc ID 1588609.1)

How to Create a Clean oraInventory in Release 12.2 (Doc ID 1967205.1)

Best Practices for Gathering Statistics with Oracle E-Business Suite (Doc ID 1586374.1)

Fixed Objects Statistics Considerations [Doc ID 798257.1]

Sharing the Application Tier File System in Oracle E-Business Suite Release 12.2 (Doc ID 1375769.1)

Cloning Oracle E-Business Suite:

Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone (Doc ID 1679270.1)

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)

Oracle E-Business Suite Application Tier Patching:

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 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 (Doc ID 2233485.1)

12.2 Online Patching Utility ADOP Fails During Cutover Due to Error "[UNEXPECTED] adop has detected a configured disaster recovery site" (Doc ID 2131833.1)

The adop Patch Utility in the E-Business Suite Maintenance Guide

Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 (Doc ID 2033780.1)

OPMN Fails to Start and Says to Check Adopmnctl.txt (Doc ID 2174221.1)

Oracle Engineered Systems (Exadata, SuperCluster):

Exadata Database Machine and Exadata Storage Server Supported Versions (Doc ID 888828.1)

Oracle Exadata Database Machine exachk or HealthCheck (Doc ID 1070954.1)

Oracle Exadata Best Practices (Doc ID 757552.1)

Database Patches Required by Oracle E-Business Suite on Oracle Engineered Systems: Exadata Database Machines and SuperClusters (Doc ID 1392527.1)

Exadata Write-Back Flash Cache - FAQ (Doc ID 1500257.1)

Oracle Exadata Database Machine Performance Best Practices (Doc ID 1274475.1)

Configuring Exadata I/O Resource Manager for Common Scenarios (Doc ID 1363188.1)

Oracle Exadata Database Machine Setup/Configuration Best Practices (Doc ID 1274318.1)

Oracle SuperCluster Supported Software Versions – All Hardware Types (Doc ID 1567979.1)

OS Required Packages and HugePages:

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

HugePages on Oracle Linux 64-bit (Doc ID 361468.1)

HugePages and Oracle Database 11g Automatic Memory Management (AMM) on Linux (Doc ID 749851.1)

USE_LARGE_PAGES To Enable HugePages (Doc ID 1392497.1)

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

 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

 

newStartCD 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

 

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

 

newChanging 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

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

newGetting 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

newANNOUNCEMENT: 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

newOracle 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

Oracle E-Business Suite Release 12 Critical Patch Update Knowledge Document (April 2019) Note 2514102.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


 

 

newAD 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

newOracle 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)

Oracle E-Business Suite Release 12.2 System Schema Migration

In This Document Section 1: Overview of the EBS System Schema Section 2: Requirements for Using the EBS System Schema Section 3: Migrating t...