Menu

Post image 1
Post image 2
Post image 3
Post image 4
Post image 5
Post image 6
1 / 6
0

Oracle Fusion Report Scheduling with Skip Conditions

DEV Community: sql·Naveen·2 days ago
#KMtASTeq
#dev#model#report#skip#event#photo
Reading 0:00
15s threshold

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.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More