My Oracle Support Banner

Load Of Items On W_PRODUCT_D Missing? (Doc ID 3072996.1)

Last updated on FEBRUARY 24, 2025

Applies to:

Oracle Retail Insights Cloud Service Suite - Version 24.1 and later
Information in this document applies to any platform.

Goal

On : 24.1 version, Batch Modules

We need to better understand how the items are loaded from the marketing hierarchy to the W_PRODUCT_D table.
We have over 700 items in the tables and only 30 were passed to the final table.?

There are few items with a status other than Approved, and the only relationship we discovered between the 30 items that reached the final tables was:

Item with type MANL or VPLU orderable_ind = 'Y' and inventory_ind = 'Y'
However, we also have other items in the same scenario in item_master that were not loaded in this initial seed ?
 

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


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