Oracle Retail Invoice Matching Cloud Service

Release Notes

Release 16.0

 

E85979-01

March 2017

This document introduces Oracle Retail Invoice Matching Cloud Service 16.0.

Overview

Oracle Retail Invoice Matching Cloud Service supports the verification of merchandise invoice costs, quantities and taxes prior to payment. ReIM receives invoice data through Electronic Data Interchange (EDI), an Induction process, or from invoices manually entered through a group or single invoice entry facility. Invoice records are verified against associated purchase orders and receipts in an automated matching process.

If invoices are matched to receipts within retailer defined tolerance at a summary, parent, or item level, they are evaluated for best payment terms and posted to a staging table. The staging table is interfaced with the retailer's accounts payable system, where payments are processed and corresponding accounting entries are posted.

If invoices and receipts are not matched after a specified period of time, the auto-matching process flags the invoice with cost or quantity discrepancies. Users can then begin a manual identification of summary and detail-level matches or individually resolve item-level discrepancies. Discrepancies are resolved by applying reason codes based on a set of defined actions (for example, charge-back supplier) that determine the disposition of the discrepancies.

Note

The Merchandising Cloud Services are based on corresponding on-premises applications. References to the on-premises application names exist throughout the Merchandise Cloud Services applications and documents.

 

Oracle Retail Cloud Services and Business Agility

Oracle Retail Invoice Matching Cloud Service is hosted in the Oracle Cloud with the security features inherent to Oracle technology and a robust data center classification, providing significant uptime. The Oracle Cloud team is responsible for installing, monitoring, patching, and upgrading retail software.

Included in the service is continuous technical support, access to software feature enhancements, hardware upgrades, and disaster recovery. The Cloud Service model helps to free customer IT resources from the need to perform these tasks, giving retailers greater business agility to respond to changing technologies and to perform more value-added tasks focused on business processes and innovation.

Oracle Retail Software Cloud Service is acquired exclusively through a subscription service (SaaS) model. This shifts funding from a capital investment in software to an operational expense. Subscription-based pricing for retail applications offers flexibility and cost effectiveness.

Client System Requirements

The following technology is supported:

n        Operating Systems

-           Microsoft Windows 7

-           Microsoft Windows 10

n        Browser Support

-           Mozilla Firefox ESR 45

-           Internet Explorer 11.0

-           Google Chrome (Desktop) 48+

Functional Enhancements

The following were functional enhancements for the on-premises 16.0 version of Oracle Retail Invoice Matching. They are provided here for reference purposes.

Invoice Induction

Invoice induction enables the user to upload documents into ReIM using a spreadsheet format through the use of customizable templates. Invoice induction handles most types of ReIM documents including merchandise invoices, debit memos, credit memos, credit note requests, credit notes, and non-merchandise invoices.  

The Invoice induction process engages the same validation that is used in the online manual entry of documents. 

Key features of this option include:

n        The ability to download a blank template that can be used to upload documents back into ReIM.

n        An 'Upload' asynchronous process that sends a notification when the process is completed.

n        An option to review the status of uploaded files, which includes the following:

-           Ability to view errors

-           Option to download errors into a spreadsheet which can be fixed and used to resubmit the upload.

Unmatching Invoices

The ReIM system now supports the ability to unmatch a matched or partially-matched invoice.

Unmatching a partially matched invoice is supported as part of the detail match dialog.

Unmatching a fully matched invoice is initiated from the match inquiry screen.

If an invoice that was part of a summary match is unmatched, all invoices included in the summary match are also unmatched. Receipts that were included in a match are also unmatched as part of the invoice unmatch process. 

Financial Posting Error Handling

When matched invoices are posted to financials for payment, in rare cases, the posting cannot be completed successfully. Historically when this failure occurred, technical support intervention was needed to resolve these issues and complete the posting. ReIM 16.0 includes a new process (and screen) that allows a user to view the posting problems and better understand the reasons the error occurred.

Depending on the root cause, users with appropriate access may be able to fix the problem in the new screen or determine where additional setup is needed to allow the posting for the specific document to be completed successfully. This new process allows retailers to address most posting issues themselves without involving technical resources. They can then more quickly complete the posting and payment process. In addition, an audit trail of any corrections is maintained.  

UI Visibility

In this release of ReIM, several enhancements were introduced in the user interface (UI). These include the following:

n        The addition of the vendor product number (VPN) to several screens including:

-           Detail Match screen

-           Discrepancy Review List

-           Match Inquiry screen

-           The Items tab of Document Maintenance screen

n        The ability to search by VPN in the item popup within the Document Maintenance screen.

n        The addition of a hyperlink on the invoice column of the Detail Match screen which calls the Document Maintenance screen in view mode.

n        The addition of a hyperlink on the receipt column of the Detail Match screen which displays the receipt header information.

n        The addition of a hyperlink to the item column on the item tab of the Document Maintenance screen. The hyperlink then calls the item details popup in edit mode.

Operational Insights

All Operational Insights dashboards and reports were transitioned from Oracle Business Intelligence Enterprise Edition (OBIEE) to the Application Development Framework Data Visualization Tools (ADF DVT) as part of this release. This transition allowed the dashboards and reposts to more closely align with the look and feel of the ReIM application and to reduce the overall cost of ownership for the application.

As part of the rewrite, standard ADF features such as Query by Example, detach, and column sorting are included on reports, which can leverage these features.

Additional modifications included the following:

n        A new filtering feature for the invoices due report. This feature uses five tiles which, when selected, apply a pre-defined filter to the invoices due report.

n        A new Contextual BI report called 'Tolerance Range Report' was added to the Summary Match and Detail Match screens. The Tolerance Range Report shows the tolerances that are in effect for the current match. 

Technical Enhancements

Online Help

ReIM now references Cloud based online help, allowing retailers to ensure they are referencing the most up to date User Guide content via the Online Help.

Asynchronous Framework and Notifications

An asynchronous framework was added to ReIM, along with a notifications common feature to support the Induction feature.

Support Considerations

For product support and logged defects, the new product identifier for Oracle Retail Invoice Matching Cloud Service is 13312. Each logged defect will be analyzed to determine the source of the reported issue. Note that this Cloud Service product code also includes trade management and sales audit functionality.

Known Issues

The known issue below remains in this release.

Known Issue/Defect

Defect Number

When Navigating to the Discrepancy Review List from the Invoices Report on the Dashboard, you must re-execute the search (press the search key in the criteria section) before taking any other actions on the screen. Failure to do so can result in one of the following results: 

n        Null pointer exception if the 'select all' check box is selected

n        A 'blank' popup screen if you select a discrepancy to resolve and then press the 'Resolve' button. 

25106606

 

Related Documentation

For more information, see the following documents in the Oracle Retail Invoice Matching Cloud Service, Release 16.0 documentation set:

n         Oracle Retail Invoice Matching User Guide

n         Oracle Retail Merchandising Cloud Services Implementation Guide

n         Oracle Retail Merchandising Cloud Services Administration Guide

n         Oracle Retail Merchandising Cloud Services Administrator Action List

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 Invoice Matching Cloud Service Release Notes, Release 16.0

E85979-01

Copyright © 2017, 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, 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.

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.

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your beta trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.