Release Notes

1 Release Notes

This document highlights the major changes for Release 19.3.005 of Oracle Retail Merchandising Foundation Cloud Service.

Overview

Retailers leverage Oracle Retail Merchandising Foundation Cloud Service (RMFCS) functionality to execute core merchandising activities, including merchandise management, inventory replenishment, purchasing, import processes, sales auditing, and financial tracking. Its Trade Management module is used to manage the import process, including automating the steps necessary to import goods, managing file exchanges with trading partners, and providing a central database of critical import order information.

Merchandising Foundation Cloud Service also includes the Sales Audit module. The Sales Audit module evaluates sales transaction from all channels, identifying any missing, duplicate, or erroneous data and highlighting any suspicious transactions, to ensure errors are resolved so that downstream systems operate off the same cleansed sales information.

Feature Summary

The enhancements below are included in this release.

Table 1-1 Feature Summary

Feature	Bug Number	Module Impacted	Delivered	Scale	Customer Action Required?
Actual Departure Date Fields Added to Transportation Upload	33448823	Merchandising	Disabled	Small	Yes
Added Oracle WMS Cloud Integration for Stock Order Allocation and Deallocation	N/A	Merchandising	Disabled	Small	Yes
Corrected Out of Balance Error When Loading Sales for Customer Special Orders	33559209	Sales Audit	Enabled	Small	No
Corrected an Issue where POs are not Automatically Scaled by the Replenishment Batch	33495420	Merchandising	Enabled	Small	No
Data Conversion - Banners and Channels Exception	33598656	Merchandising	Enabled	Small	No
Data Conversion - Consignment Item Mismatch Between Parent and Child Items	33515910	Merchandising	Enabled	Small	No
Data Conversion - Create Items with Custom UOM	33495994	Merchandising	Enabled	Small	No
Data Conversion - Department Create Limitations	33628501	Merchandising	Enabled	Small	No
Data Conversion - Department Upcharges Exception	33589574	Merchandising	Enabled	Small	No
Data Conversion - Disable Item/Location Traits Publisher	33469287	Merchandising	Enabled	Small	No
Data Conversion - ELC Components Exception	33611031	Merchandising	Enabled	Small	No
Data Conversion - Item Entity Returning False Success	33520118	Merchandising	Enabled	Small	No
Data Conversion - Item Performance Improvements	33572154	Merchandising	Enabled	Small	No
Data Conversion - Item/Location Ranging Exception	33619988	Merchandising	Enabled	Small	No
Data Conversion - Item/Location with CFAS in Multiple Groups	33538168	Merchandising	Enabled	Small	No
Data Conversion - Load Supplier Entity Before Set of Books	33492966	Merchandising	Enabled	Small	No
Data Conversion - Non-EA UOMs for Items	33584259	Merchandising	Enabled	Small	No
Data Conversion - Purchase Order Exceptions	33619029	Merchandising	Enabled	Small	No
Data Conversion - Store Create Performance Improvements	33624820	Merchandising	Enabled	Small	No
Data Conversion - Supplier Hierarchy Types for Item/Supplier/Location	33639978	Merchandising	Enabled	Small	No
Data Conversion - Updated Chunk Size and Threads for Customer Orders	33503630	Merchandising	Enabled	Small	No
Delete Transactions Displayed in Open Transactions Dashboard Report	33032390	Sales Audit	Enabled	Small	No
Document Sequence and E-Invoicing Templates Moved to Finance Administration	32498773	Merchandising	Enabled	Small	No
EDI Order Download Extracting Redundant Order Files	33135836	Merchandising	Enabled	Small	No
Error Code Spreadsheet Upload	33520275	Sales Audit	Enabled	Small	No
Error Occurring when Processing POSU Files	33429482	Merchandising	Enabled	Small	No
Filter by Date in Manage Orders Search Screen	33503290	Merchandising	Enabled	Small	No
General Ledger to Financials Job Changed to Partial Dataset	33606225	Merchandising	Enabled	Small	No
Improved Handling of Supplier Web Service Errors	31463208	Merchandising	Enabled	Small	No
Include CFA Configuration Tables in the Exclusions During Mock	33517778	Merchandising	Enabled	Small	No
Invoice Induction Templates Added to Template Configuration	33359847	Merchandising	Enabled	Small	No
Issue with Item Publication API Shutting Down	30974229	Merchandising	Enabled	Small	No
Item Loc Inventory Detail REST Service to Include In Progress Sales	33394442	Merchandising	Enabled	Small	No
Multi-Threading Sales Audit Purge	33511011	SAles Audit	Enabled	Small	No
New DAS Tables	33652619	Merchandising	Disabled	Small	Yes
Online Scaling of Time Supply Replenishment Orders	33548497	Merchandising	Enabled	Small	No
Performance Improvement to REPLADJ Batch Job	33467352	Merchandising	Enabled	Small	No
Performance Improvements for the Inventory Control Dashboard	33663281	Merchandising	Enabled	Small	No
Performance Improvements in Financial Analysts Dashboard	33623677	Merchandising	Enabled	Small	No
Performance Improvements in Sales Processing Job	33587267	Merchandising	Enabled	Small	No
Performance Improvements to ASNOUT Interface	33641153	Merchandising	Enabled	Small	No
Performance Improvements to GL Cross Reference Setup	33380586	Merchandising	Enabled	Small	No
Performance Improvements to Scheduled Item Maintenance	33554916	Merchandising	Enabled	Small	No
Performance improvement for SITMAIN	33554975	Merchandising	Enabled	Small	No
Pre-Export Batch Performance Improvement	33377386	Sales Audit	Enabled	Small	No
Pre-Issue Order Report Showing Blank	33456382	Merchandising	Enabled	Small	No
Purge Job Performance Improvements	33545549	Merchandising	Enabled	Small	No
Record Locking Issues in Fulfill Order Service Fixed	33541706	Merchandising	Enabled	Small	No
Removed Delivery Date Requirement from XTransfer API for Modifications	33609806	Merchandising	Enabled	Small	No
Removed Latest Ship Date Requirement from XOrder API	33554415	Merchandising	Enabled	Small	No
Removed Requirement for Transfer Zone when Creating a Store	33581947	Merchandising	Enabled	Small	No
Replenishment Order Built Performance Improvement	33474263	Merchandising	Enabled	Small	No
Replenishment Parameter Download Performance Improvements	33479800	Merchandising	Enabled	Small	No
Resolved Issue with Associated Locations to Groups Upload	33541917	Merchandising	Enabled	Small	No
SAEXPGL Does Not Export New Revisions of Sales Totals to GL	33485606	Sales Audit	Enabled	Small	No
Sales File Archive Job Added	33610605	Merchandising	Disabled	Small	Yes
Stock Counts Posted Across Months	33668812	Merchandising	Enabled	Small	No
Supplier Pre Mark Indicator Disabled when Financial_Ap = A	33470047	Merchandising	Enabled	Small	No
Support Definition of Store Class for Franchise Stores	33601898	Merchandising	Enabled	Small	No
Totals Maintenance - Displaying Latest Revision of Total	33301692	Sales Audit	Enabled	Small	No
Vendor Address Messages Getting Published with No Detail	33329689	Merchandising	Enabled	Small	No
Corrected Calculation and Defaulting of Components with Customs Entry Min/Max Limits	33601753	Merchandising	Enabled	Small	No
Corrected Calculation of the Customs Entry Screen Actual Assessment - Other Value	33601736	Merchandising	Enabled	Small	No
Corrected Calculation of the Customs Entry Screen Actual Assessment - Taxes Value	33601716	Merchandising	Enabled	Small	No
Corrected Error Encountered While Loading New Item Locations via Data Conversion Tool	33534780	Merchandising	Enabled	Small	No
Create Store Day for Expected Transactions Process Updated to use Store Data Table	33491308	Sales Audit	Disabled	Small	Yes
Improvements to Stock Count Processing	33310588	Merchandising	Enabled	Small	No
Performance Improvements to Cost Event Purge	33458092	Merchandising	Enabled	Small	No
Performance Improvements to Location List Rebuild	33434685	Merchandising	Enabled	Small	No
Performance Improvements to Sales Audit Purge Processing	33433639	Sales Audit	Enabled	Small	No
Updated Creation of Non-Merchandise Invoices from Customs Entry	33472507	Merchandising	Enabled	Small	No
Updated Defaulting of Order Exchange Rate in Purchase Order Data Loading	33428281	Merchandising	Enabled	Small	No
Updated Handling of Comments on Orders Created via Customer Order Fulfillment Service	33446658	Merchandising	Enabled	Small	No
Updated Handling of Expenses for Buyer Packs via Order Subscription API	33509841	Merchandising	Enabled	Small	No
Updated Processing to Calculate Average Weight at Receiving Location for Catch Weight Items	33487127	Merchandising	Enabled	Small	No
Updated Retail by Zone to Correctly Calculate Markup upon Entering Screen	33455675	Merchandising	Enabled	Small	No
Updated Transportation Upload to Accept Non-Numeric Item Identifiers	33630046	Merchandising	Enabled	Small	No
Correct Error While Purging Vouchers	32660288	Sales Audit	Enabled	Small	No
Corrected Future Cost Creation through Cost Change Process and Deletion of Item/Supplier/Country/Location Record	33557286	Merchandising	Enabled	Small	No
Fixed Import Job to Process RTLOG Files in the Order they are Received	33602174	Sales Audit	Enabled	Small	No
Fixed Issue Preventing Delete of Cost Changes in Worksheet Status	33501937	Merchandising	Enabled	Small	No
Fixed Issue in Sales Process Job While Creating Consignment Returns	33681149	Merchandising	Enabled	Small	No
Fixed Item Mass Change to Allow Only Valid Supplier and Country Combination	33404628	Merchandising	Enabled	Small	No
Fixed Order Revision Screen for Accepting EDI Quantity Changes	33600661	Merchandising	Enabled	Small	No
Fixed Order Screen to Prevent Showing Invalid Error Related to Currency Exchange Rate	33550734	Merchandising	Enabled	Small	No
Performance Improvement to Weekly Job Updating Stock On Hand and Retail Value for Item Location	33568784	Merchandising	Enabled	Small	No
Removed Restriction on Store Class and Store Type Combinations from Store XAPI	33567629	Merchandising	Enabled	Small	No
Allow Re-use of Cartons from Cancelled Shipments	33349889	Merchandising	Enabled	Small	No
Changed Requirement for Pricing Location for Warehouses	32795411	Merchandising	Enabled	Small	No
Corrected Display of Customer Information	32982860	Merchandising	Enabled	Small	No
Corrected Display of Roll-up Levels for Over/Short Totals	33532575	Sales Audit	Enabled	Small	No
Corrected Error in SUPSPLIT Processing	33474842	Merchandising	Enabled	Small	No
Corrected Last Update ID and Date Capture	32171929	Merchandising	Enabled	Small	No
Corrected Results for Date Search in Manage Transaction	33415678	Sales Audit	Enabled	Small	No
Corrected Transaction Out of Balance Issue for Special Orders	33552807	Sales Audit	Enabled	Small	No
Corrected Translation Issue in PO Spreadsheet Download	33444317	Merchandising	Enabled	Small	No
Enabled Adding Custom Error Messages	33278756	Merchandising	Enabled	Small	No
Enabled SAEXPUAR for Ad-Hoc Scheduling	33484721	Sales Audit	Disabled	Small	Yes
Performance Improvement for Item Location BDI Export	33550558	Merchandising	Enabled	Small	No
Performance Improvements for Transfer Purge	33484594	Merchandising	Enabled	Small	No
Performance Update for Inventory by Location Screen	33383336	Merchandising	Enabled	Small	No
Preserved Deal Status on Modification via Deal Upload	33474371	Merchandising	Enabled	Small	No

