Oracle Retail Merchandising System Release Notes

Oracle® Retail Merchandising System

Release Notes

Release 14.1.1

E63825-01

May 2015

Oracle Retail Merchandising System (RMS) Release 14.1.1 is both a patch release available on My Oracle Support and a full release for new customers available on the Oracle Software Delivery Cloud 14.1. RMS 14.1.1 includes selected defect fixes and enhancements for RMS 14.1 code.

Oracle Customer Support investigates submitted issues assuming that all released updates have been applied. It is the customer's decision when to apply a new release; however, delays in applying updates can complicate the support process.

This document contains the following topics:

n Overview

n About Patch Releases

n Hardware and Software Requirements

n Applying the Patch Release

n Running Scripts

n Functional Enhancements

n Technical Enhancements

n Integration Enhancements

n Documentation Enhancements

n RMS Defect Fixes and Documentation

n RMS Noteworthy Defect Fixes

n RMS Related Documentation

n Oracle Retail Sales Audit (ReSA)

n Documentation Accessibility

Overview

RMS is used to execute core merchandising activities, including merchandise management, inventory replenishment, purchasing, vendor management, and financial tracking.

Oracle Retail Sales Audit (ReSA) provides the tools to evaluate point-of-sale data to ensure the accuracy and completeness of information exported to downstream systems used in optimization processes, financial reporting, and analysis.

As part of the Oracle Retail Merchandising Operations Management (MOM) product suite, Oracle Retail Fiscal Management (ORFM) Release 14.1.1 is the Brazil localization solution for the market. ORFM is the first standalone release with its own Release Notes.

ORFM enables retailers to operate in Brazil, receiving and shipping merchandise with a Nota Fiscal (NF). As part of the Oracle Retail portfolio, ORFM integrates with RMS, Oracle Retail Store Inventory Management (SIM), and Oracle Retail Warehouse Management System (WMS). This solution covers localization of end to end merchandising and supply chain processes, as well as financial integration, for retailers in Brazil.

About Patch Releases

Oracle Retail patch releases are periodic releases that can include the following:

n New defect fixes

n Product enhancements

n Technical upgrades

Documentation for patch releases includes the following:

n Updated guide (for example, Data Model) that applies to the patch release level.These documents include applicable updates made since the last release. See RMS Related Documentation for a list of the documents published for RMS 14.1.1.

n Defect reports for new fixes.

Note

Customers must apply the entire patch release to update their installation to the currently supported level.

See the Oracle Retail Merchandising System Installation Guide and Oracle Retail Sales Audit Installation Guide for Release 14.1.1 for instructions about how to apply the defect fixes and enhancements that you have not already applied.

Hardware and Software Requirements

See the Oracle Retail Merchandising Installation Guide and Oracle Retail Sales Audit Installation Guide for additional information about the following:

n Hardware and software requirements

n Oracle Retail application software compatibility

Applying the Patch Release

Before applying the RMS 14.1.1 patch release, be sure that:

n RMS 14.1 has been installed.

n ReSA 14.1 has been installed.

Before applying the new files over your code:

n Note whether any modules have been customized. If so, the customizations must be reapplied to the new version of the module, or the fix may need to be applied to the custom version of the code.

n Copy the original files to a different directory before you copy over them, in case you need to refer to them at a later date.

Running Scripts

Back up data before running any script, because the scripts provided do not preserve data. See defect reports for details.

Check with your database administrator to determine whether your database should be analyzed after a script is run. In many cases, an analysis of the database is necessary to take advantage of new or modified indexes intended to improve performance of the application.

Functional Enhancements

The following functional enhancements are included in Oracle Retail Merchandising System Release 14.1.1:

Defect Number

Summary

21066091

Customer Order Fulfillment:

With Commerce Anywhere, the Oracle Retail Merchandising Operations Management (MOM) product suite supports retailers in end-to-end processing of orders placed in different channels and fulfilled through the supply chain, whether it is a store, warehouse, or vendor.

In Brazil, these variations of sourcing and fulfillment may require one or more Nota Fiscal (NF) documents. Oracle Retail Merchandising System (RMS) is enhanced to meet these Brazil localization requirements for the customers, enabling Brazilian retailers to fulfill customer orders.

