1 Feature Summary
This chapter describes the feature enhancements in this release.
Noteworthy Enhancements
This guide outlines the information you need to know about new or improved functionality in the Oracle Retail Merchandising Cloud Services 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.
Column Definitions
-
Feature: Provides a description of the feature being delivered.
-
Module Impacted: Identifies the module 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 on users is moderate.
-
Large: These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.
-
-
Delivered: Is the new feature available for use immediately after upgrade or must the feature be enabled or configured? If no, the feature is non-disruptive to end users and action is required (detailed steps below) to make the feature ready to use.
- 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.
Merchandising Modernization – Warehouses
This cloud service update introduces a modernized Warehouse user interface within Merchandising, as part of a broader, phased redesign aligned with contemporary design standards to ensure a smooth user transition. The enhanced Warehouse workflow is available in the Locations destination and can be accessed through the Stores and Warehouses Search screen. This interface lists all stores and physical warehouses and provides intuitive search and filtering capabilities to help users quickly locate specific warehouses. From here, users can create new locations or view and edit existing ones.
A unified interface is now available for creating and managing all warehouse components, including physical warehouses, virtual warehouses, and associated addresses. Additionally, the Warehouse page features an AI-generated summary that offers a concise overview of the physical warehouse and its primary virtual warehouse, providing warehouse insights at a glance.
The workflow also supports AI-driven translations, making it easier for users to manage content in multiple languages and reduces the manual effort involved in creating such translations. Users can further review and adjust the generated translations as required, ensuring that the final content is accurate as well as contextually appropriate.
Steps to Enable
To access or view the Warehouse page in the Locations destination, new appropriate privileges are required. Refer the Foundation Security Guide to review the additional privileges/duties needed.
Security
Table 1-1 Privileges
| Priv Name | Change Type | Priv Description | Parent Duty |
|---|---|---|---|
| MAINTAIN_WAREHOUSES_PRIV | New | A privilege for creating and editing physical and virtual warehouse definitions, including addresses and custom flexible attributes (CFAS). Users with this privilege must also have the Search Stores and Warehouses Priv, and the View Warehouses Priv | LOCATION_MGMT_DUTY,WAREHOUSE_MGMT_DUTY |
| VIEW_WAREHOUSES_PRIV | New | A privilege for viewing physical and virtual warehouse definitions, including addresses and custom flexible attributes (CFAS). Users with this privilege must also have the Search Stores and Warehouses Priv. | LOCATION_INQUIRY_DUTY,WAREHOUSE_INQUIRY_DUTY |
Table 1-2 Duties
| Duty Name | Change Type | Duty Description | Child Duty | Base Role |
|---|---|---|---|---|
| WAREHOUSE_MGMT_DUTY | New | A duty for maintaining warehouses. This duty is an extension of the Warehouse Inquiry Duty. | WAREHOUSE INQUIRY DUTY | |
| WAREHOUSE_INQUIRY_DUTY | New | A duty for viewing warehouse definitions. |
Address Assist
This cloud service update introduces a new feature that leverages Oracle Maps service to assist users while creating or editing addresses for stores and warehouses by suggesting addresses based on key words entered. This suggestion feature along with manual entry and further refinement capabilities is expected to result in reduced effort and better accuracy.
Item API Enhancements
This cloud service update brings consistency in managing various item related attributes such as Item Supplier UOMs, Import Attributes and Substitute Items across all item creation methods, including online screens, ReST APIs, and the Spreadsheet Upload/Download process.
Item Supplier UOMs is added to the Item and Item Supplier Upload ReST APIs, allowing external systems to create supplier UOM details during item or item-supplier creation. Additionally, three new ReST services are now available to create, update, and delete miscellaneous units of measure (UOM) for existing item-supplier combinations.
The Item Import Attributes entity is added to the Item Upload ReST API and Spreadsheet template, enabling users to maintain these attributes during item creation or maintenance. In addition, two new ReST services are available to create and update the import-specific attributes for existing items.
A new ReST API and Spreadsheet based template is also available to create, update, and delete Substitute Items for item-location combinations. Substitute Items are also included in spreadsheet downloads when items are downloaded from Merchandising. The Item Location management ReST API is also modified to include substitute items.
Item Supplier UOMs
Table 1-3 Integration Updates
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Create Item Supplier UOM | New | ReST Service | MerchIntegrations/services/item/supplier/uom/create | This service is to create miscellaneous units of measure (UOM) for an item/supplier combination. Supplier UOM can also be added together with the creation of a new item. This UOM indicates the equivalent of one unit of the item in the specified UOM. |
| Create Item Suppliers Service | Update | ReST Service | supplier/uom | New node, to create miscellaneous units of measure (UOM) for an item/supplier combination, has been added to the existing payload of Create Item Suppliers ReST Service. |
| Create Items Service | Update | ReST Service | supplier/uom | New node, to create miscellaneous units of measure (UOM) for an item/supplier combination, has been added to the existing payload of Create Items ReST Service. |
| Delete Item Supplier UOM | New | ReST Service | MerchIntegrations/services/item/supplier/uom/delete | This service is to delete miscellaneous units of measure (UOM) for an item/supplier combination. |
| Item Subscription API | Update | RIB Message | UOM | New message types have been added: xisuomcre, xisuommod, xisuomdel |
| Update Item Supplier UOM | New | ReST Service | MerchIntegrations/services/item/supplier/uom/update | This service is to update miscellaneous units of measure (UOM) for an item/supplier combination. |
Item Import Attributes
Table 1-4 Integration Updates
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Create Item Import Attributes Service | New | ReST Service | MerchIntegrations/services/item/importAttributes/create | This service is used to add an import attribute to an existing item in Merchandising. Import attribute of an item can also be added together with the creation of a new item. |
| Create Items Service | Update | ReST Service | itemImportAttributes | New node, to add an import attribute, has been added to the existing payload of Create Items ReST Service. |
| Item Subscription API | Update | RIB Message | Item Import Attributes | Import attributes of an Items can be added together with the creation of a new item or added to an existing item. New message types xitemimpattrcre and xitemimpattrmod have been added. |
| Update Item Import Attributes | New | ReST Service | MerchIntegrations/services/item/importAttributes/update | This service is used to update an import attribute to an existing item in Merchandising. |
Substitute Items
Table 1-5 Integration Updates
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| External Integration Item Location ReST Service | Update | ReST Service | substituteItems | The JSON contract has been modified to include Substitute Items details. |
| Manage Substitute Items | New | ReST Service | MerchIntegrations/services/item/location/substituteItems/manage | New service to create, update or delete substitute Item. |
Table 1-6 Code Updates
| Code Type | Code Type Description | Code | Code Description | New or Updated? | Delivered |
|---|---|---|---|---|---|
| IDBT | Induction Download Blank Template | SUBITM | Substitute Items | Update | Enabled |
| RMST | RMS Admin API Templates | SUBITM | Substitute Items | Update | Enabled |
| S9A6 | Spreadsheet action types - Substitute Items | CREATE | Create | New | Enabled |
| S9A6 | Spreadsheet action types - Substitute Items | DELETE | Delete | New | Enabled |
| S9A6 | Spreadsheet action types - Substitute Items | UPDATE | Update | New | Enabled |
| SIFP | Substitute Item Fill Priority | M | Main Item | New | Enabled |
| SIFP | Substitute Item Fill Priority | S | Substitute Item | New | Enabled |
Table 1-7 Privilege Updates
| Priv Name | Change Type | Priv Description | Parent Duty |
|---|---|---|---|
| VIEW_SUBSTITUTE_ITEMS_VIA_SPREADSHEET_PRIV | New | A privilege for viewing Substitute Items information via spreadsheet download. | RMS_SUBSTITUTE_ITEMS_VIA_SPREADSHEET_INQUIRY_DUTY |
| MAINTAIN_SUBSTITUTE_ITEMS_VIA_SPREADSHEET_PRIV | New | A privilege for maintaining Substitute Items information via spreadsheet upload. | RMS_SUBSTITUTE_ITEMS_VIA_SPREADSHEET_MGMT_DUTY |
Table 1-8 Duty Updates
| Duty Name | Change Type | Duty Description | Child Duty | Base Role |
|---|---|---|---|---|
| RMS_SUBSTITUTE_ITEMS_VIA_SPREADSHEET_MGMT_DUTY | New | A duty for maintaining Substitute Items information via spreadsheet upload. | RMS_SUBSTITUTE_ITEMS_VIA_SPREADSHEET_INQUIRY_DUTY | RMS APPLICATION ADMINISTRATOR, DATA STEWARD, BUYER, INVENTORY ANALYST, INVENTORY MANAGER |
| RMS_SUBSTITUTE_ITEMS_VIA_SPREADSHEET_INQUIRY_DUTY | New | A duty for viewing Substitute Items information via spreadsheet download. | CORPORATE INVENTORY CONTROL ANALYST, INVENTORY CONTROL MANGER, SOURCING ANALYST, SUPPLY CHAIN ANALYST, FINANCIAL ANALYST, FINANCIAL MANAGER |
Complex Deal ReST Service Enhancements
This cloud service update enhances the existing Complex Deal ReST service to allow the user to update and delete all types of complex deals that are currently supported within Merchandising. Previously, complex deals could only be created using this service. Additionally, the service will also support create, update and delete of proof of performance fulfillment. The error response has also been updated to include two new fields - Proof of Performance sequence number and Fulfillment sequence number, thus supporting error reporting at these levels.
Table 1-9 Integration Updates
| API Name | Change Type | Integrtaion Type | Field Name | Change Description |
|---|---|---|---|---|
| Complex Deals Upload Service | Update | ReST Service | /deals/complexDeals/manage | Service will now support action Update and Delete |
Fixed Deal Enhancements
This cloud service update introduces the following enhancements to the way fixed deals are created and managed within Merchandising.
- Ability to create merchandise fixed deals at an item-location level.
- Ability to specify whether the income should be applied to the inventory value through Stock Ledger postings and Weighted Average Cost (WAC) re-calculation for items included in the deal. This can be controlled by a new header level indicator.
- Support for prepaid merchandise deals which will allow retailers to bill and collect the total income upfront and then apportion it to the item inventory value over time based on a schedule. It applies only to merchandise fixed deals with item-location associations.
Invoice Matching has been enhanced to support invoicing for fixed deals created against supplier sites and also for fixed deals at the item-location level.
Table 1-10 Batch Schedule Updates
| Process Name | Process Type | New or Updated? | Delivered |
|---|---|---|---|
| SALDLY_JOB | Nightly | Update | Enabled |
| SALWEEK_JOB | Nightly | Update | Enabled |
| SALMTH_JOB | Nightly | Update | Enabled |
| FIFGLDN3_JOB | Nightly | Update | Enabled |
| DEALFINC_JOB | Nightly | Update | Enabled |
| VENDINVF_JOB | Nightly | Update | Enabled |
| DEALPRG_JOB | Nightly | Update | Enabled |
| DEAL_PURGE_JOB | Background | Update | Enabled |
Table 1-11 Code Updates
| Code Type | Code Type Description | Code | Code Description | New or Updated? | Delivered |
|---|---|---|---|---|---|
| FXIA | Fixed Deal Income Apportionment Method. | R | Ratio | New | Enabled |
| FXIA | Fixed Deal Income Apportionment Method. | V | Value | New | Enabled |
| FXML | Fixed Deal Merchandise Levels | IM | Item | New | Enabled |
| FXML | Fixed Deal Merchandise Levels | IP | Item Parent | Update | Enabled |
| FXPF | Fixed Deal Posting Frequency | M | Monthly | New | Enabled |
| FXPF | Fixed Deal Posting Frequency | Q | Quarterly | New | Enabled |
| FXPF | Fixed Deal Posting Frequency | W | Weekly | New | Enabled |
Support for Daily Income Reporting for Complex Deals
This cloud service update introduces an option to calculate and display deal income at daily level which can be used in the Gregorian or the 4-5-4 calendar setup based on business requirements.
AI-Assisted Invoice Document Creation
This cloud service update introduces a new AI-assisted workflow to allow creation of invoice documents in Invoice Matching Cloud Service from a physical invoice file. The new workflow is designed to allow users to upload an invoice file, extract key attributes with AI assistance, and present them on the screen for further review and augmentation before the invoice is ready to be matched.
The new workflow is controlled by a system level option - “AI Assistance” which must be checked before this feature can be used.
Ability to Post Sales/Deals Transactions to Separate GL Account
This cloud service update provides the option to map sales and deals transactions to separate GL accounts based on configurable GL Reference Number for sales transactions and billing type for deals.
For sales transaction postings (transaction codes 1, 2, 3, 4 and 5) in the transaction data table, retailers can define/configure a posting classifier at the item-location level. This custom classification will be recorded in the GL Reference Number field. This allows retailers to classify sales transactions depending on the requirement for differential accounting treatment (e.g., consignment, owned, owned-private label, etc.). The posting classifier can be managed using Merchandising screens or the Manage Item Location ReST Service. This attribute will not be updated based on item ownership changes or other item location processes. Once created or updated, it will immediately start reflecting in transaction data postings.
For sales-based deal income posting (transaction code 6) in the transaction data table, the billing type for the specific deal will be captured in the GL Reference Number field to provide the option to distinguish between bill backs and vendor funded deals.
The GL Cross Reference and Financial Posting processes have been enhanced to use the GL Reference Number values for differential accounting for transaction codes 1, 2, 3, 4, 5 and 6. These changes do not impact Stock Ledger rollups.
Table 1-12 Integration Updates
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Create Item Locations | Update | ReST Service | POSTING_CLASSIFIER | Added the field posting_classifier |
| Item Location Subscription API | Update | RIB Message | POSTING_CLASSIFIER | Added the field posting_classifier |
| Update Item Locations | Update | ReST Service | POSTING_CLASSIFIER | Added the field posting_classifier |
Table 1-13 Code Updates
| Code Type | Code Type Description | Code | Code Description | New or Updated? | Delivered |
|---|---|---|---|---|---|
| POCL | Posting Classifier | C | Consignment | New | Enabled |
| POCL | Posting Classifier | O | Owned | New | Enabled |
Table 1-14 DAS/RDS Updates
| Application Table | DAS/RDS Table or View | Change Type | Change Description |
|---|---|---|---|
| ITEM_LOC | RDS_WV_ITEM_LOC | Update | Added column POSTING_CLASSIFIER |
| ITEM_LOC | DAS_WV_ITEM_LOC | Update | Added column POSTING_CLASSIFIER |
Transportation Update Enhancements
This cloud service update introduces the option to edit key values of a transportation record (i.e., Vessel, Voyage/Flight, Estimated Departure Date, Order No., Item, Container, BOL/AWB, Commercial Invoice) until the transportation record is added to a Customs Entry or Obligation. Previously, these values were not editable once specified and saved. This provides flexibility to retailers to modify details during the long transportation process wherever changes are needed.
This option is controlled by a system level parameter “Extend Transportation Input State” and must be turned ON before usage. Change to this parameter only impacts the ability to edit the key values from that point forward.
Steps to Enable
To enable this feature navigate to the System Options Screen, go to the Import Management Section, and select the 'Extend Transportation Input State' field.
For batch - TRANUPLD_JOB V3 file format must be sent to RMS, and corresponding configuration must be completed in POM.
Updates
Table 1-15 System Option Updates
| Attribute Name | New or Updated? | Attribute Description | Default Value |
|---|---|---|---|
| EXTEND_TRANSPORTATION_INPUT_STATE | New | Indicates if the transportation key values (i.e. Vessel, Voyage/Flight, Estimated Departure Date, Order No., Item, Container, BOL/AWB, Commercial Invoice) will remain in an extended input state or not. When set to Yes (Y), the key value fields will remain editable after values have been provided, up until the transportation record is added to a customs entry or obligation. When set to No (N), the key value fields will be restricted from editing as soon as a value is provided and saved. If this value is changed, it will only impact the ability to edit key values from that point forward. | N |
Table 1-16 Batch Schedule Updates
| TRANUPLD_PROCESS | Nightly | Update | Disabled |
| TRANUPLD_PROCESS_ADHOC | Ad Hoc | Update | Disabled |
Table 1-17 DAS/RDS Updates
| Application Table | DAS/RDS Table or View | Change Type | Change Description |
|---|---|---|---|
| RTM_UNIT_OPTIONS | RDS_WV_RTM_UNIT_OPTIONS | Update | Added new field - EXTEND_TRANSPORTATION_INPUT_STATE |
| SYSTEM_OPTIONS | DAS_WV_SYSTEM_OPTNS | Update | Added new field - EXTEND_TRANSPORTATION_INPUT_STATE |
| SYSTEM_OPTIONS | RDS_WV_SYSTEM_OPTIONS | Update | Added new field - EXTEND_TRANSPORTATION_INPUT_STATE |
| RTM_UNIT_OPTIONS | DAS_WV_SYSTEM_OPTNS | Update | Added new field - EXTEND_TRANSPORTATION_INPUT_STATE |
Visibility of CFIN Supplier ID in Merchandising
This cloud service update introduces an option to automatically prefix CFIN Supplier ID to the Supplier Name in Merchandising during the process of importing suppliers from Oracle Cloud Financials (CFIN) using the ‘Supplier and Partner Upload Service’. This applies only to suppliers that are imported into MFCS and not supplier sites. This also allows users to easily view/search using the Financial System Supplier ID in RMFCS and Invoice Matching without any additional changes.
This new feature is controlled by a system level parameter “Prefix Financial Supplier ID” which must be turned ON before usage.
Table 1-18 System Option Updates
| Attribute Name | New or Updated? | Attribute Description | Default Value |
|---|---|---|---|
| PREFIX_FINANCIAL_SUPPLIER_ID | New | This field will control whether the specification of the Financial System Supplier ID, maintained in External Refernece Id column, should be prefixed to the Supplier Name while importing suppliers into Merchandising using the Rest service. This will only impact the storage of the Name field for parent supplier records imported into Merchandising. There will be no impact on the Supplier Sites and the names on these records. | N |
Automated Migration for Custom Validation Rules
This cloud service update ensures that the Custom Validation Rules (CVR) metadata and related objects are now automatically migrated between pre-production to production environments as part of the data refresh activities. This eliminates the need of a Service Request for such activity and support from the Oracle Cloud Operations team is no longer required.
Manage Allocations ReST Service Enhancement
This cloud service update introduces enhancements to the Manage Allocations ReST Service to enable processing of allocation creation in bulk and handle a larger message payload. Business validations are now performed in bulk and multiple errors per allocation contained in the payload can be returned.
Effective Date Query Parameter in Price Event APIs
This cloud service update introduces the effective date of a price event as a query parameter for outbound Pricing ReST APIs. This enables a more targeted retrieval of relevant price events and helps avoid extracting unnecessary data.
Outbound ReST APIs for Price Change and Clearance now have an Effective Date and Promotion Publish ReST API has the Start and End date as query parameters.
Table 1-19 Integration Updates
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| OmniChannel V2 Clearance | New | ReST Service | effective | Effective Date criteria has been added to fetch the Clearances. This is an optional field. |
| OmniChannel V2 Promotion | New | ReST Service | start | Start Date criteria has been added to fetch the Promotional Offers. This is an optional field. |
| OmniChannel V2 Promotion | New | ReST Service | end | End Date criteria has been added to fetch the Promotional Offers. This is an optional field. |
| Omnichannel V2 Regular | New | ReST Service | effective | Effective Date criteria has been added to fetch the Price Changes. This is an optional Field. |
Enhanced Matching Logic for Fiscal Document Receiving (Purchase Orders)
This update introduces an enhancement to the fiscal document receiving workflow that allows more accurate matching between the fiscal document and the item master. When this feature is enabled for a location, the system will validate the product code provided in the fiscal document (cProd/Prod) directly against the item's master data. This replaces the previous behavior which relied on supplier-specific product identifiers. The new location level attribute “Validate cProd with SKU” will be delivered enabled for the new behavior.
Improved Carrier Determination for Shipment NF-e Generation
This update enhances the shipment NF-e generation workflow by allowing the carrier information to be dynamically overridden based on data provided by upstream systems. With this enhancement, the system can use carrier information sent from the source system (e.g., SIOCS) through a configurable attribute, instead of relying solely on the default carrier defined at the location. Customers must configure the shipment attribute to be used to provide the carrier override information.
Steps to Enable
The new location level attribute “Default Transporter based on SIOCS CFA” needs to be set with the name of the CFA that will hold the carrier ID coming from SIOCS.
Improved Resiliency for NF-e Approval Response Processing
This enhancement improves the robustness of the NF-e issuance workflow when handling delayed or out-of-sequence responses from SEFAZ. With this capability, the system can process approval responses even if the related document is in an error state. Previously, such responses were only accepted when the document was in a waiting state, which could lead to unnecessary rejections and manual intervention.
Enhanced Integration between Merchandising and SIOCS for Inventory Identifiers
Integration between Merchandising and SIOCS through direct-DB method is enhanced to allow SIOCS to send Inventory Identifiers such as LOT ID for accurate inventory layers tracking.
Removed Stockholding Validation for Fulfillment Locations When Processing Non-Inventoried Items
Previously, fulfillment requests for non-inventoried items were rejected if the fulfillment location was not a stockholding location, such as a virtual store. With this update, the stockholding location validation is no longer applied to non-inventoried items, allowing fulfillment of non-inventoried items from virtual or non-stockholding locations.
Enhanced Item Download Service
Item Download ReST API has been enhanced with new child nodes, providing retailers with more comprehensive item information. The new nodes include Item Import Attributes, Required Documents, Item UDA Free Form Translations, Related Item Translations, Item Image Translations, and Item Supplier Translations. This enhancement improves data exchange and integration with downstream systems. Note that to populate these new attributes for existing items, retailers will need to run the MerchAPI data rebuild/refresh processes.
Table 1-20 Integration Updates
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Get Items API | Update | ReST Service | itemImportAttributes,requiredDocuments,udaFreeformTranslation, itemImageTranslation,itemSupplierTL | New child nodes are added in the response payload |
Allow Multiple Contexts in the Same Shipment
With this enhancement, retailers can now include multiple transfer contexts in the same shipment document, giving them more flexibility and control. Previously, the default behavior only allowed one transfer context per document. The system will now only return an error if multiple contexts exist in the document, are configured in the options mapping table, and are mapped to different tax transaction types.
Enhanced Multi-Threading for Purge Item Location Batch
Previously, the batch ran sequentially, which could lead to longer run times for extensive purges.
This update introduces multi-threading to the Purge Item Location batch process, enabling parallel execution based on departments and item hierarchies to accelerate processing times and handle larger volumes more efficiently.
Additionally, history tables are now created to retain staging data snapshots before purging, facilitating easier troubleshooting and data recovery if needed.
Location Publish API to Oracle Retail AI Foundation Cloud Service (AIF)
With this enhancement, Merchandising will automatically publish updates to store, warehouse, and external partner data to AIF for planning purposes. This ensures that your planning data is accurate and up-to-date, and you can make informed decisions. The publishing is triggered by various events, such as changes to organizational hierarchy, franchise store associations, channels, banners, or address details.
Steps to Enable
To enable this feature, follow these steps:
- Go to the Webservice Configuration Screen.
- Configure the Publish API integration.
- Save your changes.
Updates
Table 1-21 Integration Updates
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Location Services API | New | ReST Service | /MerchIntegrations/services/foundation/aif/Locations | New location publish API for AIF |