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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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