My Oracle Support Banner

System Allows to Assign an Incorrect Combination of Supplier/Main Country (Doc ID 2853210.1)

Last updated on MARCH 03, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

Change item/location attributes screen allows to assign an incorrect combination of supplier/main country, and this affects the ITEM_LOC table.

Steps To Recreate:

1.2 Suppliers with 2 Diff Origin Country

ITEM SUPP COUNTRY PRIMARY_SUPP PRIMARY_COUNTRY

A 1200 CN Y Y

A 2400 MX N Y

2. ITEM_LOC has Primary Supplier 1200 and Primary Country CN as well.

3. Perform a Mass Change. First Enter 2400 as Supplier and Select MX for country. Then change the supplier back to 1200. Click Save. “Popup message appears. Click Yes”.

4.The Item Location Screen errors out.

5. Check DB. Change is saved in ITEM_LOC.

ITEM LOC PRIMARY SUPP PRIMARY COUNTRY

A 1521 1200 MX

A 1121 1200 MX

6. This should not be allowed, since there is no 1200/MX record in ITEM_SUPP_COUNTRY table.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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