Need Supplier Products & Services Category Hierarchy levels in FDI

User_VRYO3

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.

RVohra

You might need to log a SR for Oracle support to review it. Oracle Support can review and suggest if it needs an idea in the Idea Lab.

RVohra

Please refer

R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet — Cloud Customer Connect

There is Excel Spreadsheet recently uploaded


Rel13_25.x_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx.zipUploaded Sep 25, 202544.5 MB

Hope it helps!

User_VRYO3

Thanks for your response. I have verified in this data lineage previously; however, I am unable to find any PVO for the hierarchy tree - POR_BROWSE_TREES / POR_BROWSE_NORMALIZED_TREES

User_VRYO3

Sure, thank you

RVohra

As per Analytics community guidelines, please accept the answer so that this post can be considered Closed and future community members can refer it accordingly.