How to create a direct database query with OTBI?

Within Oracle Fusion OTBI go to New > Analysis and click on Create Direct Database Query:

image

specify the connection Pool information within the editor:

image

The following connection pools can be entered:

  • HCM – ”HCM_OLTP”.”Connection Pool”
  • CRM – “CRM_OLTP”.”Connection Pool”
  • FIN and PROC – “FSCM_OLTP”.”Connection Pool”

Please note: when copying&pasting the connection pool names from WordPress, there may be an issue with the double quotes(“) and you may need to re-type the double quotes (“) within OTBI.

After that, a query may be entered for direct database execution on the Oracle Fusion Cloud (bundled) Database (identified by the Connection pool supplied before):

image

For a listing of all Physical Tables please refer to (only available for HCM): https://cloudcustomerconnect.oracle.com/posts/ac54c31fcf

This contains a Excel mapping with the Physical OTBI Tables:

image

 

For a full support note, please refer to:

For a similar approach using BI Publisher please check:

To check the general TechNote for OTBI and Fusion HCM, please refer to: