Hi @Alejandro Casillas , Welcome to Oracle Analytics community. From your post, this looks like more of a question as compared on an idea. So, please submit it under correct category. And to answer your question, this is not supported in OTBI currently. You need to make use of BIP. Please let us know how we can add the…

No, you can directly connect to Fusion BI catalog and write queries in the tool itself: SQLConnect - An Oracle Cloud Tool by SplashBI! Thanks.

I dont have the exhaustive list. You can google it. I know people using DataFusing/Sublime/SplashBI/RiteSoftware etc. https://forums.oracle.com/ords/apexds/post/how-to-run-sql-queries-in-oracle-fusion-cloud-8339 Thanks.

There are external editors/tools available which allows you to connect to your Fusion environment. But yes, if Oracle can provide something, that will be great.

Hi , Welcome to Oracle Analytics and AI community. This category is specific to Oracle analytics related queries. But it seems your query is more for Oracle JDE? If yes, then this is not the right forum. Please post your query on below forum for better traction and response: JDEdwards EnterpriseOne (MOSC) — oracle-mosc…

HI @MRAJEEV , Welcome to Oracle Analytics and AI community. Can you please confirm how are you writing the files to CS? Are you using bursting? Or where you want to use this token based approach? Thanks.

Also, make sure that the refresh manager hierarchy process is scheduled. Details on below thread: Populating the manager hierarchies for OTBI reporting — Cloud Customer Connect Thanks.

Welcome to Oracle Analytics and AI community. Can you please check below post from @Raghavendra Raghunath-Oracle and see if it helps? Worker - Matrix Manager hierarchy — Cloud Customer Connect Thanks.

Welcome to Oracle Analytics and AI community, Nick. The information you are looking for is not available currently: Missing PII Candidate Report (OTBI) — Cloud Customer Connect Candidate date of birth and gender are not pulled from OTBI report — Cloud Customer Connect Thanks.

Welcome to Oracle Analytics and AI community. Can you try to execute one of the sample from below post and let us know? Assignment Approvals — Cloud Customer Connect Thanks.

Welcome to Oracle analytics and AI community. For Fusion SaaS specific modules, Cloud Customer connect is best community to get a better traction and report. I will suggest you to post your query on below community category: Warehouse Management — Cloud Customer Connect Thanks.

Upvoted.

Love it.

Hi Bhaskar, I don't think it provides the ESS Job Display name as this is not stored. Can you recheck? Thanks.

Great resource.

Hi Joon, A new role should be created and assigned to all the users who will have access to this report. This role allows the access to view documents on content server. Check my blog on same: Security - Role to view document of record attachments on UCM - MSPL Thanks.

Upvoted. If REST APIs can be exposed for deployment, it will be great!!!

This is not supported yet: https://community.oracle.com/customerconnect/discussion/582140/deliver-otbi-report-to-sftp Thanks.

Hi, Can anyone please guide me on how to track the defects and their current status? Thanks.

Hi, Not the complete solution but you may find below useful: Adjust Auto numbering in RTF Template Output — Cloud Customer Connect BI Publisher - RTF Template - Numbered List in Offer Letter — Cloud Customer Connect Same Data Model - Different RTF Templates - How can a template be picked dynamically based on a valu —…