Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to get the latest BICC PVO Lineage with a Soap or Rest API by Release

Organization Name
The Cleveland Clinic Foundation
Description
For maintainability purposes, we need to get the latest BICC PVO Lineage frequently.
It is difficult to find information related to a BICC PVO in the current excel spreadsheets provide with the lineage as of 21A release, if there is a repository with the latest information of all the PVO’s that can be accessed via API it will be easier to maintain an to identified deprecated attributes.
Use Case and Business Need
PVO changes such as adding columns to an extract or removing deprecated columns from an extract is proving to be challenging as not always these changes are documented in the corresponding lineage document.
We need to compare the changes of columns on the Lineage for all approximately 125 PVOs being used to extract data from ERP Cloud when there are changes.
More details
The PVOs are segregated in different spreadsheets and sometimes is not clear which spreadsheet will contain the lineage for a specific PVO, especially when the PVOs are across pillars.
Original Idea Number: 9e283806c7
Comments
-
This is a need of our group too.
0 -
Lineage document is out-of-date.
Metadata information is incorrect.
Names are different in different areas making it difficult to line up date from OTBI, extracts, queries, API's, etc...0