My Oracle Support Banner

BI Report Schedule Failing When Selecting Multiple Parameters For The Trigger (Doc ID 2758303.1)

Last updated on APRIL 02, 2021

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

Have a BI report which has a schedule trigger defined works fine when we run the report on demand.

When scheduling the report it runs ok when selecting only one parameter for the Trigger.
However, When we scheduling the report and selecting more than one parameter for the Trigger, the job status shows as Skipped and the job shows:

The trigger SQL failed to execute
[INSTANCE_ID=bip.bi_serverHA] [JOB_ID=204202]
Failed to execute event trigger
oracle.xdo.servlet.scheduler.ProcessingException: Failed to execute event trigger
at oracle.xdo.servlet.ReportContext.executeEventTrigger(ReportContext.java:651)
at oracle.xdo.enterpriseScheduler.SchedulerJob.execute(SchedulerJob.java:287)
at oracle.xdo.service.scheduling.impl.ess.EssJob.execute(EssJob.java:105)
at oracle.as.scheduler.rp.JavaSysExecWrapper$1.run(JavaSysExecWrapper.java:424)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.internal.jaas.AccActionExecutor.execute

Tried enabling Diagnostics, but no Diagnostic log was generated.

Changes

 Schedule the report and select multiple parameters for the Event Trigger.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.