Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide

• New and Changed Features for 11g Release 7 (11.1.7)
• Other Significant Changes in this Document for 11g Release 7 (11.1.7)

1 Introduction to Oracle Fusion Applications Patching Framework

• 1.1 Maintaining Oracle Fusion Applications
• 1.2 Oracle Fusion Applications Patching Framework Components
  • 1.2.1 Oracle Fusion Applications Patch Manager
  • 1.2.2 Oracle Fusion Applications RUP Installer
  • 1.2.3 Oracle Fusion Applications Language Pack Installer
  • 1.2.4 AD Administration
  • 1.2.5 AD Controller
  • 1.2.6 HomeChecker
• 1.3 Oracle Fusion Applications Patching Framework Processes

2 Understanding Oracle Fusion Applications Patching Concepts

• 2.1 Patching Topology and Configuration
  • 2.1.1 Patching Installation and Configuration
  • 2.1.2 Oracle Fusion Applications Oracle Home
  • 2.1.3 Patch Top Directory
  • 2.1.4 Backup Copies of Patched Database Artifacts
  • 2.1.5 Oracle Universal Installer (OUI) Inventory
  • 2.1.6 Taxonomy URL
• 2.2 Patch Types
  • 2.2.1 Impact of a One-off Patch
• 2.3 Patch Directory Structure and Contents
  • 2.3.1 Patch Directory Structure
  • 2.3.2 Patch Contents
• 2.4 Oracle Fusion Applications Patching and the Security Model

3 Using Oracle Fusion Applications Patch Manager

• 3.1 Introduction to Oracle Fusion Applications Patch Manager
  • 3.1.1 Coordinated Patching
  • 3.1.2 Patching Database Artifacts
    • 3.1.2.1 Worker Processes
    • 3.1.2.2 File Version Verification
    • 3.1.2.3 Compiling Invalid Objects
  • 3.1.3 Patching Oracle Fusion Middleware Artifacts
  • 3.1.4 Online and Offline Patching
    • 3.1.4.1 Online Mode
    • 3.1.4.2 Offline Mode
  • 3.1.5 Applying Multiple Patches Using a Patch Plan
• 3.2 Running Oracle Fusion Applications Patch Manager
• 3.3 Validating Patches
• 3.4 Applying Patches
• 3.5 Running Patching Reports
  • 3.5.1 Patch Impact Report
    • 3.5.1.1 Running the Patch Impact Report
  • 3.5.2 Product Families Report
    • 3.5.2.1 Running the Product Families Report
    • 3.5.2.2 Example Syntax for the Product Families Report
  • 3.5.3 Patches Applied Report
    • 3.5.3.1 Running the Patches Applied Report
    • 3.5.3.2 Example Syntax for the Patches Applied Report
  • 3.5.4 Patch Status Report
    • 3.5.4.1 Running the Patch Status Report
  • 3.5.5 Diagnostics Report
    • 3.5.5.1 Running the Diagnostics Report
• 3.6 End-to-End Process for Applying Individual Patches
• 3.7 End-to-End Process for Applying Multiple Patches

4 Patching Oracle Fusion Applications Artifacts

• 4.1 Oracle Fusion Applications Patch Manager Middleware Artifact Support
• 4.2 Oracle Fusion Applications Patch Manager Database Artifact Support
• 4.3 Patching Oracle B2B Metadata
  • 4.3.1 Manually Deploying Trading Partner Agreements
    • 4.3.1.1 Deploying Agreements from the User Interface
    • 4.3.1.2 Deploying Agreements from the Command Line
• 4.4 Patching Oracle Business Intelligence Publisher Artifacts
  • 4.4.1 Prerequisites for Manual BI Publisher Artifact Deployment
  • 4.4.2 Manually Deploying BI Publisher Artifacts
