Hi Ultika, As per my experience, BIP is a better choice for such historical scenarios. Let me know if you need any help with BIP>. Thanks.

Please confirm if there were some performance intensive programs were running during the last execution. Monitor for few days, if you encounter an issue again, it would be better towards working on the perf enhancement or make sure that no resource intensive program is running in parallel. Thanks.

Hi Gavi, Can you give a try using schedule option and select your parameter values while scheduling? Thanks.

Hi Mark, Can you please try below? $if{ (:p_agg_pic_acc == Yes) }$ $if{ (:p_agg_zero_supp == Yes) }$ SQL Statement $endif$ $else{ SQL Statement }$ $endif$ Thanks.

Welcome to Oracle Analytics Community. As per my knowledge, this is not supported for most of the transactions. Normally we schedule the extracts to sync the DWH. Thanks.

Hi, Can you schedule the report and check approx how much time it is taking to run? The error while editing, can you try it in incognito mode? I have seen this happening where there was a lot of code in one of MY BIP reports. Thanks.

From there, it is not possible currently. Thanks.

Hi @User_VOGVU Welcome to Oracle Analytics and AI community. @Raghavendra Raghunath-Oracle , can you please help here? Thanks, Mandeep.

Hi Abdul, Welcome to Oracle Analytics community. You can try using RANK function: Can someone help me how to apply Pivot in my OTBI Analysis? — Cloud Customer Connect Thanks.

Hi Rosita, If your filters are at query level, then there is no restriction. Thanks.

Hi Mohammad, Please check the query on below thread: https://fusionhcmconsulting.com/2025/01/bip-report-to-extract-bip-scheduled-jobs/ In this query, you can pull data from ess_request_property where name = 'CONTROL_XML'. Value for this name will give you data that you are looking for. Thanks.

Excellent, thanks for sharing !!!

This is awesome. A great visualization.

This is wonderful. Quite innovative.

Congratulations all !!!

Thanks for the reference but it seems the issue is still there in 26A while the knowledge base article talks about 22a/22b only. Thanks.

Thanks for the update, Roger.

There is no specific code for a scheduled trigger. It will be similar to your main query but will return true/false to indicate if the data will be returned by main query or not. Check below links for working examples: Skip Schedule using Schedule Triggers in BI Publisher Creating Schedule Triggers Thanks.

Hi, Welcome to Oracle Analytics and AI community. As your query is more specific to Fusion SaaS, I would suggest you to post your query on clous customer connect (a sister community) for better traction and response: Reporting and Analytics for ERP — Cloud Customer Connect Thanks.

Hi, Can you check if there is no change in the setup of GL KFF in your production system? Compare the setup of these segments in Test and Prod and then check? Thanks.