1 Feature Summary
Oracle Retail Supply Chain Collaboration Cloud Service 25.1.401.0 is a Critical Update.
Oracle Retail Supply Chain Collaboration Cloud Service includes the following modules:
-
Oracle Retail Supply Chain Hub
-
Oracle Retail Supplier Evaluation
This chapter describes the feature enhancements in this release.
Noteworthy Enhancements for Supplier Evaluation
This guide outlines the information you need to know about new or improved functionality in the Oracle Retail Supply Chain Collaboration Cloud Service update and describes any tasks you might need to perform for the update. Each section includes a brief description of the feature, the steps you need to take to enable or begin using the feature, any tips or considerations that you should keep in mind, and the resources available to help you.
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.Column Definitions
-
Feature: Provides a description of the feature being delivered.
-
Module Impacted: Identifies the module impacted associated with the feature, if any.
-
Scale: Identifies the size of the feature. Options are:
-
Small: These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.
-
Medium: These UI or process-based features are typically comprised of field, validation, or program changes. Therefore, the potential impact to users is moderate.
-
Large: These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.
-
-
Delivered: Identifies whether the feature is Enabled or Disabled upon initial delivery.
- Customer Action Required: You must take action before these features can be used. These features are delivered disabled and you choose if and when to enable them.
Table 1-1 Noteworthy Enhancements
| Feature | Module Impacted | Scale | Delivered | Customer Action Required? |
|---|---|---|---|---|
| MFCS Item Integration (Inbound) |
Product |
Medium |
No |
Configure system parameters. |
| JET UI Supplier Form | Supplier | Medium | No | Enable JET UI Forms. |
| Audit/Visit and Confirm Details Notification | Supplier | Small | No | Configure system parameters. |
| Process & Activity Brief Extract Filters | Process | Small | Yes | No |
| JET UI List View Improvements | All | Small | Yes | No |
MFCS Item Integration (Inbound)
The existing integration of Supplier Sites from Merchandising Foundation Cloud Service (MFCS) is extended to include the integration of Items from MFCS, as a means of automatically creating Product Records corresponding to the MFCS items at Style or SKU level.
The interface is one-way, from MFCS to ORSE. It is managed in ORSE using the existing integration architecture to call the MFCS API for retrieval of items, and the creation/update of Product Records in ORSE; the MFCS supplier and item codes being the common identifiers.
The key features of the integration are:
- Automated call is scheduled in ORSE to retrieve the latest MFCS item data (based on the same concept as the existing MFCS-ORSE Supplier Site integration).
- Utilizes an existing standard MFCS Item API.
- Dynamically synchronizes items/product between the systems based on approval in MFCS.
- Ability to define whether items are integrated at Style or SKU level.
- Creation and update of ORSE Product Records.
- Stores MFCS item number in the supplier/site specific ORSE Product Record as common identifier (the MFCS item number may be used by multiple suppliers).
- Just basic data such as item number, title, status and supplier/site is mapped, with predefined default values used where necessary to populate mandatory fields.
- Prerequisites are the existing MFCS-ORSE Supplier Site integration is enabled, and the Product Codes table in the Product Record is enabled.
- If it does not already exist, a Retailer User is created with the name TBC as part of the installation. This is used as a default if a Technologist or other contact cannot be derived when creating a Product Record through integration.
Note:
See the Oracle Retail Supply Chain Collaboration Cloud Service Administration Guide for details of the configurable system parameters.JET UI Supplier Form
This release includes the Supplier form as part of the transition of forms to the new JET UI design.
The Supplier form is used to maintain the details of the individual supplier records, such as name & address and contact details, billing and invoicing information, showing associated Site and Product Records.
For Supplier users, the Supplier form is presented as their Company form.
The new JET UI form is based on the Oracle Redwood design standard, giving a common look and feel with other Oracle Retail products.
With JET UI enabled, the new JET UI Supplier form can be enabled with the JET UI Forms Enabled system parameter; or individual users can enable the forms using the new Preview JET UI Forms setting in their User Preferences.
Examples
The Details page contains the main supplier and contact details:
The Billing Details page contains the billing and invoicing details:
The Associated Records page contains lists of the associated Contacts, Sites and Product Records:
Audit/Visit and Confirm Details Notification
This enhancement provides the ability for clients to control the frequency of the notification emails sent when Audits & Visits are due or overdue, and when Supplier/Site accounts require confirmation that the details are up to date. Currently the notifications are sent on a daily basis. The changes apply to the notifications sent to both Supplier/Site users and to Retailer users.
System parameters are introduced to control the frequency that the emails are to be sent. For example, setting the Audit Overdue email to 7 days would see the email being sent when the Audit initially becomes overdue, then being re-sent every 7 days until it is no longer overdue. If not set, the emails will continue to be sent daily.
Additionally, for the Audits & Visits emails, the notifications can be conditioned on the status of the Site. The Confirm Details emails are already sent based on the status of the Site, and switching on can be controlled by activating or deactivating the email template, so no additional control is needed in this respect.
Process & Activity Brief Extract Filters
The Process & Activity Brief Extract facility has additional filters provided for narrowing down the Process records to include in a single extract:
- Parent Process
- Process Title
- Proposed Start Date (From) and Proposed Start Date (To) – Proposed Start Date (From) includes Processes with a start date later than that specified. Proposed Start Date (To) includes Processes with a start date earlier than that specified. Use of both the filters creates a date range between which Process records will be included.
- Proposed End Date (From) and Proposed End Date (To) – Proposed End Date (From) includes Processes with an end date later than that specified. Proposed End Date (To) includes Processes with an end date earlier than that specified. Use of both the filters creates a date range between which Process records will be included.
Additionally, the enhancement includes a new system parameter to increase the number of Processes included in a single extract from the current limit of 800, to a maximum of 5000.
JET UI List View Improvements
Various improvements have been made to the JET UI list views.
- Categorized Activity List Views – New categorized list views of Process Activities are provided:
-
Retailer - All Activities – Available to Retailer users with the Process Manager or Process Administrator authority profiles. Lists all Activities (excluding Deleted records).
Categorized by users named in the Activity Team, the categorization includes a top-level category for All, and chips to select status (Not Started, Started, Approval Required, and Completed). Quick filters are All, and Overdue (overdue Activities).
-
Retailer - My Activities – Available to all Retailer users who have access to the Process module. Lists Activities where the user is Owner, Responsible, or Viewer.
Categorized by Activity Status (Not Started, Started, Approval Required, and Completed), the Categorization includes a top-level category for All. Quick Filters are: All, Overdue (overdue Activities), and Owner (Activities where the user is listed in the Activity Team as Owner).
-
Supplier - Activities – Available to all Supplier users who have access to the Process module. Lists Activities where the External Role for the Team in the Activity is set to either Supplier Viewer or Supplier Responsible AND the Supplier or Site fields in the associated Process record are the user's own Supplier or Site.
Categorized by Activity Status (Not Started, Started, Approval Required, and Completed), the categorization includes a top-level category for All. Quick Filters are: All, Overdue (overdue Activities), and Supplier Responsible (Activities where the External Role in the Activity Team is populated with Supplier Responsible).
-
- Assignment View Actions – Actions are provided in the Assignments list views:
- Process Change Status – Available from Assignment links: Processes You are Responsible For, Processes You are Owner For with sub-actions to set status, Set to Created, Set to In Progress, Set to Completed, and Set to Cancelled. Acts the same as the status change action in the Processes list view.
- Activity Change Status – Available from Assignment links: Activities You are Responsible For, Activities You are Owner For, Activities Overdue with sub-actions to set status, Set to Started, Set to Not Started, and Set to Complete. Acts the same as the status change action in the Activities list view. Validates that all the selected Activities meet the criteria to progress to the selected status.
- Sites Change Status – Available from Assignment links: Sites Awaiting Approval with sub-actions to set status: Set to Active. Acts the same as the status change action in the Sites list view.
- Documents Mark As Read – Available from Assignment links: Documents to be Read and Overdue Documents to be Read. Acts the same as the Mark as Read action in the Documents list view.
- Documents Mark As Accepted – Available from Assignment links: Documents to be Read and Overdue Documents to be Read. Acts the same as the Mark as Accepted action in the Documents list view.
Noteworthy Features for Retail Supply Chain Hub
This section highlights the specific features that are included in this update of Retail Supply Chain Hub.
| Affected Component | Feature Number | Summary |
|---|---|---|
| Application Management | RCV-44033 | Ignore unpublished translated applications during deployment window opening and closing. |
| Appointments Management | RCV-42402 | Add system parameter to define language used in email. |
| Appointments Management | RCV-42404 | Change how applications derive their language. |
| Common | RCV-41119 | Translations - English Usability Issues. |
| Common | RCV-42404 | Change how applications derive their language. |
| Common | RCV-43973 | Metrics Configuration - Include process ID on log. |
| Common | RCV-45276 | Add support to have a custom transfer timeout value per endpoint when invoking webservices from the database. |
| Common APEX | RCV-41640 | Add MODULE_HIER_ID column to ORCV_DYND_CHART_CFG table. |
| Common APEX | RCV-42404 | Change how applications derive their language. |
| Common APEX | RCV-43731 | Load IG hidden column heading not working. |
| Common APEX | RCV-43796 | Modals cannot be dismissed using keyboard and with chained modals, last modal does not have focus. |
| Common APEX | RCV-43935 | Common Apex When working with JSON_ARRAYAGG ensure RETURNING CLOB is made. |
| Configuration Management | RCV-42404 | Change how applications derive their language. |
| Cost Change Management | RCV-42402 | Add system parameter to define language used in email. |
| Cost Change Management | RCV-42404 | Change how applications derive their language. |
| Custom Validations | RCV-41119 | Translations - English Usability Issues. |
| Customer Order Fulfillment | RCV-42404 | Change how applications derive their language. |
| Customer Order Fulfillment | RCV-44533 | SPCO Change upload popup link redirect to the new upload page5. |
| Deals | RCV-44494 | When integrating billback deals, ensure that the Deal class is populated in accordance with the system parameter 'DEAL_CLASS_BB'. |
| Deals Management | RCV-42404 | Change how applications derive their language. |
| Deals Management | RCV-44107 | SPDM Change upload popup link redirect to the new upload page5. |
| Deals Management | RCV-44494 | When integrating billback deals, ensure that the Deal class is populated in accordance with the system parameter 'DEAL_CLASS_BB'. |
| Event | RCV-42402 | Add system parameter to define language used in email. |
| Event | RCV-42404 | Change how applications derive their language. |
| Finance | RCV-41119 | Translations - English Usability Issues. |
| Financial Summary | RCV-42404 | Change how applications derive their language. |
| Integration | RCV-41690 | Generic file integration Java service. |
| Integration | RCV-44903 | Add default SFTP timeout for integration file transfer. |
| Inventory | RCV-41102 | Item Transformation integration implementation. |
| Inventory Sales | RCV-42404 | Change how applications derive their language. |
| Items Management | RCV-42402 | Add system parameter to define language used in email. |
| Items Management | RCV-42404 | Change how applications derive their language. |
| Items Management | RCV-43796 | Modals cannot be dismissed using keyboard and with chained modals, last modal does not have focus. |
| Price | RCV-37242 | Prevent Recommendations if Price Change already exists for same Effective Date. |
| Price | RCV-41119 | Translations - English Usability Issues. |
| Price | RCV-44578 | Activate validation NEW_PRICE_HAS_PC_PENDING for Competitor and Markup strategies. |
| Procure To Pay Management | RCV-42404 | Change how applications derive their language. |
| Profile | RCV-42404 | Change how applications derive their language. |
| Profile | RCV-45327 | Alter table "ORCV_PRFL_CFG_APP_OPTIONS_TL". |
| Quality Control | RCV-42402 | Add system parameter to define language used in email. |
| Quality Control | RCV-42404 | Change how applications derive their language. |
| Quality Control | RCV-43796 | Modals cannot be dismissed using keyboard and with chained modals, last modal does not have focus. |
| Quality Control | RCV-44108 | QLCT Change upload popup link redirect to the new upload page5. |
| Query | RCV-42404 | Change how applications derive their language. |
| RCVDocs | RCV-42404 | Change how applications derive their language. |
| RCVDocs | RCV-43796 | Modals cannot be dismissed using keyboard and with chained modals, last modal does not have focus. |
| Reports | RCV-42404 | Change how applications derive their language. |
| Retail Price | RCV-42402 | Add system parameter to define language used in email. |
| Retail Price | RCV-42404 | Change how applications derive their language. |
| Retail Price | RCV-44106 | SPPM Change upload popup link redirect to the new upload page5. |
| Return to Vendor | RCV-42404 | Change how applications derive their language. |
| Return to Vendor | RCV-44105 | SPRV Change upload popup link redirect to the new upload page5. |
| Rule Engine | RCV-41119 | Translations - English Usability Issues. |
| Rule Engine | RCV-42404 | Change how applications derive their language. |
| Supplier Penalties | RCV-42404 | Change how applications derive their language. |
| Supplier Performance | RCV-42404 | Change how applications derive their language. |
| Supplier Performance | RCV-44539 | SPPF Change upload popup link redirect to the new upload page5. |
| Supply Chain Hub | RCV-34487 | The user is not receiving a notification whenever one or more errors occur when processing updates by upload. |
| Supply Chain Hub | RCV-39364 | When user enters directly to configuration management, some apps are repeated if more than one hub installed. |
| Supply Chain Hub | RCV-41654 | On the notification’s sidebar, the Mark as Read hyperlink is not translated. |
| Supply Chain Hub | RCV-42140 | Is not possible to download SPIM_SUPP_DFLT template in language different from English and Spanish. |
| Supply Chain Hub | RCV-42404 | Change how applications derive their language. |
| Supply Chain Hub | RCV-42692 | Translations Remove '/' from strings and adjust size of worksheet names. |
| Supply Chain Hub | RCV-44105 | SPRV Change upload popup link redirect to the new upload page5. |
| Supply Chain Hub | RCV-44106 | SPPM Change upload popup link redirect to the new upload page5. |
| Upload and Download | RCV-41119 | Translations - English Usability Issues. |
| Upload and Download | RCV-41690 | Generic file integration Java service. |
| Upload and Download | RCV-42404 | Change how applications derive their language. |
Post Release Tasks and Impact on Existing Installations
The following post release tasks and impact on an existing installation must be taken into account as part of this release.
Note:
See the Noteworthy Resolved Issues document for 25.1.401.0 for additional post release tasks.Permissions
A new Scoring Administrator authority profile is introduced which gives administrator access to the Evaluation and Scoring system parameters (the existing Integration Administrator authority profile now only gives access to the MFCS Integration system parameters).
Assign the new Scoring Administrator (SCORING ADMINISTRATOR) authority profiles to user roles and users, as appropriate.
Add the entries below to the bottom of the Admin page of the Permissions spreadsheet.
| Record (A) | Authority Profile (B) | Menu Option (C) | Sub Menu Option (D) | Action (E) | Data Record (F) | User Mode (L) | Access Level (M) |
|---|---|---|---|---|---|---|---|
| Admin | SCORING ADMINISTRATOR | Admin | Manage Supplier Evaluation Type | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SUPPLIER EVALUATION TYPE | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | Admin | Manage Supplier Evaluation Scoring Rules | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SUPPLIER EVALUATION SCORING RULES | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | SET TO ACTIVE | SUPPLIER EVALUATION SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SET TO INACTIVE | SUPPLIER EVALUATION SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | NEW VERSION | SUPPLIER EVALUATION SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SUPPLIER EVALUATION SCORING CRITERIA | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | SUPPLIER EVALUATION SCORE | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | SET TO ACTIVE | SUPPLIER EVALUATION SCORE | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SET TO INACTIVE | SUPPLIER EVALUATION SCORE | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | NEW VERSION | SUPPLIER EVALUATION SCORE | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | Admin | Manage Supplier Evaluation Score | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | Admin | Manage Supplier Evaluation Site Type Group | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SUPPLIER EVALUATION SITE TYPE GROUP | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | SUPPLIER EVALUATION SCORING RULE SCORE DETAIL | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | Admin | Manage Entity Scoring Rules | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | ENTITY SCORING RULES | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | SET TO ACTIVE | ENTITY SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SET TO INACTIVE | ENTITY SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | NEW VERSION | ENTITY SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | ENTITY SCORING CRITERIA | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | ENTITY SCORING RULE SCORE DETAIL | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | REVIEW SCORE | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | SET TO ACTIVE | REVIEW SCORE | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SET TO INACTIVE | REVIEW SCORE | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | NEW VERSION | REVIEW SCORE | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | Admin | Manage Review Score | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | REVIEW SCORING RULE SCORE DETAIL | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | Admin | Manage Review Scoring Rules | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | REVIEW SCORING RULES | NORMAL | F | |||
| Admin | SCORING ADMINISTRATOR | SET TO ACTIVE | REVIEW SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | SET TO INACTIVE | REVIEW SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | NEW VERSION | REVIEW SCORING RULES | NORMAL | Y | ||
| Admin | SCORING ADMINISTRATOR | REVIEW SCORING CRITERIA | NORMAL | 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.
System Text
The following features include new system text:
- JET UI Supplier Form
- Audit/Visit and Confirm Details Notifications
- Process & Activity Brief Extract Filters
- JET UI List View Improvements
System text records are added automatically during the release process, however any translation overrides must be added manually, by the retailer administrator.
Post Release Configuration and Testing
The following feature has post release configuration and testing requirements:
- MFCS Item Integration (Inbound)
- Audit/Visit and Confirm Details Notifications
- Process & Activity Brief Extract Filters
MFCS Item Integration (Inbound)
Set the system parameters in the MFCS Integration page, to enable the integration if it is required, including:
- The Messages per Call system parameter controls how many records are retrieved or sent per call to the MFCS integration APIs. The recommended setting is 100.
- Consider the setting of the whether Product Records represent a single or multiple variants before enabling the integration. The recommended and default method is single variant, where the Allow Creation of Multiple Products system parameter is No. This means a Product Record represents a single variant of a product, and the item integration will create a separate Product Record for each item variant. The setting cannot be changed once the first Product Record or Specification has been created.
- A Retailer User is created with the name TBC as part of a new installation. This is used as a default if a Technologist or other contact cannot be derived when creating a Product Record through integration.
Audit/Visit and Confirm Details Notifications
The enhancement includes new system parameter (in the Audits & Visits and Login pages) which can be set to enable the feature:
- Audit/Visit Due Email Frequency (Days) is a number of days by which the Audit/Visit Due email will be sent. By default the value is blank, meaning the emails will continue to be sent to the existing daily frequency.
- Audit/Visit Overdue Email Frequency (Days) is a number of days by which the Audit/Visit Overdue email will be sent. By default the value is blank, meaning the emails will continue to be sent to the existing daily frequency.
- Supplier/Site Details Reminder Frequency (Days) is a number of days by which the Supplier/Site Details Reminder email will be sent. By default the value is blank, meaning the emails will continue to be sent to the existing daily frequency.
-
Notify if Site Status is a multi-selector of Site Statuses to set at which statuses a Site will have the Audit/Visit notification due and overdue notifications sent. By default, Active and Awaiting Approval are selected.
This may mean that an Audit/Visit notification may still appear in a user's Assignments, but email notifications will not be sent if the Site is not at an applicable status.
If the client is already using these emails, it is recommended to include testing to ensure that they are still sent as expected.
Process & Activity Brief Extract Filters
Clients who utilize the Process & Activity Brief Extract function should test that their existing extracts continue to return expected results.
The enhancement includes a new Process & Activity Brief Extract Limit system parameter (in the Global page) which can be set to increase the current limit of 800 Processes included in a single extract, up to 5000.
Note that the system parameter is applicable only to the Process & Activity Brief Extract, which is managed through the report schedule, and not the separate Process and Activity Brief extracts from list views.
Application Program Interfaces (APIs)
The following API is affected by this release. Consider if changes need to be made to any external systems that call the API.
-
Product REST API: The MFCS Item Integration (Inbound) feature adds the Integration Source field.
For further information on the data content, see the associated Data Dictionary documents.
Enabling Identity Management Notifications
As an IDCS or OCI IAM Administrator, verify that Notifications are enabled in the corresponding Stage / Production tenant.
Enabling User Roles
If they do not already exist, configure the Power User, Account Administrator, Assistant Technologist, and Site Inspector user roles, and assign to the appropriate users.
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.