@Prasad_G , Welcome to the Oracle Analytics Community! I am not sure if above tables will be able to get you the Content ID. Please explore ess_request_history and ess_request_property and see if it works for you.

@SJ77225 , Welcome to the Oracle Analytics Community! As suggested above @Brendan T , please give it a try. Alternatively, see if following approach will be better for long term solution and avoid CASE statements… Create a small Goals table (Legal Employer, Month, Goal) Load via data augmentation Join to Time + Legal…

@s.datta , thanks for providing the update. This approach was provided by Oracle Product SME so next step would be to log a SR with Oracle Support.

@Jae.L , in case, if this column is display only, then try to make it NULL safe, essentially if it is NULL then ' ' else use CAST function. Hope it helps!

Hi @User_7AIAG , there are a few different ways to create an FDI instance. It depends on what approach was used for a particular implementation. Oracle recommends integrating FDI directly with the Fusion Applications instance, as it results in a much smoother and more tightly connected setup. With this approach, the FDI…

Hi @User_7AIAG, yes it will have additional cost but if you talk to Sales, it will give you a better estimate, based on the different options or relationship with Oracle. Hope it helps!

Thanks for the update!

Also, as a best practice, after patching, validate credentials/connectivity. Hope it helps!

@User_7AIAG , Welcome to the Oracle Analytics Community! Before scheduled patching to your Fusion ERP/SCM environment, plan and communicate the maintenance schedule with the team that owns your FDI pipelines. Notify analytics users and pipeline owners of planned maintenance windows. Schedule full or incremental loads to…

Thanks, @Jamie Anderson-Oracle, appreciate it!

@Paul Therrien , Welcome to the Oracle Analytics Community! Can you confirm if it is a date aware measure, it should directly come from the fact and not be calculated / derived KPI. Alternatively, see if FILTER can be used instead of TODATE FILTER( "Gross Sales", "Calendar Date" >= TIMESTAMPADD(SQL_TSI_YEAR, 0,…

@Kamalakannan Natarajan , Welcome to the Oracle Analytics Community! Thanks for your question. A. Enabling a Report for Bursting Prerequisite: A report defined in BI Publisher. The report data must contain an element by which the report will be split and an element by which the report will be delivered. Enabling a report…

@philipgodfrey , thanks for sharing, it is very useful. Appreciate it.

@Raluca Balan-Oracle , Welcome to the Oracle Analytics Community! We might need to explore using LEFT, RIGHT, POSITION, on very high level see if something below works LEFT( RIGHT( "Location", LENGTH("Location") - POSITION('-' IN "Location") - 1 ), POSITION( '-' IN RIGHT( "Location", LENGTH("Location") - POSITION('-' IN…

Thanks for the update! If issue is still not resolved, please contact Oracle Support by logging a Service Request.

@User_N6HIU , did it work or still having the issue? Thanks

@User_6WR9W , Welcome to the Oracle Analytics Community! While there is not REST API support yet, have you considered extracting data from source instead of OAC. It might be faster provided you can come up with the query. Hope it helps!

@Raju Punith-60121 , Welcome to the Oracle Analytics Community! Thank for your question. I am not sure if it is possible programmatically, but we can always enable or disable Query Caching. In Oracle Analytics Cloud, the query cache is enabled by default. You can enable or disable query caching on the Advanced System…

As mentioned above, OAC provides REST APIs that get catalog items and their Access Control List (ACL). You can format the data returned by these REST APIs and use the data to build a report or visualization in OAC. This blog describes how to get catalog items and permissions based on the item type and create a report in…

As per latest oracle doc, Interface B (with “Notification”) is more consistent with the latest standard UI as described in the January 2026 documentation.