Oracle® Retail Data Model Release Notes

Release 11.3.1

E20364-03

Oracle® Retail Data Model

Release Notes

Release 11.3.1

E20364-03

July 2012

Changes for this release and known issues in the current release of Oracle Retail Data Model are documented in the following sections:

- New Features and Changes in Release 11.3.1

- Known Issues

- Documentation

- Documentation Accessibility

New Features and Changes in Release 11.3.1

Oracle Retail Data Model Release 11.3.1 includes the following new features:

New Feature

Description

Oracle Database 11g Release 2

Oracle Retail Data Model Release 11.3.1 supports Oracle 11g Release 2 (11.2) as the underlying database, including:

- Interval Partition: an extension of range partitioning which instructs the database to automatically create partitions of a specified interval when data inserted into the table exceeds all of the existing range partitions.

- Improved OLAP

- Reduces the number of materialized views, improves performance, and provides enhanced manageability.

- Improved Mining

ARTS Data Model 6.0

This version of Oracle Retail Data Model contains the Association for Retail Technology Standard (ARTS) Data Model version 6.0.

New Database Objects

These support the following areas:

- Food service transactions, recipe, and reservations

- Manufacturer's view of items and multiple retailers

- Retailer private label and business to business sales

- Retailers: in-store, e-commerce, catalog, wholesale

- Wholesale franchise customers and stores

- Point of Service control transactions, Store Financials

- Invoice, Receivable, Payable, General Ledger, Journal Entries

New Advanced Analytics, Forecasting, and Prediction

Including: Price Elasticity, Customer Sentiment, Customer Value, Workforce Optimization

Support for additional measures and new reports

Improved reports with less operational and more advanced analytics. Update-able metadata for impact and lineage analysis.

Known Issues

The following are Oracle Retail Data Model known issues:

- OLAP A Patch Required

- Unit of Measure (UOM) Functionality Not Supported

- Missing Staging Tables and Staging to Base/Reference ETL

- Oracle Retail Data Model 10.2 to 11.3.1 Upgrade Not Supported

- Deinstall Warning Message can be Ignored

- Manual Intra-ETL Execution

- Installing Sample Reports on AIX Platform Fails

OLAP A Patch Required

Before installing Oracle Retail Data Model you need to obtain the appropriate OLAP A Patch for your platform and install the OLAP A patch for Oracle Database 11.2.0.3.0.

Do the following to obtain and install the OLAP A patch:

1. To obtain the appropriate patch for your platform, go to My Oracle Support at
https://support.oracle.com

2. Go to Patches & Updates tab, Search for Patch Number 13819727 and select Enter. Choose the patch 13819727 with Description "OLAP A PATCH FOR 11.2.0.3.0 (Patch)" and also choose the Platform from available choices and download the patch.

3. Unzip the patch and follow the installation in the readme file to install the patch.

Unit of Measure (UOM) Functionality Not Supported

Bug 14163842 - Unit of Measure (UOM) functionality is not supported

The Unit of Measure (UOM) functionality is not supported in Oracle Retail Data Model Release 11.3.1.

Workaround

There is no workaround for this issue.

Missing Staging Tables and Staging to Base/Reference ETL

Bug 14188114 - missing staging tables and staging to base/reference ETL

The staging layer consists of interface tables and ETL to move data from staging tables to base/reference tables. The staging and Interface layer is not included in the Oracle Retail Data Model installation.

Workaround

There is no workaround for this issue.

Oracle Retail Data Model 10.2 to 11.3.1 Upgrade Not Supported

Bug 14188107: Upgrade From 10.2 Not Supported

Oracle Retail Data Model does not provide support for the upgrade path from Oracle Retail Data Model Release 10.2 to Oracle Retail Data Model 11.3.1.

Workaround

There is no workaround for this issue.

Deinstall Warning Message can be Ignored

Bug 14050274 and Bug 14003000: deinstall warning error in the deinstall log file

The following warning message or messages similar to the following message can be ignored on deinstall:

WARNING: Error while copying directory
ORACLE_BASE/dbhome_1/inventory with exclude file list
'/tmp/OraInstall2012-01-11_02-37-25PM/installExcludeFile.lst' to nodes "xxx_xxx"
[PRCF-2016 : Required binary file "ractrans" not found]
Refer to /orainventory_location/logs/installActions2012-01-11_02-37-25PM.log' for details.
You may fix the errors on the required remote nodes.Refer to the install guide for error recovery.

Manual Intra-ETL Execution

Bug 13737901 Workflow Manual Execution Shell Script ordm_execute_wf.sh Missing

Oracle Retail Data Model is missing a program to manually execute the Intra-ETL.

Workaround

Run the Intra-ETL as described in the Oracle Retail Data Model Implementation and Operations Guide, in the sections: "Executing the Default Oracle Retail Data Model Intra-ETL" and "Refreshing the Data in Oracle Retail Data Model Warehouse".

Installing Sample Reports on AIX Platform Fails

On the AIX platform, the sample reports install can fail with the following errors if the database is not configured according to the documented requirements. Depending on how your AIX platform is configured, you may see errors similar to the following. You can find these error details in the Oracle Retail Data Model configuration log file:

$ORACLE_BASE/cfgtoollogs/ordm/ordm_<date_time>.log

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 16048 bytes (session
heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2
ORA-39097: Data Pump job encountered unexpected error -1427
ORA-39065: unexpected master process exception in MAIN
ORA-01427: single-row subquery returns more than one row

or

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-04031: unable to allocate  bytes of shared memory ("","","","")
Failing sql is:
BEGIN
sys.dbms_cube_exp.schema_info_imp_11_2('ORDM_SAMPLE', 1, 1, '11.02.00.00.00', 'D
BMS_CUBE_EXP$$CLOB_TBL');COMMIT; END;

Resolution

For details on setting AIX configuration parameters as required for Oracle Retail Data Model, see Oracle Retail Data Model Installation Guide and for details on setting configuration parameters for AIX, review the section, "Configure Shell Limits and System Configuration Parameters" in Chapter 2, "Oracle Database Preinstallation Requirements", in Oracle Database Installation Guide for IBM AIX on POWER Systems (64-Bit).

You need to modify the parameters:

- Soft DATA segment: set to -1 (Unlimited)

- Soft Real Memory size: set to -1 (Unlimited)

For more details, see Bug 14019338 and Bug 14369235.

Documentation

The Oracle Retail Data Model documentation includes the following books:

- Oracle Retail Data Model Installation Guide

- Oracle Retail Data Model Reference

- Oracle Retail Data Model Implementation and Operations Guide

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle Retail Data Model Release Notes, Release 11.3.1

E20364-03

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Oracle Retail Data Model contains the ARTS Data Model licensed to Oracle by ARTS.

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.