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
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle Provides PVOs for Views?
Best Answer
-
Hi @User_E4X3H,
Sure.
Please find attached latest files. Give me a shout if you need for previous versions.
Hope this help.
Cheers,
1
Answers
-
Hi @User_E4X3H,
Can you please provide some more details regarding your requirement & query so that fellow community members can help you.
Cheers,
0 -
In Oracle Fusion Applications, PVOs (Persisted View Objects) are typically used to store data persistently for better performance and reporting purposes. However, Oracle does not directly provide PVOs for standard views. Instead, it provides:
- VBC (View-Based View Objects) – These are View Objects (VOs) based on SQL views, which allow fetching data from database views.
- Standard BI View Objects – Used for OTBI and BI Publisher reporting.
- Public View Objects (PVOs) – These are used for exposing data to external integrations, but they are not available for all Oracle Fusion standard views.
1 -
Hi @User_E4X3H,
Thanks for the details. Yes, your understanding is correct.
If you are looking for all the available objects, lineage etc. please take a look into the following posts.
Hope this help.
Cheers,
0 -
Hi Bhaskar,
Thanks for the notes, could you please help me to access the above links. Am getting access denied messages while opening.0 -
Thanks, Bhaskar. The files you provided were helpful, and I was able to figure out the problem.
1 -
Hi @User_E4X3H,
Glad to hear that.
Can you please accept the answers that helped you to resolve your issue? It'll be helpful for fellow community members in future.
Thank you!
Cheers,
0