Oracle® Retail Merchandising System

Release Notes

Release 16.0.1

E88025-02

July 2018

Oracle Retail Merchandising System (RMS) Release 16.0.1 is a patch release for RMS 16.0. RMS 16.0.1 includes selected defect fixes and enhancements for RMS 16.0 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 Defect Fixes and Documentation

n Functional Enhancements

n Technical Enhancements

n Integration Enhancements

n RMS Noteworthy Defect Fixes

n Oracle Retail Sales Audit (ReSA)

n Documentation Accessibility

Overview

Oracle Retail Merchandising System (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.

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 New and updated guides (for example, operations and user guides) that apply to the patch release level.

n Defect reports for new fixes and enhancements for the patch release.

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 16.0.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 16.0.1 patch release, be sure that:

n RMS 16.0 has been installed.

n ReSA 16.0 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.

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) that is posted to My Oracle Support at the following location: Oracle Retail Defect Document Listings (MOS ID:2021275.1).

In the same folder, the file named DEFECT MODULE XREF RMS 16.0.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.

Functional Enhancements

The following key functional enhancements are included in this release.

Using Xitem

The flexibility to send Item Supplier Country Location records through Xitem in Release13.2 was not extended to the Item induction functionality in Release16.0. Instead in Release16.0, the behavior of defaulting all available locations for each Item-Supplier Country record was implemented for the induction-based uploads thus making the behavior in sync with the UI. Some customers, who used RMS as a slave system had raised a concern that the defaulting of all locations for XItem based uploads proved to be a performance concern especially with the need to make tax calls for each location. This enhancement provides this flexibility in the latest release.

RETL Extract Scripts for RPAS

RETL extract scripts RMSE_MFP_INVENTORY.KSH and RMSE_MFP_ONORDER.KSH are not extracting data correctly. This enhancement ensures that the RMSE_MFP_INVENTORY.KSH script extracts data using local currency instead of extracting data using primary currency.

Item Seasons Information Through Item Induction

The uploading of Item Seasons through Xitem was not introduced in the Induction functionality. However, this enhancement has been introduced in this release through a 'Item Seasons' tab in the Induction template as part of the uploading and downloading process.

Data Loading

For all entities managed by the Data Upload/Download process (formerly called Admin APIs), updates have been made to increase the usability of this functionality.

n The 'Success' messages displayed have been removed on successfully submitting an upload process as this was confusing to the user. It implied that their upload was successful, and that was not necessarily the case.

n Added notifications for failures for data uploads using this process, similar to those that have been added for item, cost change, and PO. The notification should have a link to the process tracker so that you can identify the error and make the corrections.

Sales Processing from Non-RPM Promotions

Sales upload processing has been modified to allow non-RPM promotional sales to be correctly classified. Today, in Retail Sales Audit (ReSA) the promotion type used is 9999 (from CODE_TYPE PRMT on CODE_DETAIL) to mean a non-RPM promotion. In RMS, there are some processing tied to this same code type related to employee discounts, in store discount, and off retail - but not for 9999 so, although it properly records the promo markdown to TRAN_DATA, it does not classify the sales as promotional on ITEM_LOC_HIST, even though it is being declared as such.

On further investigation, it was observed that promotion type 9999 is meant to be RPM promotions. Some existing clients use promotion type 2000 (DTC promotion) as non-RPM promotion. For this requirement, the system now uses 2000 for non-PRM promotion and update the code description accordingly. RPM (9999) and non-RPM (2000) promotions should behave the same way, including writing the same TRAN_DATA records with a SALES_TYPE of 'P' (promotion) and writing ITEM_LOC_HIST with a SALES_TYPE of 'P' (promotion). The only difference is RPM promotions will have an added step of validating the Promotion Number/Promotion Component in TDETL against the RPM_PROMO_COMP table. NULL is not a valid Promotional Tran Type in TDETL. Hence, the transaction will be rejected.

Promotion types 1004 (In Store Discount), 1005 (Employee Discount), and 1006 (Off Retail) should not be classified as promotional sales on TRAN_DATA.SALES_TYPE and on ITEM_LOC_HIST.SALES_TYPE. Promotion types 1004 and 1006 will write TRAN_DATA 15 (Promotional Markdown) with SALES_TYPE of 'R' (regular). Promotion type 1005 will write TRAN_DATA 60 (Employee Discount).

Reinstate POSCDNLD Batch with Modifications

To streamline the system, the POS Configuration download batch process was removed in Release 16.0. However, given that two of the POS configurations (Coupons and Product Restrictions) remain part of RMS, this program is needed in order to communicate the information from RMS to the POS. The program will need to have other POS configurations, such as money orders and tender types, removed. Only coupon and product restrictions should remain.

Coupon Criteria Defects

When adding items to a coupon, the Merchandise Criteria screen is used. The following two issues are addressed:

n The label when accessing this screen from the coupon screen is incorrect. It should read "Criteria for Coupon". However, it currently states 'Criteria for Restriction'.

n In this release, an option was added to refresh dynamic item lists when selected as criteria to ensure the latest items are added to the list. Default the check box to refresh (checked).

