Database Views

Introduced Database Views, which enables users to create database views for use in application processing and reports. Users can select a primary table by classification, add secondary tables including self-joins, select or derive columns, specify join conditions, and register the view for classification-based use in Allocation. The feature provides view summary, search, export, pinning, and lifecycle actionsIntroduced Database Views, which enables users to create database views for use in application processing and reports. Users can select a primary table by classification, add secondary tables including self-joins, select or derive columns, specify join conditions, and register the view for classification-based use in Allocation. The feature provides view summary, search, export, pinning, and lifecycle actions

Provides a governed alternative to physical-table selection, allowing applications to consume purpose-built views with the required joins and columns.

Steps to enable and configure

NA

Key resources

https://docs.oracle.com/en/industries/financial-services/ofs-analytical-applications/profitability-balance-sheet-base/index.html