Actual Departure Date Fields Added to Transportation Upload

Added actual departure date in Transportation Upload (tranupld) input file. This field is optional but if a date is not provided 8 blank spaces need to be included in the input file. If provided, it will be validated together with the actual arrival date to prevent errors when opening the transportation record in Merchandising. An update was also made to documentation to correctly reflect the order number supports length 12, not 8 as previously documented.

Steps to Enable

The updated input file format that includes the actual departure date must be adopted before the transportation upload will run successfully. If the source cannot provide a value for this field the input can send eight blank spaces in the file.

Integration Impacts

Table 1-2

API Name	New/Updated?	Integration Type	Field Name	Change Notes
Transportation Upload	Update	Flat File	Actual Departure Date	This new field may contain the actual departure date for the transportation record. This field is optional but if a date is not provided 8 blank spaces need to be included in the input file. The field has been added to the file in the DTRAN record type between the Shipment Number and Actual Arrival Date fields. The data type and size is char(8) with a format of YYYYMMDD.

Added Oracle WMS Cloud Integration for Stock Order Allocation and Deallocation

Previously, Merchandising was not updated when a user in WMS Cloud started working on a stock order (transfer or allocation) with the process of waving which allocated units against that stock order. As a result, Merchandising did not have visibility to stock order operations taking place in WMS until it got packed. This often resulted in RIB message failures from Merchandising to WMS Cloud, in cases where Merchandising sent updates or cancellations for a stock order which was already allocated but not yet packed in WMS. The reason is that once the quantity gets allocated to a stock order, WMS Cloud does not accept any further changes from Merchandising against the same. In order to address this gap, allocation or deallocation through waving or un-waving operations in WMS Cloud will now be communicated via the Stock Order Status message to Merchandising. With this change, activity code 85 (Order Detail Status Change) in Oracle WMS Cloud will be configured as SO Status messages to increase or decrease the selected quantity on transfer and allocation within Merchandising. **Note:** This feature also includes updates in the Oracle Retail Integration Cloud Service to support the changes described above.

