| Oracle® Retail Brand Compliance Management Cloud Service Release Notes Release 18.1.16.0 |
|
 Previous |
| Oracle® Retail Brand Compliance Management Cloud Service Release Notes Release 18.1.16.0 |
|
Previous |
Release Notes
Release 18.1.16.0
November 2019
This document highlights the major changes for Release 18.1.16.0 of Oracle Retail Brand Compliance Management Cloud Service.
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 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.
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 60+
Google Chrome (Desktop) 73+
|
Note: Where new fields, User Interface (UI) changes, or glossary entries are introduced as part of a change, the portal owner may need to apply their own translations of the core system text. |
The following functional enhancement is included in this release:
A third phase of standard report templates is made available within the new BI Publisher Reports module. The new reports are available for scheduling, and may be copied and adapted to form custom variants.
The following standard reports are made available:
Standard Reports
| Report | Description |
|---|---|
| CR10 Products Country of Origin | Based on the Other Labelling Copy section, the report searches Product Specifications for products from specified countries of origin. Can search for multiple countries. |
| CR12 Product Country of Manufacturing Origin | Two versions: a) Product Country of Manufacturing; b) Product Country of Manufacturing (per Country).
Based on the Main Details section, the report searches Product Specifications (all types) for those where the primary site's location country matches a selected country. Option is available to group the output by Country. Can search for multiple countries, locating specifications where the primary sites are located in any of the specified countries. |
| CR29 Scorecards by Date Range | The report provides a KPI trend analysis of completed Scorecards within a specified date range by supplier.
A monthly analysis of the number of completed Scorecards, between specified date ranges is presented as a time series chart. Option is available to show the results by Scorecard Type. |
| CR30 Sites with Scorecards Overdue | Three versions: a) Sites with Scorecards Overdue; b) Sites with Scorecards Overdue per Supplier; c) Sites with Scorecards Overdue per Score Type.
The report searches Scorecards that are overdue, listing them by Site. The number of days overdue is calculated (+/- relative to the current date). Option is available to group the output by Supplier or by Scorecard Type. |
| CR36 Active Specifications Summary | Two versions: a) Active Specifications Summary; b) Active Specifications Summary (Multiples Breakdown).
a) Shows counts for each specification type/category grouping, by active date or period. The final total will always match the actual number of specifications. Separate tables give totals per date or period (month and year) of approval by different groupings:
All specification types can be reported on; each row gives count columns per specification type and category grouping with totals per row and per column. b) Shows a full breakdown for each specification type/category, but only for categories where multiples can occur, by active date or period. Where a specification has multiples within a specific category, this will be output for each multiple so it will exceed the actual number of specifications if there are multiples. Separate tables give totals for each category:
|
| CR37 Products without an Active Specification | The report searches Product Records (all types except Produce) that do not have an active Product Specification associated. |
| CR38 Sites without a Completed Audit/Visit | The report searches Sites that do not have a completed Audit or Visit of the specified type.
The report also includes Sites with a Completed Audit/Visit of the specified type, but where the Completion Date is older than a specified period from the date the report is run, using a relative date filter. |
| CR39 Sites without a Completed Scorecard | The report searches Sites that do not have a completed Scorecard of the specified type.
The report also includes Sites with a Completed Scorecard of the specified type, but where the Completion Date is older than a specified period from the date the report is run, using a relative date filter. |
| CR40 Produce Specification Acceptance | Based on Produce Specifications, and the Supplier Information section, the report returns a list of Produce Specifications which meet the filters applied.
The report includes basic details from the Produce Specification Main Details section, plus details from the Supplier Information section. The details are taken from the Specification, not the Product Record, as the Product Record is not created until after the Specification has been accepted. Note: A filter is applied to the system-delivered Data Source record, to only include Produce specifications. |
| CR41 Produce Ingredients Country of Origin | Based on the Produce Specifications Product Requirements section, the report searches for specifications containing any Ingredients from specified countries of origin, or specified ingredients from specified countries of origin.
Can search for multiple countries, or multiple ingredients and countries, and specify All or Any. Since the Ingredient Country of Origin is held as a table within the Product Sourcing table, the report will contain multiple rows for each applicable country found. Where the report shows the months per country, these will be a comma separated list. Note: A filter is applied to the system-delivered Data Source record, to only include Produce specifications. |
| CR47 Specification Status History | Detail of the specification's status change history, from the Status Change History table in the Change History section. |
| CR51 Scorecard Summary | Three versions: a) Scorecard Summary; b) Scorecard Summary (per Supplier); c) Scorecard Summary (per Scorecard Type).
The report searches for Scorecards based on the selected Filters. Option is available to group the output by Supplier or by Scorecard Type. |
| CR52 New Suppliers | The report lists Supplier records with a Created On date that is newer than a specified period from the date the report is run, using a relative date filter. |
| CR60 Global Network Bus Errors | The report is a listing of any errors that have occurred during the synchronization of data within the Global Network Bus (GNB) portal. As the GNB is only accessible by Oracle Hosting, it is not possible for system administrators or Oracle Support to monitor for integration issues. This report can be scheduled to run on the Global or Satellite portals.
If any of the following web services listed in the Web Service Log have a status of Failed or Internal Failure in the past 24 hours (assuming scheduled to run every 24 hours), the error is reported. The following API web services are included in the reports referenced below:
|
A field has been added to all system-delivered report data sources to denote whether the query returns deleted records or not. As part of the update, a filter of
Deleted = False is added to all system-delivered report data sources and designs.
New reports that are based on the system-delivered data sources will now filter out deleted records; others will not.
For existing reports that are not based on the system-delivered data sources, in order to exclude deleted records, it will be necessary to add the Deleted = False filter to the reports' Report Schedule, Report Design, or Report Data Source records, as a post release task.
Changes to APIs
User Type: When the user name is returned in the Users API (and when referencing users, such as a Technologist or other retailer user within the Product, Site, Audit, and Scorecard APIs), a userTypeText element is introduced alongside the existing userType element.
This identifies whether the user being referenced is a supplier or a retailer user. The userType element will contain the static code, such as RETAILER, and the userTypeText element will contain the actual description of the user type, such as Retailer (an item of translatable system text).
Site Selection: When the contact is returned in the Contacts API, to identify if the contact is for all sites, or selected sites (by an item of translatable system text), an additional siteSelectionText element is introduced alongside the existing siteSelection element.
The siteSelection element will contain the static code, such as SELECTED_SITES, and the siteSelectionText element will contain the actual description, such as Selected Sites (an item of translatable system text).
Record Type: When the audit or visit is returned by the Audits API, the recordType element identifies the record as being either an Audit or a Visit.
An additional recordTypeText element is introduced alongside the existing recordType element. The recordType element will contain the static code, such as AUDIT, and the recordTypeText element will contain the actual description, such as Audit (an item of translatable system text).
The following tables list issues fixed in this release:
Table 1 General Fixed Issue
| Defect Number | Description |
|---|---|
|
29939668, 30347260 |
Rich Text Editor Performance/Reliability Improvement Improvements have been made with regards to the way that the Rich Text Editor component is loaded into the User Interface. In some instances, it has been experienced that "network lag" within an organization is causing the Rich Text Editor to not load properly. This therefore has the effect of not being able to provide the correct content in various areas of the application.While in the vast majority of environments, there is not an issue with this component, this improvement will stabilize this component on all environments. |
Table 2 Product Fixed Issues
| Defect Number | Description |
|---|---|
|
29205663 |
Values missing from US legislation dual column nutrition panels in Pack Copy A fix has been made to rectify an issue with the dual column nutrition panel on the pack copy for specifications with US legislation not wrapping the per serving and per serving prepared text correctly. To fix this, the per serving values are now moved onto a separate line where the dual column nutrient panel has a nutrient configured with a constituent level greater than 1. |
|
30314306 |
Specification status updated to Pack Copy Sent when validation override is not approved by the Retailer A fix to utilize the specification target status to trigger validation rather than using the current status has been implemented. The error occurred because current status was being used and the system configuration for validation on the specification status was not in the list of not mandatory statuses and therefore was not triggering the validation process. |
Table 3 Project Fixed Issues
| Defect Number | Description |
|---|---|
|
29754099, 30164014 |
Actual Start Date incorrect on the Activity Details page A fix to prevent the activity start date being updated when there is a change to the status has been implemented. The error occurred when project activity status was updated and the system would also update the actual start date for the activity. This resulted in completed project activities having the same start and end date. |
|
30089295 |
The Project Activities page was showing the wrong dates in the Start Date and End Date columns A fix to ensure the fields are populated with the corresponding data has been implemented. The error occurred when the activity sub-status column was visible resulting in the Start Date column showing the Planned End Date and the End Date column showing the Actual Start Date. This fix also addresses the start and end dates not being visible until the activity was complete. They should be visible when the activity has been started. |
Table 4 Supplier Fixed Issue
| Defect Number | Description |
|---|---|
|
30055014 |
Unable to select current date in Audits/Visits A fix is made to rectify an issue with the date picker in the Audit/Visit record not allowing the current date to be selected. The issue is due to the date picker deriving the current date from the time zone of the portal's server (UTC), which may be different to the user's time zone. If the user's current time is ahead of the server's time, and the user's time has moved into the "next" day, then the system will prevent the user from selecting their current date as the server is interpreting this as being in the future. The user would then have to wait until the server time catches up with the user's time to allow the user to perform their appropriate action. The fix derives the current date for the date picker from the time zone of the user's locale (set in their user profile), instead of the portal server's time zone. The fix is also applied to the Completed Date in the Audit Issue record. |
Table 5 Reports Fixed Issues
| Defect Number | Description |
|---|---|
|
30397318 |
Incorrect sequence numbers in report filter tables A fix has been made to rectify an issue with sequence numbers within report filter tables being incorrect as a result of a previous upgrade script. The fix correctly re-sequences the rows in the filter tables. |
|
30477624 |
Legacy reports: D&A Contains data not reportable A fix is made to rectify an issue in reports, where Contains questions in the product specification's Allergy and Dietary Advice section were not available for reporting. The issue occurred where a Label Declaration had not been selected. The Contains data is now reportable, regardless of whether the Label Declaration is used or not. |
|
30547400 |
Report CR54 (Label Claims & Statements) empty rows A fix is made to rectify an issue with the Label Claims & Statements report including empty rows, for specifications that do not have an Other Labelling Copy section. Specifications that do not have an OLC section are now omitted from the report. |
|
30547415 |
Raw Materials data source error A fix is made to rectify an error with the Raw Materials data source query. The fix removes the SURV_CLASSIFICATION from use as a column or filter, as it is not relevant to this data source. |
Reports
In order to omit deleted records from existing reports that are not based on the system-delivered data source (that is, where a custom version of the data source or design has been created), consider adding a Deleted = False filter to the reports' Report Design or Report Data Source records, or directly to the associated Report Schedule records.
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.1.16.0
Copyright © 2019, 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.
