What are the recommended steps to access Oracle database tables directly within Oracle BI EE for reporting and analysis?
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
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.
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how theseā¦
Hi,š I have a technical issue that I am struggling to resolve. I created an RTF layout, and the preview works correctly when using the BI Publisher Add-in tool. However, when I upload the layout in eText format, the generated report displays only question marks (???) instead of the expected data. I have not been able toā¦
hi Oracle team, Have a scenario: Country = A, then page 1 should have a notification for that country with no header/footer however page 2 onwards, the existing content with header/footer. but if Country != A then no notification and has to display existing one with the header/footer. Tried option A: Native word optionā¦
Hi Oracle Community, I have a requirement in Oracle Fusion HCM Performance Management and would like to understand the recommended approach for BI Publisher. The business flow is as follows: A Manager logs into Oracle Fusion using their manager account. The manager can see the performance documents of their direct reports.ā¦
I have Windows 64-Bit in my system and I have downloaded Oracle BI Publisher Desktop 64-bit. when trying to install Oracle BI Publisher in my system, I get error like "Set Word2007 flg failed" or "Please uninstall the current version using Add or Remove Program from the control Panel" But there is no program for Oracle BIā¦
The issue is related to theĀ NordPass browser extensionĀ installed via our corporate policy. Issue observed:Ā Users were unable to upload custom BI Publisher templates in Oracle Fusion (BI Publisher / Oracle Analytics) using Microsoft Edge and Google Chrome. The upload dialog remained indefinitely atĀ "Uploading, pleaseā¦
