Manage Load Plans Toolbar Options

The Manage Load Plan page contains the following icons and menu options.

Icon or Menu Option	Description
Actions menu: Execute Reset Data Warehouse Scenario	This command resets the warehouse by deleting all warehouse load related entries from the `W_ETL_LOAD_DATES` table (SDE, SIL,PLP). Subsequent run of the load plan will cause the relevant warehouse table(s) to be truncated and warehouse mappings will run as full load. It does not reset the SDS and the SDS related entries in `W_ETL_LOAD_DATES` table will remain as is.
Actions menu: Reset SDS Schema	This command resets data as follows: For Cloud Replicator sources (Taleo/Rightnow), it updates the Last Extract Date for the replicator sources in the replicator schema. For Fusion data sources, it removes all Fusion SDS FTS tasks entries made by the Fusion cloud adaptor load plan run from the warehouse history tracking table (W_ETL_LOAD_TABLES). This ensures that all SDS load maps run in FULL load mode in the next run of the Fusion Cloud adaptor load plan. For External data sources, it drops all the tables in the SDS Schema.
	Duplicate Enables you to define a new load plan with the same fact groups as the selected load plan definition but with a different name and identifier.
	Generate Starts the process to build the load plan in the Oracle Data Integrator (ODI) repository. A load plan must build successfully before it can be executed.
	Show Generation Status Details Shows the generation status for each step included in the load plan.
	Reset Generation Status Resets the generation status to Not Generated.
	Show Load Plan Details Launches the ODI Console, which enables you to view detailed information about the selected load plan.
	Execute Executes a load plan that has been successfully generated.
	Show Execution Status Details Displays the execution details of a load plan that has been executed.
	Generation Status: Not Generated Indicates the load plan has not been generated, or was modified in Configuration Manager without being regenerated.
	Generation Status: In Progress Indicates the load plan is in the process of being generated.
	Generation and Execution Status: Succeeded In the Generation Status column, indicates the load plan was successfully generated. In the Execution Status column, indicates the load plan completed its run successfully.
	Generation and Execution Status: Failed In the Generation Status column, indicates the load plan generation failed. In the Execution Status column, indicates the load plan run failed due to an error.
	Execution Status: Not Executed Indicates the load plan has not been executed.
	Execution Status: Running Indicates the load plan is currently running.