Skip Headers

Oracle® Business Intelligence Discoverer Configuration Guide
10g Release 2 (10.1.2.0.0)
Part No. B13918-02
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents

Previous
Previous
 

Index

A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  R  S  T  U  V  W 

Numerics

500 Internal Server Error - troubleshooting, D.1.19

A

accessibility
about, Preface
framedisplaystyle preference configuration, 13.8
JAWS, 13.8
Apache
timeout, A.1
Application Server Control, 5.1
how to display the Discoverer home page, 5.1.2
how to start, 5.1.2
using to manage Discoverer components, 5.1.2
why use with Discoverer, 5.1.1
applypreferences.bat, A.1
applypreferences.sh, A.1
architecture
of Discoverer, 1.6
of Discoverer Catalog, 6.1.4
ASO encryption certification, 14.2

B

BI Beans Catalog, 6.1.5
administer, 5.1.1
block size
Discoverer Catalog, 6.2.2.1
browser
requirements, 3.2
supported by Discoverer, 3.2

C

caching
creating a rule for Discoverer, 8.5.1
in Discoverer Portlet Provider, A.2
Catalog
Discoverer, 6.1
OLAP, 6.1.2
CellPadding preference, 10.7
certdb.txt, A.1
certification
Oracle Applications, D.1.2
character limits
browser limits, 13.2
checkconfiguration utility, 6.6
checkdiscoverer utility, A.1, A.1, D.3.1, D.3.2
collectlogs.bat, A.1, D.3.1, D.3.9
collectlogs.sh, A.1, D.3.1, D.3.9
column spacing in reports, 10.7
communication protocols, 5.1.1, 5.1.1, 5.1.1
about HTTP, 14.6.3, 14.6.3.2
about HTTPS, 14.6.3.2, 14.9.3
about JRMP, 14.6.3, 14.6.3.2
configuration files
applypreferences.bat, A.1
applypreferences.sh, A.1
certdb.txt, A.1
checkdiscoverer.bat, A.1
checkdiscoverer.sh, A.1
collectlogs.bat, A.1
collectlogs.sh, A.1
configuration.xml, A.1, A.2
defaults.txt, A.1
dis51pr, A.1
discwb.sh, A.1
error.txt, A.1, A.1
migrateprefs.bat, A.1
migrateprefs.sh, A.1
mod_osso.conf, A.1
opmnctl, A.1
opmn.xml, A.1, A.3
pref.txt, A.1, A.1
reg_key.dc, A.1
tnsnames.ora, A.1, A.1
web.xml, A.1
configuration utility
Discoverer Plus OLAP, 6.6
configuration.xml
settings, A.2
summary, A.1
connections, 3.7, 3.11
about, 4.1, 4.3
about private connections, 4.2.1
about public connections, 4.2.2
connections page, 4.4
creating a public connection, 4.6, 4.7
enabling private, 4.8
how to find out a connection ID, 13.4.3
managing with Oracle Application Server Control, 4.3
migrating, 4.3
private, 3.7, 3.11
private for OLAP data, 6.3.8
public, 5.1.1
types, 4.2
connections ID
how to find out, 13.4.3
CORBA components
Preferences, 1.8.2, 1.8.2.2
Session, 1.8.2
currency
Euro countries, 10.7
customizing
Discoverer Plus, 9.1, 9.1.1
Discoverer Viewer, 9.2
customizing Discoverer Viewer
about, 9.2.1
layout, 9.2.3
look and feel, 9.2.2

D

