In one of the earlier posts Direct Database Query, we saw how to use the Direct Database Query feature of OTBI analytics. This feature has been removed from 19A, so if you have upgraded or planning to upgrade to 19A, remember that the reports created using this feature will not be supported post upgrade.
Oracle has suggested moving these analytics to subject area based analytics. I do not know the exact reason for removing this useful feature. This was most widely used when we need to get the complete output of a query without having to create data model and BI Report.
Oracle has provided us with a 12 month temporary window to have this feature post upgrade to 19A.
Steps for Temporary Fix:
Future Product Direction
Direct database query is not a supported OTBI feature for building reports. Customers are encouraged to use BI Answers to create interactive analyses, use BI Publisher for fixed-format reports and use BI Cloud Connector (BICC) for data extraction. If customers have created OTBI reports with Direct Database Query option, Oracle development strongly recommends migrating those reports to use OTBI subject areas as Direct Database Query will be deprecated in OTBI in 12 months.
This feature is no more valid now. Keeping it on website for tracking that we had such feature in the past.
If you have any questions, please feel free to reach out to me by posting in comments section.
If you are interested in learning Fusion Technical tools go through this post
If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM