Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Schedule Event Trigger in Data Model Errors immediately when Scheduled
Summary:
I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data model and I use the schedule trigger, the report fails immediately with the following error.
::JOB_WAIT_TIME_SECONDS{1.4}::JOB_EXECUTION_TIME_SECONDS{0}::JOB_PRIORITY_COLON_NORMAL::::FAILED_TO_EXECUTE_TRIGGER::[INSTANCE_ID=bip.bi_serverHA] [JOB_ID=809649]::
Failed to execute event trigger::
Content (required):
I have added the SQL used in the Event Trigger below, which runs fine if you use it as the SQL for a Data Model. I am not sure why and there is no real detail to the error and running with diagnostic returns no diagnostic information on the error.
Tagged:
0