Oracle® Retail Brand Compliance Management Cloud Service

Release Notes

Release 18.3.0.1

June 2020

This document highlights the major changes for Release 18.3.0.1 of Oracle Retail Brand Compliance Management Cloud Service.

Overview

Oracle Retail Brand Compliance Management Cloud Service is an application designed to meet all aspects of sourcing, developing, and protecting retailer brands. The application provides solutions for product development, compliance, quality, and traceability. It is designed specifically for retail, food service, and manufacturing businesses to develop and protect their brands, manage their suppliers, and ensure full end-to-end product lifecycle management.

Oracle Retail Brand Compliance Management Cloud Service is composed of the following modules:

• Library enables the issue, receipt, and acceptance of policies, guidelines, and key working documents.

• Product supports the development of products and production specifications.

• Project supports the development of project briefs, plans, and workflow management.

• Supplier enables the identification, selection, and approval of suppliers.

• Reports - reporting tool for reporting across the system, using standard templates and custom reports.

Oracle Retail Cloud Services and Business Agility

Oracle Retail Brand Compliance Management Cloud Service is hosted in the Oracle Retail 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:

• The following web browsers are supported:

  
  

  Note: Oracle Retail assumes that the retailer has ensured its Operating System has been patched with all applicable updates.

  
  

  • Microsoft Internet Explorer 11

  • Mozilla Firefox ESR 68+

  • Google Chrome (Desktop) 79+

  • Edge 44+

Fixed Issues

The following tables list issues fixed in this release:

Table 1 Product Fixed Issues

Defect Number	Description
29875591, 30085526, 30519764, 30568758, 30633216, 31198867, 31198923	Issues with Front of Pack Nutrition Scoring A fix is made to rectify an issue in the Front of Pack Nutrition Scoring Rules glossary, in the Product Global Glossaries admin area. The issue resulted in rows of the Score Bandings table being hidden. The fix addresses a related issue where the front of pack nutrition score color coding was not present in the product specification's Nutrition section. This fix also rectifies an error that occurred when editing the Front of Pack Nutrition Scoring Rules glossary.
30119032, 30456410, 31198854	Temporary specifications list view does not save site details The issue occurred where the site information was not saved when creating temporary specifications of type Processed/Manufactured. Null values were saved at the list view level such that when the data was downloaded, site information was not populated for the temporary specifications. A fix has been implemented to ensure the site information is populated for newly created temporary specifications of type Processed/Manufacture.
30516180, 30516184, 31191121, 31191125, 31191126	Surveillance test reports not uploading site codes which do not match the product code The issue occurs when site codes do not match any of the site codes on the product record. This issue has been resolved so when the system parameter Use Site Codes is set to Yes, if a site code does not match a site code on the product RECORD, an import error will be generated to allow it to be corrected or ignored. However, the site code must still be a valid site code for the corresponding supplier.
30574454, 31144391, 31174633, 31197697	Issues saving updates in the Finished Products Standards section A fix has been implemented to resolve user updates not being saved to the Microbiological Classification tables, within the Finished Products Standards section of product specifications. The issue occurred when a user was entering details into the Microbiological table and clicked Save on the specification. If the user continued to enter more details into the Microbiological table, then these additional details after the save were being lost. A temporary work around was to perform a Save and Exit on the specification and then afterwards reedit the specification and make the subsequent changes. This fix also address the same issue on the Product Standards section of Produce Specifications.
30616480, 31115327, 31174604	Error when creating new version of an active Specification A fix has been made to rectify an error when creating a new version of an active product specification. The error was related to the On Pack Ingredients List field in the Recipe and Raw Materials exceeding a 4,000 character limit. As a result of the fix, the On Pack Ingredients List field will accommodate 4,000 characters, plus any hidden HTML markup code that is stored for applying rich text formatting, such as emboldening ingredients to highlight them as allergens.
30688901, 30756160, 30957886, 31174563, 31191114	Issues with upload of Surveillance Test Reports Improvements have been made to the pre-validation routine for the Surveillance Test reports to reduce the timeout exceptions that have been experienced. Once the Surveillance Test report has passed pre-validation and been handed off to a batch job for processing, additional efficiencies have been made in this area to help with the creation of the actual Surveillance Test reports.
30995670, 31144209, 31174626	Nutrient value limited to N5.N8, increased to N8.N8 The format of the numeric fields within the Nutrients table on the Nutrition section has been updated to increase the size of the value that can be entered. This is to support necessary requirements for some customers. The new format is N8.N8, xxxxxxxx.xxxxxxxx (maximum 8 digits before decimal place, 8 digits after).
31067362	Error when uploading Surveillance Test Report A fix has been made to rectify an error when uploading a Surveillance test report. The error occurred when the file contained a blank row. This type of exception is now handled by the validation.
31117652	Unable to load surveillance reports due to errors Further improvements have been made to the pre-validation routine for the Surveillance Test Report upload to reduce the timeout exceptions that can be experienced. Additionally, an issue of case sensitivity was included as part of 17.0.15.5, for the Country of Origin, Sample Type, Lab Opinion, Test Name, and Units. This case sensitivity has now been removed. Current recommendation is to still keep the Surveillance Test Report that is uploaded to be around the 500 rows in Excel.
31190597	Missing values in a combined specification's Recipe section A fix has been made to rectify an issue with compound ingredients having values missing from the Recipe section when two product specifications had been combined. The issue occurred where the recipe was nested to two levels or more.
31304200	Unable to edit combined specification's Nutrition section A fix has been made to rectify an issue with it not being possible to edit the Nutrition section of a combined specification after unlocking the section.

