Skip Headers

Oracle iStore Implementation and Administration Guide
Release 12.1
Part Number E13575-08
Go to Table of Contents
Go to previous page
Go to next page

Verify Mandatory Dependencies

This chapter covers the following topics:

Overview of Verify Mandatory Dependencies Chapter

This chapter describes the tasks that must be performed before beginning your implementation of Oracle iStore.

The mandatory dependencies discussed in this chapter must be implemented in order for your implementation to be successful.

Dependencies and Integrations to Other Oracle Applications

Oracle iStore integrates with many other Oracle applications to provide and extend its functionality; therefore, a large portion of your implementation will involve understanding, setting up, and maintaining the integrating applications.

Oracle iStore and Multiple Organizations

Information about multiple organizations (multi-org), specific to Oracle iStore, is contained in the chapter, Implementing Globalization and Multi-Org Architecture. For Oracle Applications multi-org information, see Multiple Organizations in Oracle Applications, Part No. A81174-02.

Mandatory Dependencies and Optional Integrations

Oracle iStore's dependencies and integrations range from those applications that supply an underlying structure for your sites to those that extend its functionality and capabilities. The applications that provide structure are mandatory, while ones that enhance Oracle iStore are optional integrations.

Mandatory Dependencies

Oracle iStore mandatory dependencies are Oracle products which provide the underlying technology stack, schema, and structure.

Oracle iStore mandatory dependencies are:

Limited setup information about these products is contained in this chapter. Refer to the product-specific implementation and user manuals for complete information.

Optional Integrations

Oracle applications that extend Oracle iStore's capabilities are considered optional integrations. Basic setup information is contained in this guide, but you will need to refer to the product-specific setup and user manuals for complete information. Setting up the optional modules is not required; however, if they are not set up, then the additional functionality provided by these modules will not be available.

See the "Optional Integrations with Oracle iStore" section of this chapter for a discussion of these applications.

Mandatory Dependency Implementation Steps

The following table provides a recommended sequence for beginning your implementation and setting up the Oracle iStore mandatory dependencies.

Mandatory Dependencies Setup Steps
Step Required Reference
Install Software Yes "Install Software" section
Verify Underlying Technology Stack Installation No "Initial Installation Verification" section
Set up Oracle E-Business Tax Yes "Setting up Oracle E-Business Tax" section
Set up Oracle General Ledger Yes "Setting up Oracle General Ledger" section
Set up Oracle Human Resources Yes "Setting up Oracle Human Resources" section
Set up Oracle Inventory Yes "Setting up Oracle Inventory" section
Set up Oracle Order Management and Oracle Order Capture Yes "Setting up Oracle Order Management" section
Set up Oracle Pricing Yes "Setting up Pricing" section
Set up Oracle CRM Technology Foundation Yes "Setting up Oracle CRM Technology Foundation" section
Set up Oracle Trading Community Architecture Yes "Setting up Oracle Trading Community Architecture" section

Accessing the Applications

Tasks in this guide require login on the following two Oracle technology stacks:

Oracle Applications come with a supplied (seeded) system administrator login, with which you can access both Oracle Forms and the Oracle E-Business Suite HTML Applications. The seeded login is:

It is strongly recommended that you change the password at your earliest convenience after installing and accessing the applications. For more information, see:

Visit OracleMetaLink for these installation and upgrade documents.

Accessing Oracle Forms

Many setups for Oracle iStore and its dependencies require that you use Oracle Forms. Launch Oracle Forms by navigating to: http://<host>:<port>/and selecting Apps Logon Links, VIS Logon through the Forms cartridge.

Once logged into Oracle Forms, you can select from a list of responsibilities that determine the functionality you are allowed to use.

Accessing Oracle E-Business Suite HTML Applications

To access the Oracle E-Business Suite HTML applications, navigate to: http://<host>:<port>/oa_servlets/oracle.apps.jtf.base.session.CRMLogin. This login is known as the CRM Login Servlet.

Log in with the appropriate username and password. The seeded username/password is:

Responsibilities and Oracle Applications

All Oracle applications use the concept of user responsibilities for basic user security and application mapping. The responsibility a user logs in with will determine the application (and hence, the menus) that appear. Each responsibility is mapped to a menu structure in Oracle Forms. For information on Oracle iStore responsibilities, see the chapter, Implementing User Management, and the appendix, Seeded User Data.