• 4.5 Patching Oracle Business Process Management (Oracle BPM) Templates
  • 4.5.1 Manually Publishing Oracle BPM Templates
    • 4.5.1.1 Creating the mds-config.xml Configuration File
    • 4.5.1.2 Publishing the New Oracle BPM Template to the MDS Repository
• 4.6 Patching C Artifacts
• 4.7 Patching Common Resource (Activity Strings) Artifacts
• 4.8 Patching Diagnostic Testing Framework (DTF) JAR Files
• 4.9 Patching E-Mail and Web Marketing (EWM) Artifacts
• 4.10 Patching Flexfield Artifacts
  • 4.10.1 Manually Deploying Patched Flexfields
  • 4.10.2 Perform Flexfield NameSpaces Merge
• 4.11 Patching Group Space Templates
  • 4.11.1 Manually Deploying Group Space Templates
• 4.12 Patching Imaging and Process Management (IPM) Artifacts
  • 4.12.1 Prerequisites for the Deployment of IPM Artifacts
  • 4.12.2 Manually Deploying IPM Artifacts
• 4.13 Patching Java EE Artifacts
• 4.14 Patching Oracle Data Integrator (ODI) Artifacts
  • 4.14.1 Manually Importing ODI Changes
• 4.15 Patching Oracle Forms Recognition and Oracle Document Capture Artifacts
  • 4.15.1 Install OFR Artifacts
  • 4.15.2 Update ODC Expenses Metadata
• 4.16 Patching Oracle Fusion Applications Patch Manager Artifacts
• 4.17 Patching Script Files
• 4.18 Patching Security Artifacts
  • 4.18.1 Patching Applications Policies (system-jazn-data.xml)
    • 4.18.1.1 Prerequisites for Patching Applications Policies in Online Mode
    • 4.18.1.2 Patching Applications Policies in Offline Mode using APM
  • 4.18.2 Patching Data Security Grants
    • 4.18.2.1 Prerequisites for Patching Data Security Grants
    • 4.18.2.2 Patching Data Security Grants
  • 4.18.3 Patching Data Role (RGX) Templates
    • 4.18.3.1 Manually Deploying Data Role (RGX) Templates
  • 4.18.4 Patching Data Security Grants and Data Role (RGX) Templates
  • 4.18.5 Backing up the Data Security Store
  • 4.18.6 Recovering Data Security Seed Data from the Backup
• 4.19 Patching Service-Oriented Architecture (SOA) Composites
  • 4.19.1 Preserving SOA Composite JDeveloper Customizations Before Applying a Patch
  • 4.19.2 Manually Deploying SOA Composites
• 4.20 Patching SOAEXTENSION Artifacts
• 4.21 Patching SOA Resource Bundles
  • 4.21.1 Manually Deploying SOA Resource Bundle JAR Files
• 4.22 Patching Sales Prediction Engine (SPE) Inline Service Artifacts
  • 4.22.1 Prerequisites Required Before Manual SPE Artifact Deployment
  • 4.22.2 Manually Deploying SPE Artifacts After You Apply the Patch in Offline Mode
• 4.23 Patching Tree Artifacts

5 Introduction to Oracle Fusion Applications Languages

• 5.1 Installing and Upgrading Languages
• 5.2 Maintaining Languages

6 Patching Oracle Identity Management Artifacts

• 6.1 Overview of the Oracle Identity Management Patching Framework
  • 6.1.1 Products Supported
• 6.2 Understanding the Oracle Identity Management Patching Framework Concepts
  • 6.2.1 Oracle Identity Management Patch Manager
    • 6.2.1.1 Patch Plan Generation
  • 6.2.2 Oracle Identity Management Patcher
    • 6.2.2.1 Patch Plan Phases
  • 6.2.3 Oracle Identity Management Patching Framework Installation
  • 6.2.4 Directory Structure
  • 6.2.5 Configuration Files
  • 6.2.6 Verify patchtop-contents.properties
  • 6.2.7 Verify env.properties
