This chapter covers the following topics:
Complete these steps to set up source systems:
In the source EBS system, set up the profile option MTH: System Global Name.
The name defined should be configured as a service name in EBS.
In the Microsoft Excel template, update MTH_SYSTEMS_SETUP.csv with definitions for the source system.
Run the ODI Scenario MTH_PKG_SYSTEMS_SETUP_EXT to load source systems into MOC.
This table displays the structure of the Microsoft Excel template that is used to define the source system:
System Code | System Type | System Name | USER_ATTR1 | USER_ATTR2 | USER_ATTR3 | USER_ATTR4 | USER_ATTR5 |
TESTSYST01 | EXCEL | TESTSYST01 | A | B | C | D | E |
System Type can be any value, but it is recommended that you use one of the following choices which are available in a lookup table:
Enterprise Resource Planning
Manufacturing Execution Systems
Advance Planning
Device Data Source
Historian
Supervisory Control and Data Acquisition
Quality Management System
Statistical Process Control
Maintenance Management System
Legacy System
Spreadsheet
Other Sources
Note: If the System Code and System Name are not unique, then errors display.
Data rows are marked with Unassigned System if you collect data from a source for which the system name is not populated.
You can update the System Name, System Type, and User Attributes for the System Code. You must not delete the system name.