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

Last updated on JANUARY 30, 2023

Applies to:

Symptoms

Requirement:

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

Table 2:LOC_LIST_HEAD

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

Cause

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