Index

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

A

access

multiple-user access, about, 13.5

read-only mode, 13.5.2

read/write mode, 13.5.1

accessing

Metadata Loader, 12.9.1

adding

workspace user, 3.3, 4.3

adding role, 7.2.4

Administrator role, 13.6.2

application name, 7.2.7

architecture, 1.2

assigning

roles, 13.4.1

roles to users, 13.7.1

security roles, 13.6

system privileges, 13.4.3

audit connection pool, 7.2.9.1

audit data source

configuring, 7.2.3

audit table data source

configuring, 7.2.9.2

audit table logging, 7.2.9

C

cat_owb.sql, 3.2.1, 4.2.1

changing

Control Center Agent settings with JRTAdministratorMBean, 7.2.11.5

metadata, 11.2

passwords, 13.10.2

session timeout, 7.1.1

Check for Updates Wizard, 1.3

clean_owbsys.sql, 3.2.1, 4.2.1, 5.5

cleaning repository

clean_owbsys.sql, 3.2.2, 4.2.2

Linux, 4.2.2

Windows, 3.2.2

Cluster Topology, 7.2.4

Code Template, 7.2.1

code templates

installing, 7.2.12

components, 1.2

configuration architecture, 1

configuring

audit data source, 7.2.3

audit table data source, 7.2.9.2

Control Center Agent security roles, 7.2.4

Control Center Agent server-side logging, 7.2.2

Control Center Agent web service (jrt-web.war), 7.2.8

Control Center service

Linux, 4.2.4

reset_owbcc_home.sql, 3.2.4, 4.2.4

Windows, 3.2.4

on Linux, 4

on Windows, 3

OWB installed as a standalone

Linux, 4.2

Windows, 3.2.1

OWB installed with Oracle Database 11g Release 2

Linux, 4.1

Windows, 3.1

owblient.bat file for memory, A.3

OWBSYS audit connection pool, 7.2.9.1

repository browser environment, 7.1

connecting

database, errors connecting to, A.3

Design Repository, error, A.3

connection

testing, 7.2.9.1

connection pool type, 7.2.9.1

connection pools, 7.2.9.1

context root, 7.2.7

Control Center

enabled roles, A.3

Control Center Agent, 1.2

configuring server-side logging, 7.2.2

deploying to OC4J, 7.2.7

Control Center Agent audit table logging

enabling, 7.2.9

Control Center Agent files, 7.2.11

Control Center Agent runtime log file, 7.2.11.2

Control Center Agent security roles, 7.2.4

configuring, 7.2.4

Control Center Agent settings, 7.2.11.4

Control Center Agent settings with JRTAdministratorMBean

changing, 7.2.11.5

Control Center Agent topology, 1.2.5

Control Center Agent web service

configuring, 7.2.8

Control Center Service, 1.2

Control Center service

configuring

Linux, 4.2.4

Windows, 3.2.4

reset_owbcc_home.sql, 3.2.4, 4.2.4

stopping

Linux, 4.2.2

Windows, 3.2.2

creating

database user, 3.3, 4.3

database users, 13.3.2

JMS queue, 7.2.5

repository workspace

Linux, 3.3

Windows, 4.3

workspace, 3.3, 4.3

creating OWBSYS schema

cat_owb.sql, 3.2.3, 4.2.3

Linux, 4.2.3

Windows, 3.2.3

ct_permissions.properties, 7.2.1

D

data libraries

Name and Address, A.3

data source type, 7.2.9.2

Data Sources, 7.2.9.2

database roles, changing, 13.3.3

database user

creating, 3.3, 4.3

database users

creating in Warehouse Builder, 13.3.2

registering as Warehouse Builder users, 13.3

data-sources.xml, 7.2.3

default object privileges, 13.4.2

defining

security roles, 13.4.3

deleting

repository, 5.5

Repository users, 5.2

schema objects, 5.4, 5.4

workspace, 5.3

workspace owner, 5.3

workspace user, 5.2

deploying

Control Center Agent to OC4J, 7.2.7

deployment errors, A.2

deployment plan, 7.2.7

Design Control Center

enabled roles, A.3

Design Repository

connecting error, A.3

destination name, 7.2.5, 7.2.5

destination type, 7.2.5, 7.2.5

-Dlimit parameter

owbclient.bat file, memory threshold, A.3

dropping

workspace, 5.3

E

