Oracle Provides PVOs for Views?

Unnikrishnan Raju

Bhaskar Konar

Unnikrishnan Raju

Feb 19, 2025

Hi Bhaskar,

Thanks for the notes, could you please help me to access the above links. Am getting access denied messages while opening.

Hi @User_E4X3H,

Sure.

Please find attached latest files. Give me a shout if you need for previous versions.

Rel13_25.x_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx.zip

Uploaded Feb 19, 202510.99 MB

Rel13_25.x_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx.zip

Uploaded Feb 19, 20252.25 MB

Hope this help.

Cheers,

Bhaskar Konar

Oracle Provides PVOs for Views?

Unnikrishnan Raju

Feb 19, 2025

---

View Post

Hi @User_E4X3H,

Can you please provide some more details regarding your requirement & query so that fellow community members can help you.

Cheers,

Unnikrishnan Raju

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:

1. VBC (View-Based View Objects) – These are View Objects (VOs) based on SQL views, which allow fetching data from database views.
2. Standard BI View Objects – Used for OTBI and BI Publisher reporting.
3. Public View Objects (PVOs) – These are used for exposing data to external integrations, but they are not available for all Oracle Fusion standard views.

Bhaskar Konar

Unnikrishnan Raju

Feb 19, 2025

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:

1. VBC (View-Based View Objects) – These are View Objects (VOs) based on SQL views, which allow fetching data from database views.
2. Standard BI View Objects – Used for OTBI and BI Publisher reporting.
3. Public View Objects (PVOs) – These are used for exposing data to external integrations, but they are not available for all Oracle Fusion standard views.

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.

R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet

R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet

Hope this help.

Cheers,

Unnikrishnan Raju

Hi Bhaskar,

Thanks for the notes, could you please help me to access the above links. Am getting access denied messages while opening.

Unnikrishnan Raju

Thanks, Bhaskar. The files you provided were helpful, and I was able to figure out the problem.

Bhaskar Konar

Unnikrishnan Raju

Feb 19, 2025

Thanks, Bhaskar. The files you provided were helpful, and I was able to figure out the problem.

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,