Ability to get the latest BICC PVO Lineage with a Soap or Rest API by Release

user716429-Oracle

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

John Dzurik

This is a need of our group too.

David Langford

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...