Steps to Enable

Given that the activity code 85 (Order Detail Status Change) pre-existed within WMS Cloud but was not integrated, it is critical to ensure that only new records are integrated to Merchandising when this code is configured in the integration. Therefore, it is recommended to integrate these using "Enable Auto Send" option on the Inventory History Activity Parameters screen in Oracle WMS Cloud. This option enables real time integration of the activity codes and only future transactions for these activity codes in the Inventory History table would get interfaced to Merchandising. The steps to configure activity code 85 as SO Status Message are described below:

The value 85 needs to be added to the list of activity codes configured for the SOStatusCre message type in the Output Interface Configuration UI for the interface type Inventory History Export within Oracle WMS Cloud.
The Enable Auto Send option in the Inventory History Activity Parameters screen needs to be set for the Activity code 85. See also the Retail and WMS Cloud Implementation Guide for more details on the configurations described above.

Integration Impacts

Table 1-3

API Name	New/Updated?	Integration Type	Field Name	Change Notes
SO Status	Update	RIB Message	N/A	Update required in WMS Cloud configuration to include activity code 85 records in publication to SO Status.

Corrected Out of Balance Error When Loading Sales for Customer Special Orders

Corrected transaction out of balance issue when loading sales for special order items with tax details. Issue occurred when Order Initiate and Order Complete were both being used.

