Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need Supplier Products & Services Category Hierarchy levels in FDI

Question
12
Views
0
Comments

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.

Tagged: