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 is used as a service name when the OWB location is specified for the EBS system.
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.
Configure MTH_SOURCE_LOCATION to populate the system identifier to be the same as the ones set up in the source system. Data collected from EBS is automatically stamped with the source system's identifier.
Run the mapping MTH_SYSTEMS_SETUP_XS_ALL_MAP under the MTH Utilities folder to load source systems into Oracle Manufacturing Operations Center (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.