How to create a direct database query with OTBI?

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


specify the connection Pool information within the editor:


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):


For a listing of all Physical Tables please refer to (only available for HCM):

This contains a Excel mapping with the Physical OTBI Tables:



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:

1 thought on “How to create a direct database query with OTBI?

  1. When copying & pasting the Connection Pool from WordPress to BICS, the double quotes might not be correct. You may need to replace with a manual entering of the double quote ” from the keyboard..


Leave a Reply to balatino Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.