Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How I access the oracle tables in Oracle BI EE Publisher

Accepted answer
33
Views
2
Comments
Naveen_NJ
Naveen_NJ Rank 1 - Community Starter
edited Aug 20, 2025 1:29PM in Oracle Analytics Publisher
image.png

What are the recommended steps to access Oracle database tables directly within Oracle BI EE for reporting and analysis?

Best Answers

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead
    Answer ✓

    Hi @Naveen_NJ ,
    You are using the wrong data source, please use either the Fusion HCM/Fusion FSCM OR Fusion CRM depending on which module the tables belong to.

    The Table you are trying to access seems to be from FSCM application, please use the Fusion FSCM Data Source for this.

    https://docs.oracle.com/en/cloud/saas/financials/25a/oedmf/arcmgtcasefolders-27831.html

    If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

    Regards,
    Gaurav

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist
    Answer ✓

    You can't access the fusion direct tables using Oracle BI EE data source. You can use this data source to run a logical SQL generated from an OTBI analysis. If you want to run a direct query on a table, then use the appropriate data source. For HCM, use Fusion HCM. Same for other modules.

    Thanks.