Go to primary content
Oracle® Retail Data Extractor for Merchandising Release Notes
Release 15.0.2
E91621-01
  Go To Table Of Contents
Contents

Previous
Previous
 
 

Oracle® Retail Data Extractor for Merchandising

Release Notes

Release 15.0.2

E91621-01

December 2017

This document highlights the major changes for 15.0.2 of Data Extractor for Merchandising.

Overview

Data Extractor for Merchandising (ORDE) is packaged within the Oracle Retail Integration Bus (RIB) product suite. It provides packaged data extraction capabilities for sourcing data from the Oracle Retail Merchandising System (RMS) into a flat file format that facilitates loading into the Oracle Retail Merchandising Insights Cloud Service application or the Oracle Retail Merchandising Insights on-premise analytic application.

The Oracle Retail Data Extractor for Merchandising provides the functionality to integrate with RMS and extract data in ORDE staging tables and then unload the data into the respective flat files for Oracle Retail Insights consumption.

The primary characteristics of the Oracle Retail Data Extractor for Merchandising are:

  • Source Integration Solution: The Retail Data Extractor provides data integration with source applications such as RMS and Retail Price Management (RPM).

  • Performant ETL Code: The Retail Data Extractor data processing tool, Oracle Data Integrator (ODI), offers high performance for the database batch processes on an Oracle database.

  • Extensibility: The Retail Data Extractor ETL code can be customized and extended for client-specific needs.

Hardware and Software Requirements

See the Oracle Retail Data Extractor for Merchandising Installation Guide, Release 15.0.2 for information about the following:

  • Hardware and software requirements

  • Oracle Retail application software compatibility

Applying the Patch Release

Before applying the ORDE 15.0.2 patch release, be sure that:

  • ORDE 15.0 has been installed

Before applying the patch release over your files:

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

  • 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, 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


Note:

The user interface (UI) of this application was developed using the Oracle Application Development Framework (ADF). Because the resulting code is closed to modification, defect documents are not being provided for this line of code. For additional information, contact Customer Support.

Noteworthy Defect Fixes

The following defect fixes and enhancements are included in ORDE 15.0.2. This is not a complete list; see the cross-reference spreadsheet and defect reports for a complete list and full details.

Table 1 Noteworthy Defect Fixes

Defect Number Summary

25307995

Coupon number length changes in RESA. Same need to be reflected in RDE.

25664435

RI batch SLSITSDE.KSH fails with error when the ITEM_TYPE is GCN.

25893910

INTEGRATION_ID value not populated correctly.

25894490

Retail Insights job Supplier Invoice Match Fact duplicating data for each currency exchange rate.


Supplemental Training

The following documents are available through My Oracle Support. Access My Oracle Support at the following URL:

https://support.oracle.com

Transfer of Information (TOI) Material (ID 732026.1)

For applicable products, online training is available to Oracle supported customers. These online courses provide release-specific product knowledge that enables your functional and technical teams to plan, implement and/or upgrade and support Oracle Retail applications effectively and efficiently.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. 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.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

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 Data Extractor for Merchandising Release Notes, Release 15.0.2

E91621-01

Copyright © 2017,D:\RDE for Merchandising\15.0.2\AppData\Local\Temp\xml\insets\holder_ak.xml

D:\RDE for Merchandising\15.0.2\AppData\Local\Temp\xml\insets\licwarrantnotice_ak.xmlD:\RDE for Merchandising\15.0.2\AppData\Local\Temp\xml\insets\restrictedrightslegend_ak.xmlD:\RDE for Merchandising\15.0.2\AppData\Local\Temp\xml\insets\hazardnotice_ak.xmlD:\RDE for Merchandising\15.0.2\AppData\Local\Temp\xml\insets\trademarknotice_ak.xmlD:\RDE for Merchandising\15.0.2\AppData\Local\Temp\xml\insets\webcontentnotice_ak.xml

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.