Oracle Retail Place 12.2 User manual

Oracle®Retail Place
Installation Guide
Release 12.2
November 2008

Oracle®Retail Place Installation Guide, Release 12.2
Copyright © 2006, 2008, Oracle. All rights reserved.
Primary Author: Anirudha Accanoor
The Programs (which include both the software and documentation) contain proprietary information; they
are provided under a license agreement containing restrictions on use and disclosure and are also protected
by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly,
or decompilation of the Programs, except to the extent required to obtain interoperability with other
independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in
the documentation, please report them to us in writing. This document is not warranted to be error-free.
Except as may be expressly permitted in your license agreement for these Programs, no part of these
Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any
purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on
behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data
delivered to U.S. Government customers are "commercial computer software" or "commercial technical data"
pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As
such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation
and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license
agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial
Computer Software—Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City,
CA 94065
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy and other measures to ensure the safe use of such applications if the Programs are used for such
purposes, and we disclaim liability for any damages caused by such use of the Programs.
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third
parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites.
You bear all risks associated with the use of such content. If you choose to purchase any products or services
from a third party, the relationship is directly between you and the third party. Oracle is not responsible for:
(a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the
third party, including delivery of products or services and warranty obligations related to purchased
products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from
dealing with any third party.

Value-Added Reseller (VAR) Language
Oracle Retail VAR Applications
The following restrictions and provisions only apply to the programs referred to in this section and licensed
to you. You acknowledge that the programs may contain third party software (VAR applications) licensed to
Oracle. Depending upon your product and its version number, the VAR applications may include:
(i) the software component known as ACUMATE developed and licensed by Lucent Technologies Inc. of
Murray Hill, New Jersey, to Oracle and imbedded in the Oracle Retail Predictive Application Server -
Enterprise Engine, Oracle Retail Category Management, Oracle Retail Item Planning, Oracle Retail
Merchandise Financial Planning, Oracle Retail Advanced Inventory Planning and Oracle Retail Demand
Forecasting applications.
(ii) the MicroStrategy Components developed and licensed by MicroStrategy Services Corporation
(MicroStrategy) of McLean, Virginia to Oracle and imbedded in the MicroStrategy for Oracle Retail Data
Warehouse and MicroStrategy for Oracle Retail Planning & Optimization applications.
(iii) the SeeBeyond component developed and licensed by Sun MicroSystems, Inc. (Sun) of Santa Clara,
California, to Oracle and imbedded in the Oracle Retail Integration Bus application.
(iv) the Wavelink component developed and licensed by Wavelink Corporation (Wavelink) of Kirkland,
Washington, to Oracle and imbedded in Oracle Retail Store Inventory Management.
(v) the software component known as Crystal Enterprise Professional and/or Crystal Reports Professional
licensed by Business Objects Software Limited ("Business Objects") and imbedded in Oracle Retail Store
Inventory Management.
(vi) the software component known as Access Via™ licensed by Access Via of Seattle, Washington, and
imbedded in Oracle Retail Signs and Oracle Retail Labels and Tags.
(vii) the software component known as Adobe Flex™ licensed by Adobe Systems Incorporated of San Jose,
California, and imbedded in Oracle Retail Promotion Planning & Optimization application.
(viii) the software component known as Style Report™ developed and licensed by InetSoft Technology
Corp. of Piscataway, New Jersey, to Oracle and imbedded in the Oracle Retail Value Chain Collaboration
application.
(ix) the software component known as DataBeacon™ developed and licensed by Cognos Incorporated of
Ottawa, Ontario, Canada, to Oracle and imbedded in the Oracle Retail Value Chain Collaboration
application.

v
Contents
Preface ................................................................................................................................................................. ix
Audience....................................................................................................................................................... ix
Related Documents ..................................................................................................................................... ix
Customer Support....................................................................................................................................... x
Review Patch Documentation ................................................................................................................... x
Oracle Retail Documentation on the Oracle Technology Network ..................................................... x
Conventions ................................................................................................................................................. x
1 Overview
Overview of Place..................................................................................................................................... 1-1
Place Enterprise Components .......................................................................................................... 1-1
Roadmap for Implementing Place ........................................................................................................ 1-4
2 Planning Your Installation
Overview of the Planning Process ........................................................................................................ 2-1
Planning Your Environment............................................................................................................. 2-1
Planning for Optimal Place Performance....................................................................................... 2-2
Supported Configurations...................................................................................................................... 2-2
Network Requirements ..................................................................................................................... 2-2
Managed Server Configuration ................................................................................................ 2-2
Database Requirements..................................................................................................................... 2-3
Application Server Requirements.................................................................................................... 2-3
WebLogic Application Server ................................................................................................... 2-3
Client System Requirements............................................................................................................. 2-4
3 Setting Up the Database
Installing the Database ........................................................................................................................... 3-1
Creating the Default Tablespaces.......................................................................................................... 3-2
Creating the Default Data User Account ............................................................................................. 3-2
Creating the Database Links .................................................................................................................. 3-3
4 Setting Up the Application Server
Installing the WebLogic Server ............................................................................................................. 4-1
Setting Up a WebLogic Domain ............................................................................................................ 4-2

vi
Setting Up the WebLogic Startup Script.............................................................................................. 4-4
Setting Up the Maximum Message Size .............................................................................................. 4-5
5 Installing Place
Overview of the Installation Process.................................................................................................... 5-1
About Password Security Management ......................................................................................... 5-1
Installing Place.......................................................................................................................................... 5-2
Accessing the Installation Software................................................................................................. 5-2
Setting Up Your Installation Properties File .................................................................................. 5-3
Installing Place in the Silent Mode .................................................................................................. 5-3
Installing Place Using the Graphical Oracle Installer ................................................................... 5-4
Setting Up ADF Libraries ....................................................................................................... 5-11
Post-Installation Tasks.................................................................................................................... 5-11
Setting Up Targets for the JMS Servers................................................................................. 5-11
Loading Business Rules .......................................................................................................... 5-12
Loading User Roles.................................................................................................................. 5-12
Loading Seed Data................................................................................................................... 5-12
Installing the Sample Dataset........................................................................................................ 5-13
Install.properties Parameters Reference........................................................................................... 5-14
Installation Target Directories....................................................................................................... 5-14
Command Shell Settings ................................................................................................................ 5-14
Last Session Properties Files.......................................................................................................... 5-15
Application Server and Database Settings .................................................................................. 5-15
Connection Pools Settings.............................................................................................................. 5-15
Calc Engine User Setting................................................................................................................ 5-16
WebLogic Application Server Settings ........................................................................................ 5-16
Oracle Database Settings................................................................................................................ 5-17
Connection and Authentication Settings.............................................................................. 5-17
Audit Database Properties...................................................................................................... 5-19
Place Schema Properties ......................................................................................................... 5-20
Plan Front End Database Properties ..................................................................................... 5-20
ELM Schema Properties.......................................................................................................... 5-21
Place-specific Suite Properties....................................................................................................... 5-22
Cluster Properties............................................................................................................................ 5-22
MicroStrategy Properties ............................................................................................................... 5-23
Troubleshooting Installation Issues .................................................................................................. 5-24
6 Installing Place Over Plan
Setting Up the Plan Installation ............................................................................................................ 6-1
Setting Up the Place Installation........................................................................................................... 6-2
Configuring Place..................................................................................................................................... 6-3
Loading Business Rules..................................................................................................................... 6-3
Loading User Roles............................................................................................................................ 6-3
Loading Seed Data ............................................................................................................................. 6-3
Reference to the Data Load Scripts........................................................................................... 6-5
Upgrading a Co-deployed Environment.............................................................................................. 6-6

vii
Setting Up a Foreign JMS Server on WebLogic Server..................................................................... 6-6
A Files and Directory Structure
Application Directory Structure........................................................................................................... A-1
Modules Deployed On WebLogic Server........................................................................................... A-4
Index

viii

ix
Preface
This guide enables you to install the Oracle Retail Place application, along with the
server-side components required for the application.
Audience
This guide is intended for system administrators and assumes that you are familiar
with the following:
■Installing and configuring application server software
■Installing and configuring relational database management systems
■Installing and configuring distributed client/server applications on a UNIX-based
local area network
Related Documents
For more information about using the Place application, the following documents are
available in the Oracle Retail Place Release 12.2 documentation set:
■Oracle Retail Place Administration Guide
■Oracle Retail Place Configuration Guide
■Oracle Retail Place Operations Guide
■Oracle Retail Place User Guide
Supplemental Documentation on MetaLink
The following technical white paper is available on the MetaLink Web site:
MetaLink Note 737759.1: Oracle Retail Password Security Management Guide
Oracle Retail Plan and Place applications now include a Password Security
Management module that helps you generate and store encrypted passwords used in
the application. This enables you to meet the password encryption security policies or
laws mandated for your business.
The white paper introduces you to the Password Security Management module and
the methodology adopted to encrypt the passwords. It also includes information that
will help you perform administrative or recovery tasks efficiently.

x
Customer Support
■https://metalink.oracle.com
When contacting Customer Support, please provide:
■Product version and program/module name
■Functional and technical description of the problem (include business impact)
■Detailed step-by-step instructions to recreate
■Exact error message received
■Screen shots of each step you take
Review Patch Documentation
If you are installing the application for the first time, you install either a base release
(for example, 12.0) or a later patch release (for example, 12.2). If you are installing a
software version other than the base release, be sure to read the documentation for
each patch release (since the base release) before you begin installation. Patch
documentation can contain critical information related to the base release and code
changes that have been made since the base release.
Oracle Retail Documentation on the Oracle Technology Network
In addition to being packaged with each product release (on the base or patch level),
all Oracle Retail documentation is available on the following Web site (with the
exception of the Data Model which is only available with the release packaged code):
http://www.oracle.com/technology/documentation/oracle_retail.html
Documentation should be available on this Web site within a month after a product
release. Note that documentation is always available with the packaged code on the
release date.
Conventions
The following text conventions are used in this document:
Convention Meaning
boldface Boldface type indicates graphical user interface elements associated
with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for
which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code
in examples, text that appears on the screen, or text that you enter.

Overview 1-1
1
Overview
This chapter provides an overview of Oracle Retail Place and a roadmap for
implementing the application. It contains the following sections:
■Overview of Place
■Overview of Oracle Configuration Manager
■Roadmap for Implementing Place
Overview of Place
Oracle®Retail Place enables retailers to generate and publish recommended
allocations based on optimal size profiles, pack configurations, available warehouse
inventory or advance shipping notices (ASNs), and forecasted sales. It also enables the
retailers to integrate the other systems to capture the daily warehouse inventory, the
current ASNs, and generate the recommended allocations to the stores.
Place is a Web-based allocation optimization system that helps retailers optimize the
distribution of the merchandise to the stores. It helps the retailers to allocate the right
merchandise at the right time to the right stores.
Place Enterprise Components
The Place application is a distributed application, using an application server as the
platform for the services, a database, and several other software components. It
contains the following components:
■Client System Tier
■Application Server Tier
■Database Server Tier
The following figure displays a typical configuration:

Overview of Place
1-2 Oracle® Retail Place Installation Guide
Figure 1–1 Typical Configuration for Place
Client System Tier
The Client System tier contains the systems that connect to the Place application using
a Web browser. It includes systems with the following components:
■Microsoft Windows
■Microsoft Office
■Microsoft Internet Explorer 7.0, with ActiveX control
Application Server Tier
The Application Server tier contains the application server domains, clusters, and
managed servers set up as a platform used by the application and calculation engine.
This tier includes the following components hosted on the application server (BEA
WebLogic Server):
■Application – The Place application resides on a domain configured on this
application server. You can install and run multiple instances of the application
server or multiple application server machines, based on your business needs.
■Calculation Engine – It also installs on a specific domain configured on the
application server. To improve performance, you can install and run multiple
engines, and move them to any other production server within your environment
as needed.
Note: Oracle recommends that you set up separate hosts for the
application and the Calculation Engine.

Overview of Place
Overview 1-3
Database Server Tier
The Database Server tier contains the systems configured with the database
management systems (Oracle 10gDatabase) along with the necessary database
software.
The following essential schemas are created during the Place installation:
■AUDIT schema – contains information that helps you better track objects, events
and critical data changes.
■PLACE schema – contains data specific to the application.
■OAK schema – contains the business data essential for the application, such as
merchandise hierarchy, product information, inventory positions, store
information, and so on.
■ELM schema – contains the historical data that includes per store and per item
sales activities stored over a time period (daily, weekly, and so on.)
■PINE schema – contains the demand parameters data (result of the curve fitting
algorithms) to drive the forecast demand models, including item seasonalities,
price elasticities, and curve fitting parameters.
Note: Oracle recommends that you set up separate instances for the
business database (AUDIT, PLACE, OAK, and PINE schema included
in a single BASE schema) and historical database (ELM schema).

Roadmap for Implementing Place
1-4 Oracle® Retail Place Installation Guide
Roadmap for Implementing Place
This guide explains how you can install and set up the Place application, along with
the required and optional software.
The instructions in this guide assume knowledge of application servers, databases,
and application installation, and are intended for system administrators and
experienced IT personnel. Before carrying out any of these activities, ensure that you
understand UNIX commands (including shell configuration and scripting), directory
operations, and symlinks.
In order to implement Place for production, you must perform the following tasks in a
sequence:
Table 1–1 Roadmap for Implementing Place
Task Description
Pre-installation Tasks
1. Plan your environment, based on your business needs. For more information on the
planning process and the supported configurations, see Chapter 2, "Planning Your
Installation".
2. Set up your application database. For more information, see Chapter 3, "Setting Up the
Database".
3. Set up your application server. For more information, see Chapter 4, "Setting Up Your
Application Server".
Installation Task
4. Access the Place installation software, set up the install.properties file, and run the
Oracle installer. For more information, see Chapter 5, "Installing Place".
Additionally, you can also install the Place application to work along with an existing
installation of Plan. For more information, see Chapter 6, "Installing Place Over Plan".
Post-installation Tasks
5. Configure your business rules and user accounts. For more information, see the Place
Configuration Guide.
6. Modify the Place user interface to accommodate your business needs, as described in
the Place Configuration Guide. Concurrent with this activity, complete the remaining
steps in this roadmap. You can continue refining the user interface iteratively, as needed
(optional).
7. Set up user accounts and introduce the end users to the application.
8. Perform and schedule the necessary data loads, as described in the Place Operations
Guide.

Planning Your Installation 2-1
2
Planning Your Installation
Before installing the Place application, you must first determine the performance and
availability goals for your business, and then plan the hardware, network, and storage
requirements accordingly. This chapter provides some basic considerations for the
implementation. It also includes the list of hardware and software requirements.
This chapter includes the following sections:
■Overview of the Planning Process
■Supported Configurations
Overview of the Planning Process
Planning your implementation prior to an installation also gives you a better
understanding of the environment, and enables you to adapt faster to any future
changes in the environment setup.
This section contains the following topics:
■Planning Your Environment
■Planning for Optimal Place Performance
Planning Your Environment
Use the following steps to plan and prepare the product environment:
1. Plan and design the infrastructure, based on your business needs, for the
installation. This includes:
■Meeting the hardware and associated software requirements.
■Acquiring the prerequisite software (and licensing).
■Setting up the load balancers and clusters.
■Gathering the capacity data.
■Planning the data security policies.
■Designing the backup and recovery strategies.
2. Determine the size of the implementation.
3. Identify source systems. Identify the systems that will exchange data with Place.

Supported Configurations
2-2 Oracle® Retail Place Installation Guide
Planning for Optimal Place Performance
Consider the following steps to plan and prepare the product environment.
1. Determine the Place metrics relevant to your business needs.
2. Determine your relevant business policies. The business policy is a statement of
what rules govern the application processes. You need to develop a business
policy based on your business rules. For more information about business rules,
see the Place Configuration Guide.
3. Plan the periodic batch loading of business and historical databases. This also
includes the data feeds needed from the external systems for nightly, weekly, and
periodic batch updates and recycling.
Supported Configurations
This section describes the hardware and network requirements for the Place
application, and includes the following topics:
■Network Requirements
■Database Requirements
■Application Server Requirements
■Client System Requirements
Network Requirements
This section describes basic requirements for your network infrastructure:
■For connections between servers use the following:
■Minimum: 100 MBps switched ethernet
■Recommended: 1000 MBps
■For connections to the desktop, 100 MBps is sufficient.
Managed Server Configuration
You can host the Place application and the Calculation Engine over multiple server
instances (managed servers), and set up clusters to improve the system performance.
The following list illustrates a typical cluster configuration:
■Application Cluster - two or more managed server nodes that host instances of
Place and its related applications.
■Calculation Engine Cluster - two managed server nodes that host instances of the
Calculation Engine.
For clustered and multi-server implementations, a hardware load balancer may be
required. Cisco CSS series is supported.
Note: Although the Place application can work along with managed
servers, Failover clusters are not supported at the database or the
application server tier. In an event of a failure of an instance, instead
of the user’s session migrating to another (spare) instance, the user
will get redirected to the Place Login page.

Supported Configurations
Planning Your Installation 2-3
Database Requirements
Place requires the use of the Oracle database as described in the following table:
Application Server Requirements
Place requires the use of the BEA WebLogic 8.1 Server Service Pack 6.
WebLogic Application Server
Place supports the use of the BEA WebLogic Server on the Linux platform.
The following table lists the Linux requirements for the WebLogic Server:
Table 2–1 Oracle Database Requirements
Software Requirement
Database Oracle 10g Release 2 (10.2.0.2) Oracle 10g Release 2 (10.2.0.3)
Operating System HP-UX 11i v2 (11.23) Enterprise
Release on Itanium-based systems Solaris 10 for SPARC platform and x86 platform
(with appropriate libc and timezone
patches).
Utilities file transfer protocol utility (ftp or ssh/scp/rsync)
sudo utility
Note: For Oracle 10gDatabase installations on the Solaris Operating System
(x86-64), ensure that you apply the Oracle 10gRelease 2 (10.2.0.2) Patch Set.
For more information on this patch set, review the release document 316900.1
(ALERT: Oracle 10g Release 2 (10.2) Support Status and Alerts) available on
the Oracle MetaLink Web site.
To locate this document on the Oracle MetaLink Web site,
■In the Quick Find section, for Document ID, enter 316900.1, and click Go.
Table 2–2 Linux Requirements for WebLogic
Software Requirement
Operating System Red Hat Enterprise Linux release 3.0 (Taroon), Update 6 with tzdata
enhancement package (tzdata-2006m-3.el3).
Application Server BEA WebLogic Server 8.1 Service Pack 6
JVM On Red Hat Enterprise Linux environments, BEA WebLogic Jrockit 1.4.2_10
Important: You must run the Time Zone Updater tool to update the BEA
Jrockit SDK with the latest time zone information that accommodates the U.S.
2007 daylight saving time changes (US2007DST). For more information, visit
the BEA Jrockit online documentation at
http://edocs.bea.com/jrockit/geninfo/diagnos/tzupdate.html

Supported Configurations
2-4 Oracle® Retail Place Installation Guide
Client System Requirements
The following table lists the supported client system options:
Table 2–3 Client System Environment
Software Requirements
Windows XP Pro SP2
(with Office XP)
■Microsoft Office XP
■Microsoft Internet Explorer 7.0
Windows XP Pro SP2
(with Office 2000)
■Microsoft Office 2000
■Microsoft Internet Explorer 7.0

Setting Up the Database 3-1
3
Setting Up the Database
Before you run the Oracle installer to install the application, you must set up the
database to include certain necessary tablespaces, and a database user account. This
chapter describes how you can set up your database, and the various database
components. It contains the following sections:
■Installing the Database
■Creating the Default Tablespaces
■Creating the Default Data User Account
■Creating the Database Links
Installing the Database
The application requires the use of the Oracle®10g Database Release 2 (10.2.0.2) and
the Natively Compiled Java Libraries (in the Oracle Database Companion CD).
Ensure that the Oracle Database software is installed along with the Natively
Compiled Java Libraries. For more information, see the Oracle Database Installation
Guide, 10g Release 2 (10.2) and Oracle Database Companion CD Installation Guide, 10g
Release 2 (10.2).
Note: If your database requires multi-byte support, specify the following
properties in your init.ora file:
CHARACTER_SET=AL32UTF8
NLS_LENGTH_SEMANTICS=CHAR
Note: To manage the associated data and other database components
effectively, Oracle recommends that you set up separate instances for the
business database and the historical database.
In case you plan to set up separate instances, you must create database links
between the instances. For more information, see Creating the Database Links.

Creating the Default Tablespaces
3-2 Oracle® Retail Place Installation Guide
Creating the Default Tablespaces
When you run the Oracle installer, schemas and tables for the application get installed
on the database you create. For the schemas and tables to install successfully, the
database must include certain default tablespaces.
Use the Oracle 10g Database Configuration Assistant to create a default database with
the tablespaces mentioned in Table 3–1, Business Database Tablespaces. For more
information on using the Oracle 10gDatabase Configuration Assistant, see the Oracle
10g Release 2 Installation documentation.
Creating the Default Data User Account
You must also create a default user account, that can be later specified to the Oracle
Installer. The Oracle Installer connects to the Place database, using this user account,
and installs the schemas and tables.
To create a user account:
1. At the SQL prompt, type the following statement to create an user and set DATA_
01 as the default tablespace:
CREATE USER <USERNAME> IDENTIFIED BY <USERNAME>
DEFAULT TABLESPACE DATA_01;
2. Once the user is created, type the following statements to grant access privileges to
the user:
GRANT CONNECT,RESOURCE,CREATE ANY TABLE,CREATE ANY SYNONYM,CREATE VIEW TO
<USERNAME>;
exec dbms_java.grant_permission(
'<USERNAME>','SYS:java.lang.RuntimePermission', 'getClassLoader', '' )
Table 3–1 Business Database Tablespaces
Tablespace Description
DATA_01 Required. Application tablespace for Place.
Recommended size: 5 GB.
INDEX_01 Required. Application tablespace for the indexes of Place, STG,
and ASH.
Recommended size: 5 GB.
SYSTEM System tablespace used for metadata.
SUSAUX System tablespace used for system monitoring.
TEMP System tablespace used for temporary system swap space.
RBS System tablespace for automatically resolving data write clashes.
Note: The sizes of tablespaces depend on the amount of data being stored.
For any sizing recommendations, see Table 3–1, Business Database
Tablespaces.