Customer Information

Customer orders are created and managed in systems outside the Oracle Retail MOM product suite, but the Oracle Retail Merchandising System (RMS) plays an important role in ensuring that the information needed to create that order is available and accurate. This includes Foundation Data (Hierarchies, Locations, and so on), Inventory Availability, Liability Capture, and Back Orders.

To fulfill a customer order in Brazil, Fiscal Attributes from the customer are required upon order capture to ensure that taxes are correctly calculated and NFs are correctly created. Customer orders created through Online Order capture or in store through the Point-of-Service (POS) terminal must collect additional customer information and pass it to RMS. Customer order integration is enhanced to receive this additional information, from both individual and corporate taxpayer customers.

20605214

Fulfillment Order Number is missing in the EDIDLORD batch.

The EDI file sent to the customer, which had the Customer Order Number, does not have the Fulfillment Order Number in the file. One Customer Order can be associated with multiple Fulfillment Order Numbers, and not having this field would make it impossible to associate the vendor shipment notification.

Changes are made in the TORDR line in the EDI file, to include the Fulfillment Order Number, following the Customer Order Number field.

Technical Enhancements

This section addresses the technical enhancements included in Oracle Retail Merchandising System, Release 14.1.1.

Note

The list below announces the addition of Oracle Retail support for the technology described. See the Installation Guide requirements section for critical information, such as whether the enhancement below replaces previous versions or is supported in addition to already existing versions.

Database Server Support

Oracle Retail Merchandising System (RMS) Release 14.1.1 is supported for use with the following database server:

n Oracle Database Enterprise Edition 12.1.0.2

Browser Support

Oracle Retail Merchandising System (RMS) Release 14.1.1 is certified for use with the following browser:

n Mozilla Firefox 31

Java Support

The client of Oracle Retail Merchandising System (RMS) Release 14.1.1 is supported for use with the following Java version:

n Oracle Java 7 update 75

Integration Enhancements

The following integration enhancements are included in Oracle Retail Merchandising System Release 14.1.1:

Defect Number	Summary
20639657	There are no placeholders to enter the ADJUSTMENT_TYPE and ADJUSTMENT_VALUE while creating the transfer through XAPI. When an Intercompany transfer (IC) is created using RMS transfer screen, the Transfer Price Adjustment Type and Adjustment Value are required. The transfer price is calculated based on the Transfer adjustment type and value. However, currently when EG transfers are created using RIB X-transfer API, there are no placeholders for the transfer price adjustment type and the value, hence the transfer price is not calculated. This is because the intercompany transfers were assumed to not be part of the original scope of the x-Transfer functionality, which was assumed to be more of an exception scenario. However, the scope of this integration point has grown over the years since it was first implemented and the ability to specify the transfer price in the integration has been requested by multiple customers. This enhancement primarily addresses this issue by allowing Transfer Price Adjustment Type and Adjustment Value, to be specified for IC type of transfers, and populating the transfer price based on these values.
20771918	The Non Vendor Funded Items is inherited in RMS VFP deal, when the promotion is approved. When the Oracle Retail Price Management (RPM) links a VFP deal to a RPM promotion component, the deal applies for all items in the promotion component. Due to this, the Non-Vendor Funded items also inherits the VFP deal when the linked RPM promotion has both the Vendor funded items and non-Vendor Funded items in the promotional component. This enhancement addresses the issue by introducing the RPM_DEAL_IND flag. Based on this flag, an additional validation is done for the items, in the promotion component linked with the VFP deal. If the RPM links the VFP deal created by RMS for the promotion component, RMS validates the deal, item, location, and combination along with the existing deal promotion component validation. If the RPM links the VFP deal created by RPM for the promotion component, RMS validates the item, supplier, location, and combination along with existing deal promotion component validation, and based on the assumption of all items from the same supplier it will not be part of the deal.
20672729	The STOREDEL is not published to the RIB. The Store Publish Interface from RMS is modified to send the Store Type (Company or Franchise) and Stock Holding Indicator to the Store Delete message. Hence, RIB TAFR utilizes these attributes, instead of the Routing information, to decide on how the message has to be routed. The RMS will now no longer be sending any routing information to the Store Publish messages.

