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 JUNE 14, 2024

Applies to:

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

Goal

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?

Solution

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
Goal
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.