My Oracle Support Banner

Addition Of New Tables In Custom Validation Screen (Doc ID 2924336.1)

Last updated on JANUARY 30, 2023

Applies to:

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



Table 1 :Item_Loc_Supp_Country_DIM

MFCS supports several weight Units of Measure within the item dimensions module. But Business should only be using LBS (Pounds). The other weight UOMs have not been disabled but should never be used.

We tried to create a custom validation rule to restrict user from submitting the item having weight UOM other than LBS(Pounds).While creating we noticed the ITEM_SUPP_COUNTRY_DIM table is not available to choose from list of tables in Custom validation screen


Every DSD Supplier Site should have exactly one  DSD Location List to indicate its territory. This Location List will be used for ranging and status maintenance.

To enable the above the requirement, we require the LOC_LIST_HEAD table to be added in custom validation screen


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

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