D4OSYS user
database privileges, 6.2.1
privileges, 6.3.4
dashboard application, 11.1
Database Connection file, 15.1
database privileges
D4OSYS, 6.2.1
database security
about, 14.2
ASO encryption certification, 14.2
DBC files, 15.1
dc* file, A.3
defaults.txt, A.1
demilitarized zones (DMZs)
about, 14.9.2
diagnosing problems, D.3.1
checkdiscoverer utility, D.3.2
dis51pr, A.1
Discoverer
about, 1.1
and Oracle Application Server, 2.1
and Oracle Applications, 15
and OracleAS Portal, 11.1
architecture, 1.6
CORBA components, 1.8.2
J2EE components, 1.8.1
over SSL/HTTPS, 3.5, 14.6
Plus servlet, 1.8.1.2
port numbers, 5.8
Portlet Provider servlet, 1.8.1.3
process, 1.10
security, 3.3, 4.8
servlet, 1.8.1.1
URL parameters, 13.1
Viewer, 1.1
Discoverer Administrator
about, 6
Discoverer Catalog, 6.1
about, 6.1.1
administer, 6.1
architecture, 6.1.4
authorize access, 6.3.6
authorized users and roles, 6.3
block size, 6.2.2.1
D4OSYS user, 6.2.1
defined, 6.1.1
deinstallation, 6.2.3
export, 6.2.4
folder structure, 6.3.1, 6.3.1
import, 6.2.5
installation, 6.2.2
maintain users and roles, 6.3
object properties, 6.1.3
privileges, 6.3.3
privileges for objects and folders, 6.3.3
revoke access, 6.3.7
Discoverer connections
about, 4.1
and Oracle Applications, 15.1
Oracle e-Business Suite, 14.4, 15.1
Discoverer Java applet, 1.7.1
Discoverer logins
managing with Oracle Application Server Control, 4.3
Discoverer Plus, 3.6
about, 1.1
accessing over dial-up, 3.6
client machine requirements, 1.7.1
configuration, 5.1.1
look and feel, 9.1, 9.1.1
operating system rights, 3.4
process, 1.10.1
removing applet, 3
running, 3.6
running on Internet Explorer, 3.8
running on MS Internet Explorer, 3.6
running on Netscape, 3.6
running on Netscape Navigator, 3.9
security settings, 3.6
session timeout, 3.6
upgrading the applet, 1.7.1
URL arguments, 13.8
Discoverer Plus OLAP
configuration diagnostic utility, 6.6
customizing, 6.4
ensuring access, 6.3.5
information for end users, 6.5
starting with URL parameters, 13.5.6
URL parameters, 6.7
Discoverer Portlet Provider, 12.3.12, A.2
security example, 14.7.2.3
test URL, 11.2
testing, 11.2
troubleshooting, D.1.19
Discoverer preferences
migrating, 10.4
Discoverer Preferences component
specifying the machine that is going to run it, 7.6
Discoverer security
communication protocols, 14.6.3.2
configuring with HTTPS, 14.6.3.6
connections, 14.5.1
database, 14.2
default, 14.6.3.2
Discoverer Services Configuration page, 14.6.3.3
JRMP,HTTP,HTTPS, 14.6
non-Single Sign-On, 14.7.3
OracleAS Portal, 14.7.2.3
secure tunneling, 14.6.3.2
tunneling, 14.6.3.2
Discoverer Services components
about, 1.8
preferences
Preferences Component, 1.8.2.2
Session component, 1.8.2.1
Discoverer Services Configuration page
starting OEM, 14.6.3.3
Discoverer Viewer
about, 1.1
client machine requirements, 1.7.2
customization, 5.1.1
Email option, D.1.10
graph display problem, D.1.20
JavaScript, 1.7.2
look and feel, 9.2
process, 1.10.2
running, 3.11
security, 14.6.2
troubleshooting, D.1.1
discwb.sh, A.1
DMZs, 14.9.2

E

e-Business Suite login, 14.4, 15.1
Email option in Discoverer Viewer, D.1.10
encryption
how to configure Discoverer to use encryption in an intranet, 14.9.7
how to configure Discoverer to use encryption through firewalls, 14.9.8
how to verify that Discoverer is encrypting communications, 14.9.9
Enterprise Manager
changing database passwords, 5.1.1, 5.1.1, 5.1.1
creating public connections, 5.1.1
enabling graphs in Viewer/Portal, 5.1.1
Oracle Enterprise Manager, 5.1.1
query progress delay, 5.1.1, 5.1.1, 5.1.1
setting locale, 5.1.1
stylesheet pooling, 5.1.1, 5.1.1
using, 5.1.1
error diagnosis, D.1
error message - Could not resolve service name?, D.1.4
error message ORA-12154, D.1.4
error ORA-01450, 6.2.2.1
Euro currency, 10.7
EuroCountries preference, 10.7
export
temporary file, A.3
export Discoverer Catalog, 6.2.4
export errors
troubleshooting, D.1.1
export types
Web Query, 10.7
exporting data
displaying repeating values, 10.7
minimum required Excel version, D.1.1
NULL values, 10.7