Corrected an Issue where POs are not Automatically Scaled by the Replenishment Batch

The issue was caused by the “Max Scale Value" replenishment attribute being treated as the maximum final amount to scaled to. The final amount to scale up to should be the pre-scaled amount plus “Max Scale Value". The incorrect logic led to the scaling not reaching a solution even though the maximum number of scaling iteration has not been reached.

Data Conversion - Banners and Channels Exception

Previously, when banners and channels were loaded through the Data Conversion tool, a null pointer exception error was encountered. This has been fixed.

Data Conversion - Consignment Item Mismatch Between Parent and Child Items

Previously, the CONSIGN_ATTRIB_MISMATCH error which is logged when the purchase type and calculation basis is different between the parent and child items was encountered when the consignment items were converted using DC_ITEM entity. This has been corrected.

Data Conversion - Create Items with Custom UOM

Previously, the DC_ITEM entity does not allow the creation o items using a custom cost unit of measure (UOM). With this update this has been corrected so the item can be created with custom cost UOM.

Data Conversion - Department Create Limitations

Previously, the Data Conversion tool was not allowing to create departments with profit calculation type as Direct Cost and purchase type as Consignment. This has been corrected.

Data Conversion - Department Upcharges Exception

Previously, when department upcharges data were loaded through the Data Conversion tool, a null pointer exception error was encountered. This has been fixed.

Data Conversion - Disable Item/Location Traits Publisher

Previously, a large number of item/location modification messages were published when data was loaded for item/location traits using the Data Conversion tool. This is because the publishing trigger on the ITEM_LOC_TRAITS tables was not disabled during data conversion. This has been corrected.

Data Conversion - ELC Components Exception

Previously, an internal code error was faced when ELC components were loaded through the Data Conversion tool. This has been corrected.

Data Conversion - Item Entity Returning False Success

Prior to this update the process status for some of the tables converted using DC_ITEM entity when there are approval errors was set as PS- Processed Successfully rather than PE- Processed with Error. With this update this has been corrected.

Data Conversion - Item Performance Improvements

This update includes performance enhancements to the ITEM entity in the data conversion tool.

Data Conversion - Item/Location Ranging Exception

The unique constraint error logged for the New Item/Location Detail (NIL_DETAIL_R) entity for the item/location ranging conversion has been fixed in this update.

Data Conversion - Item/Location with CFAS in Multiple Groups

Previously, the Custom Flex Attributes (CFA) for item/location could not be loaded when there were CFAs belonging to multiple CFA groups in the input file. This has been corrected.

Data Conversion - Load Supplier Entity Before Set of Books

Previously, the Multiple Set of Books entity group was loaded before the Supplier entity group. As a result of this incorrect load sequence, the PARTNER_ORG_UNIT entity which is a part of the Multiple Set of Books entity group could not be loaded until partners/suppliers are created. This has been fixed.

Data Conversion - Non-EA UOMs for Items

Previously, the DC_ITEM entity was overriding the standard UOM to EACH for items with differentiators. This entity has been updated to support standard UOMs other than EACH.

Data Conversion - Purchase Order Exceptions

Prior to this update, in the Data Conversion tool purchase order expenses were not calculated for pack items. This has been corrected.

Data Conversion - Store Create Performance Improvements

This update includes performance improvements for the STORE_ADD entity in the data conversion tool.

Data Conversion - Supplier Hierarchy Types for Item/Supplier/Location

In this update, corrected the issue related to incorrect supplier hierarchy types in the item/supplier/location conversion.

Data Conversion - Updated Chunk Size and Threads for Customer Orders

Prior to this update the default values for chunk size and thread count were zero for the CREATE_CUSTOMER_ORDERS entity which is a multi-threaded entity. These have been updated to a non-zero value.

Delete Transactions Displayed in Open Transactions Dashboard Report

The Sales Audit Open Transaction Errors dashboard report was update to not display errors for deleted transactions.

Document Sequence and E-Invoicing Templates Moved to Finance Administration

In the Upload Data function the templates for Document Sequence and E-Invoice Mapping have been moved from the Foundation template type to the Finance Administration template type.

