|Oracle® Retail Data Model Release Notes
|PDF · Mobi · ePub|
Changes for this release and known issues in the current release of Oracle Retail Data Model are documented in the following sections:
Oracle Retail Data Model Release 11.3.2 includes the following new features:
|Scripts added to assist in extending the time dimension.||Oracle Retail Data Model now provides scripts and a procedure to assist in extending the initially set Time Dimension as required for an implementation.|
|Logical Data Model Entities Added||EXTERNAL DEPOSITORY TENDER HISTORY
IMPRESSION EVENT TYPE
RETAIL TENDER HISTORY DERIVED
TRANSFER IN OUT DOCUMENT
|Logical Data Model Entities Removed||CATALOG REQUEST TYPE
CHECK IN TYPE
CODE DETAIL CUSTOMER ORDER MANAGEMENT
COST VALUATION LEDGER ACCOUNT
CUSTOMER ORDER HOLD EVENT
ICD LINE ITEM ASSIGNMENT REASON
ICD LINE ITEM ASSIGNMENT TYPE
LIST QUICK FACTS
PHYSICAL COUNT TRANSACTION
PRICING ITEM LOCATION DAY
PROMOTION COST CONTRIBUTION WEEK AGGR
PROMOTION SALES MARGIN WEEK AGGR
PROMOTION TRIGGER TYPE
RETAIL MARKDOWN DEPARTMENT DAY AGGR
RETAIL MARKDOWN DEPARTMENT WEEK AGGR
RETAIL MARKDOWN ITEM DAY AGGR
RETAIL MARKDOWN ITEM WEEK AGGR
RETAIL TENDER HISTORY
RETAIL VALUATION LEDGER ACCOUNT
RETURN AND TRANSFER IN OUT DOCUMENT
STOCK LEDGER SUBCLASS MONTH AGGR
STOCK LEDGER SUBCLASS WEEK AGGR
TENDER CONTROL TYPE
VENDOR CONTRACT ITEM DAY AGGR
|Support for additional measures and new reports||Many reports are updated and improved for this release.|
Oracle Retail Data Model Release 11.3.1 includes the following new features:
|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:
|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:
|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.|
The following are Oracle Retail Data Model known issues:
Before installing Oracle Retail Data Model you need to obtain the appropriate OLAP C Patch for your platform and install the OLAP C patch for Oracle Database 188.8.131.52.0.
Do the following to obtain and install the OLAP C patch:
To obtain the appropriate patch for your platform, go to My Oracle Support at
Go to Patches & Updates tab, Search for Patch Number 15928745 and select Enter. Choose the patch 15928745 with Description "OLAP A PATCH FOR 184.108.40.206.0 (Patch)" and also choose the Platform from available choices and download the patch.
Unzip the patch and follow the installation in the readme file to install the patch.
The Unit of Measure (UOM) functionality is not supported in Oracle Retail Data Model Release 11.3.1.
There is no workaround for this issue.
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.
There is no workaround for this issue.
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.
There is no workaround for this issue.
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.
Oracle Retail Data Model is missing a program to manually execute the Intra-ETL.
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".
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:
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;
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.
During Oracle Retail Data Model Installation, when running the installer the dialog "Specify Partition Information" contains incorrect help text for the following field:
Interval Partition Start *(YYYY-MM-DD)
For the fields in this dialog, the help text should be:
Interval Partition Start Date: Specify the interval partition start date, which is used for creating initial interval partitions on base tables, derived tables, and aggregate materialized views. The interval partitions are the first level partitions.
Number of Hash Paritions for Business Unit Key: Specify the number of second level partions created for business unit key.
Number of Hash Partitions for SKU Item Key: Specify the number of second level partions created for SKU item key.
Also, the first paragraph on the help screen for "Specify Partition Information" dialog should be:
Specify the interval partition start date, which is used for creating initial interval partitions on base tables, derived tables, and aggregate materialized views. The interval partitions are the first level partitions.
In Install type dialog, the bubble help icon for all fields shows, "Specify Oracle Retail Data Model Installation Location information".
Refer to the Oracle Retail Data Model Installation Guide for details on the fields in this dialog.
The Oracle Retail Data Model documentation includes the following books:
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at
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.2
Copyright © 2012, 2013, 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.