| Oracle® Retail Brand Compliance Management Cloud Service Release Notes Release 18.1.13.0 F20977-02 |
|
 Previous |
| Oracle® Retail Brand Compliance Management Cloud Service Release Notes Release 18.1.13.0 F20977-02 |
|
Previous |
Release Notes
Release 18.1.13.0
F20977-02
July 2019
This document highlights the major changes for Release 18.1.13.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 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. |
The following functional enhancements are included in this release:
A second 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 |
|---|---|
| CR11 CNF Materials Country of Origin | Based on CNF Specifications Components section, the report searches for Product Specification containing any materials from specified countries of origin, or specified components from specified countries of origin.
Can search for multiple countries, or multiple components and countries, and specify All or Any. |
| CR13 Product Certificates - Used on Pack | Two versions:
a) Product Certificates - Used on Pack; b) Product Certificates - Used on Pack (per Certificate). Based on the Other Labelling Copy section, the report searches Product Specifications where the Certificates table contains the specified certificate type. Option is available to group the output by Certificate Type. Only certificates that appear on pack are included (that is, where the Used on Pack option is number, icon, or both). |
| CR14 Product Shelf Life | Two versions:
a) Product Shelf Life [for Food and BWS specifications]; b) Product Shelf Life (Produce). Based on the Storage section, the report searches Product Specifications where the Supplier or Business Category matches the specified value. The report lists details from the Pack Coding table. Can search for multiple suppliers or business categories. |
| CR15 Packaging Components | Based on the Packaging section, the report searches Product Specifications (all types except Produce) for those containing any Packaging Components from specified Raw Material Suppliers, Countries of Origin, or Materials.
Can search for multiple suppliers, countries, or materials, locating specifications that match the specified selections. |
| CR16 Packaging Components (Produce) | The report searches Produce Product Records for those containing any Packaging Components from specified Raw Material Suppliers, Countries of Origin, or Materials.
Can search for multiple suppliers, countries, or materials, locating specifications that match the specified selections. Note: A filter is applied to the system-delivered Data Source record, to only include Produce specifications. |
| CR18 Surveillance Testing Requirements - Product Attributes (As Consumed) | Based on the Finished Product Standards section, the report searches Product Specifications (Food types) for those containing any Product Surveillance Classifications that match the specified value. The report lists details from the FPS Attributes tables.
The report is from the perspective of the Specification, but pulls Surveillance Classifications from the Product record. |
| CR19 Surveillance Testing Requirements - Physical Standards | Two versions:
a) Surveillance Testing Requirements - Physical Standards for non-Produce specifications; b) Surveillance Testing Requirements - Physical Standards (Produce) for Produce. Based on the Finished Product Standards section, the report searches Product Specifications (all types) for those containing any Product Surveillance Classifications that match the specified value. The report lists details from the Physical Attributes tables. |
| CR20 Surveillance Testing Requirements - Chemical Standards | Two versions:
a) Surveillance Testing Requirements - Chemical Standards for non-Produce specifications; b) Surveillance Testing Requirements - Chemical Standards (Produce) for Produce. Based on the Finished Product Standards section, the report searches Product Specifications (all types) for those containing any Product Surveillance Classifications that match the specified value. The report lists details from the Chemical Attributes tables. The report is from the perspective of the Specification, but pulls Surveillance Classifications from the Product record (except for Produce, which holds the surveillance classifications in the specification's Main Details section). |
| CR21 Surveillance Testing Requirements - Microbiological Standards | Two versions:
a) Surveillance Testing Requirements - Microbiological Standards for non-Produce specifications; b) Surveillance Testing Requirements - Microbiological Standards (Produce) for Produce. Based on the Finished Product Standards section, the report searches Product Specifications (all types) for those containing any Product Surveillance Classifications that match the specified value. The report lists details from the Microbiological Attributes tables. The report is from the perspective of the Specification, but pulls Surveillance Classifications from the Product record (except for Produce, which holds the surveillance classifications in the specification's Main Details section). |
| CR23 Surveillance Test Report Summary | Four versions:
a) Surveillance Test Report Summary for non-Produce specifications; b) Surveillance Test Report (per Supplier) for non-Produce specifications; c) Surveillance Test Report Summary (Produce) for Produce; d) Surveillance Test Report (per Supplier - Produce) for Produce. Note: Countries Where Sold is taken from the Product Record. If the portal has the Product Record Controls Countries system parameter is set to No, the value will be held on the Specification, in which case it is necessary to create a custom version of the report, adding the Countries Where Sold (Spec) column from the set of additional fields. The report searches Surveillance Test Reports based on the selected filters. There will be an option to filter the Date of Sampling on either a date range or a relative date. Option is available to group the output by Supplier. |
| CR28 Audits/Visits with Issues Overdue | Three versions:
a) Audits/Visits with Issues Overdue; b) Audits/Visits with Issues Overdue (per Supplier); c) Audits/Visits with Issues Overdue (per Audit/Visit Type). The report searches Audits & Visits that have overdue Issues, 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 Audit/Visit Type. |
| CR31 Site References (Certificates) - All Valid / Overdue by Type | Three versions:
a) Site References (Certificates) - All Valid/Overdue by Type; b) Site References (Certificates) - All Valid/Overdue by Type (per Supplier); c) Site References (Certificates) - All Valid/Overdue by Type (per Certificate Type). The report searches Sites that have certificates (references). Option is available to group the output by Supplier or by Certificate Type. Two separate reports list certificates that are either overdue or valid (a certificate is considered to be overdue if its expiry date is passed the current date). |
| CR48 Audit/Visit Issue Status | Three versions:
a) Audit/Visit Issue Status; b) Audit/Visit Issue Status (per Supplier); c) Audit/Visit Issue Status (per Audit/Visit Type). Similar to CR28 Audits/Visits with Issues Overdue, but includes Issues at any status (as per the filter), rather than just Overdue Issues. Option is available to group the output by Supplier or by Audit/Visit Type. |
| CR49 Audit/Visit Summary | Three versions:
a) Audit/Visit Summary; b) Audit/Visit Summary (per Supplier); c) Audit/Visit Summary (per Audit/Visit Type). The report searches for Audits/Visits based on the selected Filters. Issue Details can be included, but overall granularity is by Audit. Option is available to group the output by Supplier or by Audit/Visit Type. |
| CR50 Audit/Visit Certificate | The report searches for Audits/Visits based on the selected Filters.
Non Conformance/Issue details are included, but overall granularity is by Audit. The report presents a page per Audit/Visit. Option is available to group the output by Supplier or by Audit/Visit Type. A maximum of 10 Audits/Visit may be selected per run. |
| CR54 Label Claims & Statements - Food | Report is based on the OLC Section of the Food Specification, and finds any Specifications which contain the Claims specified in the filters.
There will be one report query to accommodate all Food Spec claims. Since most claim fields in the OLC section are tables, including multiple claims and filers in the same report output will result in duplication of rows, therefore users should create separate reports per claim. |
| CR55 Label Claims & Statements - Formulated Non Food | Report is based on the OLC Section of the Formulated Non Food Specification, and finds any Specifications which contain the Claims specified in the filters.
There will be one report query to accommodate all Formulated Non Food Spec claims. Since most claim fields in the OLC section are tables, including multiple claims and filers in the same report output will result in duplication of rows, therefore users should create separate reports per claim. |
| CR56 Label Claims & Statements - Constructed Non Food | Report is based on the OLC Section of the Constructed Non Food Specification, and finds any Specifications which contain the Claims specified in the filters.
There will be one report query to accommodate all Constructed Non Food Spec claims. Since most claim fields in the OLC section are tables, including multiple claims and filers in the same report output will result in duplication of rows, therefore users should create separate reports per claim. |
| CR57 Label Claims & Statements - BWS | Report is based on the OLC Section of the BWS Specification, and finds any Specifications which contain the Claims specified in the filters.
There will be one report query to accommodate all BWS Spec claims. Since most claim fields in the OLC section are tables, including multiple claims and filers in the same report output will result in duplication of rows, therefore users should create separate reports per claim. |
Defect Numbers: 27225672, 29252151
A Display an empty row on tables parameter is added to the System Parameters record in the System Control section of the Admin area. This can be located on the Products tab within this page.
The parameter can be set by an administrator user with the Oracle Authorized User role. It causes data entry tables to be pre-populated with a single empty row, when creating a record.
Originally the default behavior, which was changed in release version 17.0.10.0, it now becomes configurable. Pre-filling tables with an empty row can help guide the user for data entry, particularly in tables that have mandatory columns, such as in the product specification's Specification History table. If not enabled, the user must click the Add button to add the first row to the table.
The system text for the screen label is in the Admin group:
displayEmptyTableRows=Display an empty row on tables?
Defect Numbers: 28916500, 28941873
A Synchronize Workflow option is added to the Actions menu of records that are subject to a workflow process.
This facility is intended for use by Oracle when investigating workflow related issues, so by default it is hidden from all users except the Oracle Authorized User logon (however its use is controllable by the Permissions spreadsheet).
The option appears when the record is opened in read mode. When selected, the user is presented with a confirmation dialog box before refreshing the record's status according to its actual workflow state.
Workflow-enabled records can end up in a situation where their displayed status does not match their actual progression in the workflow, typically resulting from the failure of the background job that progresses the status. This facility provides a means of performing a manual refresh, thus allowing the record to continue to be used while the root cause of the synchronization issue is investigated.
Defect Numbers: 29293406, 29341349
An enhancement is made to the suite of Brand Compliance REST APIs to allow control over the protocol of the returned URL/URI links.
A new REST API Path system parameter is added to the System Control section of the Admin area for the definition of the path used by the REST APIs.
When calls are returned from the REST API endpoints, the URL/URIs contained therein will be in the format of the specified path, thus with the protocol set to either HTTP or HTTPS accordingly. If the parameter is not set, the HTTP protocol will be used.
For example:
Currently the APIs will return their reference URLs in the format HTTP://www.website.com:80/services/rest/user/4.
This now allows the client to specify the URL that they would prefer to be returned HTTPS://www.website.com:443/services/rest/user/4. This is accomplished by simply entering HTTPS://www.website.com:443 into this new field.
|
Note: To ensure that an HTTPS response is returned within the XML from the API calls, ensure that the :443 port is specified in the new URL field on the System Parameters maintenance screen. |
This change is applicable to clients that have implemented the core API calls in earlier versions of Brand Compliance, where they have implemented an expected return of HTTPS rather than HTTP.
The enhancement is applicable to the following APIs:
ActivityRestService
AttachmentRestService
AuditRestService
BusinessCategoryRestService
ContactRestService
DataPrivacyRestService
MyArtworkRestService
ProductRecordRestService
ProductSpecificationRestService
ProjectRestService
ScorecardRestService
SiteRestService
SupplierRestService
UserRestService
The system text for the new system parameter field label is:
view.systemConfiguration.page.globalSystemConfigurationParametersPage.restApiPath=Rest API Path
Defect Number: 29615546
An enhancement is made to the Report Schedule record to store the SQL statements that were run to generate the report.
The main purpose for storing the SQL statements is to aid support when investigating issues with the report.
The following tables list issues fixed in this release:
Table 1 General Fixed Issues
| Defect Number | Description |
|---|---|
|
22997791 |
Paging of readership log in a News item A fix is made to rectify an issue with the paging control on the news item readership log. The issue caused the count in the paging bar at the bottom of the list to show an incorrect number of pages when the search was used to filter the log. |
|
27090553 |
Error when adding a column to Batch Jobs list view A fix is made to rectify an error when adding a column to the Batch Jobs list view. |
|
27875173 |
Design Agency list view columns A fix is made to rectify an issue with the columns available to add to the Design Agency list view in the Products Admin area. Additional columns such as Comments, Phone, Fax, Specification Type, and File Type can now be optionally added to the list view, in addition to the default set of columns. |
|
27908761, 27993930 |
Missing literals in Audit Admin area and Produce Product Records A fix is made to rectify an issue with missing system text literals in the following list views in the Audits & Visits Admin area:
The fix also rectifies an issue with missing system text literals in the following areas of Produce Product Records:
The system text for the screen labels are in the Product group: productRecordProduceFlow.view.advancedSearch.fieldSet.searchCriteria.CountryWhereSoldlistTitle=Countries Where Sold productRecordProduceFlow.view.advancedSearch.ProductRecordAdvancedSearch=Advanced Search productRecordProduceFlow.produce.view.ProductRecordlist.addColumnDialog.CountryWhereSoldlistTitle=Countries Where Sold And in the Audits group: view.advancedSearch.fieldSet.searchCriteria.glossaryAnswer.page.glossaryAnswerDetails.fieldSet.details.commentAvailable=Includes Comments view.advancedSearch.fieldSet.searchCriteria.view.glossaryQuestion.viewGlossaryQuestion=Details view.GlossaryAnswer list.addColumnDialog.glossaryAnswer.page.glossaryAnswerDetails.field.Set.details.commentAvailable=Includes Comments GlossaryQuestion list.addColumnDialog.view.glossaryQuestion.viewGlossaryQuestion=Details Impact on existing system Any client-specific overrides or language translations of the system text must be manually applied as a post-release task. |
|
28034729 |
Button color styling A fix is made to rectify an issue with the styling of buttons when editing Custom Field records. The standard color styling is now applied to ensure the Select All, Remove All, and dialog box buttons are clearly visible. |
|
28106868 |
Supplier Name in Business Language in Supplier spreadsheet A fix is made to rectify an issue with the Supplier Name in the Business Language field not being mandatory when importing a supplier using the spreadsheet option. If the Supplier Name in Business Language system parameter is enabled, when importing a new supplier using the spreadsheet upload option, the Supplier Name in Business Language field is now validated as being mandatory. |
|
28214128 |
Artwork Application URL system parameter cleared A fix is made to rectify an issue with the Artwork Application URL system parameter being nulled during an upgrade release. If the system parameter is set, the value is now retained following an upgrade. |
|
28721930 |
Presentation of Login page when operating IE Compatibility Mode A fix is made to rectify an issue with the presentation of the Login page when opening Brand Compliance in Internet Explorer with Compatibility Mode enabled. The issue caused the Login page to left-justify within the browser window. Impact on existing system The fix requires the system administrator to change the oracle-login style sheet. See the Post Release Tasks for instructions. |
|
28727414 |
Attachment description not shown A fix is made to rectify an issue with the file attachment description defaulting the text Attachment when adding an attachment to any record. The issue resulted in attachments being added without a description. The description is now blank by default when adding an attachment, with validation ensuring the user enters a description. |
|
28732105 |
Priority field missing from Specification glossary list views A fix is made to rectify an issue with the Priority field not being available to add as a column to the following glossaries in the Product Admin area:
|
|
28786613, 29055509 |
Error when exporting Business Categories A fix is made to rectify an error when exporting the Business Categories glossary using the Bulk Glossary Export facility in the Admin area. The fix addresses where the glossary export batch job was failing with a could not get next iterator result error. |
|
28795022, 27991337 |
Issues with glossary exports and User list views A fix is made to rectify an issue with the export of Business Category and Surveillance Classification glossaries. If an entry in the glossary has been soft deleted, it is now included in the export spreadsheet, with a column indicating a deleted record. Also, Roles, Sites, and Authority Profiles may now be added as columns in the User list views, and can be used in the Quick Search. |
|
28806780 |
Library document folder shows incorrect count A fix is made to rectify an issue with the count of documents within a Library folder showing an incorrect total. The issue occurred for Supplier users. |
|
28937299 |
Top Category flag not set when importing Business Categories A fix is made to rectify an issue with the flag that identifies a business category as a top level category not being set when importing business categories from a spreadsheet. When using the Import option from the list view to import business categories, the top level category flag is now set to true or false accordingly. |
|
29021174 |
Missing literals in Specification OLC section A fix is made to rectify an issue with missing system text literals in the Change History section of the product specification. System text items have been added for the Safety and Warning Phrases field in the Other Labelling Copy section when shown as a field change in the specification's Change History page. The system text for the screen labels are in the Specification group: labelling=Labellingsafety.textParameters=Safety and Warning Phrases Impact on existing system Any client-specific overrides or language translations of the system text must be manually applied as a post-release task. |
|
29151488 |
Support Email Address system parameter cleared A fix is made to rectify an issue with the Support Email Address system parameter being reset to a default value during an upgrade release. The email address value is now retained following an upgrade. |
|
29153222 |
Performance improvement: GNB Specification synchronization A performance improvement is made to the synchronization of Product Specifications for portals that operate the Global Network Bus functionality. The fix addresses a timeout issue that occurred when synchronizing specifications between portals. |
|
29233083 |
Error when logging in A fix is made to rectify an error when logging in. The error was caused by the query that builds the user's Tasks list on the Home page. When the task list on the home page attempted to load the metric for the number of produce specifications awaiting supplier approval, this could cause a timeout preventing the user from logging in to the application. |
Table 2 Supplier Fixed Issues
| Defect Number | Description |
|---|---|
|
27388887 |
Audit deletion message A fix is made to improve the error handling when attempting to delete the last audit held against a site. The system text for the error message is as follows: cannotDeleteLastAuditDialogTitle=Audit Delete Error cannotDeleteLastAuditDialogMessage=The last audit or visit for a site cannot be deleted Impact on existing system Any client-specific overrides or language translations of the system text must be manually applied as a post-release task. |
|
28996953 |
Block Answers missing from Audit Checklist Template Upload A fix is made to rectify an issue with the Allow Block Answers field being missing from the spreadsheet used to import and export Audit Checklist Templates in the Admin area. The standard glossary import/export facility supersedes the Upload Checklist Template option as the method for uploading Audit Checklist Templates. Impact on existing system The existing Upload Checklist Template option is removed from the Audit Checklist Templates list view in the Admin area. When importing Audit Checklist Templates, any referenced questions and answers must have previously been created, either by editing the relevant glossary, or by using the equivalent glossary import facility. |
|
29550198 |
Error when confirming Site Mandatory UIM items A fix is made to rectify an error when a supplier user opened Site Mandatory Items in the Urgent Items Manager list of tasks. The tasks affected were those related to the entry of mandatory information following completion of the registration process. |
|
29632867 |
Error when printing supplier registration Terms and Conditions A fix is made to rectify an error when clicking the Print button when accepting the terms and conditions during the supplier registration process. |
Table 3 Product Fixed Issues
| Defect Number | Description |
|---|---|
|
28238673 |
Specification Format not editable in Nutrition Panel configuration A fix is made to rectify an issue with the Specification Format field not being editable when creating a new Nutrition Panel record in the Product Admin area. |
|
28810627, 28868457 |
Quantity field in Product Record not flagged as mandatory A fix is made to rectify an issue with the Quantity field in the Product Record not showing a red asterisk to indicate it is a mandatory field. |
|
28842044 |
Site names in Specifications list view download A fix is made to rectify an issue with the download of product specifications from the list view to a spreadsheet, where the site name column was showing as numbers in the downloaded spreadsheet. The site names column in the spreadsheet now correctly shows the site name in the spreadsheet. |
|
28871718 |
Inactive glossary entries not validated when progressing a Specification A fix is made to rectify an issue with the validation of inactive glossary entries in Product Specifications when progressing their status. If the specification had values selected from a glossary that had since been deactivated, the validation was not flagging them as invalid values. For example, if a Design Agency has been selected in the Other Labelling Copy section, and subsequently deactivated in the glossary, when the specification is validated, the selected value will now be flagged as invalid. |
|
28874677, 28850589 |
Unable to open a Specification A fix is made to address an issue with the Please select a row message preventing a product specification from being opened from the list view, even when a row has been selected. The issue is intermittent, so diagnostic logging has been added as an attempt to identify the cause. |
|
28886334 |
Allergen answers cleared when saving a Specification A fix is made to rectify an issue with the answers to questions in the Dietary and Allergy section of a Food product specification not retaining their value when the specification is saved. The issue also resulted in some answers not being included in the Set all statements option. |
|
28910618 |
Unable to undelete deleted Specifications A fix is made to rectify an issue with deleted product specifications not being accessible to users who have the requisite access rights. The deleted specifications could not be opened or undeleted. The issue occurred where the portal was operating the Enhanced Access Control (EAC) extended permissions facility. |
|
28946666 |
Process Controls section not validated in a Specification A fix is made to rectify an issue with the Process Controls section of the product specification not being validated. The issue occurred when mandatory field rules were configured to apply to fields such as the Process Steps or Custom Fields. The fields are now validated accordingly. |
|
28954753 |
Sequence of Finished Product Standards Allergen declarations in Specifications A fix is made to rectify an issue with the sequencing of table rows in the Finished Product Standards product specification section. The issue caused the rows to appear in a different order when opened in read compared to the order in edit mode. |
|
28960501 |
Counter Ticket Pack Copy heading formatting A fix is made to rectify an issue with the formatting of text in the heading of the Counter Ticket Pack Copy file for Food and Produce specifications. A minor correction is applied to insert missing spaces in the page heading, to separate the values from their fixed text labels. The issue was not present in the Pack Copy files of other specification types. |
|
28975463 |
Pack Copy version missing in OLC section for FNF and CNF Specifications A fix is made to rectify an issue with the Pack Copy Version field not being updated in the Approval fields of the product specification's Other Labelling Copy section when the Pack Copy file is generated. The issue occurred in Formulated Non Food and Constructed Non Food specifications. |
|
29143835 |
Able to copy a deleted Product Specification A fix is made to rectify an issue when creating a new specification by copying an existing specification. The issue resulted in deleted specifications being available to be copied within the New Specification wizard. |
|
29169133 |
Certification field in Specification's Packaging section A fix is made to rectify an issue with the Certification field in the Packaging Components page of the product specification's Packaging section being populated with null when no value had been entered. |
|
29534395, 29648012 |
Error when adding File Type to Design Agency list view A fix is made to rectify an error when attempting to add the Field Type column to the Design Agencies list view in the Products administration area. |
|
29581556 |
Error when entering a decimal value when copying a Specification A fix is made to rectify an error when creating a new product specification by copying an existing specification. The error occurred when a decimal value (such as 1.5) was used as a search value when locating the existing specification to be copied. Decimal values may now be searched without error. |
Table 4 Project Fixed Issues
| Defect Number | Description |
|---|---|
|
28922140 |
Auto completion of Project Activities A fix is made to rectify an issue with project activities not completing automatically when a previous key activity was completed. The issue occurred where an auto completing activity was set to be both a key and a gate. |
|
29061840 |
Gate Activity completed before previous Key Activity is completed A fix is made to rectify an issue with Gate activities moving to Completed or Approval Required status before all previous Key activities have been completed. The issues occurred with activities that were set to auto complete. |
Table 5 Reports Fixed Issues
| Defect Number | Description |
|---|---|
|
27875827, 28040757, 28211914, 29191700 |
Legacy Reports: Lead Business Categories missing from Produce Specification reports A fix is made to the Product reporting domain to rectify an issue with Lead Business Categories not being available for use in Produce Specification reports. The issue was due to the data being located on the Specification for Produce, rather than the Product Record. The following Lead Business Category columns are now available: Spec Main Details > Main Details > Lead Business Category (Produce) Spec Main Details > Main Details > Lead Business Category Path (Produce) Note: This item relates to Legacy/JasperSoft reports. |
|
28113375, 28206335 |
Legacy Reports: Error when reporting on Specification's Allergen Label Declaration A fix is made to rectify an error when reporting on the Allergen Label Declaration field of a specification's Allergy & Dietary Advice section. Note: This item relates to Legacy/JasperSoft reports. |
|
28877545 |
Legacy Reports: Error in Reports installer A fix is made to rectify an error during the installation of the Reports module as part of the upgrade process. The installer code has been corrected to prevent the error condition occurring. Note: This item relates to Legacy/JasperSoft reports. |
|
28977487 |
Legacy Reports: Attachment columns in Project reports A fix is made to rectify an issue with the reporting of attachments in the Projects reporting domain. The issue was due to the join between attachments and the project details. The Attachments column can now be added to Project reports to show details of the project's file attachments. Note: This item relates to Legacy/JasperSoft reports. |
|
29197680 |
Legacy Reports: Change History Comments field labels A fix is made to rectify an issue with the label of the Change History Comments fields in the Products reporting domain. The fields are now correctly labelled as: Change History > Product Record > Status Changes > Comments Change History > Product Specification > Status Changes > Comments Note: This item relates to Legacy/JasperSoft reports. |
Table 6 Library Fixed Issues
| Defect Number | Description |
|---|---|
|
28312628, 28780743 |
Error when opening a Library document folder A fix is made to rectify an error when opening a document folder. The issue occurred when the documents contained a large number of attachments. |
|
28745090 |
Document folder count not updated A fix is made to rectify an issue with the count of documents within a document folder not being updated when a document is copied, deleted, or archived. The count is now automatically incremented or decremented accordingly. |
|
28997137 |
Error when creating a Library document folder A fix is made to rectify a timeout error when creating a document folder. |
Table 7 Application Program Interfaces Fixed Issues
| Defect Number | Description |
|---|---|
|
28842706 |
Specifications REST API date validation A fix is made to rectify an issue with the modifiedSince and modifiedUntil date parameters not being validated when passed to the Specifications REST API /services/rest/specification List of Values function. The parameters are now validated to ensure they are valid dates/times, with any errors returned in an ErrorMessage element as an HTTP 417 message. |
|
28842706 |
Specifications REST API pageSize and offset validation A fix is made to rectify an issue with the pageSize and the offset parameters not being validated when passed to the Specifications REST API /services/rest/specification List of Values function. The parameters are now validated to ensure that if passed then the pageSize must be an integer between 1 and 100, inclusive, and the offset must be 0 or greater. |
|
29119359, 29119610, 29119801 |
Tasks REST API returning incorrect list of Tasks A fix is made to rectify an issue with the Tasks REST API returning an incorrect list of task URIs for a user. |
System Text
Please be aware that for existing implementations there is new system text which will be automatically uploaded with this release. If there are any client-specific overrides or language translations required, they must be manually applied as a post-release task.
In this release, the following items have new or amended system text:
Prepopulating Tables with Empty Rows (defect numbers 27225672, 29252151).
HTTP/HTTPS Protocol in REST APIs (defect numbers 29293406, 29341349).
Missing literals in Audit Admin area and Produce Product Records (defect numbers 27908761, 27993930).
Missing literals in Specification OLC section (defect number 29021174).
Audit deletion message (defect number 27388887).
Reporting
If a reporting release has also been arranged for your maintenance upgrade (see Table 5), then you should ensure that all of your current scheduled reports and any future scheduled reports are updated so that they are no longer scheduled to run at the same time as the reporting is doing its full 24 hour refresh. Please discuss this with your CSM if required.
The Reporting Scheduler refresh task runs at midnight and will take a variable amount of time to complete based upon your database size. During this time no reports can be run, so the start times of scheduled reports may need to be adjusted accordingly.
Permissions
The following change should be made in the Products tab of the Permissions spreadsheet to ensure suppliers can accept produce specifications:
On row 83, change the access level to F (for full access for Produce).
If the portal is to be configured to prevent supplier users creating non-Produce Product records, while still allowing them to create Produce Product Records for the acceptance of Produce specifications, the following change should be made in the Products tab of the Permissions spreadsheet:
On row 22, change the access level to W (write access for non-Produce).
On row 83, change the access level to F (for full access for Produce).
|
Note: If the portal's Permissions spreadsheet has previously been customized, the rows to be edited may differ to the row numbers stated. For this change, the rows to be edited are as follows.For non-Produce, change this row from F (or C) to W: 
For Produce, change this row from W to F:  |
The instructions for downloading and uploading the amended Permissions spreadsheet are as follows:
Log in as an Oracle Authorized Administrator user and go to Company > Admin > Roles & Permissions.
Open the Permissions page.
Download the active spreadsheet by selecting the row with true in the Active Permissions column, click Download Selected, and save locally.
Edit the downloaded spreadsheet, make the changes described above, then save the spreadsheet.
Upload the edited spreadsheet by clicking Upload Permissions, select the spreadsheet, and click Ok.
Apply the changes by selecting the uploaded spreadsheet row, click Process Selected, and then click Ok to confirm.
Style Sheets
To rectify the issue with the Login page being left-justified if accessing Brand Compliance using Internet Explorer with Compatibility Mode enabled (see 28721930 in Table 1), the system administrator should edit the oracle-login style sheet as follows:
Select Company > Admin > System Control.
Select the Branding item from the left-hand menu.
Click the link to download the oracle-login.css style sheet.
Edit the downloaded file, change the .panel block of statements from this:
.panel {
width:820px;
height:400px;
position:absolute;
left:50%;
top:90px;
margin-left:-410px;
/*margin-top:-200px; */
background:url(../../images/Bespoke_Images/shadow.png) top;
left no-repeat;}
To this, removing the left no-repeat; line:
.panel {
width:820px;
height:400px;
position:absolute;
left:50%;
top:90px;
margin-left:-410px;
/*margin-top:-200px; */
background:url(../../images/Bespoke_Images/shadow.png) top;
}
In the Branding section, select Edit from the Actions menu.
Click the Browse button next to oracle-login.css.
Select the modified oracle-login.css file on your computer and click Open. This should upload the modified style sheet into the application.
Click Save and Exit from the Actions menu.
Refresh the browser page using F5. The changes made to the style sheet should now be in effect.
Mandatory Field Rules
The Prepopulating Tables with Empty Rows functional enhancement (defect numbers 27225672, 29252151) introduces a system parameter to control the defaulting of empty rows within tables.
If the parameter is enabled, any mandatory field rules that were configured as a result of the 17.0.10.0 fix, to prompt the user to complete a table, such as the Specification History, may now be removed.
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.13.0
F20977-02
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.
