Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
No output generated in bursting but status is Success in BI Publisher
Hello
I created a report with bursting and it turns out that when creating a report, I don't always have data, and logically an empty report is created, but BI bursting does not create an empty file and simply says "No output avaible". How can this problem be solved, I need even if there is no data, then an empty letter or a message that there is no data was sent. It is sent via email. Thanks for the help!
Best Answer
-
Hi @User_M9N9X ,
You can also try adding a schedule trigger with your query. If the query in the trigger returns a record, it will make it true for execution and else the bursting job would be skipped.
Reference Link: https://docs.oracle.com/cd/E29542_01/bi.1111/e22258/add_event_trig.htm#BIPDM330
Thanks,
Abhilash
1
Answers
-
Hi @User_M9N9X
Yes this is an default product behavior. Better to create an dummy record when there was no data as per query To generate an empty report.
Fusion Applications BI Publisher : ESS Job fails when the BI Publisher Bursting sql returns no data. (Doc ID 1925999.1)
Regards,
Arjun
0 -
I'm just starting to work with BI, will it be possible to add a message if there is no data to send "no data"?
0 -
Hi @User_M9N9X ,
I think that option is currently not there in the environment. The trigger works on executing a query based logic.
if data found file would be generated, if not then the run will end in Skipped status. Since that is the case, i think it would not be needing a no data message for the user.
0 -
Good day
I don't have access to My Oracle Support((
0 -
Сan you use a trigger to capture the moment when the script has worked and add something of your own, for example, sending an empty file?
0 -
I have not used it that way. Our requirement was not to mark job as error when there is no data.
0 -
But these Schedule Trigger doesn't work when you have an ESS Job. The report has to be scheduled from BIP only to get the trigger working.
0