Install Software

Install the relevant Oracle Applications Release 12 patches. See OracleMetaLink for Documentation Resources (Roadmaps). These documentation roadmaps will assist you in your installation.

Multi-Language Setup (MLS)

Oracle Applications supports the installation of Multiple Language Support, known by the acronym MLS. MLS is also known as National Language Support, or NLS.

To install more than one language, see the following:

These documents can be found on OracleMetaLink.

Oracle iStore is fully supportive of MLS/NLS, providing you have followed the required steps to set up the additional languages.

Information on globalization and multiple organizations is contained in the chapter, Implementing Globalization and Multi-Org Architecture.

Initial Installation Verification

Before proceeding with the implementation of Oracle iStore and its dependencies, you must verify that the installation and middle tier setups are correct. Verify the proper installation and configuration of the following components:

See Installing Oracle Applications for more information.

Setting up Oracle E-Business Tax

Oracle iStore integrates with Oracle E-Business Tax to display calculated tax information to customers. Following are the tax business objects supported (and displayed) in the shopping cart, order review and order details pages:

By default, Oracle iStore displays only cart-level tax data, but you can configure the pages to display tax data at the item level. For more information on setting up item-level tax display, see the "Tax Display in Shopping Carts" topic in the chapter, Implementing Carts and Orders.

Note: Integration with Oracle E-Business Tax requires Oracle Financials Family Pack, Release 12, and Oracle Order Capture (ASO), Release 12.

For more information on setting up and using Oracle E-Business Tax, see the Oracle E-Business Tax Implementation Guide and the Oracle E-Business Tax User Guide.

Setting up Oracle Trading Community Architecture

Oracle Trading Community (TCA) models and manages an electronic representation of the commercial community in which you do business. Oracle Trading Community includes:

For more information on TCA, see the Oracle Trading Community Architecture Administration Guide and the Oracle Trading Community Architecture User Guide.

Setting up Country Address Formats

Oracle iStore's address book functionality can dynamically provide address information entry fields based on the user's country, and perform address validation. Address information is stored in the Oracle TCA schema.

Guidelines for Oracle iStore

Keep the following guidelines in mind as you implement Oracle iStore.

Setting up Oracle General Ledger

Oracle General Ledger (GL) provides business unit information to Oracle iStore. You also set up currencies in GL.

See the Oracle General Ledger User Guide for information on how to perform these tasks.

Setting up Oracle Human Resources

Oracle Human Resources Management System (HRMS) stores information related to your organization. Use HRMS to set up employees and bill-to and ship-to countries. See the appropriate version of Oracle HRMS documentation for more information.

Setting up Oracle Inventory

Oracle Inventory serves as the repository of products that can be sold through Oracle iStore. Before you can create products in Oracle Inventory, you must set up and define the category structures within which products reside.

In addition, several Oracle Inventory flags need to be set in order for products to display in the Oracle iStore Customer Application. See the chapter, Implementing Products, for Oracle iStore-specific product setup details.

Refer to theOracle Inventory User's Guide for complete details of inventory setup.

Setting up Oracle Order Management

Oracle iStore uses the Oracle Order Management suite of applications to:

Oracle Order Management integrates with Oracle iStore via Oracle Order Capture APIs and schema. Order information is communicated to Oracle Order Capture via the ASO_Update_Order API.

This guide contains limited information on setting up and using Oracle Order Management. See the Oracle Order Management documentation for more information:

Setting up Defaulting Rules

You can set up Oracle Order Management to default certain values (following rules you set up in Oracle Order Management), for several order attributes, if no values exist for these attributes when a cart is submitted as an order. Use the profile option, ASO: OM Defaulting, to enable or disable the defaulting. To set parameters for specific attributes, use the steps below.



  1. Log into Oracle Forms with Order Management Superuser Responsibility.

  2. Navigate to Menu, Setup, Rules, Defaulting.

  3. Query for:

  4. In the Attributes area: Find the desired attribute, select it, and select the Defaulting Rules button.

  5. In the Defaulting Sourcing Rules window, you can add (or subtract) any source/value item for the attribute.