Changing the Exchange Rate

The estimated landed cost (ELC) calculation was not appearing correctly on the PO screen because there were issues with the conversion of the estimated expenses and assessments. There were some inconsistencies in the logic for getting the currency rate for conversation that was causing ELC to be computed incorrectly for those cases where order currency code was different than the component currency which used for both duty and expanses. This enhancement addresses this issue.

Technical Enhancements

The following technical enhancement is included in this release.

Automated Test Scripts

Oracle Retail Merchandising Test Automation, while not part of the supported RMS application itself, is a tool that is intended to help customers with 'regression testing' patches and upgrades of RMS. This solution also provides a starting point for retailers to develop their own automation tests.

These scripts are provided free of charge to all retailers who have an RMS license and have licensed the Oracle Application Test Suite (OATS).

For more information on downloading and configuring these scripts and for detailed documentation about this solution, see the Oracle Test Starter Kit Accelerator Scripts at:

http://www.oracle.com/technetwork/oem/downloads/index-084446.html

Integration Enhancements

The following integration enhancements are included in this release.

EDIDLINV Job

EDIDLINV job picks up the non-merchandising invoices and writes them to a flat file for ReIM. The currency exchange rate in the flat file was being rounded to 4 digits after decimal point even though RMS supports up to 10 digits for currency rates. Hence, this bug modified the program so as to support EXCHANGE_RATE up to 10 decimal places.

Rolling up the Dept/Class/Subclass Issues for Warehouse (WH)

Oracle Retail Allocation must have dept level issues for the destination WH at history level. But DEPT_SALES_HIST does not have WH information. It just stores the store level information.

Similarly WH level issues are missing in CLASS_SALES_HIST and SUBCLASS_SALES_HIST tables as well. Currently the dept level history is disabled for WH-WH based allocation. So, currently in the allocation policy screen the dept option is not available for WH destination.

This enhancement is based on the approach of creating materialized views at subclass level by joining from ITEM_LOC_HIST and adding dept/class/subclass columns from to this table that include both store sales and warehouse issues that could be used by Allocation.

RMS Noteworthy Defect Fixes

The following RMS noteworthy defects are fixed in this release:

Defect	Description
24678092	SALMTH does not calculate Cumulative Markon percentage (CMO) properly in exception scenarios.
25873612	Stock on hand is copied as physical count for a warehouse stock count.
25740801	Item search issues.
25773963	Problematic item master View Object (VO) main query leads to high memory consumption.
24286110	Supplier created in EBS, saved in RMS, sends PRIMARYADDRIND as N to SIM AND WMS.
24329784	Standard unit retail is incorrectly populating for child items.
24444738	Cannot create PO-LEVEL TRANSP with separate containers for multiple HTS items.
24470908	PROMO retail has not been updated in PRICE HIST after clearance reset of item in PROMO.
24665749	Input retail price staged in SVC_XITEM_RIZP is not loaded in RPM_ITEM_ZONE_PRICE.
24713690	SOH (stock on hand) is updated incorrectly at the WH after the incorrect item is received for an ALLOC.
25929043	Items with new cost as null are not deleted from cost change on save and close.
24946880	Standard UOM created incorrectly using XITEM API.
25345674	Item Induction - Create single/multiple items with Customer Flexible Attributes (CFA) ends with errors.
25364843	RMS application hangs when trying to create a new supplier in the UI form.
25726586	ADMIN_API_PURGE batch is not purging RMS data loading records.
25823628	CMO Variance Report - Issue with in context launch to stock ledger search.
25834305	Incorrect errors while uploading to STAGE and RMS tables during PO induction.
24916194	Inventory Control Dashboard - User roles and PRIVS issues.
25437142	Stock count value variance - GUI issues.
25882417	Oracle Retail item number sequence for item creation is skipping numbers.

Oracle Retail Sales Audit (ReSA)

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

Integration Enhancement

The following integration enhancement is included in this release.

Supporting RTLOG

ReSA historically had the ability to hold a 40 character coupon ID. It was the RTLOG that was limited to 16 digits for coupon details and when the customer had a valid business need for 18 digits for coupon. Due to this issue, users could not load more than 16 digits for coupon number. The bug has been fixed to support RTLOG to hold 40 character coupon ID.

ReSA Noteworthy Defect Fixes

The following ReSA noteworthy defects are fixed in this release:

Defect	Description
24007646	SA_EXPORT_LOG entry is missing for reloaded store/day.
24805093	Unable to add realms to a total in a particular order.
25191211	Transaction audit trail not showing updated/corrected amounts via transaction maintenance.
25268263	ReSA considers rollover or reset as MISSING_TRAN_BIG_GAP.
25823643	In context launch from Open Store Days report into Store Day Search is not working properly.
25828209	Template displays wrong data in the template type screen.
23533077	SAIMPTLOGI batch uploads a transaction with wrong UOM_QUANTITY IN SA_TRAN_DISC.
25907683	Upload template list has incorrect values.

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 16.0.1

E88025-02

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.