• 6.3 Using the Oracle Identity Management Patching Framework
  • 6.3.1 Creating a Patch Plan
    • 6.3.1.1 Running Oracle Identity Management Patch Manager
    • 6.3.1.2 Creating a Patch Plan
  • 6.3.2 Applying Patches
  • 6.3.3 Applying Artifact Changes
    • 6.3.3.1 Prerequisites
    • 6.3.3.2 Log File
• 6.4 Oracle Identity Management Patching Options
  • 6.4.1 Post Installation Patching
  • 6.4.2 Ongoing Patching
  • 6.4.3 Patching DMZ/Disconnected Hosts
• 6.5 Monitoring and Troubleshooting
  • 6.5.1 Tracking Patch Progress
  • 6.5.2 Restarting a Failed Patch Session
  • 6.5.3 Rolling Back Patches
  • 6.5.4 Aborting a Patch Session
  • 6.5.5 Troubleshooting

7 Patching Oracle Fusion Middleware Extensions for Applications

• 7.1 Patching Applications Core Database Artifacts
  • 7.1.1 Artifacts Supported by Oracle Fusion Applications AutoPatch
  • 7.1.2 Running Oracle Fusion Applications AutoPatch
    • 7.1.2.1 Applying Patches Non-interactively
    • 7.1.2.2 End-to-End Patching Process
• 7.2 Patching Applications Core Middleware Artifacts
  • 7.2.1 Patching Global Menus in FndSetup
  • 7.2.2 Patching the Flexfield SOA Synch Composite
• 7.3 Log Files
• 7.4 Monitoring and Troubleshooting Applications Core Patching Sessions
  • 7.4.1 Starting AD Controller
  • 7.4.2 Reviewing Worker Status
  • 7.4.3 Determining Why a Worker Failed
  • 7.4.4 Restarting a Failed Worker
  • 7.4.5 Restarting a Failed Patching Session
  • 7.4.6 Abandoning a Failed Patching Session
  • 7.4.7 Applying a Patch to the Wrong Oracle Home
• 7.5 Performing System Maintenance Tasks

8 Patching Oracle Fusion Functional Setup Manager

• 8.1 Introduction to Oracle Fusion Functional Setup Manager
• 8.2 Patching Functional Setup Manager Database Artifacts
  • 8.2.1 Database Artifacts Supported for Functional Setup Manager
  • 8.2.2 Patching the Functional Setup Manager Database
• 8.3 Patching Functional Setup Manager Middleware Artifacts
  • 8.3.1 Middleware Artifacts Required by Functional Setup Manager
  • 8.3.2 Patching Functional Setup Manager Middleware Artifacts
  • 8.3.3 How to Patch Applications Policies (jazn-data.xml)
• 8.4 Log Files
• 8.5 Monitoring and Troubleshooting Patching Sessions
• 8.6 Performing System Maintenance Tasks

9 Patching Oracle Fusion Applications Functional Core

• 9.1 Introduction to Oracle Fusion Applications Functional Core
• 9.2 Patching Oracle Fusion Applications Functional Core Database Artifacts
• 9.3 Patching Oracle Fusion Applications Functional Core Middleware Artifacts
• 9.4 Log Files
• 9.5 Monitoring and Troubleshooting Patching Sessions
• 9.6 Performing System Maintenance Tasks

10 Performing System Maintenance Tasks

• 10.1 Introduction to AD Administration
  • 10.1.1 AD Administration Main Menu
  • 10.1.2 Valid Command-Line Arguments
  • 10.1.3 Prompts and Password Security
  • 10.1.4 Starting AD Administration
• 10.2 Maintaining Snapshot Information
  • 10.2.1 Maintain Snapshot Information Menu
    • 10.2.1.1 List Snapshots
    • 10.2.1.2 Update Current View Snapshot
    • 10.2.1.3 Create a Named View Snapshot
    • 10.2.1.4 Export a Snapshot to a File
    • 10.2.1.5 Import a Snapshot from a File
    • 10.2.1.6 Delete a Named View Snapshot
