Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide for Release 11.1.3

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 Release Update Patch 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 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 Dropping Work Tables After Patching in Online Mode
  • 4.14.2 Manually Importing ODI Changes
• 4.15 Patching Oracle Fusion Applications Patch Manager Artifacts
• 4.16 Patching Oracle Fusion Applications Help Content
• 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 With Authorization Policy Manager
  • 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 Installing Release Update Patches (11.1.3.0.0)

• 5.1 Introduction to Oracle Fusion Applications Release Update Patches
  • 5.1.1 Release Update Patches
  • 5.1.2 Oracle Fusion Applications RUP Installer (RUP Installer)
  • 5.1.3 RUP Installer User Interface
    • 5.1.3.1 Abort Button
    • 5.1.3.2 Cancel Button
    • 5.1.3.3 Close Button
    • 5.1.3.4 Continue Button
    • 5.1.3.5 Next Button
    • 5.1.3.6 Retry Button
  • 5.1.4 RUP Installer Configuration Tasks
    • 5.1.4.1 Installers Invoked by the Apply Pre-PSA Middleware Patches Tasks
    • 5.1.4.2 Patches Not Supported by the Apply Pre- and Post-PSA Middleware Patches Tasks
    • 5.1.4.3 Validation Steps Performed During Online Preverification Task
• 5.2 Prepare to Install a RUP - Pre-Down Time
  • 5.2.1 Before You Begin
  • 5.2.2 Confirm Installation of Oracle Fusion Applications RUP1 (11.1.2.0.0)
  • 5.2.3 Download the RUP Repository
    • 5.2.3.1 Obtaining the Software
    • 5.2.3.2 Downloading from the Oracle Software Delivery Cloud Portal
    • 5.2.3.3 Release Update Patch Installers
  • 5.2.4 Configure Oracle Metadata Services (MDS)
  • 5.2.5 Verify Your OPatch Version
  • 5.2.6 Confirm Memory Settings
  • 5.2.7 Confirm Host Name (Unix)
  • 5.2.8 Add -d64 Option to JRE_MEMORY_OPTIONS (Solaris X64 and Solaris Sparc)
  • 5.2.9 Confirm the Local Port Range Value
  • 5.2.10 Confirm Database Settings
  • 5.2.11 Confirm All Oracle Homes Are Registered in the Central Inventory
  • 5.2.12 Update Oracle Fusion Middleware Schema Credentials
  • 5.2.13 Maintain Versions of Customized BI Publisher Reports
  • 5.2.14 Confirm That JDeveloper Customizations Can Be Merged
  • 5.2.15 Verify Credentials in Oracle Directory Services Manager (ODSM)
  • 5.2.16 Verify the Default Realm Name is myrealm
  • 5.2.17 Save WebLogic Configuration Changes
• 5.3 Prepare to Install a RUP - During Downtime
  • 5.3.1 Upgrade Identity Management Domain to the RUP2 Level
  • 5.3.2 Apply Mandatory Prerequisite Patches
    • 5.3.2.1 Stop Services on Windows Before Applying Mandatory Patches
  • 5.3.3 Verify the Status of Servers and Processes
    • 5.3.3.1 Stop Running SES Schedules
    • 5.3.3.2 Stop the Node Manager and the OPMN Control Process
    • 5.3.3.3 Start the OPSS Security Store
    • 5.3.3.4 Confirm the First Node is Running in a RAC Database
    • 5.3.3.5 Start Servers That Were Added After Provisioning
    • 5.3.3.6 Confirm the Database is Running and in Idle State
    • 5.3.3.7 Confirm All Oracle Fusion Applications Patch Manager Processes Are Complete
    • 5.3.3.8 Confirm All Oracle Fusion Applications AutoPatch Processes are Complete
    • 5.3.3.9 Confirm All AD Administration Sessions Are Complete
    • 5.3.3.10 Steps for Windows Platforms
  • 5.3.4 Perform Required Backups
    • 5.3.4.1 Back Up Oracle Fusion Applications
    • 5.3.4.2 Back Up the OPSS Security Store
    • 5.3.4.3 Back Up Applications and System Policies
    • 5.3.4.4 Back Up Oracle Business Intelligence RPD Customizations
    • 5.3.4.5 Back Up Steps for Windows Platforms
• 5.4 Install a RUP
  • 5.4.1 Perform the Installation
    • 5.4.1.1 Start RUP Installer
    • 5.4.1.2 Run RUP Installer
  • 5.4.2 Complete the Post Installation Tasks
