Duplicate Errors for Missing Item/Location on Replenishment Upload Process (Doc ID 3081781.1)

Last updated on APRIL 15, 2025

Applies to:

Symptoms

On: MFCS/RMS 25.0.102.1 version


When uploading replenishment attributes via induction for non-existent item/location combinations or non-existent source warehouses in MFCS, the system generates duplicate error messages for each invalid record. Additionally, an irrelevant "item not valid for supplier" error is incorrectly raised when no supplier is specified in the induction template.

Steps to Recreate:
-----------------------
1. Download Replenishment Induction Template:

Access the MFCS replenishment induction functionality.
Download the replenishment induction template (ODS file) containing existing data.

2. Populate Template with Invalid Item/Store Combination:

Open the downloaded ODS file.
Populate a single line with data for an item/store combination.
Set the "warehouse stocked" category for the item/store combination.
Crucially, ensure the specified item is not associated with the target store or the source warehouse.

3. Load ODS File into MFCS:

Navigate to the MFCS replenishment induction upload interface.
Upload the modified ODS file.

4. Review Upload Status and Errors:

Monitor the upload status.
Access the "Review Errors" (or equivalent) section to examine the generated error messages.


Observed Errors:

Duplicate Item/Store Missing Error: Two error messages are generated for the invalid item/store combination (from step 2), both indicating the item is missing in the store, but presented with slightly different wording. These errors are displayed as lines 1 and 2 in the Review Errors.

Duplicate Item/Warehouse Missing Error: Two error messages are generated for the invalid item/warehouse combination (if applicable based on data input), both indicating the item is missing in the warehouse, but presented with slightly different wording. These errors are displayed as lines 5 and 6 in the Review Errors.

Incorrect "Item Not Valid for Supplier" Error: An erroneous "Item is not valid for this supplier" error message is generated (displayed as line 4 in the Review Errors), even though no supplier information was included in the induction template. This error is irrelevant in the context of item/location validation.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.