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 6 (11.1.6)
• Other Significant Changes in this Document for 11g Release 6 (11.1.6)

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 My Oracle Support 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.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 Security Artifacts
  • 4.17.1 Patching Applications Policies (system-jazn-data.xml)
    • 4.17.1.1 Prerequisites for Patching Applications Policies in Online Mode
    • 4.17.1.2 Patching Applications Policies in Offline Mode using APM
  • 4.17.2 Patching Data Security Grants
    • 4.17.2.1 Prerequisites for Patching Data Security Grants
    • 4.17.2.2 Patching Data Security Grants
  • 4.17.3 Patching Data Role (RGX) Templates
    • 4.17.3.1 Manually Deploying Data Role (RGX) Templates
  • 4.17.4 Patching Data Security Grants and Data Role (RGX) Templates
  • 4.17.5 Backing up the Data Security Store
  • 4.17.6 Recovering Data Security Seed Data from the Backup
• 4.18 Patching Service-Oriented Architecture (SOA) Composites
  • 4.18.1 Preserving SOA Composite JDeveloper Customizations Before Applying a Patch
  • 4.18.2 Manually Deploying SOA Composites
• 4.19 Patching SOAEXTENSION Artifacts
• 4.20 Patching SOA Resource Bundles
  • 4.20.1 Manually Deploying SOA Resource Bundle JAR Files
• 4.21 Patching Sales Prediction Engine (SPE) Inline Service Artifacts
  • 4.21.1 Prerequisites Required Before Manual SPE Artifact Deployment
  • 4.21.2 Manually Deploying SPE Artifacts After You Apply the Patch in Offline Mode
• 4.22 Patching Tree Artifacts

5 Introduction to Oracle Fusion Applications Languages

• 5.1 Installing and Upgrading Languages
• 5.2 Maintaining Languages

6 Patching Oracle Fusion Middleware Extensions for Applications

• 6.1 Patching Applications Core Database Artifacts
  • 6.1.1 Artifacts Supported by Oracle Fusion Applications AutoPatch
  • 6.1.2 Running Oracle Fusion Applications AutoPatch
    • 6.1.2.1 Applying Patches Non-interactively
    • 6.1.2.2 End-to-End Patching Process
• 6.2 Patching Applications Core Middleware Artifacts
  • 6.2.1 Patching Global Menus in FndSetup
  • 6.2.2 Patching the Flexfield SOA Synch Composite
• 6.3 Log Files
• 6.4 Monitoring and Troubleshooting Applications Core Patching Sessions
  • 6.4.1 Starting AD Controller
  • 6.4.2 Reviewing Worker Status
  • 6.4.3 Determining Why a Worker Failed
  • 6.4.4 Restarting a Failed Worker
  • 6.4.5 Restarting a Failed Patching Session
  • 6.4.6 Abandoning a Failed Patching Session
  • 6.4.7 Applying a Patch to the Wrong Oracle Home
• 6.5 Performing System Maintenance Tasks

7 Patching Oracle Fusion Functional Setup Manager

• 7.1 Introduction to Oracle Fusion Functional Setup Manager
• 7.2 Patching Functional Setup Manager Database Artifacts
  • 7.2.1 Database Artifacts Supported for Functional Setup Manager
  • 7.2.2 Patching the Functional Setup Manager Database
• 7.3 Patching Functional Setup Manager Middleware Artifacts
  • 7.3.1 Middleware Artifacts Required by Functional Setup Manager
  • 7.3.2 Patching Functional Setup Manager Middleware Artifacts
  • 7.3.3 How to Patch Applications Policies (jazn-data.xml)
• 7.4 Log Files
• 7.5 Monitoring and Troubleshooting Patching Sessions
• 7.6 Performing System Maintenance Tasks

8 Patching Oracle Fusion Applications Functional Core

• 8.1 Introduction to Oracle Fusion Applications Functional Core
• 8.2 Patching Oracle Fusion Applications Functional Core Database Artifacts
• 8.3 Patching Oracle Fusion Applications Functional Core Middleware Artifacts
• 8.4 Log Files
• 8.5 Monitoring and Troubleshooting Patching Sessions
• 8.6 Performing System Maintenance Tasks

9 Performing System Maintenance Tasks

• 9.1 Introduction to AD Administration
  • 9.1.1 AD Administration Main Menu
  • 9.1.2 Valid Command-Line Arguments
  • 9.1.3 Prompts and Password Security
  • 9.1.4 Starting AD Administration
