How to create new Load Plan in ODI and how to schedule it to cater to various load activities to automate the process.
Category: Scheduling
Report Job Parameters Query in Oracle Fusion
Once you have gone live in fusion, you are bound to have many reports scheduled and there will be a day when the most often run report will do something funky and you would like to run a query to fetch you all the report job parameters. this query will serve the purpose: Query to… Continue reading Report Job Parameters Query in Oracle Fusion
Job details Query in Oracle Fusion
Query to find the details of Fusion Job Reports such as start date, end date, status, report path ( where report resides).
Report Scheduling – For Specific timings over the days
Report scheduling to run the only during business hours i.e. report must trigger every 10 minutes between 7:30 AM and 5:30 PM on weekdays. Now if you have scheduled a report in Oracle Fusion, you would know that one can very easily schedule the report to run periodically and you can define for how many… Continue reading Report Scheduling – For Specific timings over the days