Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How I access the oracle tables in Oracle BI EE Publisher

What are the recommended steps to access Oracle database tables directly within Oracle BI EE for reporting and analysis?
Best Answers
-
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.htmlIf 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,
Gaurav0 -
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.
0