How I access the oracle tables in Oracle BI EE Publisher

Question

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

Gaurav Bharadwaj-Oracle · Accepted 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 · Accepted 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.