Skip Headers
Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services
11
g
Release 1 (11.1.1)
B32121-01
Library
Product
Index
Next
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documentation
Conventions
Part I Getting Started
1
Introduction
1.1
Introduction to Oracle Reports
1.1.1
Oracle Reports Builder
1.1.2
Oracle Reports Bridge
1.1.3
Oracle Reports Client
1.1.4
Oracle Reports Runtime
1.1.5
Oracle Reports Servlet
1.1.6
Oracle Reports Server
1.2
What's New In This Release?
2
Understanding the Oracle Reports Services Architecture
2.1
What's New In This Release?
2.2
Oracle Fusion Middleware Platform
2.3
Oracle Reports Services
2.3.1
Overview
2.3.2
Oracle Reports Services Components
2.3.3
Oracle Reports Services Runtime Process
2.3.4
Oracle Reports Services Communication Architecture
2.3.4.1
Server Discovery Using the Broadcast Mechanism
2.3.4.2
Server Discovery Using the COS Naming Service
2.4
Setting Up Your System
2.4.1
Choosing the Types of Requests You Will Service
2.4.2
Choosing Oracle Reports Servlet, JSP, or Web Services
2.4.3
Choosing Single or Multiple-Machine Configurations
2.5
Setting Up a High Availability Environment
2.5.1
Maintaining High Availability
2.5.2
Configuring the rwservlet.properties file
2.5.3
Configuring Reports Server for High Availability
2.5.3.1
Configuring Oracle Enterprise Manager for High Availability
3
Verifying Your Installation
3.1
What's New In This Release?
3.2
Understanding the Oracle Fusion Middleware Installation Structure
3.3
Verifying OOTB Installation
3.3.1
Using Oracle Enterprise Manager
3.4
Verifying the Reports Server Environment
3.4.1
Checking Oracle HTTP Server
3.4.2
Checking Oracle Reports Servlet
3.4.3
Checking Reports Server
3.5
Confirming Security with Oracle Portal-Based Security
3.5.1
Using Oracle Enterprise Manager
3.5.2
Using the Command Line
3.6
Upgrading from the Prior Release
3.6.1
Backward Compatibility and Interoperability
3.7
Granting Access to RWbuilder
4
Interoperability Scenarios and Considerations
4.1
Interoperability with Previous Versions of Oracle Reports
4.2
Interoperability with Other Oracle Components
5
Starting and Stopping Oracle Reports Services
5.1
Starting and Stopping Reports Server
5.1.1
Starting, Stopping, and Restarting Reports Servers from Oracle Enterprise Manager
5.1.2
Starting, Stopping, and Restarting Reports Servers from the Oracle Process Manager and Notification Server
5.1.3
Alternative Methods of Starting and Stopping Reports Server
5.1.3.1
Starting the In-process Server (Windows and UNIX)
5.1.3.2
Starting Reports Server from a Command Line (Windows and Linux)
5.1.3.3
Stopping Reports Server
5.2
Starting and Stopping Oracle Reports Bridge
5.2.1
Starting, Stopping, and Restarting the Oracle Reports Bridge from the Oracle Process Manager and Notification Server
5.2.2
Starting and Stopping the Oracle Reports Bridge from the Command Line
5.3
Starting Reports Components After Shutting Down an Instance
5.3.1
Starting Reports Servlet
5.3.2
Starting Reports Standalone Server
5.4
Starting and Stopping the COS Naming Service
5.5
Starting, Stopping, and Restarting Oracle Reports Components Using Oracle Enterprise Manager
5.6
Starting and Stopping the In-process Reports Server Using Oracle Reports Servlet
5.7
Verifying that the Oracle HTTP Server Is Running
5.8
Verifying that the Reports Servlet and Server are Running
Part II Administering Oracle Reports Services
6
Administering Oracle Reports Services Using Oracle Enterprise Manager
6.1
What's New In This Release?
6.2
Configuring Reports Server for Oracle Enterprise Manager
6.3
Viewing the Component Topology
6.4
Starting, Stopping, and Restarting Oracle Reports Components
6.5
Configuring Oracle Reports Components
6.5.1
Configuring a Mail Server
6.6
Defining Oracle Enterprise Manager Administration Roles
6.7
Administering and Scheduling Jobs
6.7.1
Displaying Jobs
6.7.2
Displaying a Consolidated Job Queue
6.7.3
Performing Operations on Jobs
6.7.4
Scheduling Jobs
6.8
Securing Oracle Reports Services
6.8.1
Enabling and Disabling Security
6.8.1.1
Switching to Oracle Portal Security
6.8.2
Defining Security Policies for Reports
6.8.3
Defining Security Policies for Directories
6.8.4
Defining Security Policies for Web Commands
6.8.5
Defining Read/Write Access to Directories
6.8.6
Enabling and Disabling Single Sign-On
6.8.7
Managing Credentials
6.9
Managing Fonts
6.9.1
Configuring Fonts
6.9.2
Diagnosing Font Issues
6.10
Monitoring Performance
6.10.1
Problems Viewing Reports Metrics When Reports is Configured for Secure Sockets Layer (SSL)
6.11
Managing Log Files
6.11.1
Viewing and Searching Log Files
6.11.2
Configuring Log Levels
6.11.3
Editing Log Files
6.12
Modifying Reports Server Audit Configuration
6.13
Registering Pluggable Destinations with Reports Server
6.14
Configuring Proxy Information
6.15
Managing and Monitoring a Reports High Availability (HA) Solution
6.15.1
Configuring Reports Server for High Availability
6.15.2
Displaying a Consolidated Job Queue
6.15.3
Specifying a Shared Cache Directory
6.16
About the Oracle Fusion Middleware System MBean Browser
6.16.1
When should I use the Oracle Fusion Middleware System MBean Browser?
6.16.2
About Reports Configuration MBeans
6.17
Modifying Reports Configuration Settings Using the System MBean Browser
6.18
Diagnosing Issues
6.18.1
Specifying Logging Information
6.18.2
Diagnosing Font Issues
7
Configuring Oracle Reports Services
7.1
Oracle Reports Services Configuration Files
7.2
Reports Server Configuration File
7.2.1
Reports Server Configuration Elements
7.2.1.1
ORBPorts
7.2.1.2
pluginParam
7.2.1.3
cache
7.2.1.4
cluster
7.2.1.5
connection
7.2.1.6
destination
7.2.1.7
environment
7.2.1.8
envVariable
7.2.1.9
engine
7.2.1.10
job
7.2.1.11
jobRecovery
7.2.1.12
jobStatusRepository
7.2.1.13
log
7.2.1.14
jobRepository
7.2.1.15
notification
7.2.1.16
oidconnection
7.2.1.17
orbClient
7.2.1.18
persistFile
7.2.1.19
identifier
7.2.1.20
property
7.2.1.21
queue
7.2.1.22
folderAccess
7.2.1.23
security
7.2.1.24
proxyServer
7.2.1.25
domain
7.2.1.26
bypassProxy
7.2.1.27
proxyServers
7.2.1.28
proxyInfo
7.2.1.29
webLayout
7.2.1.30
dbProxyKey
7.2.1.31
dbProxyConnKeys
7.2.1.32
jobThresholds
7.2.1.33
server
7.2.2
Dynamic Environment Switching
7.2.2.1
Examples
7.2.2.2
Usage Notes
7.3
Oracle Reports Servlet Configuration File
7.3.1
Oracle Reports Servlet Configuration Elements
7.3.1.1
rwservlet
7.3.2
Specifying an Alternate Oracle Reports Servlet Configuration File
7.4
Oracle Reports Bridge Configuration File
7.4.1
Oracle Reports Bridge Configuration Elements
7.4.1.1
bridge
7.4.1.2
identifier
7.4.1.3
remoteBridge
7.4.1.4
remoteBridges
7.5
Network Configuration File
7.5.1
Network Configuration Elements
7.5.1.1
discoveryService
7.5.1.2
multicast
7.5.1.3
namingService
7.6
Configuring the URL Engine
7.7
Entering Proxy Information
7.7.1
Using Oracle Enterprise Manager
7.7.2
Editing the Server Configuration File
7.8
Configuring Reports Server with the Oracle Process Manager and Notification Server and Oracle Enterprise Manager
7.8.1
opmn.xml
7.8.1.1
Module Specification
7.8.1.2
Standalone Reports Server Specification
7.8.1.3
Oracle Reports Bridge Specification
7.8.1.4
COS Naming Service Specification
7.8.2
Creating a New Reports Server
7.8.3
Creating a New Bridge Component Type
7.9
Overview of SOA Integration
7.9.1
About BPEL
7.10
Configuring Oracle Reports to Communicate with Oracle BPEL Process Manager
7.10.1
Using RWWebservice to Submit Jobs to the Reports Server
7.10.2
Submitting Jobs to the Reports Server from a BPEL Process Asynchronously
7.11
Optimizing the Deployment of Reports
7.12
Sample system-jazn-data.xml File
Part III Managing Runtime Behavior
8
Managing Fonts in Oracle Reports
8.1
Using Fonts
8.1.1
Fonts in Oracle Reports Builder
8.1.2
Fonts in Report Output
8.1.2.1
Font lookup
8.1.3
Fonts in the User Interface
8.2
Adding Fonts
8.2.1
Adding Fonts to Oracle Reports Builder
8.2.2
Adding Fonts for Report Output
8.2.2.1
Adding fonts on UNIX
8.2.2.2
Adding fonts on Windows
8.3
Font Configuration Files
8.3.1
File Searching
8.4
Font Aliasing
8.4.1
Specifying Aliasing Information
8.4.2
Font Aliasing Mechanism
8.4.3
Font Alias File Sections
8.4.4
Font Aliasing File Verification
8.5
Font Types
8.5.1
Character Sets
8.5.2
Unicode
8.5.3
Type1 Fonts
8.5.4
TrueType Fonts
8.5.5
TrueType Collection
8.5.6
Barcode Fonts
8.5.7
CID Fonts
8.6
Verifying Report Output on Different Platforms
8.7
Running a Unicode Report using TTF/TTC Fonts
8.8
Diagnosing Font Issues
8.8.1
Using the Command Line
8.8.2
Using Oracle Enterprise Manager
8.9
Troubleshooting Font Issues
9
Printing on UNIX with Oracle Reports
9.1
UNIX Printing Overview
9.1.1
General Printing Mechanism
9.1.2
Oracle Reports Printing Mechanism on UNIX and Windows
9.1.3
Printing Support
9.2
Setting Up a Printer on UNIX
9.2.1
Installing a Printer on UNIX
9.2.2
Verifying the Printer Setup for Oracle Reports
9.3
Configuring the Printing Environment
9.3.1
Editing uiprint.txt File
9.3.2
Environment Variables
9.3.3
Print Property Dialog Boxes
9.3.3.1
Page Setup dialog box
9.3.3.2
Print Job dialog box
9.4
Printer-Related Files
9.4.1
Overview of Files
9.4.2
PPD Files
9.4.2.1
Local Customization of PPD files
9.4.3
HPD Files
9.4.4
Font Metrics Files
9.4.4.1
AFM files
9.4.4.2
TFM files
9.4.5
uifont.ali
9.4.6
uiprint.txt
9.4.7
Editing the Printer-Related Files
9.4.7.1
Editing PPD files
9.4.7.2
Editing HPD files for PCL printing
9.5
Enhanced Printing on Linux Using CUPS
9.5.1
Setting Up a Single Server for Printing
9.6
Globalization Support
9.6.1
Multibyte Character Set Printing
9.6.2
Overview of IX and PASTA
9.7
Debugging Options
9.7.1
DEBUG_SLFIND
9.7.2
TK_DEBUG_POSTSCRIPT
9.8
Removing DISPLAY and Printer Dependencies on UNIX
9.8.1
ScreenPrinter
9.8.2
Advanced Imaging Support
9.9
Frequently Asked Questions
9.9.1
Common Printing Error Messages
9.9.2
PCL Printing Issues
9.9.3
PostScript Printing Issues
9.9.4
Font-Related Printing Issues
9.9.5
Printed Output Issues
10
Using PDF in Oracle Reports
10.1
What's New In This Release?
10.2
PDF Features Included in Oracle Reports
10.2.1
Compression
10.2.1.1
Setup
10.2.2
Font-Related Features
10.2.2.1
Font Aliasing
10.2.2.2
Font Subsetting
10.2.2.3
Font Embedding
10.2.2.4
Font Feature Summary
10.2.3
Precedence of Execution
10.2.4
Encryption, Password Protection, and Permissions Security
10.2.5
Accessibility
10.2.6
Taxonomy
10.2.7
Graph Support
10.3
Generating a Unicode PDF File
10.3.1
Font Subsetting
10.4
Generating a Bidirectional (BiDi) PDF File
10.4.1
Font Subsetting
10.5
Generating a Multibyte PDF File
10.5.1
Font Aliasing
10.5.2
Font Subsetting
10.6
Generating a Barcode PDF File
10.6.1
Font Embedding
10.6.2
Font Subsetting
11
Font Model and Cross-Platform Deployment
11.1
What's New In This Release?
11.2
Overview of the Font Model
11.2.1
Font Lookup
11.2.1.1
Font Lookup Algorithm
11.2.2
Configuring the New Font Model
11.2.3
Font Diagnosis and Tracing
11.3
Overview of Cross-Platform Issues
11.3.1
Font Availability On Different Platforms
11.3.2
Fixing Font-Related Issues
11.4
Generating HTMLCSS, RTF, or Web Output
11.4.1
Designing Your Report
11.4.2
Deploying Your Report
11.4.2.1
Troubleshooting Information
11.4.3
Frequently Asked Questions
11.5
Generating Single-Byte PDF Output
11.5.1
Designing Your Report
11.5.2
Deploying Your Report in Pre-11g Version That Uses Motif Tool Kit Mechanism
11.5.2.1
Troubleshooting Information
11.5.3
Frequently Asked Questions
11.6
Generating Multibyte PDF Output
11.6.1
Designing Your Reportin Pre-11g Version That Uses Motif Tool Kit Mechanism
11.6.2
Deploying Your Report in Pre-11g Version That Uses Motif Tool Kit Mechanism
11.6.2.1
Troubleshooting Information
11.6.3
Frequently Asked Questions
11.7
Generating Unicode PDF Output
11.7.1
Designing Your Report in Pre-11g Version That Uses Motif Tool Kit Mechanism
11.7.2
Deploying Your Report in Pre-11g Version That Uses Motif Tool Kit Mechanism
11.7.2.1
Troubleshooting Information
11.7.3
Frequently Asked Questions
11.8
Generating PostScript Output
11.8.1
Designing Your Report
11.8.2
Deploying Your Report
11.8.3
Frequently Asked Questions
12
Configuring Destinations for Oracle Reports Services
12.1
What's New in this Release
12.1.1
Pluggable Destinations from Oracle Forms Services.
12.2
Overview of Output Processing
12.3
Registering Destination Types with the Server
12.3.1
Setting Up a Destination Section in the Server Configuration File
12.3.2
Entering Valid Values for a Destination
12.3.2.1
Destination destypes and classes
12.3.2.2
Destination Property name/value Pairs
12.3.3
Example Destination
12.4
Submitting Reports to Pluggable Destinations from Oracle Forms Services
13
Configuring and Using the Pluggable Data sources
13.1
Configuring and Using the JDBC PDS
13.1.1
JDBC Configuration File
13.1.1.1
Verifying Pre-installed Driver Entries
13.1.1.2
Installing and Configuring Merant DataDirect Drivers
13.1.2
Defining and Running a JDBC Query
13.1.2.1
Sample Connection Information
13.1.3
Running a JDBC Report Using Oracle Reports Services
13.1.4
TroubleShooting Information
13.1.4.1
Error Messages
13.1.4.2
Trace Information
13.1.5
Adding Your Own JDBC Driver
13.1.5.1
Configuring the jdbcpds.conf File
13.1.5.2
Installing the Driver's JAR Files
13.2
Configuring and Using Text PDS
13.2.1
Text Configuration File
13.3
Configuring and Using XML PDS
13.3.1
XML PDS Configuration File
14
Securing Oracle Reports Services
14.1
Introduction to Oracle Reports Security
14.1.1
Overview
14.1.2
What's New in This Release?
14.1.3
Resources Protected
14.1.3.1
Application Security
14.1.3.2
Resource Security
14.1.3.3
Data Source Security
14.1.4
Credential Store
14.1.4.1
Credential Types
14.2
Out-of-the-Box Behavior
14.3
Authentication in Oracle Reports
14.3.1
OracleAS Single Sign-On Authentication
14.3.1.1
Report Request Flow with Single Sign-On
14.3.2
Non-SSO Authentication
14.3.2.1
Report Request Flow with Non-SSO (Oracle Internet Directory-Based, File-Based, or Embedded ID Store)
14.3.3
Authentication Scenarios for JPS-Based Security
14.3.3.1
If Reports is using JPS security, JPS-OID for security policies, and an embedded ID store
14.3.3.2
If Reports is using JPS security and JPS-OID as ID store
14.3.4
Authentication Scenario for Portal-Based Security
14.4
Authorization in Oracle Reports
14.4.1
Authorization Process
14.4.2
Additional Step When Using JPS for Authorization
14.4.3
Defining Security Policies for Reports
14.4.3.1
Defining Security Policies for JPS-Based Security
14.4.3.2
Defining Security Policies for Portal-Based Security
14.4.4
Defining Security Policies for Directories for JPS-Based Security
14.4.5
Defining Security Policies for Web Commands for JPS-Based Security
14.4.6
Defining Read/Write Access to Directories
14.5
End-to-End Security Scenarios
14.6
Recommended Production Scenario for JPS-Based Security
14.7
Recommended Production Scenario for Portal-Based Security
14.8
Managing Users and Security Policies
14.8.1
Adding Users to WebLogic Embedded ID Store for In-Process Servers
14.8.2
Adding Policies to Policy Store for In-Process Servers
14.8.3
Mapping Users to Application Roles
14.8.4
Adding Users to system-jazn-data.xml for Standalone Servers
14.8.5
Adding Policies to Policy Store for Standalone Servers
14.9
Configuring External Oracle Internet Directory and Reassociating Reports
14.9.1
Configuring External Oracle Internet Directory for In-Process Servers
14.9.1.1
Configuring External Oracle Internet Directory as ID Store When Using JPS-Based Security
14.9.1.2
Configuring an External Oracle Internet Directory as Policy Store When Using JPS-Based Security
14.9.2
Reassociating Reports with Oracle Internet Directory
14.9.3
Reassociating Reports to Another Portal
14.9.4
Configuring External Oracle Internet Directory for Standalone Servers
14.9.4.1
Configuring External Oracle Internet Directory as ID Store
14.9.4.2
Configuring External Oracle Internet Directory as Policy Store
14.10
Forms and Reports Security Recommendations
14.11
Intermediate-level Security for Forms and Reports
14.12
Database Proxy Authentication
14.12.1
Using Oracle Enterprise Manager
14.12.2
Using DAS and Editing the Server Configuration File
14.12.3
Configuring Proxy User Authentication in the Database
14.12.4
Obtaining Proxy Access Information
14.12.5
Configuration Settings in Reports Configuration Files
14.12.5.1
rwserver.conf
14.12.5.2
rwservlet.properties
14.13
Oracle Portal-Based Security for Backward Compatibility
14.13.1
Security Features Provided by Oracle Portal
14.14
Security Interfaces
15
Deploying Reports in Oracle Portal
15.1
Creating Reports Users and Named Groups
15.1.1
Default Reports-Related Groups
15.1.1.1
RW_BASIC_USER
15.1.1.2
RW_POWER_USER
15.1.1.3
RW_DEVELOPER
15.1.1.4
RW_ADMINISTRATOR
15.1.2
Creating Users and Groups
15.1.3
Portal Password in Credential Store
15.2
Registering Oracle Reports Components
15.2.1
Registering a Reports Server
15.2.2
Registering a Report
15.2.3
Registering a Printer
15.2.4
Creating an Availability Calendar
15.2.4.1
Creating a Simple Availability Calendar
15.2.4.2
Creating a Combined Availability Calendar
15.2.5
The Manage Portlet
15.3
Publishing Your Report as a Portlet
15.3.1
Creating a Provider for Your Reports
15.3.2
Adding the Report Portlet to a Page
15.3.3
Adding the Report as an Item Link to a Page
15.3.4
Running Reports on Oracle Portal as an Item Link on a Nondefault Installation
15.3.5
Distributing Report Output to Oracle Portal
15.4
Connecting to Oracle Portal
15.5
Troubleshooting Information
15.5.1
Resolving Reports-Portal Integration Error When Attempting Create Resource
16
Configuring and Administering OracleAS Single Sign-On
16.1
Prerequisites
16.2
Configuring Out-of-the-Box OracleAS Single Sign-On
16.2.1
Oracle Identity Management and OracleAS Single Sign-On Infrastructure
16.2.1.1
OracleAS Single Sign-On
16.3
Administering OracleAS Single Sign-On
16.3.1
Enabling and Disabling OracleAS Single Sign-On
16.3.2
Enabling and Disabling Reports Server Security
16.3.3
Enabling and Disabling Data Source Security
16.3.3.1
SSOCONN
16.3.3.2
Populating Oracle Internet Directory
16.3.3.3
Adding a New Resource Type
16.3.4
Connecting to Oracle Internet Directory
16.3.4.1
Choosing the Connecting Entity for Oracle Internet Directory
16.3.4.2
Choosing the Oracle Internet Directory Instance
16.4
Choosing the Connecting Entity for Oracle Internet Directory
16.5
Changing the Reports Servlet Port to Be Protected by Single Sign-On
16.6
Oracle Forms Services Security Considerations
16.6.1
What's New In This Release?
Part IV Sending Requests to the Server
17
Running Report Requests
17.1
The Reports URL Syntax
17.1.1
Oracle Reports Servlet
17.1.2
JSP
17.2
Report Request Methods
17.3
Deploying Your Reports
17.3.1
Deploying a Report with a Paper Layout
17.3.2
Running a Report with a Paper Layout
17.3.3
Deploying a JSP Report to the Web and to Paper
17.3.3.1
Creating a New Java EE Application
17.3.3.2
Deploying Java EE Application Using WebLogic Server
17.3.4
Running a JSP-Based Web Report from a Browser
17.3.5
Running a JSP report with a Paper Layout
17.3.6
Running with the WE8MSWIN1252 Character Set on UNIX
17.4
Publishing a Report in Oracle Portal
17.5
Specifying a Report Request from a Web Browser
17.6
Sending a Request to the URL Engine
17.7
Running Reports Through a Web Service
17.8
Calling Oracle Reports from Oracle Forms Services
17.8.1
Communication Between Reports and Forms When Installed on Different Instances
17.8.2
Generating Random and Non-Sequential Job IDs
17.9
Running Reports Using Oracle BPEL Process Manager
17.10
Scheduling Reports to Run Automatically
17.11
Additional Parameters
17.12
Reusing Report Output from Cache
17.12.1
Usage Note
17.13
Using a Key Map File
17.13.1
Understanding Key Mapping
17.13.2
Enabling Key Mapping
17.13.3
Adding Key Mapping Entries to a Key Map File
17.13.4
Using a Key with Non-JSP Reports
17.13.5
Using a Key with a Report Run as a JSP
18
Using the Oracle Reports Web Service
18.1
Overview
18.2
Getting Started
18.2.1
Invoking the RWWebService Servlet
18.2.2
Viewing the WSDL
18.3
Oracle Reports Web Service Operations
18.3.1
Using Oracle Enterprise Manager to Test RWWebService
18.3.1.1
getAPIVersion
18.3.1.2
getServerInfo
18.3.1.3
getJobInfo
18.3.1.4
killJob
18.3.1.5
runJob
18.4
Using RWWebServiceUtil to Test RWWebService
19
Creating Advanced Distributions
19.1
Distribution Overview
19.2
What's New In This Release?
19.3
Introduction to Distribution XML Files
19.3.1
The distribution.dtd File
19.3.2
Using Variables Within Attributes
19.4
Elements of a Distribution XML File
19.4.1
destinations
19.4.2
foreach
19.4.3
mail
19.4.4
body
19.4.5
attach
19.4.6
include
19.4.7
file
19.4.8
printer
19.4.9
destype
19.4.10
property
19.5
Distribution XML File Examples
19.5.1
foreach Examples
19.5.1.1
Single E-Mail with Report Groups as Separate Attachments
19.5.1.2
Separate E-Mail for Each Group Instance
19.5.1.3
Separate E-Mails with Separate Sections as Attachments
19.5.1.4
Separate File for Each Section
19.5.1.5
Separate Print Run for Each Report
19.5.2
mail Examples
19.5.2.1
E-Mail with a Whole Report as the Body
19.5.2.2
E-Mail with a Section of a Report as the Body
19.5.2.3
E-Mail with Two Report Sections as the Body
19.5.2.4
E-Mail with External File as Body and Report as Attachment
19.5.2.5
E-Mail with Whole Report and Grouped Sections Attached
19.5.2.6
E-Mail to Relevant Manager and Department
19.5.3
file Examples
19.5.3.1
File for Whole Report
19.5.3.2
File for Combined Report Sections
19.5.3.3
File for Each Group of Combined Sections
19.5.3.4
File for Each Report Group Instance
19.5.4
printer Examples
19.5.4.1
Print Whole Report
19.5.4.2
Print Two Sections of a Report
19.5.4.3
Print Grouped Report
19.5.4.4
Print Combined Sections for Each Group Instance
19.5.4.5
Print Relevant Instance of a Report to Its Relevant Printer
19.5.5
destype Examples
19.5.5.1
Oracle Portal Destination
19.5.5.2
FTP Destination
19.5.5.3
WebDAV Destination
19.5.5.4
Fax Destination
19.6
Using a Distribution XML File at Runtime
19.7
Limitations with Using Distribution
19.7.1
Delimited Output
19.7.2
Dynamic Format Values
20
Using Event-Driven Publishing
20.1
The Event-Driven Publishing API
20.1.1
Elements of the API
20.1.2
Creating and Manipulating a Parameter List
20.1.2.1
Add_Parameter
20.1.2.2
Remove_Parameter
20.1.2.3
Clear_Parameter_List
20.1.3
Including non-ASCII Characters in Parameter Names and Values
20.1.4
Submitting a Job
20.1.5
Checking for Status
20.1.6
Using the Servers' Status Record
20.2
Debugging Applications that Use the Event-Driven Publishing API
20.3
Invoking a Report from a Database Event
20.4
Integrating with Oracle Advanced Queuing
20.4.1
Creating a Queue That Holds Messages of Type SRW_PARAMLIST
20.4.2
Creating the Enqueuing Procedure
20.4.3
Creating the Dequeuing Procedure
21
Customizing Reports with XML
21.1
Customization Overview
21.2
Creating XML Customizations
21.2.1
Required XML Tags
21.2.2
Changing Styles
21.2.3
Changing a Format Mask
21.2.4
Adding Formatting Exceptions
21.2.5
Adding Program Units and Hyperlinks
21.2.6
Adding a New Query and Using the Result in a New Header Section
21.2.7
Encoding the URL
21.3
Creating XML Data Models
21.3.1
Creating Multiple Data Sources
21.3.2
Linking Between Data Sources
21.3.3
Creating Group Hierarchies Within Each Data Source
21.3.4
Creating Cross-Product (Matrix) Groups
21.3.5
Creating Formulas, Summaries, and Placeholders at Any Level
21.3.6
Creating Parameters
21.4
Using XML Files at Runtime
21.4.1
Applying an XML Report Definition at Runtime
21.4.1.1
Applying One XML Report Definition
21.4.1.2
Applying Multiple XML Report Definitions
21.4.1.3
Applying an XML Report Definition in PL/SQL
21.4.2
Running an XML Report Definition by Itself
21.4.3
Performing Batch Modifications
21.5
Debugging XML Report Definitions
21.5.1
XML Parser Error Messages
21.5.2
rwbuilder
21.5.3
Writing XML to a File for Debugging
Part V Globalization Support and Bidirectional Support
22
Implementing Globalization and Bidirectional Support
22.1
Globalization Support Architecture
22.1.1
Language-Independent Functions
22.1.2
Language-Dependent Data
22.2
Globalization Support Environment Variables
22.2.1
NLS_LANG Environment Variable
22.2.1.1
Defining the NLS_LANG Environment Variable
22.2.1.2
Defining the Language and Territory
22.2.1.3
Defining the Character Set
22.2.2
DEVELOPER_NLS_LANG and USER_NLS_LANG Environment Variables
22.3
Specifying a Character Set in a JSP or XML File
22.4
Bidirectional Support
22.5
Unicode
22.5.1
Unicode Support
22.5.2
Unicode Font Support
22.5.3
Enabling Unicode Support
22.6
Translating Applications
22.7
Troubleshooting Globalization Issues
Part VI Performance
23
Diagnosing and Tuning Oracle Reports
23.1
What's New In This Release?
23.2
Logging Enhancements
23.3
Performance Analysis Tools
23.3.1
Oracle Enterprise Manager
23.3.2
Log Files
23.3.2.1
Viewing Log Files
23.3.2.2
Managing Log Files
23.3.2.3
Audit Log Files
23.3.3
About WLST
23.3.3.1
Using WLST Commands for System Components
23.3.3.2
Using WLST Commands for Java EE Components
23.3.4
Logging-Related WLST Commands
23.3.4.1
listLoggers
23.3.4.2
getLogLevel
23.3.4.3
setLogLevel
23.3.4.4
listLogHandlers
23.3.4.5
configureLogHandlers
23.3.4.6
listLogs
23.3.4.7
displayLogs
23.3.5
Metrics Related WLST Commands
23.3.5.1
Viewing Metrics Tables
23.3.5.2
Viewing All Available Metrics
23.3.5.3
Viewing Specific Metric Tables
23.3.6
Audit Configuration WLST Commands
23.3.6.1
getAuditPolicy
23.3.6.2
setAuditPolicy
23.3.6.3
listAuditEvents
23.3.7
Tracing Report Execution
23.3.8
RW_SERVER_JOB_QUEUE Table
23.3.8.1
Updating the Database with Queue Activity
23.3.9
SHOWJOBS Command Line Keyword
23.3.10
Efficient SQL
23.3.11
PL/SQL
23.3.12
Java Stored Procedures
23.3.13
The Java Importer
23.4
Tuning Reports Server Configuration
23.5
Accessing the Data
23.5.1
Non-SQL Data Sources
23.5.2
Database Indexes
23.5.3
Calculations
23.5.4
Redundant Data
23.5.5
Break Groups
23.5.6
Group Filters
23.5.7
To Link or Not To Link
23.6
Formatting the Data
23.6.1
Paper Layout
23.6.1.1
Format Triggers
23.6.1.2
Image Outputs
23.6.2
Web Layout and JSP Report Definition
23.7
General Layout Guidelines
23.7.1
Fetching Ahead
23.7.2
Bursting and Distribution
23.8
Running the Report
Part VII Appendixes
A
Command Line Keywords
A.1
Using the Command Line
A.1.1
General Usage Notes
A.1.2
Rules
A.2
Oracle Reports Components Overview
A.2.1
rwclient
A.2.2
rwrun
A.2.3
rwbuilder
A.2.4
rwconverter
A.2.5
rwservlet
A.2.6
rwserver
A.2.7
rwbridge
A.3
Keyword Usage Summary
A.4
Command Line Keywords
A.5
Command Line Keywords - Part 1
A.5.1
ACCESSIBLE
A.5.2
ARRAYSIZE
A.5.3
AUTHID
A.5.4
AUTOCOMMIT
A.5.5
BACKGROUND
A.5.6
BATCH
A.5.7
BCC
A.5.8
BLANKPAGES
A.5.9
BUFFERS
A.5.10
CACHELOB
A.5.11
CC
A.5.12
CELLWRAPPER
A.5.13
CMDFILE
A.5.14
CMDKEY
A.5.15
COLLATE
A.5.16
COMPILE_ALL
A.5.17
CONTAINSHTMLTAGS
A.5.18
CONTAINSOLE
A.5.19
CONTENTAREA
A.5.20
COPIES
A.5.21
CUSTOMIZE
A.5.22
DATEFORMATMASK
A.5.23
DBPROXYCONN
A.5.24
DELAUTH
A.5.25
DELIMITED_HDR
A.5.26
DELIMITER
A.5.27
DESFORMAT
A.5.28
DESNAME
A.5.29
DEST
A.5.30
DESTINATION
A.5.31
DESTYPE
A.6
Command Line Keywords - Part 2
A.6.1
DISTRIBUTE
A.6.2
DTYPE
A.6.3
DUNIT
A.6.4
ENGINERESPONSETIMEOUT
A.6.5
ENVID
A.6.6
EXPIRATION
A.6.7
EXPIREDAYS
A.6.8
FORMSIZE
A.6.9
FROM
A.6.10
GETJOBID
A.6.11
GETSERVERINFO
A.6.12
HELP
A.6.13
ITEMTITLE
A.6.14
JOBNAME
A.6.15
JOBRETRY
A.6.16
JOBTYPE
A.6.17
JVMOPTIONS
A.6.18
KILLENGINE
A.6.19
KILLJOBID
A.6.20
LONGCHUNK
A.6.21
MIMETYPE
A.6.22
MODE
A.6.23
MODULE|REPORT
A.6.24
NAME
A.6.25
NONBLOCKSQL
A.6.26
NOTIFYFAILURE
A.6.27
NOTIFYSUCCESS
A.6.28
NUMBERFORMATMASK
A.6.29
ONFAILURE
A.6.30
ONSUCCESS
A.6.31
ORIENTATION
A.7
Command Line Keywords - Part 3
A.7.1
OUTPUTFOLDER
A.7.2
OUTPUTGRAPHFORMAT
A.7.3
OUTPUTIMAGEFORMAT
A.7.4
OUTPUTPAGE
A.7.5
OVERWRITE
A.7.6
PARAMETER
A.7.7
P_AVAILABILITY
A.7.8
P_DESCRIPTION
A.7.9
P_FORMATS
A.7.10
P_JDBCPDS
A.7.11
P_NAME
A.7.12
P_OWNER
A.7.13
P_PFORMTEMPLATE
A.7.14
P_PRINTERS
A.7.15
P_PRIVILEGE
A.7.16
P_SERVERS
A.7.17
P_TRIGGER
A.7.18
P_TYPES
A.7.19
PAGEGROUP
A.7.20
PAGESIZE
A.7.21
PAGESTREAM
A.7.22
PARAMFORM
A.7.23
PARSEQUERY
A.7.24
PDFCOMP
A.7.25
PDFEMBED
A.7.26
PDFOWNER
A.7.27
PDFSECURITY
A.7.28
PDFUSER
A.7.29
PFACTION
A.7.30
PRINTJOB
A.7.31
READONLY
A.7.32
RECURSIVE_LOAD
A.7.33
REPLYTO
A.7.34
REPORT | MODULE
A.8
Command Line Keywords - Part 4
A.8.1
ROLE
A.8.2
RUNDEBUG
A.8.3
SAVE_RDF
A.8.4
SCHEDULE
A.8.5
SERVER
A.8.6
SHOWAUTH
A.8.7
SHOWENV
A.8.8
SHOWJOBID
A.8.9
SHOWJOBS
A.8.10
SHOWMAP
A.8.11
SHOWMYJOBS
A.8.12
SHUTDOWN
A.8.13
SITENAME
A.8.14
SOURCE
A.8.15
SQLTRACE
A.8.16
SSOCONN
A.8.17
STATUSFOLDER
A.8.18
STATUSFORMAT
A.8.19
STATUSPAGE
A.8.20
STYPE
A.8.21
SUBJECT
A.8.22
SUPPRESSLAYOUT
A.8.23
TOLERANCE
A.8.24
URLPARAMETER
A.8.25
USEJVM
A.8.26
USERID
A.8.27
USERSTYLES
A.8.28
VALIDATETAG
A.8.29
WEBSERVER_DEBUG
A.8.30
WEBSERVER_DOCROOT
A.8.31
WEBSERVER_PORT
B
Environment Variables
B.1
Environment Variables
B.1.1
CA_GPREFS
B.1.2
CA_UPREFS
B.1.3
DELIMITED_LINE_END
B.1.4
DOC
B.1.5
DEVELOPER_NLS_LANG
B.1.6
NLS_CALENDAR
B.1.7
NLS_CREDIT
B.1.8
NLS_CURRENCY
B.1.9
NLS_DATE_FORMAT
B.1.10
NLS_DATE_LANGUAGE
B.1.11
NLS_DEBIT
B.1.12
NLS_ISO_CURRENCY
B.1.13
NLS_LANG
B.1.14
NLS_LIST_SEPARATOR
B.1.15
NLS_MONETARY_CHARACTERS
B.1.16
NLS_NUMERIC_CHARACTERS
B.1.17
NLS_SORT
B.1.18
ORACLE_AFM
B.1.19
ORACLE_HOME
B.1.20
ORACLE_HPD
B.1.21
ORACLE_INSTANCE
B.1.22
ORACLE_PATH
B.1.23
ORACLE_PPD
B.1.24
ORACLE_TFM
B.1.25
ORAINFONAV_DOCPATH
B.1.26
PRINTER
B.1.27
REMOTE
B.1.28
REPORTS_ADD_HWMARGIN
B.1.29
REPORTS_ARABIC_NUMERAL
B.1.30
REPORTS_ALLOW_DB_CONNECT_STRING
B.1.31
REPORTS_BIDI_ALGORITHM
B.1.32
REPORTS_CGIDIAGBODYTAGS
B.1.33
REPORTS_CGIDIAGHEADTAGS
B.1.34
REPORTS_CGIHELP
B.1.35
REPORTS_CGIMAP
B.1.36
REPORTS_CGINODIAG
B.1.37
REPORTS_CLASSPATH
B.1.38
REPORTS_CONTAINSHTMLTAGS
B.1.39
REPORTS_COOKIE_EXPIRE
B.1.40
REPORTS_DB_AUTH
B.1.41
REPORTS_DEFAULT_DISPLAY
B.1.42
REPORTS_DEFAULT_PIXEL_SIZE
B.1.43
REPORTS_ENABLE_RTF_SPACING
B.1.44
REPORTS_ENCRYPTION_KEY
B.1.45
REPORTS_ENHANCED_FONTHANDLING
B.1.46
REPORTS_ENHANCED_SUBSET
B.1.47
REPORTS_FONT_DIRECTORY
B.1.48
REPORTS_GRAPH_IMAGE_DPI
B.1.49
REPORTS_IGNORE_IMAGE_TAG_RES
B.1.50
REPORTS_JPEG_QUALITY_FACTOR
B.1.51
REPORTS_JVM_OPTIONS
B.1.52
REPORTS_NETWORK_CONFIG
B.1.53
REPORTS_NLS_XML_CHARSETS
B.1.54
REPORTS_NO_DUMMY_PRINTER
B.1.55
REPORTS_NO_HTML_SPACE_REPLACE
B.1.56
REPORTS_OUTPUTIMAGEFORMAT
B.1.57
REPORTS_PATH
B.1.58
REPORTS_RESTRICT_DIRECTORIES
B.1.59
REPORTS_RESOURCE
B.1.60
REPORTS_SERVER
B.1.61
REPORTS_SOLARIS_9
B.1.62
REPORTS_SPACE_BREAK
B.1.63
REPORTS_SRWRUN_TO_SERVER
B.1.64
REPORTS_SSLPORT
B.1.65
REPORTS_SYS_AUTH
B.1.66
REPORTS_TAGLIB_URI
B.1.67
REPORTS_TMP
B.1.68
REPORTS_USEREXITS
B.1.69
REPORTS_UTF8_XMLOUTPUT
B.1.70
RW
B.1.71
TK_PRINT
B.1.72
TK_PRINT_STATUS
B.1.73
TK_PRINTER
B.1.74
TK_AFM
B.1.75
TK_HPD
B.1.76
TK_PPD
B.1.77
TK_TFM
B.1.78
TNS_ADMIN
B.1.79
USERNAME
B.1.80
USER_NLS_LANG
C
Batch Registering Reports in Oracle Portal
C.1
Batch Registering Report Definition Files
C.1.1
Run rwconverter to Generate a SQL Script
C.1.2
Run the Script in SQL*Plus
C.2
Batch Removing Report Packages
C.3
PL/SQL Batch Registering Function
D
Troubleshooting Oracle Reports Services
D.1
Problems and Solutions
D.1.1
Hanging Report Requests
D.1.2
Reports Server Activity Generates Error REP-50125
D.1.3
Long Running Report Failure with Oracle Reports Servlet
D.1.4
Fonts Do Not Display Consistently On Different Platforms
D.1.5
Running Reports on UNIX Platforms Generates REP-56048
D.1.6
Font Issues with Right-to-Left Languages
D.1.7
Errors When Running Reports from Oracle Forms Using RUN_REPORT_OBJECT
D.1.8
Displaying Report Output in Microsoft Excel
D.1.9
Report Containing User Exit Fails on UNIX
D.1.10
Printing and Font Errors When Using In-process Reports Server
D.2
Diagnosing Performance Problems
D.3
Diagnosing Font Problems
D.4
Diagnosing Printing Problems
D.5
Diagnosing JDBC PDS Problems
D.6
Diagnosing Oracle Portal Problems
D.7
Diagnosing Globalization Problems
D.8
Diagnosing Oracle Reports Bridge Problems
D.9
Need More Help?
E
Reports Server and Bridge Diagnostic Utility
E.1
Overview of rwdiag
E.1.1
Examples
E.1.1.1
Example 1
E.1.1.2
Example 2
E.1.1.3
Example 3
E.1.1.4
Example 4
E.1.1.5
Example 5
E.1.1.6
Example 6
E.2
Command Line Syntax
E.2.1
Syntax
E.2.2
Usage Notes
Glossary
Index