This section contains reference information about the Manage Load Plans user interface elements in the Oracle BI Applications Configuration Manager.
This section contains the following topics:
The Manage Load Plan window contains the following icons and menu options.
Icon or Menu Option | Description |
---|---|
Actions Menu: Execute Reset Data Warehouse Scenario |
This command resets the data warehouse by truncating the W_ETL_LOAD_DATES table. This ensures that the subsequent load will truncate all target tables and do a fresh full load. |
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 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 Oracle Data Integrator 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. |
Use the Manage Load Plans main page to view and edit existing load plans and to create new load plan definitions. You can search for an existing load plan by clicking Search above the master list panel. The search input fields are not case sensitive.
The Load Plans list displays the load plans in the Configuration Manager repository. See "Manage Load Plans Toolbar Options" for a description of the toolbar options on this page.
Use this tab to view the fact groups associated with a load plan selected in the Load Plans list. Fact groups displayed may belong to a hierarchy of fact groups. You can expand the fact group node to view the hierarchy. If a fact group is a child of another fact group in a hierarchy, it appears twice in the tree table, since it is associated with both the functional area and the parent fact group.
Use this tab to view and edit the data load parameters associated with a load plan selected in the Load Plans list. The Data Load Parameters list includes both application-specific and global parameters. Application-specific parameters are associated with one or more fact groups included in the load plan definition. Global parameters apply to all applications and can also be associated with specific fact groups.
Key points about the Data Load Parameters tab:
If a listed parameter requires a value but a value has not been assigned, the respective row in the table is tagged with an error icon. Parameters that do not require a value (value can be null) are not tagged even if no value has been assigned.
You can filter the list of parameters to display only the data load parameters that have no value by using the Show drop-down list in the toolbar.
You can export and save content displayed in the table to a Microsoft Excel formatted file by clicking the Export icon in toolbar.
You can change a parameter value by selecting the parameter in the list, and then clicking the Edit icon in the toolbar. The Edit Parameter Value dialog is displayed. To change a parameter value, the user must have been assigned a role that has the appropriate privilege.
Use the Domains and Mappings tab to view and edit domains and mappings related to a load plan selected in the Load Plan list. The domains and mappings are associated with the fact group included in the load plan definition.
Key points about the Domains and Mappings tab.
If a source domain in the list contains members that have not been mapped to an appropriate warehouse domain member, the row in the table is tagged with an error icon. Some source domain members are not applicable, and, therefore, are not tagged even if they are unmapped.
You can filter the list of mappings to display only the domains that have unmapped source members using the Show drop-down list in the toolbar.
You can export and save content displayed in the table to a Microsoft Excel formatted file by clicking the Export icon in toolbar.
You can change a domain mapping by selecting the mapping in the list, and then clicking the Edit icon in the toolbar. The Edit Domain Member Mappings dialog is displayed. To change a domain member mapping, the user must have been assigned a role that has the appropriate privilege.
Use the Schedule tab to view, create, edit and delete schedules for the execution of a load plan. A load plan schedule includes the following required properties:
Context - The ODI context to be used when the load plan is run. Note that Global is the only supported context.
Logical Agent - The ODI Agent to be used when the load plan is run.
Recurrence - Frequency of occurrence. Possible values are the following:
On Agent Startup
Simple
Hourly
Daily
Weekly
Monthly (day of the month)
Monthly (week day)
Yearly
Status - Status of the schedule. Possible values are the following:
Active
Inactive
Active for the period
Scheduled Time - Date and time the load plan is to be executed.
The toolbar icons provide the following functionality:
Add - This command invokes the Schedule Load Plan dialog, which enables you to define a new schedule for the selected load plan.
Edit - Applies to a selected schedule. This command invokes the Schedule Load Plan dialog, which enables you to make changes to the selected schedule.
Remove - This command removes the schedule from the repository.
Update Schedules - This command adds the schedule to the ODI Agent scheduler if the agent is already started in ODI. Note that if the ODI Agent is already running at the time you define the schedule in the Oracle BI Applications Configuration Manager, you must click Update Schedules to add the schedule to the ODI Agent scheduler.
Use the Define Load Plan pages to define a new load plan. A load plan comprises one or more fact groups as well as additional properties.
Element | Description |
---|---|
Define Load Plan first page |
The first page of the Define Load Plan series requests the following information:
|
Define Load Plan second page |
The second page of the Define Load Plan series contains the following tabs:
|
Use the Duplicate Load Plan page to duplicate an existing load plan. The Duplicate Load Plan page displays the load plan information for the load plan you want to copy. You must provide a unique name for the duplicate load plan. You can optionally change the following information:
First page of the Duplicate Load Plan series
Description
Load Plan Type
Source Instance
Second page of the Duplicate Load Plan series
Fact Group
Use the Edit Load Plan page to edit an existing load plan.You can edit the following information:
First page of the Edit Load Plan series
Name
Description
Source Instance
Second page of the Edit Load Plan series
Fact Group
Use the Load Plan Details page to view detailed information about the definition and execution status of the load plan selected in the Load Plan list.
Element | Description |
---|---|
Navigation tabs |
In the Navigation tabs, you can browse for objects contained in the repository. When an object or node is selected, the Navigation Tab toolbar displays icons for the actions available for this object or node. If an action is not available for this object, the icon is greyed out.
|
Load Plan tab |
The Load Plan tab displays three panels, containing the following information:
|
Load Plan Execution tab |
The Load Plan execution tab displays three panels, containing the following information:
|
Use the Schedule Load Plan dialog to create and edit schedules for load plan execution. A load plan schedule includes the following properties:
Context - The ODI context to be used when the load plan is run. Note that Global is the only supported context.
Logical Agent - The ODI Agent to be used when the load plan is run.
Log Level - The level of logging information to retain. The Oracle BI Applications Configuration Manager uses Oracle Diagnostic Logging. For information about managing log files and diagnostic data, see Oracle Fusion Middleware Administrator's Guide.
Status - The status of the schedule. Possible values are the following:
Active
Inactive
Active for the period
Recurrence - The frequency of occurrence. Possible values are the following:
On Agent Startup
Simple
Hourly
Daily
Weekly
Monthly (day of the month)
Monthly (week day)
Yearly
Depending on the Recurrence option you select, options for selecting the date and time are dynamically displayed.