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 - Locations
This cloud service update introduces new modernized user interfaces for selected entities in Merchandising, incorporating contemporary design standards. The new experience is being introduced in phases to ensure a smooth transition. The location management screens are the first to be enhanced, specifically, the ability to create, view and maintain the organizational hierarchy, to search for store or warehouse locations, and to create, view and maintain store locations, as well as to manage addresses and translations.
The new workflows are all housed in a new Locations Destination. The Locations Destination landing page serves as a navigational hub. From this page, users can quickly launch the Organizational Hierarchy and the Stores and Warehouses search workflows, each equipped with the ‘Ask Oracle’ Smart Search feature. This smart search feature is designed to provide quick results, suggested actions, and efficient task completion.
The Organizational Hierarchy page displays the Company, Chain, Area, Region, and District levels in a hierarchical manner. This layout provides the user with a clear visual representation of the overall structure and simultaneously allow seamless navigation from one level to another. Additionally, users can utilize the smart search capabilities to navigate through various organizational levels. Each one provides the option to create, modify, or delete specific hierarchy data.
The Stores and Warehouses search page displays a list of all stores and physical warehouses present in the system and provides users with smart search features to filter and locate a specific location. From here, users can choose to edit/view an existing store or create a new one.
Additionally, users can access AI-generated store summaries when viewing or editing store information, providing store insights at a glance.
The updated workflow also introduces 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
The VIEW_LOCATIONS_DESTINATION_PRIV privilege is required to access or view the new Locations task in Merchandising.
Please refer to the Merchandising Foundation Security Guide to review the additional roles necessary for accessing the new OJet screens.
Code Impact
| Code Type | Code Type Description | Code | Code Description | New or Updated? | Delivered |
|---|---|---|---|---|---|
| STSV | Store services offered | EN | Engraving | New | Enabled |
| STSV | Store services offered | IP | In-Store Pickup | New | Enabled |
| STSV | Store services offered | SD | Same-Day Delivery | New | Enabled |
| PHTP | Alternate Phone Number Types for addresses | MA | Main | New | Enabled |
| PHTP | Alternate Phone Number Types for addresses | HO | Home | New | Enabled |
| PHTP | Alternate Phone Number Types for addresses | HF | Home Fax | New | Enabled |
| CLBL | Alternate City Labels for addresses | C | City | New | Enabled |
| CLBL | Alternate City Labels for addresses | T | Town | New | Enabled |
| STBL | Alternate State Labels for addresses | RG | Region | New | Enabled |
| ADDO | Address fields display order | CSP | City, State, Postal Code | New | Enabled |
| ADDO | Address fields display order | CPS | City, Postal Code, State | New | Enabled |
| ADDO | Address fields display order | PSC | Postal Code, State, City | New | Enabled |
| STSV | Store services offered | HD | Hyperlocal Delivery | New | Enabled |
| STBL | Alternate State Labels for addresses | CT | Country | New | Enabled |
| LABL | Label | VWH | Virtual Warehouse | New | Enabled |
| STSV | Store services offered | GW | Gift Wrapping | New | Enabled |
| PCLB | Alternate Postal Code Labels for addresses | PC | Postal Code | New | Enabled |
| PCLB | Alternate Postal Code Labels for addresses | PN | Pin Code | New | Enabled |
| STSV | Store services offered | SC | Self Checkout | New | Enabled |
| PHTP | Alternate Phone Number Types for addresses | WO | Work | New | Enabled |
| PHTP | Alternate Phone Number Types for addresses | AS | Assistant | New | Enabled |
| STBL | Alternate State Labels for addresses | ST | State | New | Enabled |
| STBL | Alternate State Labels for addresses | PR | Province | New | Enabled |
| ADDO | Address fields display order | SPC | State, Postal Code, City | New | Enabled |
| ADDO | Address fields display order | PCS | Postal Code, City, State | New | Enabled |
| STSV | Store services offered | CP | Curbside Pickup | New | Enabled |
| STSV | Store services offered | MO | Monogramming | New | Enabled |
| STSV | Store services offered | EM | Embroidery | New | Enabled |
| PHTP | Alternate Phone Number Types for addresses | CM | Company Main | New | Enabled |
| PHTP | Alternate Phone Number Types for addresses | WF | Work Fax | New | Enabled |
| PHTP | Alternate Phone Number Types for addresses | PA | Pager | New | Enabled |
| CLBL | Alternate City Labels for addresses | V | Village | New | Enabled |
| PCLB | Alternate Postal Code Labels for addresses | ZC | Zip Code | New | Enabled |
| ADDO | Address fields display order | SCP | State, City, Postal Code | New | Enabled |
Security
Privileges
| Priv Name | Change Type | Priv Description | Parent Duty |
|---|---|---|---|
| MAINTAIN_STORES_PRIV | New | A privilege for creating and editing store definitions, including addresses, CFAS, store location traits and walk-through stores. | LOCATION_MGMT_DUTY |
| MAINTAIN_WAREHOUSES_PRIV | New | A privilege for creating and editing physical and virtual warehouse definitions, including addresses and CFAS. | LOCATION_MGMT_DUTY |
| SEARCH_STORES_AND_WAREHOUSES_PRIV | New | A privilege for searching for stores and warehouses. This allows access to the Stores and Warehouses search screen, but does not allow users to view details of any stores or warehouses or perform actions against the locations. | LOCATION_INQUIRY_DUTY |
| VIEW_STORES_PRIV | New | A privilege for viewing store definitions, including addresses, CFAS, store location traits and walk-through stores. | LOCATION_INQUIRY_DUTY,ORGANIZATIONAL_HIERARCHY_INQUIRY_DUTY |
| VIEW_WAREHOUSES_PRIV | New | A privilege for viewing physical and virtual warehouse definitions, including addresses and CFAS. | LOCATION_INQUIRY_DUTY |
| MAINTAIN_AREAS_PRIV | New | A privilege for creating and editing Areas. | ORGANIZATIONAL_HIERARCHY_MGMT_DUTY |
| MAINTAIN_CHAINS_PRIV | New | A privilege for creating and editing Chains. | ORGANIZATIONAL_HIERARCHY_MGMT_DUTY |
| MAINTAIN_COMPANY_PRIV | New | A privilege for editing the Company definition via the Organizational Hierarchy screen in the Locations destination. | ORGANIZATIONAL_HIERARCHY_MGMT_DUTY |
| MAINTAIN_REGIONS_PRIV | New | A privilege for creating and editing Regions. | ORGANIZATIONAL_HIERARCHY_MGMT_DUTY |
| MAINTAIN_DISTRICTS_PRIV | New | A privilege for creating and editing Districts. | ORGANIZATIONAL_HIERARCHY_MGMT_DUTY |
| VIEW_ORGANIZATION_HIERARCHY_PRIV | New | The View Organization Hierarchy Priv provides access to the Organizational Hierarchy card in the Locations destination landing page, the Organizational Hierarchy suggestion link in the Home experience, and the Organizational Hierarchy screen, where the user can view all levels of the Organizational Hierarchy. | ORGANIZATIONAL_HIERARCHY_INQUIRY_DUTY |
| VIEW_COMPANY_PRIV | New | A privilege for viewing the Company definition via the Organizational Hierarchy screen in the Locations destination. | ORGANIZATIONAL_HIERARCHY_INQUIRY_DUTY |
| VIEW_LOCATIONS_DESTINATION_PRIV | New | A privilege for accessing the Locations destination which is a new alternative to the classic Organizational Hierarchy workflow. | RMS_LOCATIONS_DESTINATION_ACCESS_DUTY |
Duties
| Duty Name | Change Type | Duty Description | Child Duty | Base Role |
|---|---|---|---|---|
| ADMIN_CONSOLE_DUTY | New | A duty for accessing the Application Administrator Administration Console (RAAC) suggestion link in the Foundation solution’s Home experience. | FND_APPLICATION_ADMINISTRATOR_JOB_PREPROD | |
| LOCATION_MGMT_DUTY | New | A duty for maintaining stores and warehouses. This duty is an extension of the Location Inquiry Duty. | LOCATION_INQUIRY_DUTY | FND_APPLICATION_ADMINISTRATOR_JOB,FND_DATA_STEWARD_JOB |
| STORE_INQUIRY_DUTY | New | A duty for viewing store definitions. | ||
| STORE_MGMT_DUTY | New | A duty for maintaining store definitions. This duty is an extension of the Store Inquiry Duty. | STORE_INQUIRY_DUTY | |
| LOCATION_INQUIRY_DUTY | New | A duty for searching for stores and warehouses via the Stores and Warehouses screen, and viewing store and warehouse definitions. | SUPPLY_CHAIN_ANALYST_JOB | |
| ORGANIZATIONAL_HIERARCHY_INQUIRY_DUTY | New | A duty for searching for and viewing the organizational hierarchy, stores, and warehouses via the Organizational Hierarchy screen. This includes viewing all grouping levels of the hierarchy, Company, Chain, Area, Region, and District. | ||
| ORGANIZATIONAL_HIERARCHY_MGMT_DUTY | New | A duty for creating and maintaining the grouping levels of the Organization Hierarchy. This includes all grouping levels of the hierarchy, Company, Chain, Area, Region, and District. This duty is an extension of the Organizational Hierarchy Inquiry Duty. | ORGANIZATIONAL_HIERARCHY_INQUIRY_DUTY | FND_APPLICATION_ADMINISTRATOR_JOB,FND_DATA_STEWARD_JOB |
| RMS_LOCATIONS_DESTINATION_ACCESS_DUTY | New | A duty for accessing the Locations destination which is a new alternative to the classic Organizational Hierarchy workflow. | RMS_APPLICATION_ADMINISTRATOR_JOB |
DAS/RDS Updates
| Application Table | DAS/RDS Table or View | Change Type | Change Description |
|---|---|---|---|
| DEAL_HEAD | DAS_WV_DEAL_HEAD | Update | Added COMPARISON_DATE column. Modified the comments on columns SUPPLIER and PARTNER_TYPE |
| DEAL_HEAD | RDS_WV_DEAL_HEAD | Update | Added COMPARISON_DATE column. Modified the comments on columns SUPPLIER and PARTNER_TYPE |
| FIXED_DEAL | DAS_WV_FIXED_DEAL | Update | Modified the comments on columns SUPPLIER and PARTNER_TYPE |
| FIXED_DEAL | RDS_WV_FIXED_DEAL | Update | Modified the comments on columns SUPPLIER and PARTNER_TYPE |
| DEAL_DETAIL | DAS_WV_DEAL_DETAIL | Update | Modified the comments on columns GET_FREE_DISCOUNT |
| DEAL_DETAIL | RDS_WV_DEAL_DETAIL | Update | Modified the comments on columns GET_FREE_DISCOUNT |
ReST Service for Complex Deal Creation
This cloud service update introduces a new REST service that can be used to create all types of complex deals that are currently supported within Merchandising. This service functions as an enhanced version of the existing deal upload workflow but contains the latest set of enhancements.
Integration
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Complex Deals Upload Service | New | REST Service | /deals/complexDeals/manage | New service added to support creation of complex deals. |
DAS/RDS Updates
| Application Table | DAS/RDS Table or View | Change Type | Change Description |
|---|---|---|---|
| DEAL_COMP_PROM | DAS_WV_DEAL_COMP_PROM | Update | Added audit columns - CREATE_ID, CREATE_DATETIME, LAST_UPDATE_ID, LAST_UPDATE_DATETIME |
| DEAL_THRESHOLD | RDS_WV_DEAL_THRESHOLD | Update | Added column CREATE_ID |
| DEAL_ITEMLOC_ITEM | DAS_WV_DEAL_ITEMLOC_ITEM | Update | Added column CREATE_ID |
| DEAL_ITEMLOC_PARENT_DIFF | RDS_WV_DEAL_ITEMLOC_PARENT_DIFF | Update | Added column CREATE_ID |
| DEAL_DETAIL | DAS_WV_DEAL_DETAIL | Update | Added CREATE_ID column |
| DEAL_PROM | DAS_WV_DEAL_PROM | Update | Added audit columns - CREATE_ID, CREATE_DATETIME, LAST_UPDATE_ID, LAST_UPDATE_DATETIME |
| DEAL_ITEMLOC_DIV_GRP | DAS_WV_DEAL_ITEMLOC_DIV_GRP | Update | Added column CREATE_ID |
| DEAL_ITEMLOC_ITEM | RDS_WV_DEAL_ITEMLOC_ITEM | Update | Added column CREATE_ID |
| DEAL_DETAIL | RDS_WV_DEAL_DETAIL | Update | Added CREATE_ID column |
| DEAL_ITEMLOC_DCS | DAS_WV_DEAL_ITEMLOC_DCS | Update | Added column CREATE_ID |
| DEAL_ITEMLOC_DCS | RDS_WV_DEAL_ITEMLOC_DCS | Update | Added column CREATE_ID |
| DEAL_ITEMLOC_PARENT_DIFF | DAS_WV_DEAL_ITEMLOC_PARENT_DIF | Update | Added column CREATE_ID |
| DEAL_ITEMLOC_DIV_GRP | RDS_WV_DEAL_ITEMLOC_DIV_GRP | Update | Added column CREATE_ID |
| DEAL_COMP_PROM | RDS_WV_DEAL_COMP_PROM | Update | Added audit columns - CREATE_ID, CREATE_DATETIME, LAST_UPDATE_ID, LAST_UPDATE_DATETIME |
| DEAL_THRESHOLD | DAS_WV_DEAL_THRESHOLD | Update | Added column CREATE_ID |
| DEAL_PROM | RDS_WV_DEAL_PROM | Update | Added audit columns - CREATE_ID, CREATE_DATETIME, LAST_UPDATE_ID, LAST_UPDATE_DATETIME |
Ability to Calculate Deal Income using Supplier Cost
This cloud service update allows a user to specify whether supplier cost should be used to calculate income for Purchase and Issue based Bill-Back (BB)/Bill-Back Rebate (BBR) deals and Vendor Funded Promotion (VFP) deals.
Enhanced Allocation ReST Service to Include Additional Attributes
This cloud service update enhances the Get Allocation ReST Service to include the following fields from the ALLOC_HEADER and ALLOC_DETAIL tables.
Attributes from ALLOC_HEADER:
-
PO_TYPE (poType)
-
ALLOC_METHOD (allocMethod)
-
RELEASE_DATE (releaseDate)
-
DOC (documentNo)
-
ALLOC_DESC (allocDesc)
-
COMMENT_DESC (commentDesc)
-
ORIGIN_IND (originInd)
-
CLOSE_DATE (closeDate)
Attributes from ALLOC_DETAIL:
-
QTY_TRANSFERRED (quantityTransferred)
-
QTY_PRESCALED (quantityPrescaled)
-
QTY_DISTRO (quantityDistro)
-
QTY_SELECTED (quantitySelected)
-
QTY_CANCELLED (quantityCancelled)
-
QTY_RECEIVED (quantityReceived)
-
QTY_RECONCILED (quantityReconciled)
-
PO_RCVD_QTY (poReceivedQty)
-
NON_SCALE_IND (nonScaleInd)
-
WF_ORDER_NO (franchiseOrderNo)
Note:
The JSON message in MERCHAPI_EXT_ALLOC for existing allocations in the table will not be updated to include the new field. Therefore, the Get Allocation Service for existing allocations will not have the values for the new attributes populated. The regenerated JSON message will contain the new attributes only when there are new allocations or updates to existing allocations.For an existing allocation, if the downstream system requires these new attribute to be populated, the MerchAPI Data Rebuild processes (MERCHAPI_DATA_REBUILD_ADHOC_JOB and MERCHAPI_REFRESH_ADHOC_JOB) should be executed to submit a request to refresh the table.
Integration
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Get Allocation (/MerchIntegrations/services/inventory/allocation) | Update | REST Service | Multiple | Multiple attributes have been added from Alloc_header and Alloc_detail table |
| Get Allocation Details for single Alloc (/MerchIntegrations/services/inventory/allocation/{allocNo}) | Update | REST Service | Multiple | Multiple attributes have been added from Alloc_header and Alloc_detail table |
Enhanced Create Allocation ReST Service to Capture External Allocation Identifier
This update enhances the Create Allocation ReST service
(/MerchIntegrations/services/inventory/allocations/create) by introducing a new optional
attribute, sourceParentAllocationId. External systems can now include their own
allocation identifier, which is stored in the new SOURCE_PARENT_ALLOC_ID column of the
ALLOC_HEADER table. This addition supports improved traceability between allocations created in
Merchandising and their corresponding records in external systems. The external allocation
identifier can be linked to multiple Merchandising allocations, if necessary.
Note:
Accuracy of this value is managed by the external system, and it cannot be changed once set.Enhanced Pre-built Supplier Subscription from Oracle Fusion
This cloud service update introduces a new address template selection option within Merchandising to improve the way in which supplier address information is interpreted from Oracle Fusion SCM. This enhancement allows organizations to configure the address lines that are to be used when processing supplier messages, ensuring better alignment with regional address formats at the country level. The standard configuration supports reading and storing the first 3 address lines from the Oracle Fusion Supplier message. Now an additional option is available to alternately read and store address lines 1, 2, and 4 instead. This configuration can be managed through the Country data management spreadsheet, offering greater control and adaptability for international supplier data integration.
Enhanced Supplier Subscription to Support External Reference ID
This cloud service update includes the following enhancements:
-
The Direct Supplier subscription from Cloud Financials has been enhanced to support the External Reference ID column in the STATE table. The External Reference ID provided will be used to validate the State.
-
The Manage External Cross Reference Identifier Service will support STATE as a valid entity type. This service has also been extended to include a sub-ID in the payload that will contain a valid partner type for the partner entity, or a valid country ID for the STATE entity and support STATE as a valid entity type.
Integration
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Manage External Cross Reference Identifier Service | Update | REST Service | entitySubId1 | This service also supports managing an external reference ID for the STATE table. To support two keys in the state table, a new sub-identifier has been added to capture the State and country ID. |
DAS/RDS Updates
| Application Table | DAS/RDS Table or View | Change Type | Change Description |
|---|---|---|---|
| STATE | DAS_WV_STATE | New | Added this column. This column holds an optional external identifier (non-ISO code) for the State to support localization requirement for selective pre-built inbound service calls where non-ISO codes for states are accepted. |
| STATE | RDS_WV_STATE | Update | Added EXTERNAL_REF_ID - This column holds an optional external identifier (non-ISO code) for the State to support localization requirements for selective pre-built inbound service calls where non-ISO codes for states are accepted. |
Enhanced VAT Region Defaulting during Supplier Subscription
The Supplier Subscription service has been enhanced to improve the assignment of VAT regions for new suppliers. Previously, if a VAT region was not provided, the system would attempt to identify an appropriate VAT region based on existing store locations that match the supplier’s country or state. This enabled suppliers to be created in an active status, with the option for users to update the VAT region afterward.
With this update, a default VAT region can now be defined at the country level to serve as a default for suppliers located in countries having no retailer stores. This further automates VAT region assignment and simplifies supplier onboarding in these scenarios. The default settings can be managed and updated conveniently through the Country Data management spreadsheet.
Integration
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Manage Supplier and Partners (/MerchIntegrations/services/foundation/suppliers/create) | Update | REST Service | vatRegion | Internal processing logic when this attribute is null has been changed to calculate a default VAT region using the country_attrib table, in addition to earlier solution checking store existing in the same Country/State or Country. |
Exception Based Handling of Up Charges
This cloud service update introduces an efficient way of handling up charges where users can define the primary set of up charges at the department level, while only specifying item-level exception ones wherever necessary. This implies that all the up charges that are defined at the department level apply to all the items belonging to the same, and no explicit user definition is required at an individual item level for such charges. This streamlined process simplifies ongoing maintenance, reduces data redundancy, and improves the overall workflow performance.
Batch Schedule
| Process Name | Process Type | New or Updated? | Delivered |
|---|---|---|---|
| ITEM_UPCHARGE_CLEANUP_ADHOC_PROCESS | Ad Hoc | New | Enabled |
Integration
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| RIB_XItemDesc_REC | Update | RIB Message | TSF_ALLOC_UP_CHRG_SOURCE_TYPE | Added TSF_ALLOC_UP_CHRG_SOURCE_TYPE Field |
| Manage item service | Update | REST Service | TSF_ALLOC_UP_CHRG_SOURCE_TYPE | Added TSF_ALLOC_UP_CHRG_SOURCE_TYPE field |
Code Impact
| Code Type | Code Type Description | Code | Code Description | New or Updated? | Delivered |
|---|---|---|---|---|---|
| TAUS | Transfer Allocation Up Charge Source Type' | D | Department if not found on item | New | Enabled |
| TAUS | Transfer Allocation Up Charge Source Type | I | Item only | New | Enabled |
DAS/RDS Updates
| Application Table | DAS/RDS Table or View | Change Type | Change Description |
|---|---|---|---|
| ITEM_MASTER | DAS_WV_ITEM_MASTER | Update | Added TSF_ALLOC_UP_CHRG_SOURCE_TYPE column |
| ITEM_CHRG_HEAD | RDS_WV_ITEM_CHRG_HEAD | Update | ITEM_CHRG_HEAD will only hold exceptions. To get all up charges applicable to the item, use RDS_WV_V_ITEM_CHRG_HEAD defined for V_ITEM_CHRG_HEAD. |
| ITEM_MASTER | RDS_WV_ITEM_MASTER | Update | Added TSF_ALLOC_UP_CHRG_SOURCE_TYPE column |
| V_ITEM_CHRG_DETAIL | DAS_WV_V_ITEM_CHRG_DETAIL | New | New table added for DAS replication. |
| V_ITEM_CHRG_DETAIL | RDS_WV_V_ITEM_CHRG_DETAIL | New | New table added for RDS replication. |
| ITEM_CHRG_DETAIL | DAS_WV_ITEM_CHRG_DETAIL | Update | ITEM_CHRG_DETAIL will only hold exceptions. To get all up charges applicable to the item, use DAS_WV_V_ITEM_CHRG_DETAIL defined for V_ITEM_CHRG_DETAIL. |
| SVC_ITEM_MASTER | DAS_WV_SVC_ITEM_MASTER | Update | Added TSF_ALLOC_UP_CHRG_SOURCE_TYPE column |
| SVC_ITEM_MASTER | RDS_WV_SVC_ITEM_MASTER | Update | Added TSF_ALLOC_UP_CHRG_SOURCE_TYPE column |
| V_ITEM_CHRG_HEAD | RDS_WV_V_ITEM_CHRG_HEAD | New | New table added for RDS replication. |
| ITEM_CHRG_HEAD | DAS_WV_ITEM_CHRG_HEAD | Update | ITEM_CHRG_HEAD will only hold exceptions. To get all up charges applicable to the item, use DAS_WV_V_ITEM_CHRG_HEAD defined for V_ITEM_CHRG_HEAD. |
| V_ITEM_CHRG_HEAD | DAS_WV_V_ITEM_CHRG_HEAD | New | New table added for DAS replication. |
| ITEM_CHRG_DETAIL | RDS_WV_ITEM_CHRG_DETAIL | Update | ITEM_CHRG_DETAIL will only hold exceptions. To get all up charges applicable to the item, use RDS_WV_V_ITEM_CHRG_DETAIL defined for V_ITEM_CHRG_DETAIL. |
Extension of Additional Deal Reporting Days for All Billing Periods
This cloud service update enhances the current ability to extend the generation of invoices related to billback deals for periodic billing cycles (for example, weekly, monthly) by a specified number of days that can now be added to each billing period for that deal, in addition to the existing feature of adding it only to the last reporting period.
REST Service to Integrate Sales Directly into Merchandising Foundation Cloud Service
This cloud service update introduces a new REST service, Sales Upload Service – Upload and Process Sales, that allows for sales from an external Sales Audit or Point of Sale system to be uploaded directly into Merchandising. The validations imposed by this new service are similar to those enforced by the upload sales process that loads sales data from Sales Audit into Merchandising.
Item API Enhancements
This cloud service update adds new REST services and induction upload functionality for creating and managing certain item related features such as Required Documents, Related Items, Related Item Translations, and Free Form UDA Translation within Merchandising. These enhancements complement the existing capabilities for managing item attributes via the spreadsheet upload and REST services.
Integration
Table 1-1 Item Free Form UDAs Translations
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Create Items Service | Update | REST Service | /services/items/create | New child node added for Free Form UDA Translations |
| Update Item UDA Free Form Translations | New | REST Service | /services/item/uda/translations/update | This service is used to update freeform item UDA level translations of an existing item within Merchandising. |
| Delete Item UDA Free Form Translations | New | REST Service | /services/item/uda/translations/delete | This service is used to delete freeform UDA translation from an existing item in Merchandising. |
| Create Item UDA Free Form Translations | New | REST Service | /services/item/uda/translations/create | If translations have been defined for items at the freeform UDA level, they can be included as part of this service. The service will accept both the language and the description specified in the language to add freeform UDA translations to an existing item in Merchandising. |
| Item Subscription API | Update | RIB Message | Free From UDA Translation | Translation for Item Free From UDA may be added together with the creation of a new item or added to an existing item. New message types xitemudafftlcre, xitemudafftlmod and xitemudafftldel have been added. |
Table 1-2 Related Item Translations
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Item Subscription API | Update | RIB Message | Related Items Translation | Translation for Related Items may be added together with the creation of a new item or added to an existing item. New message types xritemtlcre, xritemtlmod and xritemtldel have been added. |
| Create Items Service | Update | REST Service | /services/items/create | New child node added for Translations for Related Items |
| Update Related Item Translations | New | REST Service | /services/item/relatedItem/translations/update | This service is used to update related item level translations of an existing item within Merchandising. |
| Delete Related Item Translations | New | REST Service | /services/item/relatedItem/translations/delete | This service is used to delete an existing translation record of a related item relationship in Merchandising. |
| Create Related Item Translations | New | REST Service | /services/item/relatedItem/translations/create | If translations have been defined for items, at related item level, then they can be integrated as part of this service. The service will accept the language and the description specified in the language to add related item translations to an existing item in Merchandising. |
Table 1-3 Related Items
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Create Items Service | Update | REST Service | /services/items/create | New child node added for Related Items |
| Delete Related Items | New | REST Service | /services/item/relatedItems/delete | This service is used to delete existing item relationship from Merchandising. In order to perform this deletion, the relationship ID must exist within Merchandising, else an error will be returned. |
| Update Related Items | New | REST Service | /services/item/relatedItems/update | This service is used to update item relationships of an existing item within Merchandising. In order to update an item relationship, the specified relationship ID must exist for the item in Merchandising, else an error will be returned. |
| Item Subscription API | Update | RIB Message | Related Items | Related Items may be added together with the creation of a new item or added to an existing item. New message types xritemscre, xritemsmod and xritemsdel have been added. |
| Create Related Items | New | REST Service | /services/item/relatedItems/create | This service is used to add related items to an existing item in Merchandising. Related items can also be added together with the creation of a new item. For more details on item creation, see the Create Items service description. |
Table 1-4 Required Documents
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Create Required Documents | New | REST Service | /services/item/requiredDocuments/create | This service is used to add required documents to an existing item in Merchandising. Required documents may be added together with the creation of a new item as well. For more details on item creation, see the Create Items service description. |
| Delete Required Documents | New | REST Service | /services/item/requiredDocuments/delete | This service is used to delete required document data from an existing item in Merchandising. |
| Item Subscription API | Update | RIB Message | Required Documents | Required Documents may be added together with the creation of a new item or added to an existing item. New message types xitemreqdoccre, xitemreqdocdel have been added. |
| Create Items Service | Update | REST Service | /services/items/create | New child node added for Required Documents |
Single Point of Entry for Common Inbound REST Services for Merchandising Foundation Cloud Service and Store Inventory and Operations Cloud Services
This cloud service update provides a single point of entry for interfaces that are common to Merchandising Foundation Cloud Service (MFCS) and Store Inventory and Operations Cloud Services (SIOCS) 26.1.101 and above. This is applicable in cases where the two applications are integrated directly via the database and enables external systems integrating with both MFCS and SIOCS via REST Services to only invoke a single REST endpoint at the MFCS end, thereby making the process more efficient. The following integration flows benefit from this new feature:
-
ASNIn (Purchase Order Shipment)
-
ASNOut (Warehouse to Store Shipment)
-
Stock Order Status
Steps to Enable
This new feature is disabled by default. To enable this, users have to enable any combination of the following system options, each corresponding to an integration point:
-
ROUTE_EXT_ASNOUT_TO_SIOCS_IND
-
ROUTE_EXT_ASNIN_TO_SIOCS_IND
-
ROUTE_EXT_SOSTATUS_TO_SIOCS_IND
This can be done through the System Options screen, under the “Publish to Oracle Retail Store Inventory Operations” section.
System Options
| Attribute Name | New or Update? | Attribute Description | Default Value |
|---|---|---|---|
| ROUTE_EXT_SOSTATUS_TO_SIOCS_IND | New | This indicates if a Stock Order Status change from a Warehouse system will be passed on to SIOCS from MFCS or not. If set to Y, MFCS will write an ICL_RMS_TRANSFER or ICL_RMS_ALLOC record for SIOCS to process. | N |
| ROUTE_EXT_ASNOUT_TO_SIOCS_IND | New | This indicates if a warehouse to store shipment of stock orders (i.e. ASNOUT) from a Warehouse system will be passed on to SIOCS from MFCS or not. If set to Y, MFCS will write an ICL_RMS_SHIPMENT record for SIOCS to process. | N |
| ROUTE_EXT_ASNIN_TO_SIOCS_IND | New | This indicates if a vendor shipment of purchase orders (i.e. ASNIN) from an external system will be passed on to SIOCS from MFCS or not. If set to Y, MFCS will write an ICL_RMS_ASNIN record for SIOCS to process. | N |
Integration
| API Name | Change Type | Integration Type | Field Name | Change Description |
|---|---|---|---|---|
| Manage Inbound ASN | Update | REST Service | uin | Added uin field |
| Manage Inbound ASN | Update | REST Service | tracking_Nbr | Added tracking_Nbr field |
DAS/RDS Updates
| Application Table | DAS/RDS Table or View | Change Type | Change Description |
|---|---|---|---|
| PRODUCT_CONFIG_OPTIONS | DAS_WV_PRODUCT_CFG_OPTNS | Update | Added ROUTE_EXT_ASNOUT_TO_SIOCS_IND, ROUTE_EXT_ASNIN_TO_SIOCS_IND, and ROUTE_EXT_SOSTATUS_TO_SIOCS_IND columns |
| SYSTEM_OPTIONS | RDS_WV_SYSTEM_OPTIONS | Update | Added ROUTE_EXT_ASNOUT_TO_SIOCS_IND, ROUTE_EXT_ASNIN_TO_SIOCS_IND, ROUTE_EXT_SOSTATUS_TO_SIOCS_IND columns |
| SHIPSKU_PRG_HIST | DAS_WV_SHIPSKU_PRG_HIST | Update | Added TRACKING_NBR and COMMENTS columns. |
| SHIPSKU | RDS_WV_SHIPSKU | Update | Added TRACKING_NBR and COMMENTS columns. |
| PRODUCT_CONFIG_OPTIONS | RDS_WV_PRODUCT_CONFIG_OPTIONS | Update | Added ROUTE_EXT_ASNOUT_TO_SIOCS_IND, ROUTE_EXT_ASNIN_TO_SIOCS_IND, ROUTE_EXT_SOSTATUS_TO_SIOCS_IND columns |
| SYSTEM_OPTIONS | DAS_WV_SYSTEM_OPTNS | Update | Added ROUTE_EXT_ASNOUT_TO_SIOCS_IND, ROUTE_EXT_ASNIN_TO_SIOCS_IND, ROUTE_EXT_SOSTATUS_TO_SIOCS_IND columns |
| SHIPSKU | DAS_WV_SHIPSKU | Update | Added TRACKING_NBR and COMMENTS columns. |
| SHIPSKU_PRG_HIST | RDS_SHIPSKU_PRG_HIST | Update | Added TRACKING_NBR and COMMENTS columns. |
Item Attribute Extraction Through Oracle Digital Assistant
This cloud service update enhances the Oracle Digital Assistant (ODA) to offer the capability to extract item attributes from a textual description or image uploaded via the ODA interface. The attributes extracted can be aligned or tuned to the retailer’s business requirements by providing relevant examples through an override service.
Purchase Order-Specific Deal Related Enhancements
The Purchase Order (PO) Specific Deal functionality has been enhanced to offer the following additional flexibilities
-
Automatic synchronization of PO-specific deal dates: Modifications have been made to ensure that when the "Not Before Date" or "Not After Date" of a Purchase Order are updated, the Active Date and Close Date of the associated PO-specific deal will be automatically updated to match, regardless of the deal’s current status (Active or Non-Active but Approved). This ensures that deal timelines remain consistent with their corresponding Purchase Orders.
-
Flexibility to create PO-specific deals of the same type: Provide users an option to create and approve a new PO-Specific deal of the same type (Off Invoice, Allowance, Bill Back, or Bill Back Rebate) even if an active deal of that type already exists. Users creating a new PO-Specific deal from the Purchase Ordering UI will be informed if an existing PO Specific Deal exists and that proceeding with the creation/approval of the new deal would render the preexisting deal invalid. If the user proceeds with the creation, then, upon approval of the new deal, any previously approved deal of the same type will be automatically closed.
REST Service to Integrate Supplier Options into Invoice Matching Cloud Service
This cloud service update introduces a new REST service, Supplier Options Upload Service – Manage Supplier Options, for mass maintenance of supplier options and supplier group options in Invoice Matching. This complements the existing capability of managing these records via the application screens with an additional feature to handle externally generated supplier group identifiers associated with a set of supplier group members.
New Jurisdiction Code Attribute for CFIN Integration
This cloud service update introduces a new fiscal attribute in the Fiscal Data Management (FDM) module of RFMCS. This new attribute is meant to be used exclusively with Fusion Cloud Financials for supplier integration. The information sent by Fusion Cloud Financials will be received in FDM and automatically updated in the Merchandising Address table for suppliers and partners created and maintained in Fusion.
New Tax Context Field for Accounts Mapping in General Ledger Cross Reference: Exclusive for Standalone Documents
This cloud service update introduces a new Tax Context field for Standalone Documents generated in Fiscal Document Generation (FDG) so they can be mapped to various accounts in GL Cross Reference mapping. This is an additional level of classification that can be used to allow mapping to various set of accounts using this information as criteria to differentiate between documents generated in the same workflow.
Noteworthy Workflow Updates within Retail Fiscal Management Cloud Service
This cloud service update introduces updates in Retail Fiscal Management Cloud Service (RFMCS) Workflows applied exclusively to Brazil NFe.
-
FDG: Default Weight determination based on item dimensions: In cases where the inventory systems in charge of shipments cannot provide the total shipment weight information, the FDG workflows in RFMCS are now able to derive this information based on item’s dimension setup.
-
Standalone Document Generation: Added Document Cancelation Steps: Fiscal document cancellation via an external request using a REST service can now be leveraged for documents generated in the standalone workflows (DNIDG and DNODG), which was not supported for these workflows in previous versions.
-
Standalone Document Generation: Map tag Comments to the Fiscal Document Payload: The API for fiscal document generation has a tag “comments” as part of the payload. This tag is now mapped to the “infAdFisco” tag in Brazil’s NFe document layout. This is exclusive to the standalone document generation workflows.
-
Purchase Order Fiscal Document Receiving (POFDR): Added Supplier Quantity Level attribute in PO matching logic: The “Supplier Quantity Level” attribute in MFCS is meant to identify suppliers that have their shipments and ASN data generated in terms of “Eaches’ or “Cases”. This attribute is used in MFCS and SIOCS to trigger the calculation of expected quantity. RFMCS now considers this attribute for the same purpose, allowing suppliers to generate their invoices in “EA” or “CA”, irrespective of how the purchase order is created.