My Oracle Support Banner

Fusion Applications BI Publisher : FAILED_TO_EXECUTE_TRIGGER error when a Schedule Trigger is added to a BI Publisher report (Doc ID 1982007.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Fusion Workforce Directory Management Cloud Service - Version and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Oracle Fusion Application Toolkit - Version and later
Information in this document applies to any platform.


On : version, Technology Management - Reports/Analytics

When attempting to use a Schedule Trigger to manage report execution during scheduling
the following error occurs.


The issue can be reproduced at will with the following steps:
1. create a simple data model which includes a schedule trigger using the following SQL (SELECT '1' from dual). Base the schedule trigger and data model on ApplicationDB_HCM datasource
2. create a report against the simple data model
3. create a scheduled job against the simple report and ensure that it uses the schedule trigger
4. submit the scheduled job
5. scheduled job will fail with the above error

The issue has the following business impact:
Due to this issue, users cannot manage report executions which results in reports being generated with no data found




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

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

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