Table 2 Supplier Fixed Issue

Defect Number	Description
30614366, 30957417, 31043397, 31047441, 31174571	Unable to accept Audit corrective actions A fix has been made to rectify an issue with the acceptance of Audit corrective actions. The issue relates to the Audit Issue's non-conformance approval date. When accepting a corrective action, the user's time zone was not being taken into account. Thus, there were occasions when validation prevented the acceptance of an issue, due to the approval date being ahead of UTC. The user's time zone is now taken into account.
31103618, 31174635	Saved audit checklist answers only visible in edit mode When completing an audit checklist, the answers entered and saved would not be visible to the user afterwards in read mode, suggesting the checklist answer data was not being saved. Only on entering edit mode would the previous saved answers be visible. This fix ensures the saved checklist answers are visible in read mode.

Table 3 General Fixed Issues

Defect Number	Description
30556947, 31042535, 31174619	Error when synchronizing Product Specification data A fix has been made to rectify an error that occurred when synchronizing Product Specifications. The exception was related to the Find by spec number and version method.
30983015, 31075654	Timeout during upgrade A fix has been made to rectify a timeout issue that occurred during the upgrade process. The issue was related to the data generator that soft deletes Reports data, for queries that are no longer in use.
30984931, 31174588	Error when synchronizing Contact data A fix has been made to rectify an error that occurred when synchronizing Supplier Contacts. When the login id and the email address are changed against a supplier/site user on a satellite system, running a 17.0 version, this is causing an issue when trying to reflect this change on the global system, when running an 18.2 version. From release 18.2, Oracle Identity Cloud Service (IDCS) manages users' login ids and email addresses. There is no ability to change them in Brand Compliance. The fix ensures that the email address remains synchronized between satellite portals that are not controlled by IDCS, and the global portal to prevent this issue.
31034556	Users removed from IDCS legacy group A fix has been made to rectify an issue with the hourly batch job that synchronizes user updates between Brand Compliance and Identity Cloud Service (IDCS). The issue resulted in the user being removed from the XX_BC_User legacy IDCS group.

Table 4 Reports Fixed Issues

Defect Number	Description
31232956	Reports data warehouse build failure A fix has been made to rectify an issue with the build of the Reports data warehouse during start-up of the application.
31355311	Legacy Reporting Data Warehouse Optional Build Parameter An update has been made to allow the legacy reporting installer to optionally skip areas of the Data Warehouse rebuild. In order for an area to be skipped, the appropriate server configuration needs to be applied and the reporting instance restarted. Note: Without this server configuration being applied, the legacy reporting installer will operate as normal.
31383303	KPI Report returning zero value A fix has been made to rectify an issue with a scheduled KPI report incorrectly returning a zero value when reporting on the count of Product Specifications. The issue was due to an error in the report schedule batch job.

Post Release Tasks

There are no specific post release tasks that need to be done as part of this release.

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 Brand Compliance Management Cloud Service Release Notes, Release 18.3.0.1

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