Oracle Transactional Business Intelligence
Corresponding PVO in BICC through which we can load the fusion tables
Summary:
Hi Team,
We are trying to load the data from BICC PVO to below Fusion tables related to Purchase Orders using the Business Intelligence Cloud Connector. But we are not able to find the relevant PVO's created for these Fusion tables to load the data.
1. PO_DISTRIBUTIONS_ARCHIVE_ALL
2. PO_LINES_ARCHIVE_ALL
3. PO_LINE_LOCATIONS_ARCHIVE_ALL
4. PO_ONLINE_REPORT_TEXT
For example : for loading the Fusion table PO_LINE_TYPES_B table(Purchase Order Line Types) we have the BICC PVO : FscmTopModelAM.PrcPoPublicViewAM.PurchasingLineTypeBP
Similarly we are looking for the PVO's mapping to above fusion tables.
Kindly help us in providing the PVO name that will cater to these fusion tables. Also the PVO must be having all the columns present in Fusion table and the count of records in PVO should match with the count of rows for the above fusion tables.
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi Anshul,
I do not believe any of these tables are exposed through a PVO. You may have to go through the BIP report route(invoked from ODI) if you require data from these tables.
Certain attributes of the table PO_HEADERS_ARCHIVE_ALL is exposed through the VO FscmTopModelAM.PrcPoPublicViewAM.PurchasingDocumentVersionPVO. There is no mention of the other tables in the OTBI lineage sheet. Also, checked on BICCC, there are some PO History related PVO's, but, that exposes Action History information, not, archived PO data.
-
Please review the below data lineage documentation, if they are not available here then in the current release they are not available
-
None of these tables are present in the latest OTBI lineage sheet.
-
If they are not available in the lineage sheet then they are not available.
Alternate solution is to create the BIP report
