Product Hierarchy is not populated in OBIA 7.9.6 with EBS R12.1.1 as the source (Doc ID 1110185.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Data Warehouse Business Adapter for Oracle - Version 7.9.6 [1340] and later
Business Intelligence Applications Consumer - Version 11.1.1.7.1 to 11.1.1.7.1 [Release 11g]
Information in this document applies to any platform.
Checked for relevance 13-Oct-2014

Goal

1) In order to populate Product Hierarchies (W_PROD_CAT_DH), Do we need to go back to the source system (EBS R12.1.1) and populate this table MTL_CATEGORY_SET_VALID_CATS?

2) Is this table (MTL_CATEGORY_SET_VALID_CATS) populated by checking the box "Enforce List of Valid Categories" when creating Category Sets?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms