Invalid Error Message Captured In MC_REJECTIONS Table. (Doc ID 3009637.1)

Last updated on MARCH 15, 2024

Applies to:

Symptoms

On : NA version, Merch - Inventory Tracking

When attempting to update replenishment attributes for a item-loc,
the following error occurs.

ERROR
-----------------------
Can not associate Supplier %s1 and Location 35 as they belong to different Org Units.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Choose item-loc whose STOCK_CAT is W in REPL_ITEM_LOC
2. Create a replenishment attribute update for this Item-Loc. Make sure that STOCK_CAT now selected is D [Direct to Store] [Supplier which is selected and Location all lies under same Org Unit]
3. wait for the nightly batch. After that see records are rejected in MC_REJECTION with the error "Can not associate Supplier %s1 and Location 35 as they belong to different Org Units."
4. This error is misleading as both the supplier and location fall under same Org ID.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are misled though the configurations are correct.

Cause

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