EDI Order Download Extracting Redundant Order Files

The Download Purchase Orders to Supplier (EDIDLORD) process has been modified to only send the PO in the extract file when something that impacts the vendor has truly changed based on the old and new values. Previously a “change" file was being generated for non-material changes.

Error Code Spreadsheet Upload

An unhandled exception was encountered when Error Codes were uploaded due to the fatal_ind column that was added. This has been fixed.

Error Occurring when Processing POSU Files

There was an issue with processing sales files where sales-based deal income was being accrued if the sales came after the last reporting period of a closed deal. This has been corrected so these sales process correctly and there is no deal income accrued.

Filter by Date in Manage Orders Search Screen

The ability to filter records in the results table using the Query by Example column headers for the Not Before Date and Not After Date columns has been added. Previously attempting to filter records by these date columns resulted in an error.

General Ledger to Financials Job Changed to Partial Dataset

The Finance General Ledger to Financials Interface (FinGenLdgr_Tx_ProcessFlow_From_RMS) has been updated to extract a partial dataset rather than a full dataset according to the job's design.

Improved Handling of Supplier Web Service Errors

If the supplier web service encounters an error when creating or updating suppliers, an unhandled error was being returned to the calling solution. This has been updated to correctly handle the error and provide correct error details.

Include CFA Configuration Tables in the Exclusions During Mock

In the past, the Mock functionality was cleaning up data from the Custom Flex Attributes (CFA) configuration tables while refreshing the conversion environment. To address the issue, the CFA configuration tables have been added in the exclusion list of environment refresh.

Invoice Induction Templates Added to Template Configuration

The ability to configure the Invoice Matching Induction templates has been added to the Merchandising Template Configuration Screens.

Issue with Item Publication API Shutting Down

An issue resulting in the Item Publication API shutting down when processing high volumes has been resolved.

Item Loc Inventory Detail REST Service to Include In Progress Sales

The in-progress sales quantity to the value has been added to the return object of the Item Loc Inventory Detail Service. Note: the in-progress sales field is not being used in this cloud service update so it will not have a value. It has been added to support future development.

Integration Impacts

Table 1-4

API Name	New/Updated?	Integration Type	Field Name	Change Notes
Item Loc Inventory Detail Service	Update	REST Service	inProgressSalesQty	Returns the In Progress Sales Qty value of an Item/Location combination

Multi-Threading Sales Audit Purge

The ability to run the Sales Audit Purge (sapurge) processes in multiple threads has been added to improve the performance.

New DAS Tables

New tables were added for replication in DAS. Additionally, there was a change to a configuration file: create_rms01_synonyms.sql - Added synonym for IM_DOC_MATCH_ATTRIB_SEQ sequence.

Steps to Enable

In order to enable this functionality, you will need to replace the modified configuration files with the latest version. The directions for how to download updated files and replace the old versions can be found in the white paper on My Oracle Support (support.oracle.com) under ID 2283998.1.

Data Access Schema (DAS) Updates

Table 1-5

Table Name	View Name	New/Updated?	Change Notes
ORD_PREISSUE	DAS_WV_ORD_PREISSUE	New	New table added for DAS Replication.
IM_DOC_MATCH_ATTRIB	DAS_WV_IM_DOC_MATCH_ATTRIB	New	New table added for DAS Replication.
IM_RWO_SHIPSKU_HIST	DAS_WV_IM_RWO_SHIPSKU_HIST	New	New table added for DAS Replication.
IM_RWO_SHIPMENT_HIST	DAS_WV_IM_RWO_SHIPMENT_HIST	New	New table added for DAS Replication.

Online Scaling of Time Supply Replenishment Orders

Fixed an issue where online scaling of time supply replenishment purchase orders was not completing, which resulted in the screen hanging and the order not be scaled properly.

Performance Improvement to REPLADJ Batch Job

Performance improvements have been made to the Recalculate Maximum Levels for Floating Point Replenishment (repladj) batch job.

Performance Improvements for the Inventory Control Dashboard

Updates have been made to improve the performance of the Inventory Control Dashboard, specifically the Stock Orders Pending report. In addition an error related to a divisor being zero was fixed.

Performance Improvements in Financial Analysts Dashboard

Queries have been updated in the Financial Analysts Dashboard reports to improve performance.

Performance Improvements in Sales Processing Job

Performance improvements have been made to the Sales Processing Job (salesprocess.ksh).

Performance Improvements to ASNOUT Interface

Updates were made to improve the overall performance of processing of ASNOUT messages.

Performance Improvements to GL Cross Reference Setup

Performance improvements have been made to the GL Cross Reference setup process.

Performance Improvements to Scheduled Item Maintenance

Performance improvements have been implemented in the Scheduled Item Maintenance process (SITMAIN), specifically to the logic touching reclassification plus additional database hints being added.

