| Oracle® Retail Brand Compliance Management Cloud Service Release Notes Release 18.2.1 F28207-02 |
|
 Previous |
| Oracle® Retail Brand Compliance Management Cloud Service Release Notes Release 18.2.1 F28207-02 |
|
Previous |
Release Notes
Release 18.2.1
F28207-02
September 2020
This document highlights the major changes for Release 18.2.1 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 Windows 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. |
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:
| 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. |
| 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:
|
This section highlights specific key fixes that are included in this release. In some cases, only a percentage of the overall fixed defects are listed.
| Affected Component | Defect Number | Summary |
|---|---|---|
| Admin: Global Change | 29441797 | Product Responsibility Global Change
The Change Product Responsibility global change option in the Admin area has been changed so that when the product technologist role is selected, the To picklist only shows users who have the Show in lists of product Technologists option selected on their user profile. A similar change has also been made to the Change Produce Responsibility global change. |
| Admin: Mandatory Fields | 30125146 | Mandatory Field Configuration not applied to FPS section field
A fix has been applied so the Microbiological Classification field held on the Finish Product Standards section is validated, and has a red asterisk, when configure to be a mandatory field. |
| Admin: Reporting | 30547415, 30376337 | Raw Materials data source error
A fix has been 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. |
| Admin: Users | Not Applicable | Error is generated when attempting to create a new user
The error occurs when the system attempts to create users in IDCS and the environment is not linked to IDCS. A fix has been implemented to check the system configuration to ensure a valid IDCS url is set, before attempting to create a user in IDCS. |
| APIs: Product Specification REST API | 29704246, 30548409 | API server error when filtering with non-unique site codes
A server error was generated when using the specification/advanced ProductSpecification REST API endpoint with a filter for a non-unique site code. The process now successfully processes.
|
| Audits & Visits | 30055014, 30528169 | Unable to select current date in Audits/Visits
A fix has been 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. |
| Audits & Visits | 30614366, 30659845, 30677948, 30686403 | Error is generated when trying to accept Audit Corrective Actions
The issue occurs when the user accepting the corrective action is in a different time zone. A fix has been made to verify the date approved is correct with the respective user's time zone. |
| Audits & Visits: Checklists | 30490214 | Unable to set an Audit to a status of Awaiting Corrective Action
An error message was generated when trying to update the status of an Audit to Awaiting Corrective Action when there were non-conformances. The audit needed to be created using an audit template based on a checklist template with questions, where the Code and Ref (Default) fields were populated. A fix has been implemented so the audit status can be advanced to Awaiting Corrective Action per the expected successful functionality. |
| General: IDCS Logging | 30660424 | IDCS response and fault handling improvements
Improvements have been made to the IDCS user authentication integration. The IDCS service logging has been enhanced to include additional diagnostics logging. IDCS requests will produce a log output showing basic information about the request, for events such as:
|
| General: Rich Text Editor | 29939668, 30347260, 30528235 | 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. |
| General: System Calendar | Not Applicable | Error when setting up System Calendar
A fix has been made to rectify an error when attempting to reset the periods for a year in the System Calendar. The error occurred due to calendar entries that had yet to have periods assigned being unnecessarily validated for overlapping dates. |
| General: Users | 30594383 | IDCS update failure when creating or deleting a user is not managed by ORBC
A fix has been implemented so ORBC handles the HTTP response code, from calling IDCS, indicating a failure by generating an appropriate error message to the user within the ORBC application. |
| Product: Nutrition Values | 30786481, 30710538 | Issue with Nutrition values in Product Specifications
A fix has been made to rectify an issue with nutrition values in specifications not showing correctly after configuration changes had made to the associated Nutrition Panel. The issue occurred following upgrade to release version 18.0. |
| Product Specifications: Nutrition | 29205663, 30528174 | 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. |
| Product Specifications: Nutrition | 30531423 | Recalculation of specification nutrition values causes error
A NullPointException error occurred when editing a specification to add nutrients to the nutrients section. When attempting to recalculate the nutrients and declarations, the system became unresponsive. A fix has been implemented to recalculate specification nutrition values without generating an error. |
| Product Specifications: Performance | 29434629 | Delayed application response when navigating product specifications
When editing a product specification with a status of collaborative draft, there is significant application delay when navigating to the Recipe, Allergy, or Nutrition sections. A fix has been implemented so the rendering of the sections is within expected limits. |
| Product Specifications: Workflow | 30299694, 30203859 | An error is generated when attempting to undelete a specification
A fix has made to the undelete process so specifications can now be successfully undeleted without error, returning the specification to a status of supplier/retailer draft. |
| Product Specifications: Workflow | 30314306, 30332024 | 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. |
| Product Surveillance | 30688901, 30756160 | Surveillance Test Results cannot be uploaded as XLSX spreadsheets
An error occurs when attempting to upload Surveillance Results from the latest Excel file type of XLSX. A fix has been made and both XLS and XLSX spreadsheets are processed successfully by the application. |
| Project Activities | 29754099, 30164014, 30528198 | 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. |
| Project Activities | 30089295, 30528232 | 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. |
| Project Activities | 30181738, 30640217, 30821429 | Error when unlinking Product Specifications from Projects
A fix has been made to rectify an error when attempting to unlink a Product Specification from a Project Activity. The error occurred due to the link reference not being removed from the Activity prior to the link being deleted, which resulted in a constraint violation exception error. |
| Reports | 30397318, 30528278 | 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 resequences the rows in filter tables. |
| Reports | 30547400 | Report CR54 (Label Claims & Statements) empty rows
A fix has been 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. |
| Reports | Not Applicable | Report CR10 Products Country of Origin is failing to generate when scheduled
The issue occurred due to the configuration for the report including Advanced Packaging columns. A fix has been implemented and the report is now generated successfully. |
| Reports: Allergy & Dietary | 30477624, 30477620, 30294303, 30560815, 30717552, 30828325, 30294313, 30528257 | Legacy reports: D&A Contains data not reportable
A fix has been 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. |
| Reports: Data Sources | 29841515, 30528281 | Report data source fix
A fix has been made to the code that generates various report data sources. The fix relates to the use of Other Contacts in the following data sources:
|
| Reports: Legacy Reports | 30594400, 30315862 | Accessing Legacy Reporting using IDCS
A fix has been made to address a 401 error occurring due to the Legacy Reports Single Sign On filter being unable to connect to IDCS to retrieve the user details. |
| Reports: Product Requirement Reports | 30434562 | Reports using the SpecAPI data source fails when using a filter value for the product technologist
The error occurred due to the application attempting to map the filter value against the login ID as opposed to the user, resulting in a user not found error message. |
| Reports: Specification Extract | 30623040 | Formatting of multiple values in Specification Extracts
A fix has been made to the formatting of data in the Specifications Extract, to handle where a specification has multiple values in fields such as Technologist or Business Category. Previously, the extract contained a separate row in the spreadsheet for each. The fix makes these columns consistent with other multi-value columns, such as Site. Multiple values are now concatenated into a single cell using a comma as the separator. For example, the previous output for multiple Business Categories was: food.otherLabellingCopy.spec.extract.businessCategories.code This would now be formatted as: food.otherLabellingCopy.spec.extract.businessCategories.code |
| Scorecards | 30506698 | Unable to issue a new scorecard due to code already exists error
A fix has been made to the application to prevent the attempted use of codes already utilized by existing scorecards. |
| Supplier: Supplier Import | Not Applicable | Error when importing Suppliers
A fix has been made to rectify an error when using the action in Supplier list views to import new suppliers. The error occurred because the process was attempting to create IDCS user profiles for supplier users in an environment that was not configured for IDCS integration. The fix checks for a valid IDCS url before attempting to create the user profile in IDCS both for the creation of supplier and retailer users. |
| Suppliers & Sites | 30393137, 30436802 | Error when attempting to add new site for a supplier
The error occurs when All Sites are selected rather than Selected Sites against the supplier. A fix has been made so new sites can now be created successfully for suppliers. |
The following post release task is available.
Artwork is not a core Brand Compliance module, but a third-party add-on application. This process enables the integration with the third-party Artwork application, where it is used.
For existing installations that use the Artwork module, in order to configure single sign on (SSO) between Brand Compliance and the Artwork solution (using IDCS authentication), the following steps must be taken by the Customer or their Partner:
Ensure the MYARTWORK external system has been created in Brand Compliance PROD and STAGE.
Raise an SR service request for creation of the Artwork application for PROD and STAGE. The call back URLs and IDCS URLs must be provided in the SR.
Once created, you will be able to gather the Client ID and Client Secret from IDCS.
Refer to the Artwork chapter in the Oracle Retail Brand Compliance Management Cloud Service Administration Guide for the full process for enabling Artwork with SSO.
For more information, see the following document in the Oracle Retail Brand Compliance Management Cloud Service Release 18.2.1 documentation set:
Oracle Retail Brand Compliance Management Cloud Service Reports User Guide
The Oracle Retail Brand Compliance Management Cloud Service Report Layouts document has been updated for 18.2.1. The document is available through My Oracle Support:
Oracle Retail Brand Compliance Management Cloud Service Documentation Library (Doc ID: 2400174.1)
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.2.1
F28207-02
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.
