Oracle Warehouse Builder Setup

This chapter covers the following topics:

Oracle Warehouse Builder Setup Steps

For more details on installation steps, refer to the Oracle Manufacturing Operations Center (Release 12.1.1.01) Installation Readme file (Doc ID: 818813.1).

Complete the following Oracle Warehouse Builder setup steps:

  1. Set up the OWB repository.

  2. Register users.

  3. Import the Metadata Loaders (MDLs) in the order specified in the Readme file.

  4. Create locations.

    • Source system locations:

      • The location of the EBS 11.5.10 system. The Service Name defined for EBS source systems must be same as the profile name in the source system MTH: System Global Name.

      • The location of other systems based on the database on which they are installed.

      • The location of .csv templates.

    • The target system location where the Manufacturing Operations Center data is stored.

    • The location of the workflow.

  5. Configure the repository locations.

  6. Set up the Control Center.

  7. Deploy Dimensions, External Tables, Mappings, and Process flows in the order specified in the Readme file.

There is always one target system, but there can be many source systems including the location of the .csv templates. Oracle Manufacturing Operations Center (MOC) is designed to work out of the box with one EBS 11.5.10 source system and one file location. However, MOC can be customized to integrate with multiple source systems.

Troubleshooting Tips

To specify parameters when running a load:

  1. In the OWB Design Center, navigate to Tools, Preferences, MTHUSER - Deployment Process.

  2. Select the following options:

    • Prompt for Execution Parameters

    • Show Monitor

Customizing the OWB Repository for Two EBS Systems

In the first source system scenario, there are two EBS data sources for one installation of Oracle Manufacturing Operations Center (MOC). Complete the following steps to set up OWB for MOC with this source system combination:

  1. In the Project Explorer area, navigate to MTH, Databases, Oracle.

    • EBS tables that are used as a data source are listed in MTH_SOURCE, Tables.

    • MOC tables used to load the data are listed in MTH_TARGET, Tables.

    • Pre-seeded mappings to an Oracle EBS instance are listed in MTH_TARGET, Mappings.

  2. In the Connection Explorer area, navigate to Locations, Databases, Oracle.

  3. To create a new location for the second EBS source, right-click on Oracle and selecting New.

  4. In the Project Explorer area, right-click on MTH_SOURCE and select Copy.

  5. Right-click on Oracle and select Paste.

  6. If required, rename the copied source.

    When you copy a source, source tables are also copied.

  7. Map the source of the new module to the new location you created in the Connection Explorer.

  8. Navigate to MTH, Databases, Oracle, MTH_Target, Mappings.

  9. Edit the existing mappings or add a new map by copying and pasting.

  10. Open the Mapping Editor.

  11. Right-click and select Synchronize to swap the existing source in the mappings to the new source.

  12. Create new joins and filters.

  13. Deploy the Mappings

Customizing the OWB Repository for One EBS System and One Non-EBS System

In the second source system scenario there is an external EBS data source and a non-EBS external data source. Complete the following steps to set up OWB for Oracle Manufacturing Operations Center (MOC) with this source system combination:

  1. In the Project Explorer area, browse to MTH, Databases, Oracle.

    • EBS tables that are used as a data source in MOC are listed in MTH_SOURCE, Tables.

    • MOC tables used to load the data are listed in MTH_TARGET, Tables.

    • Pre-seeded mappings to an Oracle EBS instance are listed in MTH_TARGET, Mappings.

  2. In the Connection Explorer area, navigate to Locations, Databases, Oracle.

  3. Create a non-EBS source location by providing the database link details for the non-EBS source.

  4. In the Project Explorer area, create a new Data Source module in Oracle.

  5. In Step 2 of the Create Module window, point the module to the Location that you created.

  6. In the new Data Source module, right-click Tables and select Import. The Import Metadata Wizard appears.

  7. Use the Import Metadata Wizard to select the tables to import from the source.

    Note: When you select tables, only their metadata is imported and not the actual tables.

  8. In the MTH_Target module, edit existing mappings or create new mappings.

  9. Open the Mapping Editor.

  10. Right-click and select Synchronize to change the source of an existing table or view.

  11. Close the Mapping Editor.

  12. Deploy the edited or created mappings.

Refer to the Oracle Warehouse Builder User's Guide for more information.