Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Hi, You can fetch the details from this table - fusion_ora_ess.request_history using Adhocschedule column. Example query: Select substr(substr(replace(erh.adhocschedule,chr(0)),3), (instr(substr(replace(erh.adhocschedule,chr(0)),3),'FREQ=')+5),…

in Query or report on ESS request scheduling information Comment by Subhojit31 Jul 23, 2024 2:24PM
Hi, You can fetch the details from this table - fusion_ora_ess.request_history using Adhocschedule column. Example query: Select substr(substr(replace(erh.adhocschedule,chr(0)),3), (instr(substr(replace(erh.adhocschedule,chr(0)),3),'FREQ=')+5),…

in Query or report on ESS request scheduling information Comment by Subhojit31 Jul 23, 2024 2:24PM
Hi, You can get the schedule information from fusion_ora_ess.request_history table using the adhocschedule column. Suppose, frequency and interval can be fetched using the below query: Select substr(substr(replace(erh.adhocschedule,chr(0)),3), (instr(substr(replace(erh.adhocschedule,chr(0)),3),'FREQ=')+5),…

in Query or report on ESS request scheduling information Comment by Subhojit31 Jul 23, 2024 2:24PM