Home
/
Middleware
/
Oracle Forms and Reports
1/230
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
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.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 OPSS based Security
3.5.1
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 Reports Servers from the Node Manager using script
5.1.2
Alternative Methods of Starting and Stopping Reports Server
5.1.2.1
Starting the In-process Server (Windows and UNIX)
5.1.2.2
Starting Reports Server from a Command Line (Windows and Linux)
5.1.2.3
Stopping Reports Server
5.2
Starting, Stopping Reports Bridges from the Node Manager using script
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 and Stopping the In-process Reports Server Using Oracle Reports Servlet
5.6
Verifying that the Oracle HTTP Server Is Running
5.7
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
Configuring Oracle Reports Components
6.1.1
Configuring a Mail Server
6.2
Administering and Scheduling Jobs
6.2.1
Displaying Jobs
6.2.2
Displaying a Consolidated Job Queue
6.2.3
Performing Operations on Jobs
6.2.4
Scheduling Jobs
6.3
Securing Oracle Reports Services
6.3.1
Enabling and Disabling Security and Changing Security Mechanism used
6.3.1.1
Switching to Oracle Portal Security
6.3.2
Defining Security Policies for Reports
6.3.3
Defining Security Policies for Directories
6.3.4
Defining Security Policies for Web Commands
6.3.5
Defining Read/Write Access to Directories
6.3.6
Enabling and Disabling Single Sign-On
6.3.7
Using Oracle Access Manager
6.3.8
Managing Credentials
6.4
Managing Fonts
6.4.1
Configuring Fonts
6.4.2
Diagnosing Font Issues
6.5
Monitoring Performance
6.6
Managing Log Files
6.6.1
Viewing and Searching Log Files
6.6.2
Configuring Log Levels
6.7
Modifying Reports Server Audit Configuration
6.8
Registering Pluggable Destinations with Reports Server
6.9
Configuring Proxy Information
6.10
Managing and Monitoring a Reports High Availability (HA) Solution
6.10.1
Configuring Reports Server for High Availability
6.10.2
Displaying a Consolidated Job Queue
6.10.3
Specifying a Shared Cache Directory
6.11
About the Oracle Fusion Middleware System MBean Browser
6.11.1
When should I use the Oracle Fusion Middleware System MBean Browser?
6.11.2
About Reports Configuration MBeans
6.12
Modifying Reports Configuration Settings Using the System MBean Browser
6.13
Diagnosing Issues
6.13.1
Specifying Logging Information
6.13.2
Diagnosing Font Issues
7
Configuring Oracle Reports Services
7.1
Oracle Reports Services Configuration Files
7.1.1
Centralized Reports System Component Configuration
7.1.2
Decentralized Reports Application Configuration
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
urlEngineAccess
7.2.1.33
jobThresholds
7.2.1.34
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
Editing the Server Configuration File
7.8
Configuring Reports Server with the Node Manager Reports Process Management
7.8.1
Starting and Stopping Components
7.8.1.1
FMW Script
7.8.1.2
WLST Start / Stop
7.8.1.3
Files Associated with process control
7.8.1.4
Reports process management configuration file
7.8.2
Creating a New Reports Tools Component Type
7.8.3
Creating a New Reports Bridge Component Type
7.8.4
Creating a New Reports Server 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
7.13
Configuring Reports Managed Server
7.14
Enabling HTTPS for Oracle Reports
8
Test to Production
Part III Managing Runtime Behavior
9
Managing Fonts in Oracle Reports
9.1
Using Fonts
9.1.1
Fonts in Oracle Reports Builder
9.1.2
Fonts in Report Output
9.1.2.1
Font lookup
9.1.3
Fonts in the User Interface
9.2
Adding Fonts
9.2.1
Adding Fonts to Oracle Reports Builder
9.2.2
Adding Fonts for Report Output
9.2.2.1
Adding fonts on UNIX
9.2.2.2
Adding fonts on Windows
9.3
Font Configuration Files
9.3.1
File Searching
9.4
Font Aliasing
9.4.1
Specifying Aliasing Information
9.4.2
Font Aliasing Mechanism
9.4.3
Font Alias File Sections
9.4.4
Font Aliasing File Verification
9.5
Font Types
9.5.1
Character Sets
9.5.2
Unicode
9.5.3
Type1 Fonts
9.5.4
TrueType Fonts
9.5.5
TrueType Collection
9.5.6
Barcode Fonts
9.5.7
CID Fonts
9.6
Verifying Report Output on Different Platforms
9.7
Running a Unicode Report using TTF/TTC Fonts
9.8
Diagnosing Font Issues
9.8.1
Using the Command Line
9.8.2
Using Oracle Enterprise Manager
9.9
Troubleshooting Font Issues
10
Printing on UNIX with Oracle Reports
10.1
UNIX Printing Overview
10.1.1
General Printing Mechanism
10.1.2
Oracle Reports Printing Mechanism on UNIX and Windows
10.1.3
Printing Support
10.2
Setting Up a Printer on UNIX
10.2.1
Installing a Printer on UNIX
10.2.2
Verifying the Printer Setup for Oracle Reports
10.3
Configuring the Printing Environment
10.3.1
Editing uiprint.txt File
10.3.2
Environment Variables
10.3.3
Print Property Dialog Boxes
10.3.3.1
Page Setup dialog box
10.3.3.2
Print Job dialog box
10.4
Printer-Related Files
10.4.1
Overview of Files
10.4.2
PPD Files
10.4.2.1
Local Customization of PPD files
10.4.3
HPD Files
10.4.4
Font Metrics Files
10.4.4.1
AFM files
10.4.4.2
TFM files
10.4.5
uifont.ali
10.4.6
uiprint.txt
10.4.7
Editing the Printer-Related Files
10.4.7.1
Editing PPD files
10.4.7.2
Editing HPD files for PCL printing
10.5
Enhanced Printing on Linux Using CUPS
10.5.1
Setting Up a Single Server for Printing
10.6
Globalization Support
10.6.1
Multibyte Character Set Printing
10.6.2
Overview of IX and PASTA
10.7
Debugging Options
10.7.1
DEBUG_SLFIND
10.7.2
TK_DEBUG_POSTSCRIPT
10.8
Removing DISPLAY and Printer Dependencies on UNIX
10.8.1
ScreenPrinter
10.8.2
Advanced Imaging Support
10.9
Frequently Asked Questions
10.9.1
Common Printing Error Messages
10.9.2
PCL Printing Issues
10.9.3
PostScript Printing Issues
10.9.4
Font-Related Printing Issues
10.9.5
Printed Output Issues
11
Using PDF in Oracle Reports
11.1
What's New In This Release?
11.2
PDF Features Included in Oracle Reports
11.2.1
Compression
11.2.1.1
Setup
11.2.2
Font-Related Features
11.2.2.1
Font Aliasing
11.2.2.2
Font Subsetting
11.2.2.3
Font Embedding
11.2.2.4
Font Feature Summary
11.2.3
Precedence of Execution
11.2.4
Encryption, Password Protection, and Permissions Security
11.2.5
Accessibility
11.2.6
Taxonomy
11.2.7
Graph Support
11.3
Generating a Unicode PDF File
11.3.1
Font Subsetting
11.4
Generating a Bidirectional (BiDi) PDF File
11.4.1
Font Subsetting
11.5
Generating a Multibyte PDF File
11.5.1
Font Aliasing
11.5.2
Font Subsetting
11.6
Generating a Barcode PDF File
11.6.1
Font Embedding
11.6.2
Font Subsetting
12
Font Model and Cross-Platform Deployment
12.1
What's New In This Release?
12.2
Overview of the Font Model
12.2.1
Font Lookup
12.2.1.1
Font Lookup Algorithm
12.2.2
Configuring the New Font Model
12.2.3
Font Diagnosis and Tracing
12.3
Overview of Cross-Platform Issues
12.3.1
Font Availability On Different Platforms
12.3.2
Fixing Font-Related Issues
12.4
Generating HTMLCSS, RTF, or Web Output
12.4.1
Designing Your Report
12.4.2
Deploying Your Report
12.4.2.1
Troubleshooting Information
12.4.3
Frequently Asked Questions
12.5
Generating Single-Byte PDF Output
12.5.1
Designing Your Report
12.5.2
Deploying Your Report in Pre-11
g
Version That Uses Motif Tool Kit Mechanism
12.5.2.1
Troubleshooting Information
12.5.3
Frequently Asked Questions
12.6
Generating Multibyte PDF Output
12.6.1
Designing Your Reportin Pre-11
g
Version That Uses Motif Tool Kit Mechanism
12.6.2
Deploying Your Report in Pre-11
g
Version That Uses Motif Tool Kit Mechanism
12.6.2.1
Troubleshooting Information
12.6.3
Frequently Asked Questions
12.7
Generating Unicode PDF Output
12.7.1
Designing Your Report in Pre-11
g
Version That Uses Motif Tool Kit Mechanism
12.7.2
Deploying Your Report in Pre-11
g
Version That Uses Motif Tool Kit Mechanism
12.7.2.1
Troubleshooting Information
12.7.3
Frequently Asked Questions
12.8
Generating PostScript Output
12.8.1
Designing Your Report
12.8.2
Deploying Your Report
12.8.3
Frequently Asked Questions
13
Configuring Destinations for Oracle Reports Services
13.1
What's New in this Release
13.1.1
Pluggable Destinations from Oracle Forms Services.
13.2
Overview of Output Processing
13.3
Registering Destination Types with the Server
13.3.1
Setting Up a Destination Section in the Server Configuration File
13.3.2
Entering Valid Values for a Destination
13.3.2.1
Destination destypes and classes
13.3.2.2
Destination Property name/value Pairs
13.3.3
Example Destination
13.4
Submitting Reports to Pluggable Destinations from Oracle Forms Services
14
Configuring and Using the Pluggable Data sources
14.1
Configuring and Using the JDBC PDS
14.1.1
JDBC Configuration File
14.1.1.1
Verifying Pre-installed Driver Entries
14.1.1.2
Installing and Configuring Merant DataDirect Drivers
14.1.2
Defining and Running a JDBC Query
14.1.2.1
Sample Connection Information
14.1.3
Running a JDBC Report Using Oracle Reports Services
14.1.4
TroubleShooting Information
14.1.4.1
Error Messages
14.1.4.2
Trace Information
14.1.5
Adding Your Own JDBC Driver
14.1.5.1
Configuring the jdbcpds.conf File
14.1.5.2
Installing the Driver's JAR Files
14.2
Configuring and Using Text PDS
14.2.1
Text Configuration File
14.3
Configuring and Using XML PDS
14.3.1
XML PDS Configuration File
14.4
Specifying the encoding of an XML PDS Report
15
Securing Oracle Reports Services
15.1
Introduction to Oracle Reports Security
15.1.1
Overview
15.1.2
What's New in This Release?
15.1.3
Resources Protected
15.1.3.1
Application Security
15.1.3.2
Resource Security
15.1.3.3
Data Source Security
15.1.4
Credential Store
15.1.4.1
Credential Types
15.2
Out-of-the-Box Behavior
15.3
Authentication in Oracle Reports
15.3.1
Single Sign-On Authentication
15.3.1.1
Authentication Flow with Oracle Access Manager (OAM) 11g
15.3.2
Non-SSO Authentication
15.3.2.1
Report Request Flow with Non-SSO (Oracle Internet Directory-Based, File-Based, or Embedded ID Store)
15.3.3
Authentication Scenarios for JPS-Based Security
15.3.3.1
If Reports is using JPS security, JPS-OID for security policies, and an embedded ID store
15.3.3.2
If Reports is using JPS security and JPS-OID as ID store
15.3.4
Authentication Scenario for Portal-Based Security
15.4
Authorization in Oracle Reports
15.4.1
Authorization Process
15.4.2
Additional Step When Using JPS for Authorization
15.4.3
Defining Security Policies for Reports
15.4.3.1
Defining Security Policies for JPS-Based Security
15.4.3.2
Defining Security Policies for Portal-Based Security
15.4.4
Defining Security Policies for Directories for JPS-Based Security
15.4.5
Defining Security Policies for Web Commands for JPS-Based Security
15.4.6
Defining Read/Write Access to Directories
15.4.7
Searching Application Policies in Enterprise Manager
15.4.8
Searching Application Roles in Enterprise Manager
15.5
End-to-End Security Scenarios
15.6
Recommended Production Scenario for JPS-Based Security
15.7
Recommended Production Scenario for Portal-Based Security
15.8
Managing Users and Security Policies
15.8.1
Adding Users to WebLogic Embedded ID Store for In-Process Servers
15.8.2
Adding Policies to Policy Store for In-Process Servers
15.8.3
Mapping Users to Application Roles
15.8.4
Adding Users to system-jazn-data.xml for Standalone Servers
15.8.5
Adding Policies to Policy Store for Standalone Servers
15.9
Configuring External Oracle Internet Directory and Reassociating Reports
15.9.1
Configuring External Oracle Internet Directory for In-Process Servers
15.9.1.1
Configuring External Oracle Internet Directory as ID Store When Using JPS-Based Security
15.9.1.2
Configuring an External Oracle Internet Directory as Policy Store When Using JPS-Based Security
15.9.2
Reassociating Reports with Oracle Internet Directory
15.9.3
Reassociating Oracle Reports to Oracle Portal
15.9.4
Configuring External Oracle Internet Directory for Standalone Servers
15.9.4.1
Configuring External Oracle Internet Directory as ID Store
15.9.4.2
Configuring External Oracle Internet Directory as Policy Store
15.10
Forms and Reports Security Recommendations
15.11
Intermediate-level Security for Forms and Reports
15.12
Database Proxy Authentication
15.12.1
Using DAS and Editing the Server Configuration File
15.12.2
Configuring Proxy User Authentication in the Database
15.12.3
Obtaining Proxy Access Information
15.12.4
Configuration Settings in Reports Configuration Files
15.12.4.1
rwserver.conf
15.12.4.2
rwservlet.properties
15.13
Oracle Portal-Based Security for Backward Compatibility
15.13.1
Security Features Provided by Oracle Portal
15.14
Security Interfaces
16
Deploying Reports in Oracle Portal
16.1
Creating Reports Users and Named Groups
16.1.1
Default Reports-Related Groups
16.1.1.1
RW_BASIC_USER
16.1.1.2
RW_POWER_USER
16.1.1.3
RW_DEVELOPER
16.1.1.4
RW_ADMINISTRATOR
16.1.2
Creating Users and Groups
16.1.3
Portal Password in Credential Store
16.2
Registering Oracle Reports Components
16.2.1
Registering a Reports Server
16.2.2
Registering a Report
16.2.3
Registering a Printer
16.2.4
Creating an Availability Calendar
16.2.4.1
Creating a Simple Availability Calendar
16.2.4.2
Creating a Combined Availability Calendar
16.2.5
The Manage Portlet
16.3
Publishing Your Report as a Portlet
16.3.1
Creating a Provider for Your Reports
16.3.2
Adding the Report Portlet to a Page
16.3.3
Adding the Report as an Item Link to a Page
16.3.4
Running Reports on Oracle Portal as an Item Link on a Nondefault Installation
16.3.5
Distributing Report Output to Oracle Portal
16.4
Connecting to Oracle Portal
16.5
Troubleshooting Information
16.5.1
Resolving Reports-Portal Integration Error When Attempting Create Resource
17
Configuring and Administering Oracle Single Sign-On
17.1
Prerequisites
17.2
Configuring Single Sign-On
17.2.1
Single Sign-On Components used by Oracle Reports
17.3
Administering Single Sign-On
17.3.1
Enabling and Disabling Single Sign-On
17.3.2
Enabling and Disabling Reports Server Security
17.3.3
Enabling and Disabling Data Source Security
17.3.3.1
SSOCONN
17.3.3.2
Populating Oracle Internet Directory
17.3.4
Connecting to Oracle Internet Directory
17.3.4.1
Choosing the Connecting Entity for Oracle Internet Directory
17.3.4.2
Choosing the Oracle Internet Directory Instance
17.4
Choosing the Connecting Entity for Oracle Internet Directory
17.5
Postinstallation Configuration
17.5.1
Installing and Configuring Webgate with OAM
17.5.1.1
Webgate
17.5.1.2
Webgate Configuration
17.5.1.3
Registering an OAM Agent Using the Console
17.6
Oracle Forms Services Security Considerations
Part IV Sending Requests to the Server
18
Running Report Requests
18.1
The Reports URL Syntax
18.1.1
Oracle Reports Servlet
18.1.2
JSP
18.2
Report Request Methods
18.3
Reports OHS Integration
18.4
Deploying Your Reports
18.4.1
Deploying a Report with a Paper Layout
18.4.2
Running a Report with a Paper Layout
18.4.3
Deploying a JSP Report to the Web and to Paper
18.4.3.1
Creating a New Java EE Application
18.4.3.2
Deploying Java EE Application Using WebLogic Server
18.4.4
Running a JSP-Based Web Report from a Browser
18.4.5
Running a JSP report with a Paper Layout
18.4.6
Running with the WE8MSWIN1252 Character Set on UNIX
18.5
Publishing a Report in Oracle Portal
18.6
Specifying a Report Request from a Web Browser
18.7
Sending a Request to the URL Engine
18.8
Running Reports Through a Web Service
18.9
Calling Oracle Reports from Oracle Forms Services
18.9.1
Communication Between Reports and Forms Installed on Different Instances
18.9.2
Generating Random and Non-Sequential Job IDs
18.10
Running Reports Using Oracle BPEL Process Manager
18.11
Scheduling Reports to Run Automatically
18.12
Additional Parameters
18.13
Reusing Report Output from Cache
18.13.1
Usage Note
18.14
Using a Key Map File
18.14.1
Understanding Key Mapping
18.14.2
Enabling Key Mapping
18.14.3
Adding Key Mapping Entries to a Key Map File
18.14.4
Using a Key with Non-JSP Reports
18.14.5
Using a Key with a Report Run as a JSP
19
Using the Oracle Reports Web Service
19.1
Overview
19.2
Getting Started
19.2.1
Invoking the RWWebService Servlet
19.2.2
Viewing the WSDL
19.3
Oracle Reports Web Service Operations
19.3.1
Using Oracle Enterprise Manager to Test RWWebService
19.3.1.1
getAPIVersion
19.3.1.2
getServerInfo
19.3.1.3
getJobInfo
19.3.1.4
killJob
19.3.1.5
runJob
19.4
Using RWWebServiceUtil to Test RWWebService
20
Creating Advanced Distributions
20.1
Distribution Overview
20.2
What's New In This Release?
20.3
Introduction to Distribution XML Files
20.3.1
The distribution.dtd File
20.3.2
Using Variables Within Attributes
20.4
Elements of a Distribution XML File
20.4.1
destinations
20.4.2
foreach
20.4.3
mail
20.4.4
body
20.4.5
attach
20.4.6
include
20.4.7
file
20.4.8
printer
20.4.9
destype
20.4.10
property
20.5
Distribution XML File Examples
20.5.1
foreach Examples
20.5.1.1
Single E-Mail with Report Groups as Separate Attachments
20.5.1.2
Separate E-Mail for Each Group Instance
20.5.1.3
Separate E-Mails with Separate Sections as Attachments
20.5.1.4
Separate File for Each Section
20.5.1.5
Separate Print Run for Each Report
20.5.2
mail Examples
20.5.2.1
E-Mail with a Whole Report as the Body
20.5.2.2
E-Mail with a Section of a Report as the Body
20.5.2.3
E-Mail with Two Report Sections as the Body
20.5.2.4
E-Mail with External File as Body and Report as Attachment
20.5.2.5
E-Mail with Whole Report and Grouped Sections Attached
20.5.2.6
E-Mail to Relevant Manager and Department
20.5.3
file Examples
20.5.3.1
File for Whole Report
20.5.3.2
File for Combined Report Sections
20.5.3.3
File for Each Group of Combined Sections
20.5.3.4
File for Each Report Group Instance
20.5.4
printer Examples
20.5.4.1
Print Whole Report
20.5.4.2
Print Two Sections of a Report
20.5.4.3
Print Grouped Report
20.5.4.4
Print Combined Sections for Each Group Instance
20.5.4.5
Print Relevant Instance of a Report to Its Relevant Printer
20.5.5
destype Examples
20.5.5.1
Oracle Portal Destination
20.5.5.2
FTP Destination
20.5.5.3
WebDAV Destination
20.5.5.4
Fax Destination
20.6
Using a Distribution XML File at Runtime
20.7
Limitations with Using Distribution
20.7.1
Delimited Output
20.7.2
Dynamic Format Values
21
Using Event-Driven Publishing
21.1
The Event-Driven Publishing API
21.1.1
Elements of the API
21.1.2
Creating and Manipulating a Parameter List
21.1.2.1
Add_Parameter
21.1.2.2
Remove_Parameter
21.1.2.3
Clear_Parameter_List
21.1.3
Including non-ASCII Characters in Parameter Names and Values
21.1.4
Submitting a Job
21.1.5
Checking for Status
21.1.6
Using the Servers' Status Record
21.2
Debugging Applications that Use the Event-Driven Publishing API
21.3
Invoking a Report from a Database Event
21.4
Integrating with Oracle Advanced Queuing
21.4.1
Creating a Queue That Holds Messages of Type SRW_PARAMLIST
21.4.2
Creating the Enqueuing Procedure
21.4.3
Creating the Dequeuing Procedure
22
Customizing Reports with XML
22.1
Customization Overview
22.2
Creating XML Customizations
22.2.1
Required XML Tags
22.2.2
Changing Styles
22.2.3
Changing a Format Mask
22.2.4
Adding Formatting Exceptions
22.2.5
Adding Program Units and Hyperlinks
22.2.6
Adding a New Query and Using the Result in a New Header Section
22.2.7
Encoding the URL
22.3
Creating XML Data Models
22.3.1
Creating Multiple Data Sources
22.3.2
Linking Between Data Sources
22.3.3
Creating Group Hierarchies Within Each Data Source
22.3.4
Creating Cross-Product (Matrix) Groups
22.3.5
Creating Formulas, Summaries, and Placeholders at Any Level
22.3.6
Creating Parameters
22.4
Using XML Files at Runtime
22.4.1
Applying an XML Report Definition at Runtime
22.4.1.1
Applying One XML Report Definition
22.4.1.2
Applying Multiple XML Report Definitions
22.4.1.3
Applying an XML Report Definition in PL/SQL
22.4.2
Running an XML Report Definition by Itself
22.4.3
Performing Batch Modifications
22.5
Debugging XML Report Definitions
22.5.1
XML Parser Error Messages
22.5.2
rwbuilder
22.5.3
Writing XML to a File for Debugging
Part V Globalization Support and Bidirectional Support
23
Implementing Globalization and Bidirectional Support
23.1
Globalization Support Architecture
23.1.1
Language-Independent Functions
23.1.2
Language-Dependent Data
23.2
Globalization Support Environment Variables
23.2.1
NLS_LANG Environment Variable
23.2.1.1
Defining the NLS_LANG Environment Variable
23.2.1.2
Defining the Language and Territory
23.2.1.3
Defining the Character Set
23.2.2
DEVELOPER_NLS_LANG and USER_NLS_LANG Environment Variables
23.3
Specifying a Character Set in a JSP or XML File
23.4
Bidirectional Support
23.4.1
Enhanced BIDI Reshaping
23.5
Unicode
23.5.1
Unicode Support
23.5.2
Unicode Font Support
23.5.3
Enabling Unicode Support
23.6
Translating Applications
23.7
Troubleshooting Globalization Issues
Part VI Performance
24
Diagnosing and Tuning Oracle Reports
24.1
What's New In This Release?
24.2
Logging Enhancements
24.2.1
Diagnosing Engine Crashes
24.3
Performance Analysis Tools
24.3.1
Log Files
24.3.1.1
Viewing Log Files
24.3.1.2
Managing Log Files
24.3.1.3
Audit Log Files
24.3.2
About WLST
24.3.2.1
Using WLST Commands for System Components
24.3.2.2
Using WLST Commands for Java EE Components
24.3.3
Logging-Related WLST Commands
24.3.3.1
listLoggers
24.3.3.2
getLogLevel
24.3.3.3
setLogLevel
24.3.3.4
listLogHandlers
24.3.3.5
configureLogHandlers
24.3.3.6
listLogs
24.3.3.7
displayLogs
24.3.4
Audit Configuration WLST Commands
24.3.4.1
getAuditPolicy
24.3.4.2
setAuditPolicy
24.3.4.3
listAuditEvents
24.3.5
Tracing Report Execution
24.3.6
RW_SERVER_JOB_QUEUE Table
24.3.6.1
Updating the Database with Queue Activity
24.3.7
SHOWJOBS Command Line Keyword
24.3.8
Efficient SQL
24.3.9
PL/SQL
24.3.10
Java Stored Procedures
24.3.11
The Java Importer
24.4
Tuning Reports Server Configuration
24.5
Accessing the Data
24.5.1
Non-SQL Data Sources
24.5.2
Database Indexes
24.5.3
Calculations
24.5.4
Redundant Data
24.5.5
Break Groups
24.5.6
Group Filters
24.5.7
To Link or Not To Link
24.6
Formatting the Data
24.6.1
Paper Layout
24.6.1.1
Format Triggers
24.6.1.2
Image Outputs
24.6.2
Web Layout and JSP Report Definition
24.7
General Layout Guidelines
24.7.1
Fetching Ahead
24.7.2
Bursting and Distribution
24.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
Overview of Oracle Reports Components
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 (ACCESSIBLE to DESTYPE)
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 (DISTRIBUTE to ORIENTATION)
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 (OUTPUTFOLDER to ROLE)
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.7.35
ROLE
A.8
Command Line Keywords (RUNDEBUG to WEBSERVER_PORT)
A.8.1
RUNDEBUG
A.8.2
SAVE_RDF
A.8.3
SCHEDULE
A.8.4
SERVER
A.8.5
SHOWAUTH
A.8.6
SHOWENV
A.8.7
SHOWJOBID
A.8.8
SHOWJOBS
A.8.9
SHOWMAP
A.8.10
SHOWMYJOBS
A.8.11
SHUTDOWN
A.8.12
SITENAME
A.8.13
SOURCE
A.8.14
SQLTRACE
A.8.15
SSOCONN
A.8.16
STATUSFOLDER
A.8.17
STATUSFORMAT
A.8.18
STATUSPAGE
A.8.19
STYPE
A.8.20
SUBJECT
A.8.21
SUPPRESSLAYOUT
A.8.22
TOLERANCE
A.8.23
URLPARAMETER
A.8.24
USEJVM
A.8.25
USERID
A.8.26
USERSTYLES
A.8.27
VALIDATETAG
A.8.28
WEBSERVER_DEBUG
A.8.29
WEBSERVER_DOCROOT
A.8.30
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_PATH
B.1.22
ORACLE_PPD
B.1.23
ORACLE_TFM
B.1.24
ORAINFONAV_DOCPATH
B.1.25
PRINTER
B.1.26
REMOTE
B.1.27
REPORTS_ADD_HWMARGIN
B.1.28
REPORTS_ARABIC_NUMERAL
B.1.29
REPORTS_ALLOW_DB_CONNECT_STRING
B.1.30
REPORTS_BIDI_ALGORITHM
B.1.31
REPORTS_CGIDIAGBODYTAGS
B.1.32
REPORTS_CGIDIAGHEADTAGS
B.1.33
REPORTS_CGIHELP
B.1.34
REPORTS_CGIMAP
B.1.35
REPORTS_CGINODIAG
B.1.36
REPORTS_CLASSPATH
B.1.37
REPORTS_CLIPBOARD_SIZE
B.1.38
REPORTS_CONTAINSHTMLTAGS
B.1.39
REPORTS_COOKIE_EXPIRE
B.1.40
REPORTS_CUPS_PRINTING
B.1.41
REPORTS_DB_AUTH
B.1.42
REPORTS_DEFAULT_DISPLAY
B.1.43
REPORTS_DEFAULT_PIXEL_SIZE
B.1.44
REPORTS_ENABLE_RTF_SPACING
B.1.45
REPORTS_ENCRYPTION_KEY
B.1.46
REPORTS_ENHANCED_BIDIHANDLING
B.1.47
REPORTS_ENHANCED_FONTHANDLING
B.1.48
REPORTS_ENHANCED_SUBSET
B.1.49
REPORTS_FONT_DIRECTORY
B.1.50
REPORTS_GRAPH_IMAGE_DPI
B.1.51
REPORTS_IGNORE_IMAGE_TAG_RES
B.1.52
REPORTS_IGNORE_SET_ROLE_ERROR
B.1.53
REPORTS_JPEG_QUALITY_FACTOR
B.1.54
REPORTS_JVM_OPTIONS
B.1.55
REPORTS_NETWORK_CONFIG
B.1.56
REPORTS_NLS_XML_CHARSETS
B.1.57
REPORTS_NO_DUMMY_PRINTER
B.1.58
REPORTS_NO_HTML_SPACE_REPLACE
B.1.59
REPORTS_OUTPUTIMAGEFORMAT
B.1.60
REPORTS_PATH
B.1.61
REPORTS_RESTRICT_DIRECTORIES
B.1.62
REPORTS_RESOURCE
B.1.63
REPORTS_SERVER
B.1.64
REPORTS_SOLARIS_9
B.1.65
REPORTS_SPACE_BREAK
B.1.66
REPORTS_SRWRUN_TO_SERVER
B.1.67
REPORTS_SSLPORT
B.1.68
REPORTS_STDIN_PASSWORD
B.1.69
REPORTS_SYS_AUTH
B.1.70
REPORTS_TAGLIB_URI
B.1.71
REPORTS_TMP
B.1.72
REPORTS_USEREXITS
B.1.73
REPORTS_UTF8_XMLOUTPUT
B.1.74
RW
B.1.75
TK_PRINT
B.1.76
TK_PRINT_STATUS
B.1.77
TK_PRINTER
B.1.78
TK_AFM
B.1.79
TK_HPD
B.1.80
TK_PPD
B.1.81
TK_TFM
B.1.82
TNS_ADMIN
B.1.83
USERNAME
B.1.84
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.1.11
Runtime execution of Reports shifts down a record in the placeholder coulmn values
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
Index
Scripting on this page enhances content navigation, but does not change the content in any way.