Oracle® Retail Fiscal Management
Release Notes
Release 14.1.2.1
E71663-01
February 2016
As part of the Oracle Retail Merchandising Operations Management (MOM) product suite, Oracle Retail Fiscal Management (ORFM) Release 14.1.2.1 is the Brazil localization solution for the market.
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 Hardware and Software Requirements
n Running Scripts
n Functional Enhancements
n Technical Enhancements
n Related Documentation
n Documentation Accessibility
Overview
Oracle Retail Fiscal Management (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 Oracle Retail Merchandising System (RMS), Oracle Retail Store Inventory Management (SIM), and Oracle Retail Warehouse Management System (RWMS). This solution covers localization of end to end merchandising and supply chain processes, as well as financial integration, for retailers in Brazil.
Business Process
ORFM supports the following fiscal business processes:
n Receiving of Purchase Orders: To receive Nota Fiscal documents from suppliers, manual and Electronic Data Interchange (EDI) entries are possible. ORFM matches Nota Fiscal to RMS purchase orders, enforcing fiscal receiving of Nota Fiscal before any physical receiving in SIM and RWMS. If any discrepancies are found for item quantities, cost and taxes, a resolution is available with applicable tolerances.
n Receiving of Complementary Nota Fiscal: Besides regular Nota Fiscal documents received from suppliers for RMS purchase orders, ORFM also enables the receiving of additional fiscal documents, known as Complementary Nota Fiscal. ORFM supports Complementary Nota Fiscal for tax or cost correct, non-merchandise cost such as freight, insurance and expenses, as well as Triangulation Purchase Orders, in which an additional Nota Fiscal is received from the delivery supplier.
n Transfers: In Brazil, it is required that a Nota Fiscal be issued for intra-company and inter-company transfers. ORFM is able to issue outbound Nota Fiscal at the origin location and receive it at the destination location. Both single-legged and two-legged (such as in repairing or finishing processes) transfers process are supported. Issuing process can be automated for transfers from allocation and replenishment. Upon configuration, ORFM can also automatically receive transfers Nota Fiscal.
n Returns to Vendor: ORFM is able to issue an outbound Nota Fiscal for the return- to-vendor business process, issued by the retailer location, either warehouse or store, to the supplier. This Nota Fiscal cross-references the Nota Fiscal received from the supplier for a purchase order and includes some cost and taxes applied to the returned merchandise.
n Inventory Adjustments: Some states in Brazil may require a Nota Fiscal for inventory adjustments. ORFM issues a Nota Fiscal for negative inventory adjustments processed by SIM or RWMS, upon configuration per location. Nota Fiscal can be also configured to be automatically generated for an Inventory Adjustment, leveraging a transparent process for the retailer.
n Customer Orders: Leveraging Commerce Anywhere functionalities for Brazil, ORFM issues an outbound Nota Fiscal for store pick-up or shipments fulfilling a customer order from stores, warehouses, and suppliers.
n Return Merchandise Authorization: Customers returning merchandising without visiting a store require a return merchandise authorization. ORFM is leveraged to issue a Nota Fiscal to return merchandise from customers and receive it at warehouse.
n Purchase Orders for Rural Producers: In Brazil, because small farmers may not be required to issue fiscal documents, retailers purchasing from them must issue an inbound Nota Fiscal document to receive merchandise from these rural producers. To enable receiving of purchase orders from rural procures, ORFM enables issuance of an inbound Nota Fiscal document.
n Standalone Nota Fiscal: In Brazil, a Nota Fiscal document is required for several events other than core transactions supported by Oracle Retail solutions. To enable retailers to have a single solution to generate all Nota Fiscal documents, ORFM is able to generate Standalone Nota Fiscal documents, irrespective of Oracle Retail Transactions. Standalone may be issued with generic items and fiscal entities (Free Form Nota Fiscal) or using RMS items, locations, and suppliers with integration to tax engines (Direct Nota Fiscal).
Integration to Third-Party Solutions
Brazilian complex taxation, electronic Nota Fiscal (NF-e) and Brazil fiscal bookkeeping digital system (SPED) requirements are also leveraged with ORFM through integration with third-party solutions. To support the local needs required for Brazil taxes ORFM presents an integration to third-party tax engines to address Brazil tax calculation for various retail transactions supported by Oracle Retail solutions, determining taxes for inbound and outbound Nota Fiscal documents. To receive or issue NF-e, validate and make it available to the government, ORFM also supports integration to third-party solutions to handle communication with the government electronic systems. Finally because all Nota Fiscal documents must be reported to SPED fiscal reporting, ORFM makes available all Nota Fiscal documents received or issued by the retailer to be consumed by third-party fiscal reporting solutions.
|
Note ORFM Release 14.1.2.1 does not support Synchro tax engine integration. Retailers willing to integrate to Synchro tax engine are advised to install release 14.1.1. |
Integration to Financial Solutions
RMS is integrated to the Oracle Enterprise Business Suite (EBS) through the Oracle Retail Financial Integration (ORFI). As an extension to RFI, ORFM has been enhanced to support Brazil localization for financial postings. For all Nota Fiscal, merchandise cost, non-merchandise cost, recoverable taxes, and non-recoverable taxes can be mapped to financials, with Nota Fiscal documents generating vendor payments posted to Accounts Payable and Nota Fiscal from Transfers and Inventory Adjustments posted to General Ledger.
Integration to Importation Solutions
The importation process in Brazil requires clearance and related paper work as well as an inbound Nota Fiscal to receive imports from ports and airports at the retailer warehouse or store. To better support importation processes, ORFM supports integration to receive Nota Fiscal issued by importation solutions, validating, and controlling specific taxation through integration to third-party tax engines. Also, ORFM presents multi-currency capabilities, supporting maintenance of master data, and item costing for foreign suppliers, as well as exchange rates and currency conversion for transactions held in foreign currency, enabling the taxation for purchase orders and the issuance of Nota Fiscal in Brazilian currency.
Hardware and Software Requirements
See the Oracle Retail Merchandising System with Brazil Localization Installation Guide for additional information about the following:
n Hardware and software requirements
n Oracle Retail application software compatibility
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 Fiscal Management Release 14.1.2.1:
NF Cancellation and Inventory Reversal
NF documents are usually electronic documents validated and authorized with the Brazilian Government for every inventory movement and merchandise shipment. In this approval process NF documents may be rejected for authorization, requiring the fiscal documents to be resubmitted or nullified. NF documents may also have approval definitively denied. Already approved NF documents may also be required to be canceled, due to logistical issues or business reasons. In all these different situations, inventory movements and shipments are required to be reversed. To address this scenarios, ORFM is enhanced to handle inventory reversal for any issued NF documents as well as to support the different status for these fiscal documents, including canceled, denied, and nullified statuses.
ORFM supports the following capabilities:
n Pre-NF: The internal sequence for NF number is used while NF is being validated and processed. Only at the time of electronic approval, the fiscal sequence is consumed.
n NF Cancellation Form: It provides the control and monitoring of the cancellation process from the request to government up to inventory reversal steps.
n Inventory Reversal Capabilities: Considering RMS, RWMS, and SIM, for all shipments supported, ORFM can trigger and have inventory returned to stock as a result of a NF cancellation.
NF Contingency Enhancements
The enhancements in integration with the third party systems for NF issuing now permits the generation of NFs in contingency mode, supporting the new Evento Prévio de Emissão em Contingência (EPEC - Preventive Event of Contingency NF issuing) protocol established by the Brazilian government.
Ficha de Conteúdo de Importanção (FCI) and Brazilian Merchandise Origin Code Support
In order to support the new tax incentives that allows retailers in Brazil to reduce tax calculation for imported items, ORFM is enhanced to capture the Ficha de Conteúdo de Importanção (FCI - Importation Content File) number and the origin code of each item during receiving of goods, storing this information at item location level, and using it for outbound transactions. With this control, the outbound transfer NFs can be calculated with the tax reduction approved by the government.
Standalone NF Enhancements
The standalone NF functionality allows association with negative inventory adjustments performed in RWMS/SIM. Upon configuration, it will allow retailers to have a standalone NF automatically generated based on the negative inventory adjustment. The correspondent financial postings will also be created.
Technical Enhancements
This section addresses the technical enhancements included in Oracle Retail Fiscal Management, Release 14.1.2.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 Fiscal Management 14.1.2.1 is supported for use with the following database server:
n Oracle Database Enterprise Edition 12.1.0.2
Browser Support
Oracle Retail Fiscal Management 14.1.2.1 is certified for use with the following browsers:
n Mozilla Firefox ESR 38+
n Internet Explorer 11+
Java Support
The client of Oracle Retail Fiscal Management 14.1.2.1 is supported for use with the following Oracle Java version:
n Oracle Java 7 update 80
Java Runtime Environment (JRE)
The client of Oracle Retail Fiscal Management 14.1.2.1 is certified for use with the following Oracle Java Runtime Environment (JRE):
n Oracle Java Runtime Environment (JRE) 8
For more information, see the following documents in the Oracle Retail Fiscal Management release 14.1.2.1 documentation set:
n Oracle Retail Merchandising System with Brazil Localization Installation Guide
n Oracle Retail Tax Integration Layer (RTIL) Installation Guide
n Oracle Retail Fiscal Management User Guide and Online Help
n Oracle Retail RMS-ReSA User Guide for Brazil Localization and Online Help
n Oracle Retail Fiscal Management/RMS Brazil Localization Implementation Guide
n Oracle Retail Fiscal Management Data Model
n Oracle Retail Merchandising Security Guide
n Oracle Retail Licensing 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 Fiscal Management, Release 14.1.2.1
E71663-01
Copyright © 2016, 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.
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.