• 5.5 Troubleshoot RUP Installer Sessions
  • 5.5.1 RUP Installer Log File Directories
  • 5.5.2 Troubleshooting Failures During the Installation Phase
    • 5.5.2.1 Invalid Oracle Home
    • 5.5.2.2 Error in Writing to File, Text File Busy
    • 5.5.2.3 Inventory Pointer File is Empty
  • 5.5.3 General Troubleshooting During the Configuration Phase
  • 5.5.4 The Next Button Is Not Enabled During Configuration Tasks
  • 5.5.5 Error Finding WEBLOGIC_HOME
  • 5.5.6 Error During Bootstrapping Patch Manager
  • 5.5.7 Troubleshooting Applying Middleware Patches
  • 5.5.8 Failure During Applying Middleware Patch Sets
  • 5.5.9 EditTimedOutException Error During Online Preverification
  • 5.5.10 Troubleshooting Loading Database Components
    • 5.5.10.1 Error While Loading Database Tasks
    • 5.5.10.2 Database Failure While Loading Database Components
    • 5.5.10.3 AutoPatch Validation Fails
  • 5.5.11 LdapServerCheck Failure
  • 5.5.12 Troubleshooting Deployment of Applications Policies
    • 5.5.12.1 Failure During Deployment of Applications Policies
    • 5.5.12.2 Stripe Version Mismatch in Applications Policies
    • 5.5.12.3 IDM Server Failure During Deployment of Applications Policies
    • 5.5.12.4 JAZN Policy Stripe Version Validation Failure
    • 5.5.12.5 migrateSecurityStore Command Fails
  • 5.5.13 Failure during Applying OAM Configuration
  • 5.5.14 Webcat Patch File Creation Failure
  • 5.5.15 Failure During Deployment of BI Publisher Artifacts
  • 5.5.16 Failures During Starting All Servers
    • 5.5.16.1 General Failure
    • 5.5.16.2 Failure to Start BIServer
  • 5.5.17 Failure During IPM Import
  • 5.5.18 Merging SOA Composite JDeveloper Customizations While Installing a RUP
  • 5.5.19 Troubleshooting SOA Composite Deployment Failures
    • 5.5.19.1 SOA Composite Log Files
    • 5.5.19.2 Composite Revision is Already Deployed
    • 5.5.19.3 Cannot Set Default Composite
  • 5.5.20 Failure During Applying BI Metadata Updates
  • 5.5.21 AttachHome Script Hangs
  • 5.5.22 The runInstaller.sh -updateHomeDeps Command Hangs
  • 5.5.23 Verify Your Installation

6 Maintaining Oracle Fusion Applications Languages

• 6.1 Introduction to Language Maintenance in Oracle Fusion Applications
  • 6.1.1 Language Packs
  • 6.1.2 Language Pack Installer
  • 6.1.3 Language in the Policy Store
  • 6.1.4 Artifacts Supported by Language Pack Installer
  • 6.1.5 Language Pack Installer Configuration Tasks
• 6.2 Prepare to Install a Language Pack Pre-Down Time
  • 6.2.1 Download the Language Pack Repository
    • 6.2.1.1 Obtaining the Software
    • 6.2.1.2 Downloading from the Oracle Software Delivery Cloud Portal
    • 6.2.1.3 Language Pack Installer
  • 6.2.2 Confirm Oracle Fusion Applications Installation is Complete
  • 6.2.3 Verify Your OPatch Version
  • 6.2.4 Confirm Memory Settings
  • 6.2.5 Confirm Host Name (Unix)
  • 6.2.6 Confirm the Local Port Range Value
  • 6.2.7 Confirm Database Settings
  • 6.2.8 Confirm All Oracle Homes Are Registered in the Central Inventory
  • 6.2.9 Maintain Versions of Customized BI Publisher Reports
• 6.3 Prepare to Install a Language Pack - During Down Time
  • 6.3.1 Verify the Status of Servers and Processes
    • 6.3.1.1 Stop Servers
    • 6.3.1.2 Confirm the OPMN Control Process and Node Manager Are Running
    • 6.3.1.3 Start the OPSS Security Store
    • 6.3.1.4 Confirm The Database Is Running And In An Idle State
    • 6.3.1.5 Confirm All Oracle Fusion Applications Patch Manager Processes Are Complete
    • 6.3.1.6 Confirm All Oracle Fusion Applications AutoPatch Processes Are Complete
    • 6.3.1.7 Confirm All AD Administration Sessions Are Complete
    • 6.3.1.8 Steps For Windows Platforms
  • 6.3.2 Perform Required Backups
    • 6.3.2.1 Back Up Oracle Fusion Applications
    • 6.3.2.2 Back Up Applications and System Policies
  • 6.3.3 Apply Mandatory Prerequisite Patches
• 6.4 Install a Language Pack
  • 6.4.1 Perform the Installation
    • 6.4.1.1 Start Language Pack Installer
    • 6.4.1.2 Install the Language Pack
  • 6.4.2 Complete the Post Installation Tasks
• 6.5 Troubleshooting Language Pack Installer Sessions
  • 6.5.1 Language Pack Installer Log File Directories
  • 6.5.2 Failure During the Installation Phase
  • 6.5.3 Warning Message About "no translations/fsm patches for atgpf"
• 6.6 Maintaining Languages

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 Patching Sessions
  • 11.1.2 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 Retrying Failed Post-Patching Tasks in a Previous Session
    • 11.3.4.1 Requirements for retry mode
    • 11.3.4.2 Running fapmgr in retry mode
  • 11.3.5 Avoiding a Lost Connection During the Patching Session
  • 11.3.6 Resolving Components Locked by a Singleton Patch
  • 11.3.7 Resolving a Webcat Patch File Creation Failure
  • 11.3.8 Resolving an EditTimedOutException Error
  • 11.3.9 Revert To a Previous Flexfield Definition After It Is Updated By a Patch
  • 11.3.10 Resolving an Online Validation Error for BI Artifacts
  • 11.3.11 Finding Artifact Versions
  • 11.3.12 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 Setting the Environment for Troubleshooting Database Issues

A Release Update Patch Installer Screens

• A.1 Welcome
• A.2 Installation Location
• A.3 Installation Summary
• A.4 Installation Progress
• A.5 Policy Store Analysis
• A.6 Configuration Progress
• A.7 Installation Complete

B Language Pack Installer Screens

• B.1 Welcome
• B.2 Installation Location
• B.3 Installation Summary
• B.4 Installation Progress
• B.5 Policy Store Analysis
• B.6 Configuration Progress
• B.7 Installation Complete