Performance Improvement for SITMAIN

Performance improvements have been made to the Scheduled Item Maintenance (SITMAIN) job to better handle a use case of ranging a large number of item/location combinations.

Pre-Export Batch Performance Improvement

Performance improvements have been made to the Prevent Duplicate Export of Total Values Batch (sapreexp).

Pre-Issue Order Report Showing Blank

An issue where the Pre-Issue Order Number Report was showing blank has been resolved by correcting the report parameters.

Purge Job Performance Improvements

Performance improvements have been made to the DAILY_PURGE background job.

Record Locking Issues in Fulfill Order Service Fixed

During high hourly volumes of the Fulfill Order Service, the webservice was encountering record locks, specifically on the ITEM_LOC_SOH table. This was leading to failed service calls. This API has been modified to use lock wait/retry logic when a locked record on the ITEM_LOC_SOH table was encountered.

Removed Delivery Date Requirement from XTransfer API for Modifications

Removed the redundant validation and ensured that AIP_IND and transfer types fields are used when validating for required values for delivery date field. The delivery date will only be validated as required when Advanced Inventory Planning is enabled (system configuration AIP_IND = Y).

Removed Latest Ship Date Requirement from XOrder API

The XOrder API has been modified to use the existing Latest Ship Date of the PO if it is not provided in the XOrder message when updating a PO. Previously validation existed that was requiring the Latest Ship Date to be provided for order modifications.

Removed Requirement for Transfer Zone when Creating a Store

The requirement to define a transfer zone when creating a new store has been removed to allow stores to be created without specifying a value for this field.

Replenishment Order Built Performance Improvement

Performance improvements have been implemented in the Build Replenishment Orders (rplbld) job.

Replenishment Parameter Download Performance Improvements

Performance improvements have been made to the Download Replenishment Attributes (Induction) process to better handle large volumes. Previously large volumes were resulting in the screen freezing and the operation not completing.

Resolved Issue with Associated Locations to Groups Upload

An issue preventing the upload for Foundation Data -> Upload Data -> Template = “Data Filtering" -> Associated Locations to Groups has been resolved.

SAEXPGL Does Not Export New Revisions of Sales Totals to GL

An issue was fixed where the Post User Defined Totals (saexpgl) job is not exporting new sales totals to GL when it was previously a deleted store day. This happened when last exported value prior to delete is the same as the current values to be loaded after store day has been deleted.

Sales File Archive Job Added

Added archivelog.ksh script as Adoc job. This Adhoc job performs archival of 7 days old files from below folders * ${RETAIL_HOME}/data/processed, * ${RETAIL_HOME}/log, * ${RETAIL_HOME}/log/sqlloader * ${RETAIL_HOME}/error Purge the 189 days old files from below folders * ${RETAIL_HOME}/data/processed/archive * ${RETAIL_HOME}/log/archive * ${RETAIL_HOME}/log/sqlloader/archive * ${RETAIL_HOME}/error/archive * ${RETAIL_HOME}/data/archive

Steps to Enable

The new ARCHIVE_LOGS_PROCESS_ADHOC and ARCHIVE_LOGS_JOB jobs must be scheduled to run on a daily basis.

Batch Schedule Impacts

Table 1-6

Process Name	Process Type	New/Updated?	Delivered
ARCHIVE_LOGS_PROCESS_ADHOC	Ad Hoc	New	Disabled
ARCHIVE_LOGS_JOB	Ad Hoc	New	Disabled

Stock Counts Posted Across Months

Corrected the issue when posting book stock cost updated when a product hierarchy and location was active in previous month and current month if system configuration allows open stock counts during month end close. This was creating a data issue in the MONTH_DATA table.

Supplier Pre Mark Indicator Disabled when Financial_Ap = A

For suppliers created in the financial system the Pre-Mark Indicator was not available for updating. This has been corrected with this update.

Support Definition of Store Class for Franchise Stores

Previously Franchise Store locations were defaulted to the Store Class of “X". This was hardcoded and could not be updated. The store setup has now been modified to allow franchise stores to be associated to any store class.

Totals Maintenance - Displaying Latest Revision of Total

An issue where the Totals Maintenance Screen was not displaying the latest revision for a total has been corrected in this update.

Vendor Address Messages Getting Published with No Detail

There was an issue that resulted in new supplier addresses and modifications to addresses being published from Merchandising without any details associated. This has been corrected.

Corrected Calculation and Defaulting of Components with Customs Entry Min/Max Limits

There is a table that hold components which are subject to a min/max limit on a given customs entry. Previously the system was not using the correct identifier to obtain the cost components from this table. The logic has been modified to correctly determine the component identifier.

Corrected Calculation of the Customs Entry Screen Actual Assessment - Other Value

On the Customs Entry screen several totals are displayed, including Actual Assessments values for Duty, Taxes and Other. The Other value was being calculated incorrectly, the calculation has been updated.

