3 Noteworthy Resolved Issues
This following table 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 | Description |
---|---|---|
General: Custom Fields |
31080918, 31887208, 32101363, 32201145, 32786654, 32976117 |
Error when saving Custom Fields glossary record A fix has been made to rectify an error that occurred when saving a Custom Fields glossary record. The error occurred after removing values from the Field Sets table. See the Database Update Scripts section. |
General: Duplicate Emails |
33581743, 33624924 |
Duplicate notification emails A fix has been made to rectify an issue with notification emails being sent multiple times. The issue relates to the following batch jobs, which were running on multiple servers, and were therefore issuing duplicate notifications:
The batch jobs now run just once, regardless of the number of servers. |
General: Global Network Bus |
29793880, 32392153 |
Global Network Bus intermittently not displaying failure messages Failure messages which contain characters which are invalid in XML such as the ‘&’ result in no failure messages being displayed. An update to manage these characters has been implemented so General Network Bus (GNB) failure messages are always displayed. |
General: Global Network Bus |
32661927, 33331064, 33556264 |
Error occurs on product specification sync process via the GNB The product specification sync process fails when it attempts to create a new product covered record instead of updating an existing one. This issue generated a duplicate key error. An update to the Product REST API resolved the underlying issue in identifying an existing product covered record to update. |
General: Global Network Bus |
32662027, 32750531 |
Failure when creating new multi-pack specification during synchronizing of Product Specifications During the synchronizing of Product Specifications, a failure was identified when creating a new multi-pack specification. An internal change has been made to resolve the issue. The change does not affect the Product Specification API. |
General: Global Network Bus |
33777866 |
Duplicate Key error occurs on product specification sync process via the GNB The product specification sync process fails when it attempts to create a new record instead of updating an existing one. The issue occurred for specifications which contained a Recipe and Raw Materials section or an Advanced Packaging section with component details. This issue generated a duplicate key error. An amendment to the Product Specification REST API prevents the Duplicate Key issue from occurring and the product specification records are successfully updated. |
General: Global Network Bus |
29507463 |
Enhancement to validate that a satellite record is enabled before failure record re-submitted To prevent a loss of data due to data not being successfully synced, a new validation check has been introduced. When Re-submit Synchronisation is selected where a satellite record is disabled, an error will be generated: Re-submission is not possible because the Satellite is disabled. |
General: Legal Notices |
33815356, 33815580 |
Legal Notices A change has been made to the Legal Notices link on the footer bar, to reference the document located here: https://docs.oracle.com/cd/E51320_01/index.html, instead of storing the document within the source code. Also, the Legal Notices text has been updated to remove the reference to the Jaspersoft license. The key to the new system text is legalAndNoticeDialogText1. |
General: List Views |
34101805, 34135054 |
Error when adding columns to list views The move to Oracle database has meant certain columns must be converted from CLOB to CHAR data type to allow them to be added to list views. The fix applies to the following list views:
|
General: New User Email |
NA |
Retail Home link in new user email A change has been made to the email template that is used to notify new users that they have been registered in the ORBC portal. Retailer users will have the ability to access ORBC from Retail Home, along with any other Oracle Retail applications they have access to. Supplier users do not have access to Retail Home. The new user email template (IDCS2) has therefore been amended to include additional text when the email is generated for a retailer user, providing them with a link to Retail Home. Note: Any language translation overrides for the email text must be applied manually as a Post Release Task. |
General: News Item |
34105130 |
Presentation of News items A fix has been made to rectify an issue with the presentation of News items, where no separation between items was being shown. |
General: Permissions |
33354739 |
Surveillance Lab User access to Tasks/Assignments A fix has been made to prevent users with just Surveillance Laboratory User access rights seeing entries relating to Library documents in the Tasks/Assignments app. |
General: Permissions |
33354760 |
Surveillance Lab User access to Tasks/Assignments A fix has been made to prevent users with just Surveillance Laboratory User access rights using the option to view other users’ tasks in the Tasks/Assignments app. |
General: System Text |
31693367, 33281390, 34006657, 33326032, 33343345 |
Help Text not available for some fields on Product Specifications Help text was not appearing against fields where the key (system text Code field) for labelling fields did not follow standard conventions. This was identified for, but not limited to, the Product Specification fields:
An update has been implemented to ensure the help text is presented for all fields. |
General: Update Script |
NA |
Dietary & Allergy Questions update script A fix has been made to a database update script related to the release 20.1 Configurable D&A feature, which updates the Dietary & Allergy Questions glossary. The fix ensures that all configured D&A Declaration types are now included in the update. |
General: User API |
33319402 |
Enhancement to the User REST API The User REST API has been enhanced to include the <restrictedAuditorAccess> XML TAG, which corresponds to the "Restricted Auditor Access" flag that is available for RETAILER Users. |
General: User Login |
33454275, 33722501, 33793407, 33903749 |
Users unable to log on to ORBCM system An issue occurred after a system restart whereby users were unable to log on to the ORBCM system, due to a cache issue. An update has been made to prevent the cache issue occurring which will prevent the login error. |
Products: API |
32889620 |
Update of Product records using the Product Record REST API results in an error An issue was identified with updating existing Product records using the Product REST API when the records have existing Shipping Case Code data. A code change to the Product REST API to successfully process the update of Products which contain Shipping Case Code information has been implemented. |
Products: List View |
33756308 |
Benchmark columns in Product list views and data extract A fix has been made to make the Benchmark Date and Benchmark User fields available for selection in the Product Record list views, and in the advanced search. The fields are also added to the Product Record data extract file (columns AF and AG). New system text items are added automatically, however any translation overrides will need to be set up manually. See Post Release Tasks. |
Project: Activities |
33487331 |
Update to the Activity Sub Status intermittently caused an error An update has been implemented so that Activity records can now be successfully saved after editing the Sub Status. |
Reports: Advanced Packaging |
33246837 |
Tamper Evident field not available in the Advanced Packaging Component query for reporting on The Tamper Evident field was identified as not being available for reporting on, under the Advanced Packaging Component query. The query has now been updated, to include the Tamper Evident field. A new system text entry is available for managing the query column name. See Post Release Tasks for further details. |
Reports: Advanced Packaging |
33410610, 33895252 |
Advanced Packaging reports do not include Produce specification types The Advanced Packaging queries do not provide Advanced Packaging data for Produce specifications. Updated queries now include the data for the Produce specification type, for the following queries:
|
Reports: Allergen |
33608625 |
Information associated with Natasha’s Law is not available for Reporting on Updates to the following queries to ensure the inclusion of Other Allergen Declarations and Declaration fields:
|
Reports: Audits |
33544252 |
Audit query provides unexpected data The Audit query produced the wrong data for the Issue Changed By and Issue Created By fields. The query has been updated so the fields are now populated with the correct data. |
Reports: Contact Role Query |
33745884, 33824532 |
Site Selection columns in Contact Role query A change has been made to the Contact Role reporting query to include the following columns from the Contact record:
Reporting System Text records are added automatically for the new columns, however any translation overrides will need to be set up manually. See Post Release Tasks. |
Reports: Nutrients |
33521666, 33485431 |
Nutrient queries missing a required field for reporting on The Serving Size field was missing from the Nutrient queries:
An update to the queries to include the field has been implemented. |
Reports: Nutrition |
33516850 |
Energy calculation update for India Nutrition Labelling requirement Due to a legislation change, an update was required to the Energy calculation for India Nutrition Labelling. The change is to the polyols multiplier, going from 2.4/10 to 2/8 for kcal/kj respectively. |
Reports: Project Brief Extract |
33698277 |
Users and Roles in Project Brief Extract file A fix has been made to rectify an issue in the Project and Activity Brief Extract file where it was not possible to align the contents of the Role and Users columns. The file now outputs the same number of entries in the Role (X) and Users (Y) columns in the spreadsheet, in sequence, thus allowing for direct correlation between the two. Where a role has multiple users, the role name is duplicated in order to pad out the list of roles to match the list of users. The two comma‑separated lists can then be aligned to determine which users belong to which roles. |
Reports: Product Shelf Life |
33503861 |
Pack Coding query is missing a field An update to the Pack Coding query has been implemented to include the Period field. A new system text entry is available for managing the query column name. See Post Release Tasks for further details. |
Reports: Product Specification |
32844324, 32949597, 33030981 |
Specification History fields required for Reporting on are not available Specification History information is required in certain queries to identify the reason work is being carried out on a new version of a spec. The following fields from the Specification History table (Specification Main Details) were identified for reporting: The data is concatenated where there is more than one row in the Specification History table for the given specification.
These fields are now included in the following queries:
|
Reports: Product Specification |
33814461 |
Report query updates for Specifications The reporting database update script has been updated to include the population of fields for the following Product Specification sections:
The fields being populated are back-end fields used by reporting and maintained by the system as amendments to records are made. This routine sets the appropriate values for these fields for historical records that may have not been amended since introduced. See the Database Update Scripts section. |
Reports: Products |
33378451, 33410327 |
Spec Type field not available in the Product query for reporting on The Spec Type field was identified as not being available for reporting on under the Product query. The query has now been updated to include the Spec Type field. A new system text entry is available for managing the query column name. See Post Release Tasks for further details. |
Reports: Scheduling |
33603668 |
Report Scheduling does not give the schedule creator access to generated reports Previously, a user’s details needed to be included in the Recipients for the scheduling record to access any report output for the schedule. An update has been implemented so a user who creates a report scheduler record will automatically have access to the reports produced. |
Reports: Web Service |
33564049 |
Global Network Bus Errors report (CR60) A Change has been made to the method of identifying Web Service Log errors to be included in the Global Network Bus Errors report. As a result, the Outgoing Message column is no longer suitable for use as a filter on the Web Service Log report query. |
Specification: Nutrition Declaration |
33631679 |
Empty rows in Nutrition Declaration A change has been made to reinstate empty table rows in the product specification's Nutrition Declaration HTML, which were removed by an earlier change. This is to maintain backwards compatibility where clients process the HTML (such as for use in an external system). The empty rows now appear in the HTML as pairs of <TR> tags. For clients that process the Nutrition Declaration HTML, it may be necessary to regenerate affected declarations. See Post Release Tasks. |
Specification: Pack Copy Files |
32887043, 33065463, 33538669 |
Pack Copy files for multi Specifications A fix has been made to rectify an issue with the generation of Pack Copy files for Product Specifications. The issue occurred in multi-pack specifications and those with additional sections from alternative specification types. It resulted in multiple full Pack Copy files being generated for a specification instead of a single full Pack Copy plus tables for the relevant components or sections. The fix includes updates to the core Pack Copy files RTF templates. It also applies to Produce specifications. |
Specification: Print Height Table |
33571846, 33571850 |
Specification Gate Step field locking rules A change has been made to the field locking rules for the Print Height table, which appears in the Quantity page of the Product Specification's Other Labelling Copy (OLC) section when the Fixed Weight option is selected. This was previously automatically locked beyond Collaborative Draft status. The locking is now controlled by the Specification Draft Statuses field in the Static Settings page of the System Parameters record in the Admin area (this parameter is not editable, and is only visible if it was changed from the original default). Adding Gate Step to the Specification Draft Statuses field makes the Print Height table editable at Gate Step status. The configurable Spec Locking rules can be used to lock the Print Height table fields earlier if required. The Path values for locking the Print Height table are:
|
Specification: Status Change |
NA |
Error when changing Specification status A performance improvement fix has been made to rectify an error which occurred when changing the status of a Product Specification. The error resulted in a session timeout during the specification status change validation. |
Supplier: Audits |
33640020 |
Checklist Answers not appearing in the correct order After changing the order of Available Answers against a Checklist Answers record, where the Answer Type is set to Multi Choice, the order in read mode is incorrect. In addition, the Answers appeared in alphabetical order against the Checklist record, under Select Answers dialog, rather than per the configuration. A fix has been applied so after editing the order of Available Answers, against a Checklist Answers record, the order is retained in read and edit mode. A further update, for Checklist records, ensures the order of Checklist Answers is now the same as the Checklist Answers record. See the Database Update Scripts section. |
Supplier: Audits |
33885262 |
Unable to view audits awaiting corrective action from the Task App Selecting the Audits awaiting corrective action from the Task App does not open a list view of the records but causes the application to freeze/slow before returning to the home page. A performance issue in the underlying query has been identified and resolved so the Audits awaiting corrective action on the Task App can be successfully selected to open a list view. |
Supplier: Audits & Visits |
33265075, 33190648 |
Overdue email notifications not being sent to Retailer users Overdue email notifications were only sent to Retailer users if the Send Audit/Visit Due Notifications to Retailer system parameter was set to Yes as well as the required Send Audit/Visit Overdue Notifications to Retailer. An update now ensures overdue email notifications to retailers is only reliant upon the Send Audit/Visit Overdue Notifications to Retailer system parameter. |
Supplier: Contacts |
34117916 |
Error when editing Supplier Contacts A fix has been made to rectify an error that occurred when editing Supplier Contacts. |