• 9.2 Maintaining Snapshot Information
  • 9.2.1 Maintain Snapshot Information Menu
    • 9.2.1.1 List Snapshots
    • 9.2.1.2 Update Current View Snapshot
    • 9.2.1.3 Create a Named View Snapshot
    • 9.2.1.4 Export a Snapshot to a File
    • 9.2.1.5 Import a Snapshot from a File
    • 9.2.1.6 Delete a Named View Snapshot
• 9.3 Maintaining Applications Database Entities
  • 9.3.1 Compiling Invalid Objects
  • 9.3.2 Running the Health Check
  • 9.3.3 Recreating Grants and Synonyms
  • 9.3.4 Maintaining Multi-lingual Tables
• 9.4 Running Maintenance Tasks Noninteractively
  • 9.4.1 Creating a Defaults File
  • 9.4.2 Selecting a Menu Option Noninteractively
  • 9.4.3 Selecting a Menu Option While Using a Defaults File
• 9.5 Running the HomeChecker Utility

10  Monitoring and Troubleshooting Patches

• 10.1 Oracle Fusion Applications Patch Manager Logging
  • 10.1.1 Log Files for Single Patch Manager Sessions
  • 10.1.2 Log Files for Multi-apply Patch Manager Sessions
  • 10.1.3 Timing Reports
• 10.2 Monitoring Patching Sessions
  • 10.2.1 Log Summary
  • 10.2.2 Diagnostics Report
• 10.3 General Troubleshooting for Oracle Fusion Applications Patching
  • 10.3.1 Starting a New Patching Session After the Previous Session Failed
  • 10.3.2 Abandoning a Failed Patching Session
  • 10.3.3 Recovering from an Interrupted Patching Session
  • 10.3.4 Retrying Failed Post-Patching Tasks in a Previous Session
    • 10.3.4.1 Requirements for retry mode
    • 10.3.4.2 Running fapmgr in retry mode
  • 10.3.5 Avoiding a Lost Connection During the Patching Session
  • 10.3.6 Resolving Components Locked by a Singleton Patch
  • 10.3.7 Resolving a Webcat Patch File Creation Failure
  • 10.3.8 Resolving an EditTimedOutException Error
  • 10.3.9 Revert To a Previous Flexfield Definition After It Is Updated By a Patch
  • 10.3.10 Resolving an Online Validation Error for BI Artifacts
  • 10.3.11 Finding Artifact Versions
  • 10.3.12 Backing Out Patches After They Have Been Successfully Applied
• 10.4 Troubleshooting Patching Sessions for SOA Composites
  • 10.4.1 Basic Troubleshooting for SOA Composite Failures
  • 10.4.2 Troubleshooting SOA Composite Validation Failures
    • 10.4.2.1 Oracle JDeveloper Customization Error
    • 10.4.2.2 SOA Server Not Available
    • 10.4.2.3 Administration Server Not Available
    • 10.4.2.4 SOA-Infra Server Is Ready
    • 10.4.2.5 Composite with Identical Revision Is Already Deployed
  • 10.4.3 Troubleshooting SOA Composite Deployment Failures
    • 10.4.3.1 Failed to Make New Composite Revision the Default
    • 10.4.3.2 Failed to Retire Previous Composite Revision
    • 10.4.3.3 Custom Metadata and Key Flexfield Changes Are Not Propagated Across Clusters
  • 10.4.4 Troubleshooting Complex Failures during SOA Patching
    • 10.4.4.1 No Base Composite Has Been Deployed
    • 10.4.4.2 Failure at Preparation Step
    • 10.4.4.3 Unknown Deployment Status
• 10.5 Troubleshooting Patching Sessions for Database Content
  • 10.5.1 Starting AD Controller
  • 10.5.2 Reviewing Worker Status
  • 10.5.3 Determining Why a Worker Failed
  • 10.5.4 Restarting a Failed Worker
  • 10.5.5 Terminating a Hung Worker Process
  • 10.5.6 Shutting Down the Manager
  • 10.5.7 Reactivating the Manager
  • 10.5.8 Resolving the Error, "Unable to start universal connection pool"
  • 10.5.9 Resolving a Worker Blocked by a Session
  • 10.5.10 Resolving an Error During Conflict Checking
  • 10.5.11 Resolving an Error During Upload of Flexfield Data
  • 10.5.12 Setting the Environment for Troubleshooting Database Issues