When the Financial Management Domain is used to create an Adhoc report, if the SQL query that gets formed (due to the columns that get selected), contains both dwh_fin_plan_virtual_v and dwh_fin_plan_virtual_sum_v DWH views in it, then it is noticed that the query execution is slower in Oracle 19c than in Oracle 12c. An additional constraint to observe this issue is that the number of records returned by the query is at least greater than 1000.
Database: Oracle 19c
There have been no changes in the views mentioned above. The DB has been noted to behave differently in how the query is executed by it.
Following approaches can be taken: