Oracle® Retail Data Extractor for Merchandising

Release Notes

Release 15.1

E78221-01

July 2016

This document highlights the Release 15.1 of Oracle Retail Data Extractor for Merchandising.

Overview

Oracle Retail Data Extractor for Merchandising (ORDE) is a new product offering packaged within the Oracle Retail Integration Bus (RIB) product suite that 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 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.

In the 15.1 release of this product there are numerous additional integrations supporting the following new or improved Oracle Retail Insights functionality:

Purchase Order Data Area
Flexible Financial Planning including Company and Location level planning
Comparative Store Designation
Coupon Data
Gift Card Data
Tender Information for Sales Transactions

The additional integration tables are listed below:

W_RTL_ALC_DETAILS_DS - Purchase Order Allocation Information
W_RTL_BUYER_DS - Buyer Information
W_RTL_PO_DETAILS_DS - Purchase Order Details
W_RTL_PO_ONALC_IT_LC_DY_FS - Purchase Order Allocated Information
W_RTL_PO_ONORD_IT_LC_DY_FS - Purchase Order Information
W_RTL_MFPCP_PROD1_LC1_T1_FS - Current plan configuration 1
W_RTL_MFPCP_PROD2_LC2_T2_FS - Current plan configuration 2
W_RTL_MFPCP_PROD3_LC3_T3_FS - Current plan configuration 3
W_RTL_MFPOP_PROD1_LC1_T1_FS - Original plan configuration 1
W_RTL_MFPOP_PROD2_LC2_T2_FS - Original plan configuration 2
W_RTL_MFPOP_PROD3_LC3_T3_FS - Original plan configuration 3
W_RTL_CFPCP_LC_DY_FS - Company current plan
W_RTL_LFPCP_LC_DY_FS - Location current plan
W_RTL_MFP_PROD_DH_G - Planning hierarchy configurations table
W_RTL_GCN_TRX_LC_DY_FS - Sales transactions for purchasing "gift cards"
W_RTL_STTRFC_LC_DY_MI_FS - Store traffic data
W_INT_ORG_ATTR_DS - New store flag, Remodel store flag
W_RTL_LOC_COMP_MTX_DS - Comp store designations
W_RTL_COUPON_DS - Coupon dimension information
W_SLSDSC_TRX_IT_LC_DY_FS - Sales transaction discount / coupon information
W_RTL_TRX_TNDR_LC_DY_FS - Sales transaction tender information

Hardware and Software Requirements

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

Hardware and software requirements
Oracle Retail application software compatibility

Previous Releases

For information on previous Oracle Retail Data Extractor for Merchandising release enhancements and additional information, refer to the release notes and documentation that accompany the previous releases.

D:\RDE\15.1\AppData\Local\Temp\xml\insets\accessibility_statement_ak.xml

Oracle® Retail Data Extractor for Merchandising Release Notes, Release 15.1

E78221-01

D:\RDE\15.1\AppData\Local\Temp\xml\insets\licwarrantnotice_ak.xmlD:\RDE\15.1\AppData\Local\Temp\xml\insets\restrictedrightslegend_ak.xmlD:\RDE\15.1\AppData\Local\Temp\xml\insets\hazardnotice_ak.xmlD:\RDE\15.1\AppData\Local\Temp\xml\insets\trademarknotice_ak.xmlD:\RDE\15.1\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.

Oracle® Retail Data Extractor for Merchandising

Overview

Hardware and Software Requirements

Related Documentation

Previous Releases