After modifying the values, be sure to run the Build Attribute Mapping Rules concurrent program and bounce the middle-tier server.

See the "Supported Oracle Order Management Defaulting Values" section for a list of the defaulting parameters supported by Oracle iStore and Oracle Order Capture schema.

Supported Oracle Order Management Defaulting Values

The following are the defaulting values supported by Oracle iStore:

Cart (Header) Fields:

Only if ASO: OM Defaulting = Y:

Item (Line) Fields:

Only if ASO: OM Defaulting = Y:

Setting up Pricing

See the chapter, Implementing Pricing, for information about pricing setups.

Setting up Oracle CRM Technology Foundation

Oracle CRM Technology Foundation provides the underlying technology stack for the Oracle HTML applications. You must implement Oracle CRM Technology Foundation as described in Oracle Applications CRM System Administrator's Guide.

After this implementation, perform the Oracle iStore-related setups listed in the following sections:

Host Configuration

When you build the Oracle CRM Technology Foundation deployment configuration, you must set up all middle-tier hosts. For each host on which you will deploy Oracle iStore, include iStore in the host's deployed applications list.

Cookie Properties

The user session in Oracle iStore is controlled and identified by cookies. The cookies are set on the user's browser and identify return customers. The Oracle iStore process is transparent to cookie administration, setup, and control. Cookies are managed by Oracle CRM Technology Foundation methods. If the user turns off browser cookies, Oracle CRM Technology Foundation ensures that the cookie information is available through the URL.

The cookie domain is set as the Web server domain, for example, , for Oracle's online store. Once the user registers, the user account is created in the database and is used in the cookies to identify the customer. If the user is unregistered, a guest user account is used in the cookies.

Enabling cookie encryption is a mandatory setup step that involves specifying an encryption key while setting up cookie properties in Oracle CRM Technology Foundation.

Setting Look and Feel JTF Property

Ensure that the Oracle Technology Foundation property (JTF/JTT) property Look and feel.cabo is set to True, either at the JTF/JTF application level or at the IBE application level.

Use the guidelines below to determine at which level the property should be set:

Note: If you are unsure of the Cabo Look and Feel level in the applications you are using, then to be safe, set the property at the iStore application level.


The steps to set this property are:

  1. Login as System Administrator to the CRM Login Servlet.

  2. Navigate to Settings, System, Advanced. The Advanced - Properties page appears.

  3. To set the property at the JTF/JTT application level:

    1. In the View droplist, select the Oracle CRM Technology Foundation application product code, JTF. (Press the Update button if necessary.)

    2. In the list that appears, select the hyperlink of the property, LookAndFeel.cabo.

    3. In the Key Details page, enter the following values:

      Key field = LookAndFeel.cabo

      Value (Sequence 0) field = true

    4. Select the Update button to save the changes.

  4. To set the property at the IBE (Oracle iStore) application level:

    1. In the View droplist, select iStore's product code, IBE. If IBE is not in the list, see "Adding IBE to the View Droplist", below.

    2. Select the Create button.

    3. In the Create Key page, enter the following values:

      Key field = LookAndFeel.cabo

      Value (Sequence 0) field = true

    4. Click the Update button to save the changes.

  5. When you are finished making the changes, log out of the sysadmin console, and log in as the iStore Administrator.

The Cabo Look and Feel should function properly.

Adding IBE to the View Droplist

If Oracle iStore's product code, IBE, is not shown in the View droplist in the Advanced - Properties page, do the following:

  1. Navigate to Settings, System, Category. In the Property Category page, select the following:

  2. Select the Next button.

  3. In the Permission Role Mapping page, move JTF_SYSTEM_ADMIN_ROLE from the Available Roles window to the Assigned Roles window.

  4. Select the Update button to save the changes.

See the latest Oracle Applications CRM System Administrator's Guide, for more information.

Optional Integrations with Oracle iStore

Several Oracle applications modules can be set up to provide additional functionality for your electronic sites. These are mentioned below. Refer to the relevant chapter and/or product documentation for more information.

Oracle Advanced Pricing

Use Oracle Advanced Pricing to set up customer discounts, sourcing rules, pricing qualifiers, and pricing modifiers. See the chapter, Implementing Pricing, for details.