Corrected Calculation of the Customs Entry Screen Actual Assessment - Taxes Value

On the Customs Entry screen several totals are displayed, including Actual Assessments values for Duty, Taxes and Other. The Taxes value was being calculated incorrectly, the calculation has been updated.

Corrected Error Encountered While Loading New Item Locations via Data Conversion Tool

Corrected an error that was encountered when attempting to load new item location item files (NIL_DETAIL_R) via the Data Conversion tool.

Create Store Day for Expected Transactions Process Updated to use Store Data Table

Create Store Day for Expected Transactions (SASTDYCR) job was modified to now refer to the store data table (SA_STORE_DATA) for POS and OMS when creating store days. There is some data setup required for enabling this update, see Steps to Enable for details.

Steps to Enable

Upon applying this change, Sales Audit Store Data in Sales Audit should be setup first before creating store days. If store data is not setup, no new store days will be created.

Improvements to Stock Count Processing

The Stock Count Processing program has been modified to auto retry chunks that failed with locking issues. The program will commit data only if all chunks are processed and will rollback the complete file if any of the chunks fail. The logic to generate a reject file/error file has been moved to the Stock Count Process Program instead of the Stock Count Upload program.

Performance Improvements to Cost Event Purge

Updates have been made to improve the overall performance of the Cost Event Purge (costevenetpurge) batch program.

Performance Improvements to Location List Rebuild

Updates have been made to improve the overall performance of the Location List Rebuild process (lclrbld).

Performance Improvements to Sales Audit Purge Processing

Updates were made to improve the overall performance of the Sales Audit Purge job (SA_PURGE_JOB).

Updated Creation of Non-Merchandise Invoices from Customs Entry

During the Customs Entry confirmation process, assessments incurred when clearing customs are sent from Merchandising to Invoice Matching to be created as non-merchandise invoices via the Download of Invoice for Invoice Matching (edidlinv) program. This process has been modified to omit the sending of any tax entries for locations that belong to Tax Exempt VAT regions when the system level tax setting is Simple VAT (SVAT).

Updated Defaulting of Order Exchange Rate in Purchase Order Data Loading

When creating import purchase orders via the purchase order data loading spreadsheet, if the order's exchange rate is not provided, the system would always default the exchange rate to 1, the logic was updated to retrieve the correct exchange rate in this scenario.

Updated Handling of Comments on Orders Created via Customer Order Fulfillment Service

The Customer Order Fulfillment Web Service has been modified to ensure that the comments for the created Customer Order will also be captured in the corresponding Purchase Order.

Updated Handling of Expenses for Buyer Packs via Order Subscription API

The Order Subscription API processing was updated to ensure expenses are added when the item on the order is a buyer pack with an order as type of 'Pack', previously no expenses would display for these types of buyer packs in the Order workflow when they had been loaded via the Order Subscription API.

Updated Processing to Calculate Average Weight at Receiving Location for Catch Weight Items

For Catch Weight Items of Type 3 and 4, average weight for the pack and the component should be updated on shipment for both the source and receiving locations, based on either actual shipped weight or shipping location's average weight, if a weight is not provided. If a weight is included on receipt, it should be ignored, the assumption being, most of the stores do not weigh at time of receipt. Prior to this update, only the average weight for the source location was updated.

Updated Retail by Zone to Correctly Calculate Markup upon Entering Screen

Previously, when the item contained price zones that were in a currency which was different from the system's primary currency, the markup was not calculating correctly. The Retail By Zone screen has been modified to ensure the markup percentage calculates correctly regardless of the currency of the price zones.

Updated Transportation Upload to Accept Non-Numeric Item Identifiers

Updated the logic to allow for item identifiers that are non-numeric. Removed numeric only validation.

Correct Error While Purging Vouchers

Corrected an issue that was raising an error when purging sales audit vouchers in cases where existing escheat transactions were still attached to them.

Corrected Future Cost Creation through Cost Change Process and Deletion of Item/Supplier/Country/Location Record

Fixed the issue where a future cost record was being created for location level exceptions when cost change is carried out at the item level. Now such cost change doesn't result in a future cost entry of location level exceptions. Also, logic for allowing delete of item-Supp-Country-Loc record is modified to prevent accidental ownership change. Deletion is allowed only when Purchase Type is same as what is defined at the supplier-country level.

Fixed Import Job to Process RTLOG Files in the Order they are Received

The RTLOG import batch job is fixed to process RTLOGs in the order that they are received. This remediates issues that were happening when sales import cyclic jobs were skipped due to POM issues.

Fixed Issue Preventing Delete of Cost Changes in Worksheet Status

Previously, users were not allowed to delete cost changes in Worksheet status with effective date in past from the Mass Upload screen. This issue is fixed in this release.

Fixed Issue in Sales Process Job While Creating Consignment Returns