• 10.3 Maintaining Applications Database Entities
  • 10.3.1 Compiling Invalid Objects
  • 10.3.2 Running the Health Check
  • 10.3.3 Recreating Grants and Synonyms
  • 10.3.4 Maintaining Multi-lingual Tables
• 10.4 Running Maintenance Tasks Noninteractively
  • 10.4.1 Creating a Defaults File
  • 10.4.2 Selecting a Menu Option Noninteractively
  • 10.4.3 Selecting a Menu Option While Using a Defaults File
• 10.5 Running the HomeChecker Utility

11  Monitoring and Troubleshooting Patches

• 11.1 Oracle Fusion Applications Patch Manager Logging
  • 11.1.1 Log Files for Single Patch Manager Sessions
  • 11.1.2 Log Files for Multi-apply Patch Manager Sessions
  • 11.1.3 Timing Reports
• 11.2 Monitoring Patching Sessions
  • 11.2.1 Log Summary
  • 11.2.2 Diagnostics Report
• 11.3 General Troubleshooting for Oracle Fusion Applications Patching
  • 11.3.1 Starting a New Patching Session After the Previous Session Failed
  • 11.3.2 Abandoning a Failed Patching Session
  • 11.3.3 Recovering from an Interrupted Patching Session
  • 11.3.4 Avoiding a Lost Connection During the Patching Session
  • 11.3.5 Resolving Components Locked by a Singleton Patch
  • 11.3.6 Resolving a Webcat Patch File Creation Failure
  • 11.3.7 Resolving an EditTimedOutException Error
  • 11.3.8 Revert To a Previous Flexfield Definition After It Is Updated By a Patch
  • 11.3.9 Resolving an Online Validation Error for BI Artifacts
  • 11.3.10 Finding Artifact Versions
  • 11.3.11 Backing Out Patches After They Have Been Successfully Applied
• 11.4 Troubleshooting Patching Sessions for SOA Composites
  • 11.4.1 Basic Troubleshooting for SOA Composite Failures
  • 11.4.2 Troubleshooting SOA Composite Validation Failures
    • 11.4.2.1 Oracle JDeveloper Customization Error
    • 11.4.2.2 SOA Server Not Available
    • 11.4.2.3 Administration Server Not Available
    • 11.4.2.4 SOA-Infra Server Is Ready
    • 11.4.2.5 Composite with Identical Revision Is Already Deployed
  • 11.4.3 Troubleshooting SOA Composite Deployment Failures
    • 11.4.3.1 Failed to Make New Composite Revision the Default
    • 11.4.3.2 Failed to Retire Previous Composite Revision
    • 11.4.3.3 Custom Metadata and Key Flexfield Changes Are Not Propagated Across Clusters
  • 11.4.4 Troubleshooting Complex Failures during SOA Patching
    • 11.4.4.1 No Base Composite Has Been Deployed
    • 11.4.4.2 Failure at Preparation Step
    • 11.4.4.3 Unknown Deployment Status
• 11.5 Troubleshooting Patching Sessions for Database Content
  • 11.5.1 Starting AD Controller
  • 11.5.2 Reviewing Worker Status
  • 11.5.3 Determining Why a Worker Failed
  • 11.5.4 Restarting a Failed Worker
  • 11.5.5 Terminating a Hung Worker Process
  • 11.5.6 Shutting Down the Manager
  • 11.5.7 Reactivating the Manager
  • 11.5.8 Resolving the Error, "Unable to start universal connection pool"
  • 11.5.9 Resolving a Worker Blocked by a Session
  • 11.5.10 Resolving an Error During Conflict Checking
  • 11.5.11 Resolving an Error During Upload of Flexfield Data
  • 11.5.12 Setting the Environment for Troubleshooting Database Issues