F

firewalls
about, 14.9.1
how to configure Discoverer for both intranet users and users accessing Discoverer through a firewall, 14.9.10
how to configure Discoverer to use encryption through firewalls, 14.9.8
how to configure Discoverer to work through a firewall, 14.9.5, 14.9.6
policies, 14.9.2
FND_SECURE, A.3
FND_TOP, A.3
folder structure of Discoverer Catalog, 6.3.1
framedisplaystyle preference
and JAWS, 13.8
frequently asked questions
about security, 14.9

G

graphing
troubleshooting, D.1.20

H

HTTP, 14.6
about, 14.6.3, 14.6.3.2
HTTPS, 14.6
about, 14.6.3.2, 14.9.3
enabling, 3.5, 14.6
running Discoverer, 3.5
troubleshooting, D.1.7

I

import Discoverer Catalog, 6.2.5
index values
troubleshooting, D.1.16
Internet Explorer
running Discoverer, 3.8
intranet
configure Discoverer for both intranet users and users accessing Discoverer through a firewall, 14.9.10
how to configure Discoverer to work in an intranet, 14.9.4
IQY format, 5.10

J

J2EE components
about, 1.8.1
Java Plug-in
pop-up, 3
Java Plug-in 1.3, 3.10
Java runtime environment, 3
Oracle JInitiator, 3
Sun Java Plug-in, 3
Java Virtual Machine, 5.9
overriding, 5.9
Javascript
Discoverer Viewer requirements, 1.7.2
JAWS
framedisplaystyle preference, 13.8
maximising for, 13.8
JInitiator
version 1.3, 5.9
JRMP, 14.6
about, 14.6.3, 14.6.3.2

L

LAFs
Plastic, 9.1.1
layout
customizing, 9.2.3
load balancing
how to turn on OracleAS Web Cache, 8.5.2
log files, D.3.1, D.3.9
collecting, D.3.1, D.3.9
enabling Discoverer Service logs, D.3.5
enabling Discoverer Servlet logs, D.3.6
OPMN, A.3
ORB debug file, A.3
server diagnostics available, D.3.1
using OracleAS View Logs, D.3.3
viewing Discoverer Services logs, D.3.7
viewing Discoverer Servlet logs, D.3.8
look and feel, 9.1.3, 9.1.4
changing, 9.1.3
creating a custom LAF, 9.1.4
customizing, 9.1, 9.2, 9.2.2
types, 9.1.1

M

maxDataRows
Discoverer Portlet Provider caching, A.2
maxprocs
and portlet/Sessionpool/maxSessions, A.3
maxSessions
setting, A.2, A.3
memory requirements of Discoverer, 3.4
Metalink URL, D.4
Microsoft Excel
minimum supported version for export, D.1.1
minimum supported version for Web Query format, 5.10
migrateprefs.bat, A.1
migrateprefs.sh, A.1
migrating preferences, B.2.1
minimum security settings, 3.6
mod_osso.conf, 11.1, 14.7.2.1, A.1
OssoIPCheck, 11.1
multiple machine installation
about configuring Discoverer, 7.3

N

NAT (Network Address Translation), deploy Discoverer using a standard NAT, 14.9.11
Netscape Navigator, 3.6
running Discoverer, 3.9
Netscape Navigator for UNIX, 3.10
Netscape V4.x
troubleshooting, D.1.6
network exception
troubleshooting, D.1.3
NULL values in exported data, 10.7

O

OLAP
starting Discoverer Plus OLAP, 13.5.6
OLAP Catalog, 6.1.2
about, 6.1.2
OPMN
list of configuration settings in opmn.xml, A.3
opmnctl script, A.1
ORBDebug, A.3
ORBDebugLevel, A.3
ORBLogFile, A.3
settings, A.3
opmn.xml, A.1, A.3
ORA-01450 error message, 6.2.2.1
ORA-12154 error message, D.1.4
Oracle Application Server
and OracleBI Discoverer, 2.1
Oracle Application Server Control
URL, 5.1.2
Oracle Applications, 15.1
and OracleBI Discoverer, 15
AppsFNDNAM, 15.2
AppsGWYUID, 15.2
certification, D.1.2
configuration settings, 15.2
DBC files, 15.1
FND_SECURE, A.3
FND_TOP, A.3
using Discoverer with, 15.1
Oracle e-Business Suite login, 14.4, 15.1
Oracle Enterprise Manager
enabling private connections, 4.8
Oracle Enterprise Manager Application Server Control
about, 5.1
Oracle Jar Cache, 3.4
Oracle Portal
test URL for Discoverer Portlet Provider, 11.2
OracleAS Framework Security
and Discoverer, 14.6
OracleAS Portal
about, 11.1
security example, 14.7.2.3
OracleAS Web Cache
about, 8.1
benefits, 8.2, 8.2
creating a caching rule, 8.5.1
how does it work?, 8.3
how it works, 8.3
using Viewer with, 8.4, 8.5
OracleBI Discoverer
about Discoverer Plus, 1.1
about Discoverer Viewer, 1.1
about Portlet Provider, 11.1
OracleBI standalone CD, 2.1
OssoIPCheck, 11.1
out of memory issues
troubleshooting, D.1.8

P

parameter values
troubleshooting, D.1.16
password
hiding passwords in URL, 13.5.4
prompting for with URL parameters, 13.5.5
performance, 12.3.12
about Discoverer and performance, 12.1
Discoverer Portlet Provider, 12.3.12
how to improve Discoverer's performance, 12.3
by basing lists of values on tables containing distinct values, 12.3.8
by changing cache settings, 12.3.9
by increasing the size of the array used to fetch rows from the database, 12.3.7
by reducing the time taken to display business areas and folders, 12.3.2
by scheduling worksheets to run overnight, 12.3.10
by setting the Case Storage item property appropriately, 12.3.6
by using Discoverer Administrator hints, 12.3.5
by using OracleAS Web Cache, 12.3.11
by using summary folders, 12.3.3
reducing the size of reports, 10.7, 10.7
Plastic look and feel, 9.1.1
pop-up stoppers
troubleshooting, D.1.5
port number
Oracle Application Server Control, 5.1.2
port numbers for Discoverer, 5.8
portals, 11.1
ports, 5.8
Preference server
configuring, A.3
preferences
about Discoverer preferences?, 10.1
about Discoverer system preferences, 10.2
about Discoverer user preferences, 10.3
EnableWebQueryRun, 10.7
ExportToWebQuery, 10.7
how to set for specific users, 10.6
how to set user preferences for all users, 10.5
list of Discoverer user preferences, 10.7
migrateprefs script, B.2.1
migrating, 10.4
migration, B.2.1
upgrading Discoverer, 10.4
WebQueryBaseURL, 10.7
Preferences Component
in Discoverer Services tier, 1.8.2.2
pref.txt, A.1, A.1
prerequisites
for running Plus and Viewer, Preface
PrintHeadersOnce preference, 10.7
printing
reducing the size of reports, 10.7, 10.7
printing large worksheet titles, 10.7
private connections
about, 4.2.1
for OLAP data, 6.3.8
not allowed, 13.2.2, 13.7
URL parameters for, 13.2.2, 13.7
privileges
granted to PUBLIC, C.1
granted to the Discoverer manager, C.2
required for Discoverer, 3.4
public connections
about, 4.2.2
not allowed, 13.2.2, 13.7
URL parameters for, 13.2.2, 13.7

R

Redirect conflicts, D.1.17
reg_key.dc, A.1
reg_key.dc file, 10.3
reports
reducing the size of reports, 10.7, 10.7
RMI error
troubleshooting, D.1.7
running Discoverer Plus in IE, 3.8
running Discoverer Plus in Netscape, 3.9
running Discoverer Viewer, 3.11

S

