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 to [Release 11g]
Information in this document applies to any platform.
Checked for relevance 13-Oct-2014


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?


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