Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 221 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Need Supplier Products & Services Category Hierarchy levels in FDI

There is a BIP report built on the "Supplier Products and Services Category Hierarchy". The hierarchy data in BIP is sourced from the POR_BROWSE_CATEGORIES_VL, POZ_SUP_PRODUCTS_SERVICES, and POR_BROWSE_TREES tables.
Separately, a FDI report is built on "Supplier Category Hierarchy Levels" columns from the Procurement and Spend subject area. Our business team is trying to reconcile these two reports.
To align with the business requirement (Supplier Products & Services), we are looking to extend FDI so that it presents the hierarchy in the same way as the BIP report. Specifically, this requires identifying the relevant View Objects (VOs) for the following Oracle Fusion tables so they can be ingested into ADW via Data Augmentation:
POZ_SUP_PRODUCTS_SERVICES – Supplier-to-leaf category assignments
POR_BROWSE_CATEGORIES_VL – Category names
POR_BROWSE_TREES / POR_BROWSE_NORMALIZED_TREES – Category hierarchy
Any support/guidance on the process of bringing the fusion Supplier Products & Services hierarchies into FDI - such as confirming the appropriate PVOs, staging this data in FDI, building the hierarchies, applying SME extensions, and updating the FDI report would be greatly appreciated.