scalable architecture of Discoverer
how to take advantage of
specifying OC4J memory usage parameters, 12.4.1
specifying the number of OC4J processes, 12.4.2
using the scalability features of OracleAS, 12.4
Secure Sockets Layer (SSL), 3.5
security
database level, 14.2
disabling Discoverer Plus, 3.3, 4.8
disabling private connections, 3.3, 4.8
Discoverer Plus, 14.6.3
Discoverer Viewer, 14.6.2
encryption, 14.9.7
FND_SECURE, A.3
FND_TOP, A.3
installing certificates, 3.5
network level, 14.6
non-standard signing authority, 14.6.3.1
private connections not allowed, 13.2.2, 13.7
protocols, 14.6.3, 14.6.3.2
running Discoverer, 3.3, 4.8
security settings for Discoverer Plus, 3.6
Session component of Discoverer Services, 1.8.2.1
session ID
in logs, D.3.1
session pooling, 5.1.1, 5.1.1, 5.1.1
session timeout, A.3
session timeout in Discoverer Plus, 10.7.2
session timeout in Discoverer Viewer, 10.7.3
session-timeout value, 10.7.2
signing authority, 14.6.3.1
Single Sign-On
about, 14.7.2, 14.7.2
and Discoverer, 14.7.2.1
how enable and disable, 14.7.2.1
how to enable and disable, 14.7.2.2
mod_osso.conf, 14.7.2.1
OracleAS Portal example, 14.7.2.3
why enable or disable, 8.5
SMTP Server for Discoverer Viewer, D.1.10
SSL
enabling, 3.5, 14.6
ssl_enabled setting in OPMN.XML, A.3
troubleshooting, D.1.17
SSO
troubleshooting, D.1.17
SSO details propagation, 14.8
Sun Java Plugin alerts, 3

T

TAO ORB
defaults, A.3
settings, A.3
temporary file
for exports, A.3
testing
Discoverer portlet provider, 11.2
tiered architecture of Discoverer
Client tier (Plus and Viewer), 1.7
Database tier (Plus and Viewer), 1.9
Discoverer Services tier (Plus and Viewer), 1.8
Timeout
about setting in Discoverer Viewer, 10.7.3
in Discoverer Plus, 10.7.2
in Discoverer Viewer, 10.7.2
preferences, 10.7.2, 10.7.2
session timeout, 3.6, 10.7
setting timeout values, 10.7.2
timeout
Apache, A.1
Web server, A.1
titles
printing large worksheet titles, 10.7
tnsnames.ora, A.1, A.1, A.1
about, 7.7
editing, 7.7, A.1
troubleshooting, D.1
Discoverer Plus Relational help, D.1.9
Discoverer Viewer Send as Email option, D.1.10
graph display in Discoverer Viewer, D.1.20
HTTPS, D.1.7
index value for parameters, D.1.16
MS Internet Explorer v6.0, D.1.1
Netscape V4.x, D.1.6
network errors, D.1.3
OC4J_BI_forms JVM, D.1.19
ORA-12154 error, D.1.4
Oracle Applications certification, D.1.2
out of memory error, D.1.8
parameter values, D.1.16
Plastic look and feel, 9.1.1
pop-up stoppers, D.1.5
redirect conflicts, D.1.17
RMI error, D.1.7

U

UNIX client browser, 3.10
UNIX Netscape Navigator, 3.10
upgrading
Discoverer preferences, 10.4
upgrading Java Plugin, 3
URL parameters
about, 13.1
Discoverer Plus OLAP, 6.7
example of starting Plus OLAP, 13.5.6
for Discoverer Plus OLAP, 6.7
prompting for a password, 13.5.5
specifying workbooks and worksheets, 13.4
syntax, 13.2
without prompting for a password, 13.5
URLs and Discoverer
character limits, 13.2
examples of using URL parameters, 13.5
generic Discoverer URL arguments, 13.7
hiding passwords, 13.5.4
URL arguments for Discoverer Plus, 13.8
URL arguments for Discoverer Viewer, 13.9
what is the URL parameter syntax for Discoverer, 13.2
why use URL parameters?, 13.1
Users Personal Profile Space, 3.4

V

Virtual Private Database, 14.8
VPD, 14.8

W

Web Cache
see OracleAS Web Cache
Web Query
about, 5.10
configuring Discoverer, 5.10
enabling export to, 10.7
file association, 5.10
format limitations, 5.10
minimum required Excel version, 5.10
response messages, 10.7
Web server
timeout, A.1
web.xml, 10.7.3, A.1
workbook ID
how to find out, 13.4.1, 13.4.1
worksheet ID
how to find out, 13.4.2
worksheet layout
padding cells, 10.7
printing large title, 10.7