Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

Categories

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
56
Views
2
Comments
Naveen_NJ
Naveen_NJ Rank 1 - Community Starter
edited Aug 20, 2025 1:29PM in Oracle Analytics Publisher Forum
image.png

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

Tagged:

Best Answers

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics & AI 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 & AI Strategist
    Answer ✓
    https://community.oracle.com/products/oracleanalytics/discussion/26810/how-i-access-the-oracle-tables-in-oracle-bi-ee-publisher

    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.