E-Business Suite, 7.3

editing user profiles, 13.4

enabling

access to EBS, 7.3

access to metadata, 7.3

Control Center Agent audit table logging, 7.2.9

encrypting passwords, 13.10.3

enforcing security, 13.9

Enterprise Manager, 5.4

error logs

interpreting error logs, A.2

ETL mappings, 1.2.5

execution

errors, A.2

exporting

metadata, for user grants, 12.4.2.2

metadata, for user-defined definitions, 12.4.2.2

metadata, in additional languages, 12.4.2.1

metadata, results, 12.8

metadata, using the Design Center, 12.1

snapshots, 11.2.3.5

F

FND_APPLICATION table, 7.3

FND_APPLICATION_VL table, 7.3

FND_COLUMNS table, 7.3

FND_FOREIGN_KEY_COLUMNS table, 7.3

FND_FOREIGN_KEYS table, 7.3

FND_PRIMARY_KEY_COLUMNS table, 7.3

FND_PRIMARY_KEYS table, 7.3

FND_SEQUENCES table, 7.3

FND_TABLES table, 7.3

FND_VIEWS table, 7.3

G

generation

errors, A.2

GLOBAL_DBNAME parameter

Net Service Name, A.3

H

host name, 5.2

port number, 3.3, 4.3

I

iIntegrating

E-Business Suite, 7.3

import language options, 12.2.3

importing

metadata, combining import modes and matching criteria, 12.2.2

metadata, for security grants, 12.4.4.2

metadata, for user-defined definitions, 12.4.4.2

metadata, in additional languages, 12.4.4.1

metadata, language options, 12.2.3

metadata, results, 12.8

metadata, using the Design Center, 12.2

metadata, validation rules, 12.2.4

snapshots, 11.2.3.5

init.ora file

MAX_ENABLED_ROLES parameter, A.3

install option, 7.5

installating Warehouse Builder

on RAC environment, 2.4

installation

errors, A.2

troubleshooting, A.1

installation architecture, 1

installation configuration

choosing, 1.1

Control Center Agent topology, 1.2.5

multiple database topology, 1.2.3

separate client and database server topology, 1.2.2

separate Client, Control Center Service, and Database Server topology, 1.2.4

single computer topology, 1.2.1

installing

code templates, 7.2.12

earlier database releases, 2.2

JDBC drivers for OC4J, 7.2.10

JServer option, Oracle Database, A.3

on Oracle Database 11g Release 2, 2.1

on server, 2

optional components, 7

Oracle Universal Installer, 2.3

Oracle Workflow, 7.5

Repository Browser, 7.1

standalone software, 2.2

third-party name and address data, 7.4, 7.4

Warehouse Builder, 2.4.1

installing Warehouse Builder

on RAC environment, 2.4

Instance Level Security, 7.2.4

instance level security, 7.2.4

integrating

third-party name and address data libraries, 7.4

J

j2ee-logging.xml, 7.2.2

Java Virtual Machine (JVM)

verifying and reinstalling JVM, A.5

jazn.com, 7.2.4, 7.2.4, 7.2.4

JDBC drivers for OC4J

installing, 7.2.10

JDBC Resources, 7.2.9.2

JDBC resources, 7.2.9.1

JDBC URL, 7.2.9.1

JMS destinations, 7.2.5

JMS queue

creating, 7.2.5

JNDI location, 7.2.5, 7.2.5, 7.2.9.2

JobID file, 7.2.11.3

JRT

owb_abortQueue, 7.2.5

owbQueue, 7.2.5

JRTAdministrator, 7.2.11.5

JRTAdministratorMBean, 7.2.11.5

jrt-internal-log-handler, 7.2.2

JRTWebService, 7.2.8, 7.2.8

jrt-web.war, 7.2.8

jrtws.war, 7.2.8

JServer option

Repository Assistant, for the, A.3

jython_lib.zip, 7.2.1

jython_owblib.jar, 7.2.1

K

km_security_needed, 7.2.1

L

language

select, 3.3, 4.3

LD_LIBRARY_PATH, 7.5

LDAP parameters, 7.5

Level Security, 7.2.4

licence agreement, 2.2

listener.ora file

GLOBAL_DBNAME parameter, A.3

LoadJava error

Repository Assistant, A.3

log files

Metadata Loader logs, 12.7

logging

audit table, 7.2.9

logs

interpreting error logs, A.2

M

mailer parameters, 7.5

managing

workspace, 3.3, 4.3

workspace user, 5.2

materialized views, insufficient table space, A.3

MAX_ENABLED_ROLES parameter, A.3

MaxPermSize, 7.2.1

MDL

see Metadata Loader

memory

errors during batch operation, A.3

metadata, 7.1

changing, 11.2

full security strategy, 13.2.3

import and export errors, A.2

minimal security strategy, 13.2.1

multiuser security strategy, 13.2.2

security, 13.1

upgrading, 12.3

Metadata Export Utility, 12.5.1

metadata import

required access privileges, 12.2

Metadata Import Utility, 12.5.2

Metadata Loader

about, 12.9

accessing, 12.9.1

log files, 12.7

multiple user access, 12.6

results, 12.8

utilities, 12.5

metadata objects

applying security properties, 13.8

metadata repository, 3.2.1, 4.2.1

metadata snapshots, 11.2

modes

read-only mode, 13.5.2

read/write mode, 13.5.1

modifying

OC4J startup script, 7.2.1

multiple database topology, 1.2.3

multiple user access with MDL, 12.6

multiple user ecurity strategy, 13.2.2

multiple-user access

about, 13.5

read-only mode, 13.5.2

read/write mode, 13.5.1

-mx parameter

owbclient.bat file, virtual memory, A.3

My Oracle Support, 2.3

N

Name and Address

regional libraries unavailable, A.3

Name and Address server

errors, A.2

names and addresses

installing third-party data, 7.4

Net Service Name

SERVICE_NAME parameter, A.3

O

object privileges, default, 13.4.2

objects

restoring from snapshots, 11.2.3.4

OC4J startup script

modifying, 7.2.1

oc4j_app_administrators, 7.2.4

oc4jadmin, 7.2.4

oc4j-administrators, 7.2.4

ODL job log files, 7.2.11.1

opmn.xml, 7.2.1

optional components

installing, 7

Oracle Database

JServer option, A.3

Oracle service name, 3.3, 4.3, 5.2

Oracle Workflow

installing, 7.5

ORACLE_HOME, 7.5

ORACLE_PORT, 7.5

ORACLE_SID, 7.5

OWB Browser, 1.2

OWB software

uninstalling, 5.6

OWB_INTERNAL_USERS, 7.2.4

OWB_J2EE_ADMINISTRATOR, 7.2.4, 7.2.4

OWB_J2EE_EXECUTOR, 7.2.4, 7.2.4

OWB_J2EE_OPERATOR, 7.2.4, 7.2.4

OWB_USER, 7.5

owbclient.bat file

-Dlimit memory threshold parameter, A.3

-mx virtual memory parameter, A.3

OWBSYS

creating, 3.2.3

definition, 2.1

unlocking, Linux, 4.1

unlocking, Windows, 3.1

OWBSYS account, 2.1

OWBSYS audit connection pool

enabling, 7.2.9.1

OWBSYS schema

creating

Linux, 4.2.3

Windows, 3.2.3

OWBSYS_AUDIT

definition, 2.1

unlocking, Linux, 4.1

unlocking, Windows, 3.1

owbsys_audit, 7.2.9.1

OWBSYS_AUDIT account, 2.1

P

passwords

changing, 13.10.2

encrypting, 13.10.3

in Warehouse Builder, 13.10

PATH environment variable, 7.2.6

performance

-Dlimit parameter, A.3

performing a stack trace, A.4

PermGen, 7.2.1

persistence, 7.2.5, 7.2.5

port number, 5.2

pre-installation checklist, 2.4.1.1

privileges

default, 13.4.2

object, 13.4.2

SYS user, checking privileges, A.3

system, 13.4.3

Process Flow Editor, 7.5

profiles, role, 13.7

properties

security, 13.8

Python.path, 7.2.1

R

RAC environments, installing Warehouse Builder on, 2.4

read-only mode, 13.5.2

read/write mode, 13.5.1

Realms, 7.2.4, 7.2.4

remote installation

OWB home, 3.3, 4.3

setting OWB home, 3.2.7, 4.2.7

remote_owb_install.sql, 3.2.1, 4.2.1

Repository, 1.2

repository

cleaning

Linux, 4.2.2

Windows, 3.2.2

deleting, 5.5

Repository Assistant, 3.2.3, 3.3, 4.2.3, 4.3

LoadJava error, A.3

Repository Assistant, Check for Updates Wizard in, 1.3

Repository Browser

installing, 7.1

repository browser environment

configuring, 7.1

repository objects, 3.2.3, 4.2.3

Repository users, deleting, 5.2

required access privileges

metadata import, 12.2

requirements

JServer option, Oracle Database, A.3

reset_owbcc_home.sql, 3.2.1, 4.2.1

role

adding, 7.2.4

Roles, 7.2.4

roles

Administrator, 13.6.2

assigning, 13.4.1

assigning to users, 13.7.1

available, 7.2.4

changing default, 13.3.3

Everyone, 13.6.1

profiles, 13.7

security, 13.4.3, 13.6

selected, 7.2.4

S

schema objects

deleting, 5.4

schema objects, deleting, 5.4

secure website, 7.2.8

secure-web-site.xml, 7.2.8, 7.2.8

security

enforcement, 13.9

metadata, 13.1

multiple-user access, 13.5

read-only mode, 13.5.2

read/write mode, 13.5.1

roles, 13.4.3

security properties, 13.8

Security Providers, 7.2.4

security roles, 13.6

Control Center Agent, 7.2.4

security strategy

full, 13.2.3

minimal, 13.2.1

multiuser, 13.2.2

select

languages, 3.3, 4.3

separate client and database server topology, 1.2.2

separate Client, Control Center Service, and Database Server topology, 1.2.4

service names

errors resolving service name, A.3

session timeout

changing, 7.1.1

session-config, 7.1.1

setting

PATH environment variable, 7.2.6

setting OWB home

remote installation

Linux, 4.2.7

Windows, 3.2.7

remote_owb_install.sql, 3.2.7, 4.2.7

silent install response values, 2.5

single computer topology, 1.2.1

snapshots

access privileges, 11.2.3.1

adding components, 11.2.2

comparing, 11.2.3.2

converting type, 11.2.3.3

deleting, 11.2.3.6

exporting, importing, 11.2.3.5

metadata, 11.2

restoring, 11.2.3.4

uses, 11.2

standalone software

download, 2.2

SYS password, 7.5

SYS user

verifying privileges, A.3

SYSDBA privileges

checking for SYS user, A.3

system privileges, 13.4.3

T

tablespace, 7.5

select, 3.3, 4.3

tablespace, and materialized views, A.3

tablespaces

materialized views, allocation for, A.3

setting for Control Center, A.3

Target Schema

enabled roles, A.3

testing

connection, 7.2.9.1

web service, 7.2.8

third-party name and address data

installing, 7.4

third-party name and address data libraries

integrating with, 7.4

TNS connect descriptor, 7.5

tnsnames.ora file

SERVICE_NAME parameter, A.3

troubleshooting

installations, A.1

U

uninstalling

OWB software, 5.6

uninstalling OWB, 5

unlocking OWBSYS, 3.2.5, 4.2.5

unlocking OWBSYS_AUDIT, 3.2.5, 4.2.5

unregistering

workspace user, 5.2

user profiles, editing, 13.4

users

assigning roles to, 13.7.1

creating in Warehouse Builder, 13.3.2

registering as Warehouse Builder users, 13.3, 13.3

USERS tablespace, 3.2.3, 4.2.3

users, multiple

security strategy, 13.2.2

using

web service with a secure website, 7.2.8

utilities

Metadata Loader, 12.5

V

validation

errors, A.2

validation rules for metadata import, 12.2.4

virtual memory

errors, A.3

W

Warehouse Builder

frozen, A.4

hanging, A.4

installing, 2.4.1

passwords, 13.10

web service

testing, 7.2.8

web service with secure website, 7.2.8

web.xml, 7.1.1

wfinstall.bat, 7.5

wfinstall.csh, 7.5

wf.log, 7.5

workflow account, 7.5

Workflow Client, 7.5

Workflow Configuration Assistant, 7.5

workflow password, 7.5

Workflow Proxy User, 7.5

workspace, 3.2.1, 4.2.1

creating, 3.3, 4.3

Linux, 4.3

Windows, 3.3

deleting, 5.3

dropping, 5.3

managing, 3.3, 4.3

workspace owner

deleting, 5.3

workspace user

adding, 3.3, 4.3

deleting, 5.2

managing, 5.2

unregistering, 5.2