Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need PVO for fusion GOP tables MSC_HVGOP_DAILY_AVAIL_REPORT and MSC_HVGOP_WEEKLY_ALLOC_REPORT

Needs Votes
11
Views
1
Comments
Sridhar G
Sridhar G Rank 1 - Community Starter

Our current requirement needs to capture the data in these tables and it is not possible to get the entire data using BIP in one go. Also the nature of data load to these tables purges and reloads the entire tables which makes it impossible to get delta only changes. Availability of PVO for these tables would be a must for getting the entire data without partitioning.

1
1 votes

Needs Votes · Last Updated

Comments

  • @ Sridhar: Can you please provide some further details on the requirements? We would like to analyze the use case and the report/dashboard/metric samples to recommend the best approach. Assuming the customer already has FDI SCM Analytics