Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 230 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 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.
Best Answer
-
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.
0
Answers
-
Please refer
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!
0 -
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
0 -
Sure, thank you
1 -
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.
0