Oracle Advanced Supply Chain

Use Oracle Advanced Supply Chain (Global ATP Server) to provide product availability information. See the chapter, Integrating Oracle iStore with Oracle Advanced Supply Chain Planning, for details.

Oracle Bills of Material

Use Oracle Bills of Material to set up configurable items, model bundles, and items with standard warranties for sale in your sites. See the chapter, Integrating Oracle iStore with Oracle Bills of Material, for details.

Oracle Call Center Technology

Use the Oracle Call Center Technology (CCT) suite of applications to process call-me-back requests. See the chapter, Implementing Customer Assistance, for more details.

Oracle Configurator

Use Oracle Configurator to enable customer configured products, provide guided selling, and perform some of the shopping cart validations. See the chapter, Integrating Oracle iStore with Oracle Configurator, for details.

Oracle Content Manager

Use Oracle Content Manager to provide a complete range of content item creation and management capabilities. See the chapter, Integrating Oracle iStore with Oracle Content Manager, for details.

Oracle Contracts

Integrate with Oracle Service Contracts to support the selling of serviceable items and related services in the Customer Application. Integrate with Oracle Sales Contracts to provide Terms and Conditions functionality in the checkout pages of the Customer Application. See the chapters, Implementing Products, and the Integrating Oracle iStore with Oracle Sales Contracts, for details.

Oracle Customer Care

The Oracle Customer Care suite of applications provides a complete view of the customer by displaying relevant customer information. Customer Care allows agents to alter customer data and create interactions with the customer. See Oracle Customer Care Implementation Guide for details. This guide is available on OracleMetaLink.

Oracle iSupport

Use Oracle iSupport to provide self-service service request submission, order details views, return for credit authorizations, knowledge management, Install Base access, and user forums. Also integrate with Oracle iSupport to provide a unified Support dashboard for users of Oracle iStore and Oracle iSupport. See the chapter, Integrating Oracle iStore with Oracle iSupport, for details.

Oracle Install Base

Use Oracle Install Base to maintain -- and allow customers to maintain -- a repository of purchase information, including purchase date, product attributes, and applicable service agreements. See Oracle Install Base Implementation Guide for details.

Oracle Marketing

Use Oracle Marketing to create and maintain products; define, execute, and manage marketing campaigns; and to track user events. See the chapter, Integrating Oracle iStore with Oracle Marketing, for details.

Oracle Partner Management

Use Oracle Partner Management to provide a unified Partner dashboard in the Oracle iStore Customer UI. See the chapter, Integrating Oracle iStore with Oracle Partner Management, for details.

Oracle Quoting

Use Oracle Quoting to create quotes that can be published to Oracle iStore sites, to provide contracts setup for Terms and Conditions, to capture carts as quotes when users request sales assistance, and to share quotes with other users. See the chapter, Integrating Oracle iStore with Oracle Quoting, for details.

Oracle Sales Applications

Use Oracle Sales Online and Oracle TeleSales to import sales leads from Oracle iStore orders and expired shopping carts. For more information on the Lead Import functionality of Oracle iStore, see the chapter, Integrating Oracle iStore with Oracle Sales Applications.

Oracle Shipping Execution

Use the Order Management module, Oracle Shipping Execution (SE), to calculate shipping charges, and to set up shipping parameters, transportation calendars, pick slip rules, container-item relationships, suppliers (freight carriers), and document printing. The Oracle Shipping Execution module must be in place to enable post-order tracking and shipping detail views in Oracle iStore. See the chapter, Integrating Oracle iStore with Oracle Shipping Execution, for details.

Oracle Single Sign-On Server

Use Oracle Single Sign-On Server to provide single-authentication architecture. See the chapter, Integrating Oracle iStore with Oracle Single Sign-On, for more information.

Oracle Workflow

Use Oracle Workflow to send HTML e-mail notifications and confirmations to customers and sales representatives. See the chapter, Integrating Oracle iStore with Oracle Workflow, for details.

Oracle Application Server Web Cache

Use Oracle Application Server Web Cache to serve the non-transactional Oracle iStore content. See the chapter, Integrating Oracle iStore with Oracle Application Server Web Cache, for details.