BI Applications 11.1.1.7.1+ How Can We Ensure the Load Plan Does Not Get Started Again Until the Last Run has Completed Successfully

(Doc ID 1935530.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

You have a nightly scheduled load for Production. The load usually completes successfully in the right amount of time, however occasionally there have been issues that have caused it to continue running, sometimes forever. In these cases, even though the load plan is still running, when the scheduled time the next day comes the load plan will be executed again, overlapping with the last run, and ruining the integrity of the data warehouse.

This would also be an issue when the execution fails, say on the weekend. If the Friday night load failed, the Saturday and Sunday would still run, starting from the beginning, spoiling the Data Warehouse.

How can we ensure the load plan does not get started again until the last run has completed successfully?
 

Solution

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 hundreds of Community platforms