Corrected an error where the Sales Process batch used to error out when creating the RTV (return to vendor) for a consignment return transaction only in case when the system is configured to generate consignment orders and invoices at the Supplier/Department level.

Fixed Item Mass Change to Allow Only Valid Supplier and Country Combination

Fixed the Primary Supplier Site and Primary Country LOVs in the Change Item Loc Attributes screen to only return valid supplier country combination values for parent items that exists for the item at the supplier country level.

Fixed Order Revision Screen for Accepting EDI Quantity Changes

Fixed an issue where the “Accept" checkbox on the Order Revision screen was not being enabled when there is a PO quantity revision from EDI (ediupack) that is greater than the current PO quantity.

Fixed Order Screen to Prevent Showing Invalid Error Related to Currency Exchange Rate

Fixed Order screen to prevent showing “An Exchange Rate does not Exist" error when creating a PO from an existing one. The error is specific to cases when system is set to use Estimated Landed Cost and not to copy currency rate from the order. Also this used to show only when the original order has expense records whose currency code was different than the order's currency code.

Performance Improvement to Weekly Job Updating Stock On Hand and Retail Value for Item Location

Updates were made to improve overall performance of Weekly Stock on Hand and Retail Value Update for Item/Location (HSTWKUPD) job.

Removed Restriction on Store Class and Store Type Combinations from Store XAPI

XAPI interface for Stores (XStore) is modified to allow any store class for all store types (company, franchise). In the previous version company stores were not being able to be created with Store Class ‘X'.

Allow Re-use of Cartons from Cancelled Shipments

When processing inbound ASNs from the supplier, the behavior was modified to allow reuse of carton IDs if the original shipment in which the carton was used is now in cancelled status.

Changed Requirement for Pricing Location for Warehouses

Modified the Virtual Warehouse screen to make the pricing location mandatory in edit mode when Pricing is configured to recognize warehouses as locations.

Corrected Display of Customer Information

Modified the process of saving when adding and modifying customer order billing and delivery information to properly display these values in Customer Order Details screen.

Corrected Display of Roll-up Levels for Over/Short Totals

Modified the code to fix an issue that was resulting in the concatenated labels for each roll-up level from being displayed correctly.

Corrected Error in SUPSPLIT Processing

Modified the logic in the Split Replenishment Orders Among Suppliers (supsplit) batch process so as to correctly handle records where the UOM conversion factor is NULL for an item.

Corrected Last Update ID and Date Capture

Corrected to ensure that the Last Update ID and Last Update Date/Time are updated only when an attribute is modified in the Order Maintenance screen.

Corrected Results for Date Search in Manage Transaction

Corrected the displayed results when searching using the Transaction Date criteria field in Manage Transaction screen.

Corrected Transaction Out of Balance Issue for Special Orders

Fixed transaction out of balance issue when importing sales for special orders where item status is Order Initiate, Order Complete and Order Cancel.

Corrected Translation Issue in PO Spreadsheet Download

Corrected the translation of the Cross Dock value in Order Details worksheet, when downloading a spreadsheet the purchase order into a spreadsheet for non-English speaking users.

Enabled Adding Custom Error Messages

Corrected the permissions issue that was preventing users from adding custom error messages to be used in custom validation rules.

Enabled SAEXPUAR for Ad-Hoc Scheduling

Ad-hoc processing capability has been made available for the Export to Universal Account Reconciliation System from Sales Audit (SAEXPUAR) program. This program can now be run through the POM scheduler in ad-hoc mode.

Steps to Enable

To enable this job, follow these steps:

Log into the Process Orchestration and Monitoring (POM) application with the Administrator role.
In the task list, select Schedules > MERCH > Administration > Batch Administration. This will bring up the MERCH: Batch Administration screen which has the following panels:
- Batch Applications and Modules
- Batch Cycle Management
- Batch Jobs
Under Batch Jobs, scroll (or filter) to locate the job to be enabled and click the Enabled check box to enable or disable the job. Repeat until all jobs have been updated.
Click Save and Close to save your changes and update the schedule. Note: After saving, the changes will take effect once the new scheduler day is created. The changes will not take effect for the current day.

Batch Schedule Impacts

Table 1-7

Process Name	Process Type	New/Updated?	Delivered
SAEXPUAR_PROCESS_ADHOC	Ad Hoc	New	Disabled

Performance Improvement for Item Location BDI Export

Updates were made to the Item/Location BDI publication from Merchandising to improve overall performance.

Performance Improvements for Transfer Purge

Updates have been made to improve the overall performance of Transfer Purge processing.

Performance Update for Inventory by Location Screen

Implemented performance improvement in Item Inventory by Location screen for quicker display of results.

Preserved Deal Status on Modification via Deal Upload

Modified code so that when the supplier deal upload status is Approved, it is not set back to Worksheet when a modification message is processed and a status is not passed in the message.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.