Documentation Enhancements

The following documentation enhancements are included in Oracle Retail Merchandising System Release 14.1.1:

Oracle Retail High Availability Case Study 14.1 (ID 1666048.1)

This document describes the steps to configure a highly-available Oracle Linux based environment to support Oracle Retail applications. Using Oracle Fusion Middleware active-active clustering and Oracle Real Application Clusters (RAC) databases, you can deploy Oracle Retail applications to provide high availability and scalability. This case study includes the following documents:

n Oracle Retail 14.1 High Availability Case Study Introduction

n Oracle Retail 14.1 High Availability Case Study Oracle Linux

n Oracle Retail 14.1 High Availability Case Study RAC (Real Application Clusters Environment)

n Oracle Retail 14.1 High Availability Case Study Fusion Middleware Cluster (Part 1 and 2)

For more information on configuring single sign-on, review the Oracle Retail 14.1 High Availability Case Study Fusion Middleware Cluster (Part 2).

RMS Defect Fixes and Documentation

A defect fix is a modification to the base Oracle Retail code (for example, a bug fix, a performance enhancement, or a functional enhancement). Each defect fix that is included in this patch has a corresponding defect report titled <defect-number>.PDF (for example, 1234567.PDF).

In the same folder, the file named DEFECT MODULE XREF RMS 14.1.1.XLS lists every defect number and the modules and scripts that are included in the patch. Review each defect report carefully before implementing the defect fixes. Note that scripts do not preserve data. Make sure that all data is backed up before you run any script.

RMS Noteworthy Defect Fixes

The following RMS noteworthy defects are fixed in this release:

Defect	Description
20639657	While creating externally generated transfers, there are no placeholders to enter values for ADJUSTMENT_TYPE and ADJUSTMENT_VALUE.
20771918	Non-vendor funded items inherit RMS Vendor Funded Promotion (VFP) deal on approval of promotion.
20605214	A Fulfillment Order Number is missing in the EDIDLORD program.
20711930	When a late transfer/allocation shipment message (for a pack item) is posted to RMS such that a stock count already exists against the shipping warehouse, the TRAN_DATA table has two records with TRAN_CODE 22 for the same item-warehouse combination.
20736474	ELC_ITEM_SQL.RECALC_COMP calculates Item Assessments for the wrong country.
20694551	Error when creating Direct to Store Purchase Order (PO) with location in Puerto Rico.
20687365	TRAN CODES 31 and 33 are not posted to STG_FIF_GL_DATA table.
20679863	The FUTURE_COST.NET_COST column does not get properly updated after an item undergoes cost change.
20058406	Area Differentials are not applied in Retail by Zone window.
20049222	You are unable to change the invoice processing logic of a complex deal that is in an Active state.
20511894	The system generates duplicate Cost Changes on IM_RECEIVER_COST_ADJUST.
20651940	Incorrect PO receipt proration is generated to all virtual warehouses for a new item in the PO.
20598405	Total Cost of import PO is calculated incorrectly during receiving using PO Exchange Rate.
20591478	SAEXPDW batch job handles post voids incorrectly.
20590446	When Multi-channel is turned on, the EDIDLORD batch does not sum up all quantities to the Physical Warehouse level for an order before writing it to the output file.
20406135	Oracle Retail Invoice Matching (ReIM) displays incorrect error message and you are unable to proceed when creating Merchandising invoice.
20701942	Incorrect data is displayed in the TRAN_DATA table for Store when wrong Store Receipt with Allocation up charges is generated.
20691204	SAEXPRMS batch file ignores discount line items when creating POSU files for RMS to consume.
20711922	Replenishment for PO does not consider on-order quantities.
20767996	Receiver Unit Adjustment causes a prior obligation to finalize and posts an incorrect Total Cost.

RMS Related Documentation

For more information, see the following documents in the Oracle Retail Merchandising System release 14.1.1 documentation set:

n Oracle Retail Merchandising System with Brazil Localization Installation Guide

