Go to main content
1/27
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Guide News
New and Changed Features for Release 12 (11.12.x.0.0)
Significant Changes in this Document for 11g Release 9 (11.1.9)
1
Overview and Roles
1.1
Roles and Key Tasks
1.1.1
System Administrator
1.1.2
Network Engineer
1.1.3
Database Engineer
1.1.4
Oracle Identity Management
and Security Specialist
1.1.5
Oracle Fusion Applications
Technical Lead or System Administrator
1.1.6
Support Technician
2
Understand the Environment
2.1
Access Oracle Fusion Applications
2.2
Start and Stop an
Oracle Fusion Applications
Environment
2.2.1
Start the Entire Environment in Order
2.2.1.1
Start the
Oracle Database
2.2.1.2
Start the
Oracle Identity Management
Suite
2.2.1.3
Start Node Manager
2.2.1.4
Start the Key
Oracle Fusion Middleware
Components on the Provisioned Environment
2.3
Stop the Entire Environment in Order
2.3.1
Stop the Key
Oracle Fusion Middleware
Components on the Provisioned Environment
2.3.2
Stop the Oracle Identity Management Suite
2.3.3
Stop the
Oracle Database
2.4
Special Uses of the fastartstop Utility
2.4.1
Start Administration Servers and Managed Servers
2.4.2
Stop Administration Servers and Managed Servers
2.4.3
Start
Oracle HTTP Server
2.4.4
Stop
Oracle HTTP Server
2.4.5
Start
Oracle Business Intelligence
2.4.6
Stop
Oracle Business Intelligence
2.4.7
Stop an
Oracle WebLogic Server
Domain for a Product Family
2.4.7.1
Stop the
Oracle HTTP Server
2.4.7.2
Stop the Product Family Domain
2.4.8
Start an
Oracle WebLogic Server
Domain for a Product Family
2.4.8.1
Start the
Oracle HTTP Server
2.4.8.2
Start the Product Family Domain
2.4.9
Start and Stop an
Oracle WebLogic Server
Cluster in a Product Family for a Configuration Change
2.4.9.1
Start and Stop an
Oracle WebLogic Server
Cluster Using fastartstop
2.5
Understand the fastartstop Utility and its Syntax
2.5.1
fastartstop Syntax
2.5.1.1
fastartstop: "Start" Syntax Examples
2.5.1.2
fastartstop: "Stop" Syntax Examples
2.5.1.3
fastartstop: "Bounce" Examples
2.5.1.4
fastartstop: Other Syntax Examples
3
Secure Oracle Fusion Applications
3.1
Introduction to Security
3.2
Configure SSL for
Oracle Fusion Applications
3.2.1
Background for SSL Connections in
Oracle Fusion Applications
3.2.1.1
Basic Network Topology
3.2.1.2
Provisioned SSL Connections
3.2.2
End-to-End SSL for Oracle Fusion Applications
3.2.2.1
Background and Scope
3.2.2.2
Enable SSL on
Oracle Fusion Applications
Domains and Apps OHS
3.2.2.2.1
Enable the SSL Listener on the application's WebLogic Managed Server
3.2.2.2.2
Enable SSL on the Oracle HTTP Server for the
Oracle Fusion Applications
domain
3.2.2.2.3
Verify SSL Configuration
3.2.2.2.4
mod_ossl Directives for Inbound SSL Configuration to Oracle HTTP Server
3.2.2.2.5
List of Managed Servers for
Oracle Fusion Applications
Domains
3.2.2.3
Enable SSL between
Oracle Fusion Applications
Domains and IDM Components
3.2.2.3.1
Create the Identity Keystore
3.2.2.3.2
Configure SSL on the Apps OHS Server on the IDM Domain
3.2.2.3.3
Configure SSL on the Authentication OHS Server
3.2.2.3.4
Configure SSL for Oracle Access Manager
3.2.2.4
Known Issues
3.2.2.4.1
SSL connection Error
3.2.2.4.2
Issue 3: Webpage Not Available Error
3.2.3
Checklist of SSL Connections for IDM Components
3.2.4
SSL-enable
Oracle Business Intelligence
3.2.5
Enable Secure Sockets Layer on ECSF
3.3
Provision of Identities
3.3.1
Identity Provisioning Concepts
3.3.1.1
Define Implementation Users
3.3.2
Understand Provisioning Steps
3.3.3
Best Practices for the Administrator Groups
3.3.4
Manage Identities After Deployment
3.4
Security Console
3.5
Masking Data
3.5.1
Data Masking in Oracle Fusion Applications
3.5.1.1
Requirements for Data Masking
3.5.1.1.1
Data Model Descriptions
3.5.1.1.2
Required Versions
3.5.1.1.3
Preliminary Steps
3.5.1.1.4
Temporary Space Requirements
3.5.1.1.5
Database Free Space Requirements
3.5.1.1.6
Database and Operating System Parameters
3.5.1.1.7
Role Requirements
3.5.1.1.8
Custom Field Masks
3.5.1.1.9
Production-to-Test Requirement
3.5.1.2
Sensitive Data in
Oracle Fusion Applications
3.5.1.3
Masking Definitions
3.5.2
Manage the Masking Templates
3.5.2.1
Use Self Update to Obtain the Masking Templates
3.5.2.2
Import Masking Templates from the Library
3.5.2.3
Export Masking Templates from the Library
3.5.3
View and Modify Data Masking Definitions
3.5.4
Generate and Submit the Masking Script
3.5.5
Customize Mask Formats
3.5.6
Best Practices when Masking Test Databases
3.5.7
Masking References
3.6
Secure Web Services
3.6.1
Configure and Manage Local Policies
3.6.2
Configure and Manage Global Policies
3.6.3
Web Services Security Profiles
3.6.4
Key Exchange with the Domain Hosting Oracle Identity Manager
3.6.4.1
Export a Keystore Alias from Application Domain
3.6.4.2
Import a Keystore Alias into Oracle Identity Manager Domain
3.7
Hardening Tasks
3.7.1
Secure Database Network Traffic
3.7.2
Disable Unused Components to Minimize Risks
3.7.3
Hardening Backchannel Network and Services
3.7.4
Configure External Clients with Externally-Facing Web Services
3.7.4.1
Choose a Mechanism
3.7.4.2
Set Up Policy Assertions and Configure Mechanisms
3.7.4.2.1
Set Up the Policy Assertions
3.7.4.2.2
Configure the Message Encryption Certificate (Client Side)
3.7.4.2.3
Configure the Token Issuer Trust (Server Side)
3.7.5
Hardening Web Services
3.7.6
More Secure Keys and Certificates
3.8
Password and Certificate Management
3.8.1
Change the FMWAdmin Password
3.8.1.1
Change the Oracle Fusion Middleware Administrative User Password Using the Command Line
3.8.1.2
Change the Oracle Fusion Middleware Administrative User Password Using the Administration Console
3.8.2
Use PRT to Change Various Passwords
3.8.2.1
Prerequisites
3.8.2.2
Invoke PRT in Interactive Mode
3.8.3
Use PCU to Change DB Schema Passwords
3.8.3.1
Use PCU
3.8.3.2
Validate Password Complexity
3.8.3.3
Run templateGen
3.8.3.3.1
Run templateGen in Full Mode to Change All Schema Passwords
3.8.3.3.2
Run templateGen in Subset Mode to Change Only Specified Schema Passwords
3.8.3.4
Run iniGen
3.8.3.5
Run PCU Offline
3.8.3.6
Additional PCU Features
3.8.3.6.1
Run PCU from a Directory other than APPTOP
3.8.3.7
Encrypt and Decrypt with lcmcrypt
3.8.4
Use CCU to Change Common User Passwords
3.8.4.1
Categories of DB Users
3.8.4.2
Prerequisites and General Steps for Running CCU
3.8.4.3
Run CCU
3.8.4.4
Backup and Restore Features
3.8.4.4.1
Run Backup on the DB Host
3.8.4.4.2
Run Restore on the DB Host
3.8.4.4.3
Backup Copies of the DBCS Wallet File
3.8.4.5
Run utilities
3.8.5
Update Certificates with the Certificate Renewal Utility
3.8.5.1
About CRU
3.8.5.2
Locate CRU
3.8.5.3
Use CRU for fa/weblogic Certificates
3.8.5.4
Use CRU for OWSM Certificates
4
Get Started with Enterprise Manager Cloud Control
4.1
Reasons to Use Cloud Control for Oracle Fusion Applications
4.1.1
Related Documentation
4.1.2
Review Enterprise Manager Cloud Control Components
4.1.3
Plan the Cloud Control Implementation
4.1.3.1
Sizing Considerations for a Cloud Control Site
4.2
Install Enterprise Manager Cloud Control
4.2.1
Prepare the Oracle Database for the OMR
4.2.2
Run the Installer and Choose Advanced Configuration
4.2.3
Start and Stop Cloud Control Components Using EMCTL
4.3
Discover and Add Fusion Applications Targets to Cloud Control
4.3.1
Understand the Order to Discover Oracle Fusion Applications Targets
4.3.1.1
Discover Hosts: General Notes
4.3.2
Discover Databases: General Notes
4.3.3
Discover Identity Management: General Notes
4.3.4
Discover the Oracle Fusion Applications Components
4.3.4.1
Run Diagnostic Pre-Checks
4.3.4.2
Discover the Fusion Instance
4.3.5
Add and Remove Targets Later
4.3.5.1
Add Subsequent Targets and Refreshing an Instance
4.3.5.2
Remove Oracle Fusion Applications Targets
4.3.6
Use Target Credentials
4.4
Log In to Cloud Control
4.5
Create Target Groups in Cloud Control
4.6
The Fusion Instance Overview Page and Sections in Cloud Control
4.6.1
Summary Section
4.6.1.1
Monitoring and Diagnostics Region
4.6.1.2
Database System Region
4.6.2
Member Target Summary Section
4.6.3
Status Section
4.6.4
Infrastructure Section
4.6.5
Compliance Summary Section
4.6.6
Patch Recommendations
5
Monitor an Oracle Fusion Applications Environment
5.1
Access Fusion Applications Home Pages in Cloud Control
5.1.1
Access a Fusion Instance Home Page
5.1.2
Access the Product Family and Product Home Pages
5.1.3
Access the Fusion Applications-Related Cloud Control Menu
5.1.4
Access Cloud Control Online Help
5.2
Access and Use the Topology Views
5.2.1
View Options
5.2.2
Access Options
5.2.3
Use the Routing Topology
5.2.4
Use the Products Topology
5.2.5
Use the Configuration Topology
5.3
Monitor System and Key Performance Indicators
5.3.1
Check System Performance Pages
5.3.1.1
Monitor the System Performance of
Oracle Fusion Applications
Deployed to a Cluster
5.3.1.1.1
Monitor the Performance of
Oracle Fusion Applications
Cluster Applications
5.3.1.1.2
Monitor the Performance of Oracle Fusion Application Instances
5.3.2
Check Key Performance Indicators
5.3.3
Monitor Mid-Tier Elements
5.3.3.1
Monitor an
Oracle WebLogic Server
Domain
5.3.3.2
Monitor an Oracle WebLogic Server Administration or Managed Server
5.3.3.3
Monitor a Cluster
5.3.4
View Activity, Historical Reports, Metrics, and Chart Sets
5.3.4.1
View a Summary of Activity
5.3.4.2
View Current Activity
5.3.4.3
View Historical Reports
5.3.4.4
View Metrics
5.3.4.5
Manage Chart Sets
5.3.4.5.1
Save a Chart Set
5.3.4.5.2
Delete a Chart Set
5.3.4.5.3
Reorder Charts
5.3.4.5.4
Revert to an Old Chart Set
5.3.4.6
Select the Performance Time Period
5.4
Check Metrics and Change Metric Thresholds
5.4.1
Use Metrics at the Mid-Tier Level with Monitoring Templates
5.4.1.1
Access Mid-Tier Metrics
5.4.1.2
Edit Metrics Manually
5.4.1.3
Create Mid-Tier Monitoring Templates
5.4.2
Use Metrics at the Instance, Product Family, and Product Levels
5.5
Set Up Notifications and Incident Rules
5.6
Start and Stop Components
5.6.1
Start and Stop an Individual Application Instance for a Cluster Using
Cloud Control
5.6.2
Start and Stop all Application Instances for a Cluster Using
Cloud Control
5.7
Use Blackouts
5.8
Implement Compliance Rules
5.8.1
Understand Rules, Standards, and Frameworks
5.8.1.1
Real-Time Monitoring Facets
5.8.2
Prerequisites and Related Documentation
5.8.3
Implement Compliance
5.8.3.1
Understand the Rules, Standards, and Framework in the Compliance Library
5.8.3.1.1
Access the Compliance Library
5.8.3.1.2
View the System Defined Rules for Oracle Fusion Applications
5.8.3.2
Apply Standards to Targets in the Fusion Instance
5.8.3.2.1
Create, Edit, or Delete Compliance Details
5.8.3.2.2
Create Real-Time Monitoring Facets
5.9
Monitor Product Families and Products
5.10
Monitor Business Performance Metrics for a Product Family
5.11
Monitor Business Performance Metrics for a Product
5.12
Manage Disk Usage for Log Files and Diagnostic Test Results
5.12.1
Manage Incidents and Flood Control for Fusion Applications:
5.12.2
Manage Incidents and Flood Control for Middleware Components
5.12.3
Purge the Results of Selected Diagnostic Tests
6
Manage Oracle Database for Oracle Fusion Applications
6.1
Access Oracle Database Information in Cloud Control
6.1.1
Database Statistics
6.1.2
Database Alerts
6.1.3
Database Instance
6.1.4
User and Session Activity
6.1.5
Host System
6.2
Set up Diagnostic and Tune Tools for Oracle Fusion Applications Databases
6.2.1
Create a Baseline of the Database
6.2.2
Tune the Database Proactively
6.2.3
Tune the Database Reactively
6.2.4
Tune SQL Statements
6.2.4.1
Create SQL Tuning Sets
6.2.4.2
Manage SQL Profiles
6.2.4.3
Use SQL Tuning Advisor
6.2.4.4
Use SQL Access Advisor
6.2.4.5
Use SQL Tracing
6.2.5
Review Automatic Database Diagnostic Monitor (ADDM) Reports Regularly
6.2.6
Compare Database Performance Over Time Using AWR Reports
6.2.7
Identify Transient Performance Problems Using ASH Reports
6.2.8
Identify Wait Time Using Wait Events
6.3
Tune Tips Specific to Oracle Fusion Applications Environments
6.3.1
Discover How a Connection is Being Used
6.3.2
Tune Database Initialization Parameters
6.3.3
Use Fusion Applications Tools to Optimize UNDO, TEMP, and LOGS Handling
6.3.4
Configure Kernel Parameters
6.3.5
Configure the Database Listener
6.3.6
Tune Tips for the Real Application Cluster (RAC) Databases in Oracle Fusion Applications
6.3.7
Optimize SQL Statements
6.3.7.1
Collect Optimizer Statistics
6.3.7.2
Pin Packages and Cursors
6.3.8
Configure the Database Resource Manager
6.3.8.1
Assign Connections to Resource Consumer Groups
6.3.8.2
Use the Oracle Database Resource Manager
6.3.8.3
Monitor the Resource Manager
6.3.9
Tune the PS_TXN Table in the FUSION Schema
6.3.10
Optimize Maintenance Windows
6.3.10.1
Disable AUTOTASK
6.3.10.2
Adjust Default Maintenance Windows
6.3.11
Reduce Connection Creation Originating from SOA Server
6.4
Test Oracle Database Changes
6.4.1
Use the SQL Performance Analyzer
6.4.2
Use Database Replay
6.4.3
Manage Test Data Management
7
Manage
Oracle Enterprise Scheduler
Service and Jobs
7.1
Introduction to Managing
Oracle Enterprise Scheduler
7.2
Understand the Scheduler Administration Pages
7.2.1
Understand the Scheduling Service Home Page
7.2.2
Understand the Regions on the Page
7.2.2.1
Top 10 Long Running Requests and Top 10 Ready Job Requests Regions
7.2.2.2
Scheduler Components Region
7.2.2.3
Completed Job Requests Region
7.2.2.4
Response and Load Region
7.2.2.5
Performance Region
7.2.3
View General
Oracle Enterprise Scheduler
Instance Information
7.3
Monitor the Scheduler
7.3.1
Monitor Server Status
7.3.2
Monitor
Oracle Enterprise Scheduler
Service Activity
7.3.2.1
View the Top 10 Long Running
Oracle Enterprise Scheduler
Requests
7.3.2.2
View the Top 10
Oracle Enterprise Scheduler
Jobs Ready to Be Executed
7.3.3
Set Metric Thresholds and Monitor Alerts
7.3.3.1
Set Metric Thresholds
7.3.3.2
View
Oracle Enterprise Scheduler
Alerts
7.4
Manage
Oracle Enterprise Scheduler
7.4.1
Stop and Start
Oracle Enterprise Scheduler
Processes
7.4.2
Manage Job Traffic
7.4.2.1
Manage Work Assignments
7.4.2.1.1
Create or Edit a Work Assignment
7.4.2.1.2
Delete a Work Assignment
7.4.2.2
Manage Workshifts
7.4.2.2.1
Create or Edit a Workshift
7.4.2.2.2
Delete a Workshift
7.4.3
Manage Purge Policies
7.4.3.1
View Purge Policies
7.4.3.2
Set Up a New Purge Policy
7.4.3.3
Update a Purge Policy
7.4.3.4
Delete a Purge Policy
7.4.3.5
Purge Job Requests from the Database
7.4.4
Manage Schedules
7.4.4.1
Create a Schedule
7.4.4.2
Edit a Schedule
7.4.4.3
Delete a Schedule
7.4.5
Manage Incompatibilities
7.4.5.1
View Incompatibilities
7.4.5.2
Create or Edit an Incompatibility
7.4.5.3
Create or Edit an Incompatibility
7.4.5.4
Delete an Incompatibility
7.4.6
Manage Job Metadata
7.4.6.1
Manage Job Definitions
7.4.6.1.1
View Job Definitions
7.4.6.1.2
Create Job Definitions
7.4.6.2
Manage Job Sets
7.4.6.2.1
View Job Sets
7.4.6.2.2
Create or Edit Job Sets
7.4.6.2.3
Delete Job Sets
7.4.7
Manage
Oracle Application Development Framework
Connections
7.4.7.1
Create or Edit an
Oracle ADF
Connection
7.4.8
Manage
Oracle Enterprise Scheduler
Using
Oracle WebLogic Scripting Tool
Commands
7.4.9
Expand an
Oracle Enterprise Scheduler
Cluster
7.4.9.1
Perform a Health Check on a New Server
7.4.10
Configure a Request Processor
7.4.10.1
Configure a Request Processor
7.4.11
Configure a Request Dispatcher
7.4.11.1
Configure a Request Dispatcher
7.5
Troubleshoot
Oracle Enterprise Scheduler
7.5.1
Troubleshoot Jobs
7.5.2
Search for Job Requests
7.5.3
Search for Configuration Changes
7.5.4
Manage Logging for
Oracle Enterprise Scheduler
7.5.4.1
Find Log Information for a Job Request
7.5.4.2
Set
Oracle Enterprise Scheduler
Log Levels
7.5.4.3
Save Job Request Logs
7.5.5
Resolve Common
Oracle Enterprise Scheduler
Problems
7.5.5.1
Oracle BI Publisher
Job States Mismatch with
Oracle Enterprise Scheduler
States
7.5.5.2
Job Never Executes and Goes into ERROR State Immediately
7.5.5.3
Job Completes, but Goes into a WARNING State
7.5.5.4
Metadata Access Denied Error When Accessing Job Metadata
7.5.5.5
Insufficient Privilege Error on Request Error
7.5.5.6
Empty Process List in Schedule New Process Dialog Box
7.5.5.7
Slow Display of Job Definition List of Values in Schedule New Process Dialog
7.5.5.8
Job Status Notifications Are Not Sent
8
Manage Search in
Oracle Fusion Applications
8.1
Introduction to
Oracle Fusion Applications
Search
8.1.1
Understand Key
Oracle Enterprise Crawl and Search Framework
Features
8.1.2
Product-Family User Interface
8.2
Mandatory Post-Installation Validation Steps for Using Search
8.2.1
Provide Access to ECSF Pages in
Fusion Applications Control
8.3
Navigate to the ECSF Administration Pages
8.3.1
The Enterprise Crawl and Search Framework Configuration Settings Page
8.4
Perform Basic Administrative Tasks
8.4.1
Enable Search for Pre-Seeded Objects, Categories, and Indexes
8.4.1.1
Deploy the Searchable Objects
8.4.1.2
Activate the Searchable Objects
8.4.1.3
Deploy the Search Categories
8.4.1.4
Deploy the Index Schedules
8.4.1.5
Start the Index Schedules
8.4.1.6
Enable the
Oracle Fusion Applications
Search UI
8.4.1.7
Validate that Searchable Objects are Available for Search
8.4.2
Perform Additional Tasks with Existing Searchable Objects
8.4.2.1
Modify the Display Name of Deployed Searchable Objects
8.4.2.2
Delete Searchable Objects
8.4.2.2.1
Deactivate the Searchable Objects
8.4.2.2.2
Delete the Searchable Objects
8.4.2.3
Remove Searchable Objects from the
Oracle Fusion Applications
Database
8.4.2.3.1
Deactivate the Searchable Objects
8.4.2.3.2
Delete the Searchable Objects
8.4.2.3.3
Disassociate the Searchable Objects from Search Engine Instances
8.4.2.3.4
Remove the Searchable Objects
8.4.3
Perform Additional Tasks with Search Categories
8.4.3.1
Change the Association of Searchable Objects with Search Categories
8.4.3.1.1
Delete Search Categories
8.4.3.1.2
Disassociate the Searchable Objects from Search Categories
8.4.3.1.3
Associate Searchable Objects with the Search Categories
8.4.3.1.4
Deploy Search Categories
8.4.3.2
Rename Search Categories
8.4.3.3
Delete Search Categories
8.5
Administer Search
8.5.1
Manage Index Schedules
8.5.1.1
Create Index Schedules
8.5.1.2
Associate Searchable Objects with Index Schedules
8.5.1.3
Deploy Index Schedules
8.5.1.4
Start Index Schedules
8.5.1.5
Stop Index Schedules
8.5.1.6
Disassociate Searchable Objects from Index Schedules
8.5.1.7
Start Full Indexing
8.5.1.8
Delete Index Schedules
8.5.1.9
Delete Index Schedules Using Undeploy Option
8.5.2
Make External Search Categories Available for Federated Search
8.5.3
Delete External Search Categories
8.5.4
Modify Search Application Service Component Instance Parameters
8.6
Perform Advanced Administration Tasks
8.6.1
Make New Searchable Objects Available for Search
8.6.1.1
Obtain the Necessary Information
8.6.1.2
Register the Searchable Objects
8.6.1.3
Associate the Searchable Objects with Search Engine Instances
8.6.1.4
Deploy Searchable Objects to the
Oracle SES
Instance
8.6.1.5
Activate Searchable Objects
8.6.1.6
Create Search Categories
8.6.1.7
Delete Search Categories
8.6.1.8
Associate Searchable Objects with Search Categories
8.6.1.9
Deploy Search Categories
8.6.1.10
Create Index Schedules
8.6.1.11
Delete Index Schedules
8.6.1.12
Associate Searchable Objects with Index Schedules
8.6.1.13
Deploy Index Schedules
8.6.1.14
Start Index Schedules
8.6.2
Define Search Engine Instances
8.6.2.1
Create Search Engine Instances
8.6.2.2
Configure Search Engine Instance Parameters
8.6.2.3
Modify Search Engine Instances
8.6.2.4
Modify Search Engine Instance Parameters
8.6.2.5
Delete Search Engine Instances
8.6.3
Enable Search on External Data Sources
8.6.4
Add Product Families for Federated Search
8.6.5
Modify the Title, Body, Keyword, and Action Title of Searchable Objects
8.6.5.1
Deactivate the Searchable Object
8.6.5.2
Delete the Searchable Object
8.6.5.3
Edit the Title, Body, Keywords, and Action Title
8.6.5.4
Enable Customization
8.6.5.5
Deploy the Searchable Object
8.6.5.6
Activate the Searchable Object
8.6.5.7
Validate the Changes
8.7
Troubleshoot Search
8.7.1
Problems and Solutions
8.7.1.1
Missing Parameters for Search Engine Instance
8.7.1.2
Unable to Create Search Engine Instance
8.7.1.3
Searchable Object Not Listed in Fusion Applications Control for ECSF
8.7.1.4
Searchable Object Deployment Fails
8.7.1.5
Delete a Searchable Object Using the Undeploy Option Fails
8.7.1.6
Search Category Deployment Fails
8.7.1.7
Search Is Not Available for an Oracle Fusion Application
8.7.1.8
Crawl Fails
8.7.1.9
Invalid Channel Feed Type Error
8.7.1.10
ECSF Query Error
8.7.1.11
FND-6603 Error
8.7.2
Diagnose Enterprise Crawl and Search Problems
8.7.2.1
Diagnose ECSF Command Line Administration Utility Issues
8.7.2.2
Diagnose Fusion Applications Control for ECSF Issues
8.7.2.3
Diagnose Failures During Deploy/Delete Operations for Search Categories
8.8
Reference: Seeded Searchable Objects, Search Categories, Index Schedules, and Facets
8.8.1
Searchable Objects by Product Family
8.8.2
Search Categories by Product Family
8.8.3
Index Schedules by Product Family
8.8.4
Facets by Product Family
9
SOA Suite Database Growth Management
10
Back Up and Recover
Oracle Fusion Applications
10.1
Introduction to Backup and Recovery
10.2
Back Up and Recovery Tools
10.3
Back Up the Environment Overview
10.3.1
Modes of Backup
10.3.2
Types of Backups
10.3.3
Recommended Backup Strategy
10.4
Recover the Environment Overview
10.4.1
Types of Recovery
10.4.2
Recommended Recovery Strategies
10.5
Prerequisites for Using Cloud Control to Back Up or Restore the Environment
10.6
Backup and Recovery Recommendations for
Oracle Fusion Applications
10.6.1
Backup and Recovery Recommendations for
Oracle Fusion Customer Relationship Management
10.6.2
Backup and Recovery Recommendations for
Oracle Fusion Financials
10.6.3
Backup and Recovery Recommendations for
Oracle Fusion Human Capital Management
10.6.4
Backup and Recovery Recommendations for
Oracle Fusion Supply Chain Management
10.6.5
Backup and Recovery Recommendations for
Oracle Fusion Project
10.6.6
Backup and Recovery Recommendations for
Oracle Fusion Procurement
10.6.7
Backup and Recovery Recommendations for
Oracle Fusion Incentive Compensation
10.6.8
Backup and Recovery Recommendations for
Oracle Fusion Applications
Technology
10.6.9
Backup and Recovery Recommendations for
Oracle Fusion Setup
10.6.10
Backup and Recovery Recommendations for
Oracle WebCenter Content
10.6.11
Backup and Recovery Recommendations for
Oracle Enterprise Scheduler
10.6.12
Backup and Recovery Recommendations for
Oracle Enterprise Crawl and Search Framework
10.6.13
Backup and Recovery Recommendations for Java Servers for Oracle E-Mail and Web Marketing
10.7
Perform a Backup
10.7.1
Perform a Backup Using Cloud Control
10.7.1.1
Configure Cloud Control Backups
10.7.1.2
Back Up
Oracle Fusion Applications
Using Cloud Control
10.7.2
Perform a Full Offline Backup Using the Command Line
10.7.3
Perform an Online Backup of Configuration Files Using the Command Line
10.8
Create a Record of the
Oracle Fusion Applications
Configuration
10.9
Recover Using Cloud Control
10.10
Recover After Data Loss, Corruption, or Media Failure
10.10.1
Recover the Applications Base Directory
10.10.2
Recover a Middleware Home
10.10.3
Recover an
Oracle WebLogic Server
Domain
10.10.4
Recover an Oracle Home
10.10.5
Recover an Oracle Instance Home
10.10.5.1
Recover After Oracle Instance Home Deleted from File System
10.10.5.2
Recover After Oracle Instance Home Deregistered
10.10.6
Recover the Administration Server Configuration
10.10.7
Recover a Managed Server
10.10.8
Recover the Databases
10.10.9
Additional Steps for Recovering Particular
Oracle Fusion Applications
Components
10.10.9.1
Recover
Oracle Fusion Customer Relationship Management
10.10.9.2
Recover
Oracle Fusion Procurement
10.10.10
Recover Components Related to
Oracle Fusion Applications
10.10.10.1
Recover
Oracle HTTP Server
10.10.10.2
Recover
Oracle WebCenter Content
10.10.10.3
Recover
Oracle Enterprise Scheduler
10.10.10.4
Recover
Oracle Enterprise Crawl and Search Framework
10.10.10.5
Recover Oracle E-Mail and Web Marketing
10.10.10.6
Recover
Oracle BI Enterprise Edition
10.10.10.6.1
Recover
Oracle BI Enterprise Edition
in a Non-Clustered Environment
10.10.10.6.2
Recover
Oracle BI Enterprise Edition
in a Clustered Environment
10.10.10.6.3
Reconcile the LDAP Database with the
Oracle BI EE
Repository (RPD)
10.10.10.6.4
Reconcile the LDAP Database with Oracle BI Presentation Catalog
10.10.10.7
Recover
Oracle Business Intelligence Publisher
10.10.10.8
Recover
Oracle Real-Time Decisions
10.10.10.9
Recover Oracle Essbase
10.10.10.10
Recover Oracle Hyperion Calculation Manager
10.10.10.11
Recover Oracle Hyperion Financial Reporting
10.10.10.12
Recover Oracle Hyperion Smart View
10.11
Recover After Loss of Host
10.11.1
Recover the Applications Base Directory After Loss of Host
10.11.2
Recover After Loss of Administration Server Host
10.11.2.1
Recover the Administration Server to the Same Host
10.11.2.2
Recover the Administration Server to a Different Host
10.11.3
Recover After Loss of Managed Server Host
10.11.3.1
Recover a Managed Server to the Same Host
10.11.3.2
Recover a Managed Server to a Different Host
10.11.4
Recover the Databases After Loss of Host
10.11.5
Additional Actions for Recovering Entities After Loss of Host
10.11.5.1
Change the Host Name in the targets.xml File for
Fusion Middleware Control
10.11.5.2
Modify the FusionVirtualHost_
x
.conf File
10.11.5.3
Create a New Machine for the New Host Name
10.11.5.4
Update Oracle Inventory
10.11.6
Recover
Oracle Fusion Applications
After Loss of Host
10.11.6.1
Recover
Oracle Fusion Supply Chain Management
After Loss of Host
10.11.6.2
Recover
Oracle Fusion Procurement
After Loss of Host
10.11.7
Recover Components Related to
Oracle Fusion Applications
10.11.7.1
Recover
Oracle HTTP Server
After Loss of Host
10.11.7.2
Recover
Oracle WebCenter Content
to a Different Host
10.11.7.3
Recover
Oracle Enterprise Crawl and Search Framework
After Loss of Host
10.11.7.4
Recover Oracle E-Mail and Web Marketing After Loss of Host
10.11.7.5
Recover Essbase In Clustered Environment After Loss of Host
10.11.7.6
Recover
Oracle BI Enterprise Edition
to a Different Host
10.11.7.6.1
Recover
Oracle BI EE
to a Different Host in a Non-Clustered Environment
10.11.7.6.2
Recover
Oracle BI EE
to a Different Host in a Clustered Environment
10.11.7.6.3
Additional Steps for Recovering
Oracle BI EE
10.11.7.7
Recover
Oracle Business Intelligence Publisher
to a Different Host
10.11.7.8
Recover
Oracle Real-Time Decisions
to a Different Host
10.11.7.9
Recover Oracle Hyperion Calculation Manager After Loss of Host
10.11.7.10
Recover Oracle Hyperion Financial Reporting After Loss of Host
10.12
A Case Study: Recover
Oracle Fusion Customer Relationship Management
10.12.1
The Recovery Case Study Scenario
10.12.2
Recover the Middleware Home Containing Java EE Components
10.12.3
Recover the Web Tier Middleware Home
10.12.4
Recover the
Oracle Fusion Customer Relationship Management
Domain
10.12.5
Recover Servers When the Installation Directory Is Shared Between Hosts
10.12.6
Recover Servers When the Managed Server Configuration Is Local
10.12.7
Recover an Oracle Instance in an
Oracle Fusion Customer Relationship Management
Installation
10.12.8
Recover an
Oracle Fusion Customer Relationship Management
Cluster
10.12.9
Recover Databases for
Oracle Fusion Customer Relationship Management
11
Perform System Maintenance Tasks
11.1
Introduction to AD Administration
11.2
Maintain Snapshot Information
11.2.1
Use the Maintain Snapshot Information Menu
11.3
Maintain Applications Database Entities
11.3.1
Compile Invalid Objects
11.3.2
Run the Health Check
11.3.3
Recreate Grants and Synonyms
11.3.4
Maintain Multilingual Tables
11.4
Run Maintenance Tasks Non-Interactively
11.4.1
Create a Defaults File
11.4.2
Select a Menu Option Non-Interactively
11.4.3
Select a Menu Option While Using a Defaults File
11.5
Run the HomeChecker Utility
12
Prepare to Troubleshoot Using Incidents, Logs, QuickTrace, and Diagnostic Tests
12.1
Introduction to Troubleshooting Oracle Fusion Applications
12.1.1
Troubleshooting Process Overview for Oracle Fusion Applications
12.1.2
Troubleshooting Tools and Information Types for Oracle Fusion Applications
12.1.3
Use Incidents to Facilitate Troubleshooting for Oracle Fusion Applications
12.2
Other Sources of Information for Troubleshooting
12.3
Work with Automatically Created Incidents
12.3.1
View Incidents
12.3.2
View Diagnostic Test Results
12.3.3
View Dumps
12.3.4
View Logs
12.4
Work with Automatically Created QuickTrace Dumps
12.4.1
View Automatically Created QuickTrace Dump Files Using
Oracle WebLogic Scripting Tool
12.4.2
View Automatically Created QuickTrace Dump Files Using the Automatic Diagnostic Repository Command Interpreter (ADRCI)
12.5
Work with
Cloud Control
Problem Analysis and the Analyze Logs Options
12.6
Create Incidents Manually
12.7
Run and Work with Diagnostic Tests Manually
12.7.1
Navigate to the Diagnostic Dashboard Application
12.7.1.1
Navigate to the Diagnostic Dashboard Application from an Oracle Fusion Application
12.7.1.2
Navigate to the Diagnostic Dashboard Application from
Cloud Control
12.7.2
Use Diagnostic Dashboard to Run Diagnostic Tests
12.7.2.1
Search for Diagnostic Tests by Name, Categorization Tag, or Module
12.7.2.2
Configure Access to the Diagnostic Dashboard
12.7.2.3
Ensure that Diagnostic Tests Are Available
12.7.2.4
Provide Input Parameters for Diagnostic Tests
12.7.2.5
Run Diagnostic Tests Immediately
12.7.2.6
Schedule Diagnostic Tests to Run Later
12.7.3
Use the Diagnostic Dashboard Application to Check the Status of a Diagnostic Test
12.7.4
Cancel Diagnostic Test Runs
12.7.5
Use the Diagnostic Dashboard Application to View the Results of Diagnostic Tests
12.7.6
Identify Diagnostic Test Start Methods from Test Run Names
12.7.7
Purge the Results of Selected Diagnostic Test Runs
12.7.8
Configure Required Variables for the diagctl Command Line Interface
12.7.9
Use the diagctl Command-Line Interface to Run Diagnostic Tests
12.7.10
Use the diagctl Command-Line Interface to Check the Status of a Diagnostic Test
12.7.11
Use the diagctl Command-Line Interface to View the Results of Diagnostic Tests
12.8
Work with Log Files Manually
12.8.1
Search for Information in
Oracle Fusion Applications
Log Files
12.8.1.1
Search
Oracle Fusion Applications
Log Files in Single or Multiple Domains
12.8.1.2
Save
Oracle Fusion Applications
Log Search Criteria for Reuse
12.8.1.3
Reuse Saved Log Search Criteria
12.8.2
Configure
Oracle Fusion Applications
Log Settings to Change the Amount of Detail to be Logged
12.8.2.1
Configure Standard Fusion Applications Log Settings for Troubleshooting
12.8.2.2
Assist Users in Gathering Data Using Troubleshooting Options
12.8.2.3
Grant Users Access to Troubleshooting Options Command
12.8.2.4
Configure Non-Standard Fusion Applications Log Levels
12.8.2.4.1
Overview of Non-Standard Log Levels for Oracle Fusion Global Payroll
12.8.2.4.2
Configure Logging for Oracle Fusion Global Payroll Application
12.8.2.4.3
Configure Non-Standard Log Levels for
Oracle Fusion Incentive Compensation
12.8.2.4.4
View Special Log Output for Oracle Fusion Incentive Compensation
12.8.2.4.5
Configure Non-Standard Log Levels for Oracle Fusion General Ledger
12.8.2.4.6
Overview of Non-Standard Log Levels for Oracle Fusion Receivables AutoInvoice
12.8.2.4.7
Configure Non-Standard Log Levels for Oracle Fusion Receivables AutoInvoice
12.8.2.5
Configure ApplSession Log Levels
12.8.2.6
Disable Logging of a Particular Message
12.8.3
Correlate Log Messages Across Log Files and Components
12.8.3.1
Values for Correlating Log Messages
12.8.3.2
Correlate Log Messages for
Oracle Enterprise Scheduler
Jobs
12.8.3.3
Correlate Log Messages for SOA Services and BPEL Processes
12.8.3.4
Correlate Log Messages for Other Process Types
12.8.4
Download Log Files
12.9
Create and Work with Manual QuickTrace Dumps
12.9.1
Create a QuickTrace Dump Manually
12.9.2
Adjust QuickTrace Detail Levels
12.10
Work with Fusion Middleware Diagnostic Dumps
12.11
Work with Oracle Support for Assistance in Problem Resolution
12.11.1
Package Incidents Using Support Workbench
12.11.1.1
Package
Oracle Fusion Applications
Incidents Using a Wizard
12.11.1.2
Package
Oracle Fusion Applications
Incidents Using General Support Workbench Functionality
12.11.2
Send Diagnostic Test Results to Oracle Support
12.11.3
Log More Detailed Information for a Particular Code Module
12.11.4
Register Diagnostic Tests
13
Troubleshoot
Oracle SOA Suite
13.1
Introduction to
Oracle SOA Suite
13.2
Get Started with Troubleshooting and Logging Basics for
Oracle SOA Suite
13.3
Runtime Diagnostics
13.3.1
Correlate Application Issues to the SOA Composite IDs
13.3.2
Business Event Subscriptions Are Not Firing
13.3.3
Long Delays After an Event is Published and Before a Subscriber is Triggered
13.3.4
Events Are Consumed by Multiple Revisions of the Same Composites
13.3.5
Rolled Back OAOO Event Delivery Messages Are Displayed in the Log Files
13.3.6
Application Transaction Does Not Complete and the Underlying Composite Is Stuck in a Running State
13.3.7
BPEL Process Received No Response from an ADF Asynchronous Service
13.3.8
Business Event Is Picked Up Twice (Or More) By SOA Server
13.3.9
Long Running, Synchronous Calls To Remote Web Services Error Out or Asynchronous Transactions Return with an Error after a Long Time
13.3.10
Some Messages Are Lost Between EDN and Composites or Composites Across Clusters
13.3.11
Some Composites Are Being Retried Multiple Times on Failure
13.3.12
Some
Fusion Applications Control
Features Are Missing the No Recover Button or Export Composite Capability
13.3.13
Automatic Recovery of BPEL Instances is Not Recovering A Specific Instance
13.3.14
SOA Runtime Fails with a "Cannot read WSDL" Error
13.3.15
Upload a Composite for Oracle Support Services
13.3.16
Confirm SOA Component Configuration Properties for Oracle Support Services
13.4
Security and Oracle WSM Policy Manager Configuration
13.4.1
Cannot Invoke Service Due To Oracle WSM Policy Manager Security Configuration or Access
13.4.2
Service Invocation Errors Due To SOAP Fault "PolicySet Invalid"
13.4.3
Service Invocation Fails with "ADFC-0619: Authorization check failed" Error
13.4.4
Service Invocation Fails with Error "WSM-00060 : error in timestamp validation" or Due to "clockSkew"
13.4.5
Web Service Invocation Throws "Attaching multiple authentication security policies is not supported" Error
13.5
Human Workflow
13.5.1
Recover Human Task Instances Stuck in the Alerted State
13.5.2
Worklist: Notifications and Approvals Region Contains No Data
13.5.3
Task Detail Page is Not Available
13.5.4
Task Chooses an Incorrect User If Several Rules Are Defined or Errors with "Ruleset returned lists with different list builder"
13.5.5
Document Is Stuck in Pending Approval and Logs Show Error "Unable to walk hierarchy for user
user_name
"
13.5.6
Task History: Cannot Remove or Move a Participant After Yourself
13.5.7
Hierarchy List Builders Display an Error Due to Security Configuration Issues and Log Report Errors in Authentication or Authorization with HCM Services
13.5.8
HCM Services are Timing Out or Getting Stuck
13.5.9
Error/Warning Reported in Retrieving the Position for a User
13.5.10
Users See No Approvals in the Inbox when Using Position Hierarchy
13.5.11
Task Escalation Does Not Follow Job Level, Supervisory, or Position Hierarchies
13.5.12
User Is Not Allowed to Perform an Action on a Human Workflow Task
13.5.13
Email Notification Is Not Being Sent Out
13.5.14
Notifications Sent Are Not Actionable
13.5.15
Actionable Notifications Are Sent But No Action is Taken After Responding
13.5.16
After LDAP Configuration with
Oracle WebLogic Server
, Users Appear in the Console, But a "No Role found matching the criteria" Error Appears
13.5.17
Only a Subset of Users in LDAP Can Log In to
Oracle BPM Worklist
13.5.18
"Unknown Macro" Exception Appears when Myrealm Is Passed as a Parameter to the Identity Context To Identity Service APIs
13.5.19
Add Participant Button in
Oracle BPM Worklist
Is Disabled
13.5.20
Task Modifications Made in a Runtime Tool Are Not Appearing for the Task
13.5.21
How Can I Set Commonly Used Human Workflow Configuration Parameters?
13.5.22
Set Human Workflow Configuration Parameters Not Available in the
Fusion Applications Control
Properties Pages
13.5.23
System MBean Browser Does Not Reflect My Changes After Editing the Human Workflow Config MBeans
13.5.24
Human Workflow Services Are Not Locating Resource Bundles or Classes Located at the Workflow Customizations Class Path URL
13.5.25
Manually Set the URL for Displaying Task Details for a Particular Human Workflow Task Component
13.5.26
Test the Health of the Installed Server
13.5.27
User Authentication Error (in this example, the user is FMW_USERID and identityContext is jazn.com)
13.5.28
Error During Import of Task Payload Mapped Attribute Mappings
13.5.29
Error During Rule Migration
13.5.30
When Defining a Rule Based on the Approval Group List Builder During Runtime, a Message Says the Group Does Not Exist
13.6
Patching and Deployment
13.7
Performance
13.7.1
SOA Transactions are Failing and Logs Indicate the SOA Database is Running Out of Space
13.7.2
Slow Application Performance Such as Longer Time to Serve Pages or Finish Transactions
13.7.3
Slow
Fusion Applications Control
Performance
13.8
Maintenance
13.8.1
JVM is Suspended If Any In-use Log Directories are Deleted
13.8.2
Server Start Script Does Not Work for Scale-Out (Postprovisioning) Servers
13.8.3
SOA Server Does Not Start
13.8.4
SOA Server Is Not Responding To Administrative Commands
13.8.5
Delete a Composite Left in an Inconsistent State Due to a Failed Patch
13.8.6
Increased Load Observed on RAC Instances when Using Multiple Oracle RAC Servers
13.8.7
List of SOA Composite State Values
13.8.8
Log Files Have Been Deleted or Are Missing
13.9
Custom Development (Extensibility)
13.9.1
Unable to Use Layered Customization on Specific Artifacts
13.9.2
New or Deleted Artifacts Do Not Appear as a Layered Customization
13.9.3
Warnings Regarding xml:id when Building or Deploying a Customized Composite
13.9.4
Distributed Queue Topic Messages Are Retrieved Multiple Times by Subscribers
13.9.5
Internal Key is Displayed Instead of a Translated String
13.9.6
BPEL Activity Errors and the Log Shows Error "com.oracle.bpel.entity.dataprovider.EntityVarMgrException:zero Item"
13.9.7
BPEL Activity Errors and Log Shows Error "XPath variable or expression <expression> is empty"
13.9.8
Unavailable Composite Errors Occurring Even Though the Target Service Is Up and Running
13.9.9
High-Volume Cross Reference (XREF_DATA) Table Impacts Performance and Maintenance
13.9.10
Access Denied Error While Invoking an Oracle ADF BC Service from BPEL
13.9.11
Click Manage Approvals Page Gives a "SOA server may be down" or "No data to display" Error
13.9.12
Synchronous Service Invocation Errors Due to WS-Addressing
13.9.13
Deploy Human Workflow Application Throws "Unable to resolve 'TaskQueryService'" Error
13.9.14
"Invalid Subject" Error Thrown with Human Workflow API or Notification
13.9.15
Task is Assigned to the Group/Role When It Is Expected to Go to Every User in the Group/Role Individually
13.9.16
Task Completes Without Any Assignment Occurring
13.9.17
Parallel Assignees Must Approve or Reject the Task Even Though the Parallel Completion Criteria is Met
13.9.18
All Added Adhoc Participants Disappear After a Page Refresh
13.9.19
Future Approvers Are Not Visible in the History Table
13.9.20
Message Appears in the History Table About a Correlation ID Not Being Passed or Any Exception Related to the Correlation ID
13.9.21
Edit Toolbar Is Disabled or Not Shown
13.9.22
oracle.jrf.UnknownPlatformException Error When Customizing an
Oracle Mediator
13.9.23
java.lang.NullPointerException When Customizing an
Oracle Mediator
13.9.24
JDeveloper
Compilation Error in a SOA Project with SOA MDS Service Location
14
Troubleshoot the Oracle Fusion Applications Tier Performance
14.1
Introduction
14.2
Monitor and Tune Oracle Fusion Applications
14.2.1
Analyze Host Metrics
14.2.2
Check for Network Connectivity Issues
14.2.3
Analyze WebLogic Server Metrics
14.2.4
Analyze Oracle HTTP Server Metrics
14.2.5
Analyze Oracle Business Intelligence Server Metrics
14.2.6
Gather Key Identity Management Server Metrics
14.2.7
Analyze Key Enterprise Scheduler Metrics
14.2.8
Monitor Key SOA Metrics
14.2.9
Tune and Troubleshoot Oracle Identity Management
14.2.9.1
Tune Two OID Configuration Parameters
14.2.9.2
Enable Timing Logging
15
Troubleshoot the
Oracle Fusion Applications
Middle Tier Performance
16
Troubleshoot
Oracle WebCenter Portal
and
Oracle WebCenter Content
16.1
Introduction to WebCenter Components and Concepts
16.1.1
Introduction to
WebCenter Portal
16.1.2
Introduction to
WebCenter Content
16.1.2.1
Determine Keystore Type
16.1.2.2
Extract a JKS (File-based) Keystore from a KSS Based Keystore
16.1.3
Introduction to
WebCenter Portal
Portlets
16.2
Diagnostic Tools and Processes for
WebCenter Portal
Portlet Problems
16.2.1
Use Diagnostic Tools
16.2.1.1
Identify the Portlet Instance
16.2.1.2
Examine the Portlet Consumer Test Page
16.2.1.2.1
Access the Portlet Consumer Test Page
16.2.1.2.2
Locate the Portlet Producer
16.2.1.2.3
Locate and Run the Portlet Instance
16.2.1.2.4
Perform Sanity Checks
16.2.1.2.5
Check Consumer Configuration Entries
16.2.1.3
Examine the Producer Test Page
16.2.1.3.1
Access the Producer Test Page
16.2.1.3.2
Run the JSF Portlet as a Servlet
16.2.1.3.3
Check the Persistent Store Type
16.2.1.3.4
Examine the SOAP Monitor
16.2.2
Configure the Portlet Logging File
16.3
Problems and Solutions for
WebCenter Portal
Portlets
16.3.1
"Portlet Consumer Error": Check Logs for Hints about Portlet Binding
16.3.2
"Portlet Timeout" Error: Check Various Causes/Solutions
16.3.2.1
Producer Machine is Overloaded: Check Tuning and Hardware Needs
16.3.2.2
Network is Overloaded: Ping Machines and Check Test Page in Browser to Verify
16.3.2.3
Stuck Thread on Producer Machine: Check Logs to Diagnose
16.3.2.4
Application Delay from Too Much Data: Analyze Hardware and Timeout Limits
16.3.2.5
Portlet Timeout Limit is Too Short: Change Limits
16.3.3
"Remote Portlet Communication Error": Check Various Causes/Solutions
16.3.3.1
The Producer is Down: Restart the Application or Managed Server
16.3.3.2
Web Services Security Configuration is Wrong: Troubleshoot Security Settings
16.3.3.3
The Producer Managed Server Can't be Reached: Check the WSDL Endpoints to Confirm Routing
16.3.4
"Remote Portlet Error": Check Various Causes/Solutions
16.3.4.1
"OperationFailedException": Check Logs for Hints
16.3.4.2
"InvalidRegistrationException": Check the Persistence Store Settings
16.3.4.3
"InvalidHandleException": Check Persistence Store Settings
16.3.4.4
"AccessDeniedException": Check Configurations
16.4
Problems and Solutions for
WebCenter Portal
's
Composer
16.4.1
User Unable to Edit a Component in Composer's Edit Mode: Check Various Causes/Solutions
16.4.1.1
User Has Inadequate Privileges: Check Privilege Settings
16.4.1.2
MDS Customization Restriction: Remove if Needed
16.4.1.3
Component ID is Not Found: Ensure that an ID is Specified
16.4.2
Unable to Personalize Some Components
16.4.3
Wrong Users Able to Edit a Component in Composer's Edit Mode: Check Various Causes/Solutions
16.4.3.1
"Edit Current Page" Link Displayed for Users Who Should Not See It: Set Appropriate Attribute
16.4.3.2
User Has Wrong Permissions
16.4.3.3
MDS Customization Restriction Needed: Specify Using an RDF File
16.4.4
Implicit Personalizations Do Not Stick: Check Various Causes/Solutions
16.4.4.1
MDS Customization Restriction: Remove or Relax the Restriction
16.4.4.2
The adf-faces-config Settings are Wrong
16.4.5
Cannot Rearrange Components on Child Components Pane: Check ID Specifications
16.5
Problems and Solutions for
Oracle WebCenter Portal
16.5.1
Documents Service Is Not Available When Content Server Is Not Running: Restart Components
16.5.2
Workflows Do Not Work: Check Policy Attachments
16.5.3
List of Spaces Does Not Show Any Spaces: Check Various Causes/Solutions
16.5.3.1
WebCenter Portal Spaces Instance Down: Check Status
16.5.3.2
User Has Not Created Spaces: Create or Assign Membership to a Space
16.5.3.3
Possible Problems with GPA or LPA
16.5.4
Creating a Space Throws an Error or Warning: Check Various Causes/Solutions
16.5.4.1
WebCenter Portal Spaces Instance Down: Check Status
16.5.4.2
User Does Not Have Permissions to Create a Space: Check Permissions
16.5.4.3
"InterruptedException" Because Services are not Provisioned: Change Timeout Settings
16.5.4.4
"ConnectionRefused" Error: Authorize WC_Spaces IP Address
16.5.4.5
Features Not Available in WebCenter Content Version: Check Version
16.6
Problems and Solutions for Search in
WebCenter Portal
16.6.1
No Search Results Found: Check Oracle SES Server Status
16.6.2
Search Results Do Not Include Secured Resources: Check Various Causes and Solutions
16.6.2.1
No Secured Resources: Check the for Proxy Login Errors
16.6.2.2
No Secured Resources: Check Authorization Endpoints
16.6.2.3
No Secured Resources: Consider Number of Crawl Sources
16.6.3
Search Results Do Not Include Documents: Check Credentials and Update Configuration
16.6.4
Search Results Do Not Include Discussions and Announcements: Check Various Causes and Solutions
16.6.4.1
No Discussions and Announcements: Check Single Record Query
16.6.4.2
No Discussions and Announcements: Check for Lowercase User Names
16.6.5
Search Results Do Not Include Recently Added Resources: Check Crawl Schedule
16.6.6
Search Results Do Not Reflect Authorization Changes: Adjust the Security Filter Lifespan Setting
16.6.7
Search Results Do Not Include Resources Available to Wide Audience: Grant Access to Non-Members
16.7
Problems and Solutions for the Discussions Service
16.7.1
User Is Not Authorized / Service Not Configured: Troubleshoot Discussions Server Configuration
16.7.2
"User Is Not Authorized" Message for Member of a Group that Has Access: Troubleshoot User Group Cache
16.7.3
Unable to Log In to the Discussions Administration Console: Check Administration Access
16.7.4
SOAP Fault Exceptions Seen in Announcements Region: Check GPA and wsm-pm Application
16.7.5
Discussions Server Displays a Form-Based Login Instead of SSO Login Screen: Verify Correct Server Settings
16.7.6
"Discussions Not Provisioned" Warning During Space Creation: Check Configurations
16.8
Problems and Solutions for the Documents Service
16.8.1
Documents Service Unavailable: Check Content Repository and Content Server
16.8.2
Granting Permissions Errors in Documents When Creating a Space: Check Logs and Permissions
16.8.3
User Appears to Not Have the Correct Capabilities in the Documents Page for His Role: Resolve for Single or Mulitple Users
16.8.3.1
Resolve for a Single User
16.8.3.2
Resolve for Multiple Users
16.8.4
Documents Connection Not Working after Switching to Global Policy Attachment: Check Connection Properties and Security Policy
16.9
Problems and Solutions for Attachments in
WebCenter Content
16.9.1
Attachment File Is Too Large: Change the Maximum Size Parameter
16.9.2
No Attachments Appear in the Attachment Component
16.9.3
No Category Value Appears for an Attachment
16.9.4
Add an Attachment Returns the error message "You do not have permission to add a new attachment"
16.9.5
Content Server
Web Service Is Unavailable: Check Endpoints and Restart
16.9.6
Content Server
Connection Failure: Troubleshoot Connections
16.9.7
Clicking Attachments Link Results in a 404 Error: Check GetHandler Servlet
16.9.8
Authorization Failure/"Insufficient Privileges" Error:
16.9.8.1
Task 1: Check Oracle Fusion Applications Client
16.9.8.1.1
Misunderstood Headers or No Namespace URL Error
16.9.8.1.2
Invalid Security Error
16.9.8.1.3
Unable to Generate Digital Signature Error
16.9.8.2
Task 2: Check Oracle Content Server Setup
16.9.8.2.1
Public Certificate Map Error
16.9.8.2.2
Legacy Signing Request Error
16.9.8.2.3
Request Expiry Time Reached Error
16.9.8.2.4
Unable to Base64 Decode Received Signature Error
16.9.8.2.5
Unable to Verify Signature Error
16.9.9
Application Access Denied
16.9.10
CredentialAccessPermission Denied
16.9.11
Applcore Attachment Checkin Failure: Check Various Causes and Solutions
16.9.11.1
Checkin Failure Causes for All Domains
16.9.11.2
Checkin Failure Causes for Single Domain
16.9.11.3
Checkin Failure Solution 1: Policy Manager Active
16.9.11.4
Checkin Failure Solution 2: Correct Service Policy
16.9.11.5
Checkin Failure Solution 3: Correct Client Policy
16.9.11.6
Checkin Failure Solution 4: Correct JCR Connection
17
Troubleshoot
Oracle Metadata Services Repository
17.1
Get Started with Troubleshooting and Logging Basics for
Oracle Metadata Services Repository
17.1.1
Access Oracle WebLogic Scripting Tool (WSLT) Commands
17.1.2
Modify MBean Properties in Fusion Applications Control
17.1.3
Modify Log Levels
17.2
Troubleshoot Applications Performing Slowly Due to
MDS Repository
17.2.1
Check MDS Repository and Adjust Cache Size
17.2.2
Analyze Data and Purge as Needed
17.3
Diagnose Exceptions with
Oracle Metadata Services Repository
17.3.1
MDS-01273 Source Metadata Mapped to Read-Only Namespace
17.3.2
MDS-00013: No Metadata Found for Metadata Object
17.3.3
MDS-01330 Unable to Load MDS Configuration Document
17.3.4
java.util.ConcurrentModificationException
18
Troubleshoot and Tune Oracle Fusion Reports
18.1
Introduction to Oracle Fusion Reporting
18.1.1
Oracle BI Technologies
18.2
Introduction to Troubleshooting Oracle Transactional Business Intelligence
18.2.1
About OTBI Architecture
18.2.2
Introduction to OTBI Troubleshooting Tools
18.3
Resolve Problems with Logical and Physical Queries Using BI Logs and Presentation Services
18.3.1
Enable the NQQuery.log File
18.3.1.1
Clear the BI Server Cache
18.3.2
View the Presentation Services Logical Query In the Log
18.3.3
View the Logical Query In Presentation Services
18.3.4
View the Query Trace
18.3.5
View the Physical Query
18.3.5.1
Troubleshoot and Performance Guidelines for Physical Queries
18.4
Troubleshoot ADF View Objects
18.4.1
Use AdminServer-diagnostic.log File to Troubleshoot ADF View Objects
18.4.2
Use View Data to Check the Datasource Connectivity
18.5
Troubleshoot Oracle Transactional Business Intelligence (OTBI)
18.5.1
Oracle BI Presentation Services Fails to Start: Check if BI Server is Running
18.5.2
The BI Server Is Not Running: Check Log Files for Hints
18.5.3
Oracle Business Intelligence Requests Stop Responding: Check Authentication
18.6
Troubleshoot Oracle Fusion Customer Relationship Management: Data Warehouse Enabled Profile Option
18.7
Troubleshoot for
Oracle BI Publisher
18.7.1
Oracle BI Publisher Reports Are Missing from the Presentation Services Shared Folders
18.7.1.1
Confirm that Items Exist on the File System
18.7.1.2
Refresh the GUIDs
18.7.2
Oracle BI Publisher Reports Are Missing from the Oracle BI Publisher Server Shared Folders
18.7.2.1
Check User Privileges
18.7.2.2
Adjust the BI Publisher Connection to Presentation Services
18.7.2.3
Check for Catalog Corruption and Resolve as Needed
18.8
Performance Tuning Oracle Transactional Business Intelligence (OTBI)
18.8.1
Query Governance
18.8.2
Debug Slow-Running Queries
18.8.3
BIAnalytics Data Source Suspended
18.8.4
Caching Options in Oracle Transactional Business Intelligence (OTBI)
19
Troubleshoot Oracle Data Integrator
19.1
Get Started with Logging Basics for
Oracle Data Integrator
19.1.1
View and Configure ODI Agent Logs
19.1.2
View Session Logs for ODI
19.2
Resolve Common Problems
19.2.1
ODI Process Is Taking a Long Time to Complete Job Request
19.2.2
A Coherence Node Connected to ODI Is Using UDP Multicasting for Cluster Discovery Instead of Well-Known Address
19.2.3
Troubleshoot Oracle Data Integrator (ODI) Repository Issues
19.2.4
Troubleshoot ODI and ESS Callback Issues
20
Troubleshoot Oracle Identity Management
20.1
Introduction to Troubleshooting Oracle Identity Management
20.2
Get Started with Troubleshooting Oracle Identity Management
20.2.1
Verify the Security Providers in the Oracle WebLogic Server Domain
20.2.1.1
Verify the Order of Providers
20.2.1.2
Verify JAAS Control Flags
20.2.1.3
Verify Settings for the Identity Store's LDAP Authenticator
20.2.2
Use Selective Tracing to Troubleshoot Inaccessible Functionality
20.2.3
Edit Logging Level
20.3
Problems and Solutions for Missing or Incorrect Data
20.3.1
Data is Missing After Migrating or Patching the Policy Store: Use DSDataMigrator to Reconcile GUIDs
20.3.1.1
Back Up the fnd_grants Table in Oracle Fusion Data Security Repository
20.3.1.2
Run the DSDataMigrator Program
20.3.2
Administrator Search for Database Resources Returns No Results: Check Roles and Policies
20.3.3
Data is Missing or Incorrect in a Portlet: Check User Sessions
20.4
Problems and Solutions for Accessing Functionality
20.4.1
Inappropriate User Access After Enterprise Role Membership Removal: Check Refresh Intervals
20.4.2
Newly Created User Does Not Have Correct Access to Oracle Fusion Applications: Check Various Causes and Solutions
20.4.2.1
User Does Not Exist: Verify if User is in the Identity Store
20.4.2.2
A Cache Has Not Been Refreshed: Check Caches
20.4.3
After Logging Out, Access to a Secured Resource is Granted Without Logging in: Check Various Causes and Solutions
20.4.3.1
User Session Was Not Removed During Logout: Check Cookies and Session Management
20.4.3.2
Oracle Platform Security Services Not Configured with Correct URL: Verify Settings
20.4.4
Authenticated User Gets Unexpected Page when Accessing a Different Secured Resource: Check Cookies
20.4.4.1
Verify Cookies in User's Browser
20.4.5
Support Representative Cannot Impersonate an Oracle Fusion Applications User: Check Priviledges
20.4.6
Unauthenticated User Gets Error Page when Accessing a Secured Resource: Check Various Causes and Solutions
20.4.6.1
Oracle HTTP Server Web Servers Not Running: Verify Status
20.4.6.2
Managed Servers or Oracle Access Manager Services Not Running: Verify Status
20.5
Problems and Solutions for Managing Users
20.5.1
Oracle Fusion Human Capital Management Requests to Assign Roles to Users Fail: Verify User in Internet Directory Store
20.6
Problems and Solutions for Managing Roles
20.6.1
Cannot See the Function Security Policies for an External Role: Check Various Causes and Solutions
20.6.1.1
Oracle Internet Directory Not Indexing displayName Attribute: Verify Configuration
20.6.1.2
Oracle Internet Directory Authenticator Not Configured Correctly: Verify Connection Settings
20.6.1.3
External Role Not Provisioned: Examine Identity Store Containers to Verify
20.6.1.4
Administrator Does Not Have Access: Check Settings for Delegated Administrator Role
20.6.1.5
Policy Store Does Not Have Correct Application Stripes: Verify Policy Stripes
20.6.1.6
External Role is Not Mapped to Correct Application Roles: Verify Mapping
20.6.1.7
Application Role Has No Policy Attached: Verify Policies
20.6.2
Cannot See the Data Security Policies for a Data Role: Check Various Causes and Solutions
20.6.2.1
Oracle Internet Directory Not Indexing displayName Attribute: Verify Configuration
20.6.2.2
Oracle Internet Directory Authenticator Not Configured Correctly: Verify Connection Settings
20.6.2.3
User Searching for Data Security Policies Does Not Have Privileges to Do So: Verify
20.6.2.4
Data Role Does Not Exist in Identity Store: Examine Identity Store Container to Verify
20.6.2.5
Data Role Templates Did Not Create Policies for the Data Role: Verify
20.6.2.6
Security Role GUIDs Not Synchronized: Use DSDataMigrator to Reconcile
20.6.3
Problems Mapping an Application Role to an External Role
20.6.3.1
Oracle Internet Directory Not Indexing displayName Attribute: Verify
20.6.3.2
Configuration of Security Providers Is Incorrect: Verify
20.6.3.3
Mapping Activated After a Delay: Consider Adjusting Cache Settings
20.6.4
Cannot See Application Role Hierarchies
20.6.4.1
LDAP Authenticator Configured to Use Wrong Identity Store: Verify
20.6.4.2
Administrator Trying to View Role Hierarchy from Wrong Role in the Interface: Verify
20.6.4.3
Role Hierarchies Are Not Defined: Verify
20.6.5
Attempts to Add an Application Role to a Hierarchy Appear to Have No Effect
20.6.6
Cannot Create Valid Data Roles Using Data Role Template
20.6.6.1
SQL Query in Dimensions Tab is Invalid: Troubleshoot
20.6.6.2
Oracle Authorization Policy Manager Application ID Privileged Problem
20.6.6.3
Identity Store Problems: Troubleshoot
20.7
Problems and Solutions for Managing Keystores and Certificates
20.7.1
Key or Credential Store Error After an Application Invokes Web Service
20.7.1.1
Check if the Key Alias Exists in the Keystore File
20.7.1.2
Check if Key Passwords are Synchronized
20.7.2
Trust Certificate Error After Application Invokes Web Service: Verify Trust Settings
20.8
Problems and Solutions for Identity Propagation Using SAML
20.8.1
Troubleshoot SAML Issuer Name Configuration
20.8.2
Troubleshoot Subject Precedence Configuration Override
20.9
Problems and Solutions for Logging in to Secured Resources
20.9.1
Incorrect Language Appears After Logging in to a Secured Resource: Check Cookies
20.9.2
Login Page Unexpectedly Reappears (No Single Sign-On): Check Various Solutions
20.9.2.1
No SSO: Check Authentication Levels
20.9.2.2
No SSO: Check Idle Timeout and Session Lifetime Parameters
20.9.2.3
No SSO: Check Cookies
20.9.3
Cannot Access Forgotten Password Functionality from Login Page: Check Various Solutions
20.9.3.1
Login Functionality: Ping the System
20.9.3.2
Login Functionality: Verify Configurations
20.10
Additional Information for Troubleshooting Oracle Identity Management
21
Troubleshoot Oracle Enterprise Performance Management
21.1
Introduction to Reporting with Enterprise Performance Management
21.2
Problems and Solutions for Foundation Services
21.2.1
Get Started with Logging Basics for Foundation Services
21.2.1.1
Change BI Logger Levels
21.2.2
Web Traffic Snooping to Resolve Issues
21.2.3
Enterprise Performance Management Registry Problems
21.2.3.1
Enterprise Performance Management (EPM) Registry Initialization Fails
21.2.3.2
Connection to Essbase Server Fails
21.2.3.3
Host and Ports Do Not Match
21.2.4
Hyperion Security Username/Password Authentication Fails during Enterprise Scheduler Services Essbase Cube Creation in the Domain
21.2.5
EPM Workspace Problems
21.2.5.1
Set Up Client Debugging Tool
21.2.5.2
Startup Fails to Respond or Error Occurs
21.2.6
Calculation Manager
21.2.6.1
Essbase Applications Are Not Listed Under the Essbase Node
21.2.6.2
Business Rules Cannot be Deployed to General Ledger
21.2.7
Smart View Problems
21.2.7.1
Enable Advanced Logging to Troubleshoot
21.2.7.2
Re-enable Smart View in Microsoft Office Applications
21.2.7.3
Timeout Errors: Increase the Timeout Limit for Smart View Client Computers
21.2.7.4
Shared Connections Panel Does Not Display Server Names
21.3
Problems and Solutions for Financial Reporting
21.3.1
Set Up Data Sources and Debug Setup and Connectivity Issues
21.3.1.1
Unable to Connect to Essbase Cube
21.3.1.2
Error While Creating Database Connection
21.3.1.3
Cannot Set Up a Database Connection
21.3.2
Common Administrative Tasks and How to Debug Issues
21.3.2.1
Invalid Grid Error When Running a Report: Re-Save to the Database
21.3.2.2
Financial Reporting Cannot be Accessed from Workspace: Check Application Status Using Log Files
21.3.2.3
Unable to Connect to Financial Reporting Through a Firewall: Find and Modify MBean Properties
21.3.2.4
Error “Application HReports Is not Defined": Start the fressclient.ear Application
21.3.2.5
Permission Errors in Batch Scheduler: Check User Permissions
21.3.2.6
All the Jobs Fail: Restart Server if Needed
21.4
Problems and Solutions for Hyperion Provider Services
21.4.1
Provider Services Server Not Functional: Check Status, Ports, Restart if Needed
21.4.2
Provider Services Version Information Not Showing in Interface: Where to Look
21.4.3
Monitor Provider Sessions During Troubleshooting
21.4.4
Monitor Active-Active Essbase Clusters
21.4.5
Enable and Disable Active-Active Essbase Cluster Components
21.5
Problems and Solutions for Essbase
21.5.1
Get Started with Logging Basics for Essbase
21.5.2
Essbase Agent Startup Fails with "Error: FUSIONAPPID not Specified in the cfg File"
21.5.3
Essbase Agent Startup Fails with "Error While Loading Shared Libraries"
21.5.4
opmnctl Commands Fail to Execute
21.5.5
An Application Stops Responding: Search Logs for Error Messages
21.5.6
An Essbase Application Will Not Start or Network Error Displayed: Check for Port Conflict
21.5.7
ASO Database Corruption Error: Clear Database and Reload
21.5.8
Cannot Stop an Application Process: Check Logs and Forcefully Terminate if Needed
21.5.9
Change the Essbase Ports (High-Availability Mode)
21.5.10
Change the Essbase Ports (Non-High-Availability Mode)
21.5.11
Data Load Fails with the "Load Buffer Does Not Exist" Error
21.5.12
Data Load Fails with "Load Buffer Resource Usage" Error
21.5.13
Essbase Fails to Start in Cluster Mode: Check for Hostname Qualification Mismatch
21.5.14
Essbase Login Failed Due to Invalid Credentials
21.5.14.1
Gather Detailed Error Messages Using essbase.cfg File
21.5.14.2
Gather Debug-Level Messages Using essbase.cfg File
21.5.14.3
Check for BI Domain Login Errors and Add a Valid Essbase User Name
21.5.15
System Error "Failed to Open File" on UNIX: Increase Maximum Number of Open File Descriptors
21.5.16
GL Writeback Fails with "Accounting Date Conversion" Error: Check Date String Format
21.5.17
GL Writeback Fails with "Group ID Node" Error: Check User Group IDs
21.5.18
GL Writeback Fails with "Not a Valid GL Application" Error: Check cubeMap.xml
21.5.19
GL Writeback Fails with "SQL Database Connection" Error: Check SQL Driver Setup
21.5.20
Network Error "Cannot Send Data"/"Cannot Receive Data": Check xcp File and Timeout Parameters
21.5.21
OPMN Fails to Start Essbase in High-Availability Mode: Check ARBORPATH Variables
21.5.22
Restructure Failure
21.5.22.1
Memory Error 1130203: Increase Virtual Memory and Use 64-bit Installation
21.5.22.2
"Errors Validating Outline"/"Outline Has Errors": Check Log for Hints
21.5.22.3
"Cannot Write New Outline"/"Error Writing outline Change Log File": Check for Space on File System
21.5.23
"Invalid Item Index in Security File": Fix Corrupt Security File
21.5.24
Find Out if Essbase is Running by Checking Essbase Agent Status
21.5.25
"Failed to Extend File" Error During Data Load or Building Aggregate Views: Resolve Insufficient File Space Problem
22
Use Other Oracle Fusion Applications Administration Tools
22.1
Introduction to the Tools Used to Administer
Oracle Fusion Applications
22.1.1
When to Use
Fusion Applications Control
Tool, When to Use
Oracle WebLogic Server
Administration Console
22.2
Find the Administration Server Port and Other Administrative URLs for Domains
22.3
Use
Fusion Applications Control
22.3.1
Overview of How
Fusion Applications Control
Compares with
Fusion Middleware Control
22.3.2
Access
Fusion Applications Control
22.3.3
Use
Fusion Applications Control
Help
22.3.4
Navigate within
Fusion Applications Control
22.3.5
Overview of the Targets in the Target Navigation Pane
22.3.6
Navigate to the Product Family and Product Administration Pages
22.3.7
View the Performance of Targets
22.3.8
Overview of Users and Roles for
Fusion Applications Control
22.4
Use Oracle WebLogic Server Administration Console
22.4.1
Start Oracle WebLogic Server Administration Console
22.4.2
Lock the WebLogic Server Configuration
22.5
Use
Oracle Fusion Functional Setup Manager
23
Overview of Oracle Fusion Applications Incidents and Log Files
23.1
Overview of
Oracle Fusion Applications
Incidents, Logging, and QuickTrace
23.2
Oracle Fusion Applications Incidents
23.2.1
Incident Settings to Leave As-Is
23.2.2
Incident File Locations
23.2.3
Default System Settings for Incident Creation
23.2.4
When Changes to Incident Configuration Settings Take Effect
23.2.5
Recover from Incidents Generated During SOA Operations
23.3
Oracle Fusion Applications Log Files
23.3.1
Understand
Oracle Fusion Applications
Log Files and Log Messages
23.3.1.1
Standard Log File Administration Tasks and Tools
23.3.1.2
Log Files and Settings
23.3.1.3
Log Message Structure
23.3.1.3.1
Log Message Attributes Supplied by the
Oracle Fusion Middleware
and
Oracle Database
Layers
23.3.1.3.2
Log Message Attributes Supplied by Logging APIs for
Oracle Fusion Applications
23.3.1.3.3
Log Message Attributes Supplied by the Application Session
23.3.1.3.4
Log Message Attributes Supplied by Oracle Enterprise Scheduler Job Requests
23.3.1.3.5
Log Message Attributes Supplied by SOA
23.3.2
Typical Log File Locations
23.3.3
Location of Logged Information When Using Multiple Managed Servers
23.3.4
Default System Log Settings
23.3.5
Standard Logging Levels
23.3.6
Precedence and Log Settings for Troubleshooting
23.3.7
When Changes to Log File Configuration Settings Take Effect
23.3.8
View Logs from
Fusion Applications Control
Scripting on this page enhances content navigation, but does not change the content in any way.