THALES France

Project involvement for 12.1.3 to R12.2.7 Oracle E-Business Suite with Oracle Database Enterprise version 19c (CDB) database.

Oracle E-Business Suite Release 12.2 introduces Online Patching. This requires three application-tier file systems:

 fs1 (Production file system) – Used by the current users of the system.

 fs2 (Copy of production file system) – Used by the patching tools.

 fs_ne (Non-editioned file system) – Stores files containing data that is needed across all file systems (for example, data import and export files, report output files, and log files).

 Inst (INST_TOP) - Oracle E-Business Suite Release 12 Instance Home, contains all the config files, log files, SSL certificates, etc.

 

All three file systems serve a single database. The file system that is currently being used by the running application is never patched: all patches are applied to the file system that is not currently in use.

---

Company Profile : Thales S.A., trading as Thales Group is a French multinational company that designs, develops and manufactures electrical systems as well as devices and equipment for the aerospace, defense, transportation and security sectors.

---

Technical Changes Made:

1. Database Changes :

EBS 12.2 introduces a new Oracle database schema compared to version 12.1. Adjustments were made to programs and scripts to align with the new Oracle and custom schemas.

• Apps Schema Modifications: 150 package specifications/bodies were updated for apps schema across custom and PO schemas.

• JAVA Files: The directory paths for 25 JAVA files were updated from Custom TOP to the new JAVA TOP.

• Custom Tables: 380 custom tables were recreated to support the Editioning View.

  
  

2. Application Tier Changes :

Oracle E-Business Suite 12.2 now uses WebLogic Server as the application server, replacing Oracle’s Application Server used in 12.1.

• Custom Workflows: Oracle Custom Workflows were redesigned to meet updated requirements.

• iSupplier Page Adjustments: Pages using the Oracle Application Framework (OAF) and scripts referencing the application server were modified accordingly.

  
  

3. File System Layout Changes:

Oracle E-Business Suite 12.2 features a 3-file system layout, whereas 12.1 used a different layout.

• Custom scripts and programs referencing the file system layout of 12.1 were updated to support 12.2.

  
  

4. Existing Integrations:

Third-party products and integrations, such as VTOM and SPAG, were validated for compatibility with the R12.2 upgrade.

---