n Oracle Retail Merchandising System Operations Guide

n Oracle Retail Merchandising System Reports User Guide

n Oracle Retail Merchandising System User Guide and Online Help

n Oracle Retail Merchandising System Custom Flex Attribute Solution Implementation Guide

n Oracle Retail Merchandising System Data Model

n Oracle Retail Merchandising System Data Access Schema Data Model

n Oracle Retail Merchandising Security Guide

n Oracle Retail Merchandising Implementation Guide

n Oracle Retail Merchandising Data Conversion Operations Guide

n Oracle Retail Merchandising Batch Schedule

n Oracle Retail POS Suite/Merchandising Operations Management Implementation Guide

n Oracle Retail Sales Audit documentation

n Oracle Retail Trade Management documentation

n Oracle Retail Fiscal Management documentation

Oracle Retail Sales Audit (ReSA)

Oracle Retail Sales Audit (ReSA) Release 14.1.1 is a patch release for ReSA 14.1 and includes selected defect fixes and enhancements for ReSA 14.1 code.

Technical Enhancements

This section addresses the technical enhancements included in Oracle Retail Sales Audit, Release 14.1.1.

Note

Database Server Support

Oracle Retail Sales Audit (ReSA) Release 14.1.1 is supported for use with the following database server:

n Oracle Database Enterprise Edition 12.1.0.2

Browser Support

Oracle Retail Sales Audit (ReSA) Release 14.1.1 is certified for use with the following browser:

n Mozilla Firefox 31

Java Support

The client of Oracle Retail Sales Audit (ReSA) Release 14.1.1 is supported for use with the following Oracle Java version:

n Oracle Java update 75

ReSA Noteworthy Defect Fixes

The following ReSA noteworthy defects are fixed in this release:

Defect	Description
20057119	When the contextual pane size on the Store day Summary window is increased, the fields in the ReSA window begin to overlap (scrunch).
20346156	The ReSA application checks client locations for the availability of the OBIEE. If not found, the contextual pane is removed altogether.
20058522	When a transaction is opened for edits and if by chance the tab is closed using the Close button, the session locks for hours.
20883689	Store/Day cannot be changed to Worksheet status after DCLOSE transaction.

ReSA Related Documentation

For more information, see the following documents in the Oracle Retail Sales Audit release 14.1.1 documentation set:

n Oracle Retail Sales Audit Installation Guide

n Oracle Retail Merchandising System Documentation

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 that have purchased support 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 Merchandising System, Release 14.1.1

E63825-01

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, then 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 about 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 unless otherwise set forth in an applicable agreement between you and Oracle. 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, except as set forth in an applicable agreement between you and Oracle.

Licensing Note: This media pack includes a Restricted Use license for Oracle Retail Predictive Application Server (RPAS) - Enterprise Engine to support Oracle® Retail Analytic Parameter Calculator for Regular Price Optimization only.

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 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.

(ii) the Wavelink component developed and licensed by Wavelink Corporation (Wavelink) of Kirkland, Washington, to Oracle and imbedded in Oracle Retail Mobile Store Inventory Management.

(iii) 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.

(iv) 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.

You acknowledge and confirm that Oracle grants you use of only the object code of the VAR Applications. Oracle will not deliver source code to the VAR Applications to you. Notwithstanding any other term or condition of the agreement and this ordering document, you shall not cause or permit alteration of any VAR Applications. For purposes of this section, “alteration” refers to all alterations, translations, upgrades, enhancements, customizations or modifications of all or any portion of the VAR Applications including all reconfigurations, reassembly or reverse assembly, re-engineering or reverse engineering and recompilations or reverse compilations of the VAR Applications or any derivatives of the VAR Applications. You acknowledge that it shall be a breach of the agreement to utilize the relationship, and/or confidential information of the VAR Applications for purposes of competitive discovery.

The VAR Applications contain trade secrets of Oracle and Oracle's licensors and Customer shall not attempt, cause, or permit the alteration, decompilation, reverse engineering, disassembly or other reduction of the VAR Applications to a human perceivable form. Oracle reserves the right to replace, with functional equivalent software, any of the VAR Applications in future releases of the applicable program.