My Oracle Support Banner

Reason To Population Of Item_supp_country_loc And V_item_supp_country_loc (Doc ID 2920816.1)

Last updated on JANUARY 13, 2023

Applies to:

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


Understanding the functionality behind the population of v_item_supp_country_loc and item_supp_country_loc

Most of the items in the system at the moment have been loaded as part of conversions. Based on that, we need some help in understanding the following though -

1. What is the behavior of v_item_supp_country_loc table in comparison to item_supp_country_loc table?
2. What are the parameters followed for these two tables to get populated for items brought on as part of conversions?
3. What would be the impact of items being present in either or both of these tables?
4. What would be the impact of items not being present in either or both of these tables?


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.