In Oracle Fusion Applications, report scheduling plays a crucial role in automating business processes such as invoice generation, reconciliation, and operational reporting. However, not every scheduled job needs to run every time especially when there’s no relevant data.
This is where skip conditions come into play.
Skip conditions allow you to control whether a scheduled report or job should execute based on predefined logic.
Instead of wasting system resources, unnecessary runs are avoided, making scheduling smarter and more efficient.
Okay Let's drive-in into how we can save system resources.
1. Create your query in the Data Model.
2.Write Event Trigger
Simple choose Event Trigger in the same data model. Select Event Type as Scheduled.
FYR
Now write logic for when it should be skip. In my case when Data model no return any data, then won't triggers to clients.
SQL Query Reference when no data returns from data model.
SELECT DISTINCT 'true'
FROM DUAL
WHERE EXISTS (
SELECT 1
FROM abc//here your data model conditional logic
)
3.Build Report with your template & schedule it
Time to schedule the report as below. You can add your parameters also in your data model.
- choose your delivery channel. -In the Schedule Tab, select your frequency & Define Schedule Trigger(It's important here)
- Here pick your event trigger which has written early in the data model . FYR
Conclsuion
By adopting skip conditions, organizations can:
- Reduce system overhead
- Improve report relevance
- Enhance overall scheduling efficiency