16 Configuring Oracle Enterprise Asset Management Analytics

This section describes how to configure Oracle Enterprise Asset Management Analytics, and contains the following sections:

Section 16.1, "Overview of Oracle Enterprise Asset Management Analytics"
Section 16.2, "Configuration Required Before a Full Load for Oracle Enterprise Asset Management Analytics"

For information about configuring Oracle Enterprise Asset Management Analytics with Universal Adapter, see Section A.7, "List of Source Files for Oracle Enterprise Asset Management Analytics and Oracle Manufacturing Analytics".

16.1 Overview of Oracle Enterprise Asset Management Analytics

The Oracle Enterprise Asset Management Analytics application enables you to analyze:

Asset portfolio management and balance operational efficiencies
Efficiency of the maintenance organization
Effectiveness of maintenance planning
Maintenance cost variance
Maintenance work order backlog and maintenance work order completions
MRO Inventory availability
MRO Inventory Aging
Meter reading pattern
Resource availability and efficiency
Material Usage

Oracle Enterprise Asset Management Analytics offers complete and enhanced visibility into enterprise-wide maintenance information. It provides insight into failure analysis, work orders, maintenance history, cost analysis, resource utilization and enables maintenance managers to maximize performance and identify opportunities for optimizing asset availability. The Oracle Enterprise Asset Management Analytics application also requires post-load processing mappings to populate its aggregate and derived tables.

16.2 Configuration Required Before a Full Load for Oracle Enterprise Asset Management Analytics

This section contains configuration steps that you need to perform on Oracle Enterprise Asset Management Analytics before you do a full data load. It contains the following topics:

Section 16.2.1, "Configuration Steps for Oracle Enterprise Management Analytics with Oracle EBS"
Section 16.2.2, "Domain Values and CSV Worksheet Files for Oracle Enterprise Asset Management Analytics with Oracle EBS"
Section 16.2.3, "Configuration Steps for Oracle Enterprise Management Analytics for MAXIMO"
Section 16.2.4, "Domain Values and CSV Worksheet Files for Oracle Enterprise Asset Management Analytics"

16.2.1 Configuration Steps for Oracle Enterprise Management Analytics with Oracle EBS

This section contains configuration steps that you need to perform when using Oracle EBS Source Systems.

16.2.1.1 How to Disable Project Dimensions

If you have not licensed or do not want to implement Oracle Projects, you can disable Project dimensions.

To disable project dimensions:

In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
Display the Configuration Tags tab.
Query for the Configuration tag named 'Enable Project Dimensions'.
Display the Subject Areas sub tab.
Select the Inactive check box for the selected Subject Area.
In the upper pane, display the Subject Areas tab, and Query for EAM subject areas and select the appropriate Subject Area.
In lower pane, display the Configuration Tags tab.
Select the Inactive check box for the Configuration Tag named 'Enable Project Dimensions'.

For more information about DAC, see Oracle Business Intelligence Data Warehouse Administration Console User's Guide.

16.2.1.2 How to Disable Multiple Calendar Support

If you do not want to implement Multiple Calendar Support, you can disable Multiple Calendar Support.

To disable Multiple Calendar Support:

In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
Display the Configuration Tags tab.
Query for the Configuration tag named 'Multiple Calendar Support'.
Display the Subject Areas sub tab.
Select the Inactive check box for the selected Subject Area.
In the upper pane, display the Subject Areas tab, and Query for EAM subject areas and select the appropriate Subject Area.
In lower pane, display the Configuration Tags tab.
Select the Inactive check box for the Configuration Tag named 'Multiple Calendar Support'.

For more information about DAC, see Oracle Business Intelligence Data Warehouse Administration Console User's Guide.

16.2.1.3 How to Configure the DAC Parameter for Process Items for Supply chain – Inventory

To load the Process Items in W_PRODUCT_D from MTL_SERIAL_NUMBERS, the ETL task get data from Oracle EBS applications. This section applies to all versions of Oracle EBS.

To configure the DAC parameter for Process Items:

In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
Display the Tasks tab, and query for task named SDE_ORA_ProductDimension.
Display the Parameters tab in the lower pane.
Edit the value of the parameter $$MASTER_ORG and add the new value '1080' for getting Process Items.

For more information about DAC, see Oracle Business Intelligence Data Warehouse Administration Console User's Guide.

16.2.1.4 How to Disable Project Dimensions for Supply chain – inventory

If you have not licensed or do not want to implement Oracle Projects, you can disable Project dimensions.

To disable project dimensions:

In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
Display the Configuration Tags tab.
Query for the Configuration tag named 'Enable Project Dimensions'.
Display the Subject Areas sub tab.
Select the Inactive check box for the selected Subject Area.
In the upper pane, display the Subject Areas tab, and Query for named 'Supply chain – Inventory%' and select the appropriate Subject Area.
In lower pane, display the Configuration Tags tab.
Select the Inactive check box for the Configuration Tag named 'Enable Project Dimensions'.

For more information about DAC, see Oracle Business Intelligence Data Warehouse Administration Console User's Guide.

16.2.1.5 How to Disable Process Manufacturing Dimensions for EAM Subject Areas

If you have not licensed or do not want to implement Oracle Process Manufacturing dimensions, you can disable Oracle Process Manufacturing dimensions.

To disable Oracle Process Manufacturing dimensions:

In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
Display the Configuration Tags tab.
Query for the Configuration tag named 'Manufacturing – Process'.
Display the Subject Areas sub tab.
Select the Inactive check box for the selected Subject Area.
In the upper pane, display the Subject Areas tab, and Query for EAM Subject Areas and select the appropriate Subject Area.
In lower pane, display the Configuration Tags tab.
Select the Inactive check box for the Configuration Tag named 'Manufacturing – Process'.

For more information about DAC, see Oracle Business Intelligence Data Warehouse Administration Console User's Guide.

16.2.2 Domain Values and CSV Worksheet Files for Oracle Enterprise Asset Management Analytics with Oracle EBS

If you have modified or extended a seeded list of values, you must configure the CSV files for Oracle Enterprise Asset Management Analytics by mapping values from your source systems to the domain values.

This section explains how to extract the lists of values from your source system, which you then compare with the seeded values. If the lists of values are different from the seeded values, you need to follow the instructions for configuring the domain values and CSV worksheet files in this section.

This section applies to all versions of Oracle EBS.

16.2.2.1 List of Domain Values and CSV Worksheet Files for Oracle Asset Management Analytics

The table below lists the domain values for Oracle Asset Management Analytics in the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles). The table also lists the CSV worksheet source files for Oracle Asset Management Analytics in the $PMServer\SrcFiles directory (for example, INFA_HOME\server\infa_shared\SrcFiles).

Table 16-1 Domain Values and CSV Worksheet Files for Oracle Asset Management Analytics with Oracle EBS

Worksheet File Name	Description	Session
domainValues_Xact_Types_EAM_WO_Type_ora11i.csv	Lists the Enterprise Asset Management Work order types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 16.2.2.2, "How to configure domainValues_Xact_Types_EAM_WO_Type_ora11i.csv".	SDE_ORA_TransactionTypeDimension_EAM_WOType
domainValues_Xact_Types_EAM_FailureCause_oraR12.csv	Lists the Enterprise Asset Management Failure cause and the corresponding domain values for Oracle EBS application. For more information about how to edit this file ,see Section 16.2.2.3, "How to configure domainValues_Xact_Types_EAM_FailureCause_oraR12.csv".	SDE_ORA_TransactionTypeDimension_EAM_FailureCause
domainValues_Xact_Types_FailureCode_ora12.csv	Lists the Enterprise Asset Management Failure code and the corresponding domain values for Oracle EBS application. For more information about how to edit this file ,see Section 16.2.2.4, "How to configure domainValues_Xact_Types_FailureCode_ora12.csv".	SDE_ORA_TransactionTypeDimension_FailureCode
domainValues_Xact_Types_EAM_FailureResolution_oraR12.csv	Lists the Enterprise Asset Management Failure resolution and the corresponding domain values for Oracle EBS application. For more information about how to edit this file ,see Section 16.2.2.5, "How to configure domainValues_Xact_Types_EAM_FailureResolution_oraR12.csv".	SDE_ORA_TransactionTypeDimension_EAMFailureResolution
domainValues_Xact_Types_EAMCostElement_ora11i.csv	Lists the Enterprise Asset Management Cost Element types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 16.2.2.6, "How to configure domainValues_Xact_Types_EAMCostElement_ora11i.csv".	SDE_ORA_TransactionTypeDimension_EAMCostElement
domainValues_Status_EAMAsset_ora11i.csv	Lists the Asset Status and the corresponding domain values for Oracle EBS application. For more information about how to edit this file ,see Section 16.2.2.7, "How to configure domainValues_Status_EAMAsset_ora11i.csv".	SDE_ORA_StatusDimension_EAMAssetStatus
domainValues_Status_MfgJob_ora11i.csv	Lists the Manufacturing Job Status and the corresponding domain values for Oracle EBS application. For more information about how to edit this file ,see Section 16.2.2.8, "How to configure domainValues_Status_MfgJob_ora11i.csv".	SDE_ORA_StatusDimension_Manufacturing_Discrete
file_ bucket_range_master_ebs11i.csv	This file provides EAM cycle bucket ranges i.e, MIN_RANGE, MAX_RANGE, to populate the W_SCM_BUCKET_D table. For more information about configuring Cycle bucket ranges, see Section 16.2.2.9, "How to configure file_ bucket_range_master_ebs11i.csv".	SDE_ORA_SCMBucketDimension

16.2.2.2 How to configure domainValues_Xact_Types_EAM_WO_Type_ora11i.csv

This section explains how to configure the domainValues_Xact_Types_EAM_WO_Type_ora11i.csv file.

Identify the Enterprise Asset Management Work order types in your EBS source system by using the following SQL:

SELECT 'MAINTENANCE' XACT_CAT_NAME,
 'PREVENTIVE' XACT_TYPE_CODE,
 'Preventive Work Orders' XACT_TYPE_DESC,
 'PREVENTIVE' XACT_SUBTYPE_CODE,
 'Preventive Work Orders' XACT_SUBTYPE_DESC
FROM DUAL
UNION
SELECT 'MAINTENANCE' XACT_CAT_NAME,
'CORRECTIVE' XACT_TYPE_CODE,
'Corrective Work Orders' XACT_TYPE_DESC,
'PROACTIVE' XACT_SUBTYPE_CODE,
'Proactive Work Orders' XACT_SUBTYPE_DESC
FROM DUAL 
UNION 
SELECT 'MAINTENANCE' XACT_CAT_NAME,
'CORRECTIVE' XACT_TYPE_CODE,
'Corrective Work Orders' XACT_TYPE_DESC,
'REACTIVE' XACT_SUBTYPE_CODE,
'Reactive Work Orders' XACT_SUBTYPE_DESC
FROM DUAL

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAM_WO_Type_ora11i.csv file in a text editor.
Copy the XACT_CAT_NAME, XACT_TYPE_CODE, XACT_TYPE_DESC, XACT_SUBTYPE_CODE, XACT_SUBTYPE_DESC to the XACT_CODE, XACT_TYPE_CODE,XACT_SUB_TYPE_CODE,W_XACT_TYPE_CODE,W_XACT_TYPE_DESC,W_XACT_SUB_TYPE_CODE,W_XACT_SUB_TYPE_DESC column in the file.

The data must be copied starting from the 5th line.
Map each XACT_TYPE_CODE to one EAM work order type (EAM_WORKORDER_TYPE) domain value. Use commas to separate the entries.
Save and close the file.

16.2.2.3 How to configure domainValues_Xact_Types_EAM_FailureCause_oraR12.csv

This section explains how to configure the domainValues_Xact_Types_EAM_FailureCause_oraR12.csv file.

Identify the Enterprise Asset Management Failure Causes in your EBS source system by using the following SQL:
```
SELECT DISTINCT EAM_CAUSE_CODES.CAUSE_CODE,
EAM_CAUSE_CODES.DESCRIPTION 
FROM EAM_CAUSE_CODES
```
From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAM_FailureCause_oraR12.csv file in a text editor.
Copy the CAUSE_CODE to the XACT_TYPE_CODE column in the file.

The data must be copied starting from the 7th line.
Map each Transaction type code to one EAM cause code (EAM_CAUSE_CODE) domain value. Use commas to separate the entries.
Save and close the file.

16.2.2.4 How to configure domainValues_Xact_Types_FailureCode_ora12.csv

This section explains how to configure the domainValues_Xact_Types_FailureCode_ora12.csv file.

Identify the Enterprise Asset Management Failure Codes in your EBS source system by using the following SQL:
```
SELECT EAM_FAILURE_CODES.FAILURE_CODE 
FROM EAM_FAILURE_CODES
```
From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_FailureCode_ora12.csv file in a text editor.
Copy the FAILURE_CODE to the XACT_TYPE_CODE column in the file.

The data must be copied starting from the 4th line.
Map each Transaction type code to one EAM failure code domain value. Use commas to separate the entries.
Save and close the file.

16.2.2.5 How to configure domainValues_Xact_Types_EAM_FailureResolution_oraR12.csv

This section explains how to configure the domainValues_Xact_Types_EAM_FailureResolution_oraR12.csv file.

Identify the Enterprise Asset Management Failure Resolutions in your EBS source system by using the following SQL:
```
SELECT EAM_RESOLUTION_CODES.RESOLUTION_CODE FROM EAM_RESOLUTION_CODES;
```
From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAM_FailureResolution_oraR12.csv file in a text editor.
Copy the RESOLUTION_CODE to the XACT_TYPE_CODE column in the file. The data must be copied starting from the 7th line.
Map each Transaction type code to one EAM Failure code domain value. Use commas to separate the entries.
Save and close the file.

16.2.2.6 How to configure domainValues_Xact_Types_EAMCostElement_ora11i.csv

This section explains how to configure the domainValues_Xact_Types_EAMCostElement_ora11i.csv file.

Identify the Enterprise Asset Management Cost Element types in your EBS source system by using the following SQL:
```
SELECT CST_EAM_COST_ELEMENTS.EAM_COST_ELEMENT_ID 
FROM CST_EAM_COST_ELEMENTS
```
From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAMCostElement_ora11i.csv file in a text editor.
Copy the EAM_COST_ELEMENT_ID to the XACT_TYPE_CODE column in the file. The data must be copied starting from the 5th line.
Map each Transaction type code to one Cost Element (EAM_COST_ELEMENT) domain value. Use commas to separate the entries.
Save and close the file.

16.2.2.7 How to configure domainValues_Status_EAMAsset_ora11i.csv

This section explains how to configure the domainValues_Status_EAMAsset_ora11i.csv file.

Identify the Enterprise Asset Management Asset Status in your EBS source system by using the following SQL:

SELECT CSI_INSTANCE_STATUSES.INSTANCE_STATUS_ID 
FROM CSI_INSTANCE_STATUSES 
WHERE CSI_INSTANCE_STATUSES.INSTANCE_STATUS_ID IN(1,510)

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Status_EAMAsset_ora11i.csv file in a text editor.
Copy the INSTANCE_STATUS_ID to the STATUS_CODE column in the file. The data must be copied starting from the 4th line.
Map each Status code to one Asset Status (EAM_ASSET_STATUS) domain value. Use commas to separate the entries.
Save and close the file.

16.2.2.8 How to configure domainValues_Status_MfgJob_ora11i.csv

This section explains how to configure the domainValues_Status_MfgJob_ora11i.csv file.

Identify the Manufacturing Job Status in your EBS source system by using the following SQL:

SELECT FND_LOOKUP_VALUES.LOOKUP_CODE 
FROM FND_LOOKUP_VALUES 
WHERE FND_LOOKUP_VALUES.LOOKUP_TYPE = 'WIP_JOB_STATUS' 
AND FND_LOOKUP_VALUES.LANGUAGE = 'US' ;

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Status_MfgJob_ora11i.csv file in a text editor.
Copy the LOOKUP_CODE to the STATUS_CODE column in the file. The data must be copied starting from the 5th line.
Map each Status code to one Job Status (MFG_STATUS) domain value. Use commas to separate the entries.
Save and close the file.

16.2.2.9 How to configure file_ bucket_range_master_ebs11i.csv

This section explains how to configure the file_ bucket_range_master_ebs11i.csv file.

From the $PMServer\SrcFiles directory (for example, INFA_HOME\server\infa_shared\SrcFiles), open file_bucket_range_master_ebs11i.csv file in a text editor.
Configure the value of BUCKET_RANGE_NAME,MIN_RANGE and MAX_RANGE
Save and close the file.

16.2.3 Configuration Steps for Oracle Enterprise Management Analytics for MAXIMO

This section contains configuration steps that you need to perform when using MAXIMMO Source Systems.

16.2.3.1 How to Configure the DAC Parameter for Maximo calendar

In order to calculate the resource capacity, resource working calendar has to be set.

To configure the DAC parameter:

In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
Display the Source System Parameters tab, and query for parameter named $$EAM_CALENDAR.
Display the Edit tab in the lower pane.
Edit the value of the parameter $$$EAM_CALENDAR (E.g. DAY).

For more information about DAC, see Oracle Business Intelligence Data Warehouse Administration Console User's Guide.

16.2.3.2 How to Configure the DAC Parameter for Direct Items

In order to load the customized name for direct items in W_PRODUCT_D, you must specify the name of the direct item in DAC.

To configure the DAC parameter:

In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
Display the Source System Parameters tab, and query for a parameter named $$DIRECT_ITEM.
Display the Edit tab in the lower pane.
Edit the value of the parameter $$DIRECT_ITEM (for example, Descriptive Direct Item).

For more information about DAC, see Oracle Business Intelligence Data Warehouse Administration Console User's Guide.

16.2.4 Domain Values and CSV Worksheet Files for Oracle Enterprise Asset Management Analytics

This section applies to all versions of IBM Maximo.

16.2.4.1 List of Domain Values and CSV Worksheet Files for Oracle Asset Management Analytics

Table 16-2 Domain Values and CSV Worksheet Files for Oracle Asset Management Analytics with Maximo

Worksheet File Name	Description	Session
domainValues_Xact_Types_EAM_WO_Type_maximo.csv	Lists the Enterprise Asset Management Work order types and the corresponding domain values for IBM Maximo application. For more information about how to edit this file, see Section 16.2.4.2, "How to configure domainValues_Xact_Types_EAM_WO_Type_maximo.csv".	SDE_MAXIMO_TransactionTypeDimension_EAM_WOType
domainValues_Xact_Types_EAM_FailureCodes_maximo.csv	Lists the Enterprise Asset Management Failure codes and the corresponding domain values for IBM Maximo application. For more information about how to edit this file ,see Section 16.2.4.3, "How to configure domainValues_Xact_Types_EAM_FailureCause_maximo.csv".	SDE_MAXIMO_TransactionTypeDimension_EAM_FailureCodes
domainValues_Xact_Types_EAM_FailureCause_maximo.csv	Lists the Enterprise Asset Management Failure cause and the corresponding domain values for IBM Maximo application. For more information about how to edit this file ,see Section 16.2.4.4, "How to configure domainValues_Xact_Types_EAM_FailureCodes_maximo.csv".	SDE_MAXIMO_TransactionTypeDimension_EAM_FailureCause
domainValues_Xact_Types_EAM_FailureResolution_maximo.csv	Lists the Enterprise Asset Management Failure resolution and the corresponding domain values for IBM Maximo application. For more information about how to edit this file ,see Section 16.2.4.5, "How to configure domainValues_Xact_Types_EAM_FailureResolution_maximo.csv".	SDE_MAXIMO_TransactionTypeDimension_EAMFailureResolution
domainValues_Xact_Types_EAMCostElement_MAXIMO.csv	Lists the Enterprise Asset Management Cost Element types and the corresponding domain values for IBM Maximo application. For more information about how to edit this file, see Section 16.2.4.6, "How to configure domainValues_Xact_Types_EAMCostElement_MAXIMO.csv".	SDE_MAXIMO_TransactionTypeDimension_EAMCostElement
domainValues_Status_Asset_MAXIMO.csv	Lists the Asset Status and the corresponding domain values for IBM Maximo application. For more information about how to edit this file, see Section 16.2.4.7, "How to configure domainValues_Status_Asset_MAXIMO.csv".	SDE_MAXIMO_StatusDimension_EAMAssetStatus
domainValues_Status_MfgJob_MAXIMO.csv	Lists the Work order Status and the corresponding domain values for IBM Maximo application. For more information about how to edit this file, see Section 16.2.4.8, "How to configure domainValues_Status_MfgJob_MAXIMO.csv".	SDE_MAXIMO_StatusDimension_WOStatus
file_bucket_range_master_maximo.csv	This file provides EAM cycle bucket ranges i.e,MIN_RANGE,MAX_RANGE to populate the W_SCM_BUCKET_D table. For more information about configuring cycle bucket ranges, see Section 16.2.4.9, "How to configure file_ bucket_range_master_ebs11i.csv".	SDE_MAXIMO_SCMBucketDimension

16.2.4.2 How to configure domainValues_Xact_Types_EAM_WO_Type_maximo.csv

This section explains how to configure the domainValues_Xact_Types_EAM_WO_Type_maximo.csv file.

Identify the Enterprise Asset Management Work order types in your MAXIMO source system by using the following SQL:

SELECT DISTINCT WORKTYPE,WTYPEDESC,ORGID,'0' as X_CUSTOM 
FROM WORKTYPE 
WHERE WOCLASS='WORKORDER' AND TYPE='NONE'

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAM_WO_Type_maximo.csv file in a text editor.
Copy the XACT_CAT_NAME, XACT_TYPE_CODE, XACT_TYPE_DESC, XACT_SUBTYPE_CODE, XACT_SUBTYPE_DESC to the XACT_CODE, XACT_TYPE_CODE, XACT_SUB_TYPE_CODE, W_XACT_TYPE_CODE, W_XACT_TYPE_DESC, W_XACT_SUB_TYPE_CODE and W_XACT_SUB_TYPE_DESC column in the file.

The data must be copied without the column headers.
Map each WORKTYPE to one EAM work order type (EAM_WORKORDER_TYPE) domain value. Use commas to separate the entries.
Save and close the file.

16.2.4.3 How to configure domainValues_Xact_Types_EAM_FailureCause_maximo.csv

This section explains how to configure the domainValues_Xact_Types_EAM_FailureCause_maximo.csv file.

Identify the Enterprise Asset Management Failure Causes in your MAXIMO source system by using the following SQL:

SELECT DISTINCT FAILURECODE.FAILURECODE,FAILURECODE.DESCRIPTION,'0' AS X_CUSTOM 
FROM FAILURECODE, FAILURELIST 
WHERE FAILURECODE.ORGID=FAILURELIST.ORGID 
AND FAILURELIST.TYPE IN ('CAUSE') 
AND FAILURECODE.FAILURECODE=FAILURELIST.FAILURECODE

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAM_FailureCause_maximo.csv file in a text editor.
Copy the FAILURECODE to the XACT_TYPE_CODE column in the file. The data must be copied without the column headers.
Map each Transaction type code to one EAM cause code (EAM_CAUSE_CODE) domain value. Use commas to separate the entries.
Save and close the file.

16.2.4.4 How to configure domainValues_Xact_Types_EAM_FailureCodes_maximo.csv

This section explains how to configure the domainValues_Xact_Types_EAM_FailureCodes_maximo.csv file.

Identify the Enterprise Asset Management Failure Codes in your MAXIMO source system by using the following SQL:

SELECT DISTINCT 'EAM_FAILURE_CODE' XACT_CODE,'MAINTENANCE' XACT_CAT_CODE,'MAINTENANCE' XACT_CAT_NAME,FAILURECODE.FAILURECODE XACT_TYPE_CODE,FAILURECODE.DESCRIPTION XACT_TYPE_NAME,FAILURECODE.DESCRIPTION XACT_TYPE_DESC,'0' AS X_CUSTOM 
FROM FAILURECODE,FAILURELIST 
WHERE 
FAILURECODE.ORGID=FAILURELIST.ORGID 
AND TYPE IN ('PROBLEM') 
AND FAILURECODE.FAILURECODE=FAILURELIST.FAILURECODE

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAM_FailureCodes_maximo.csv file in a text editor.
Copy the FAILURECODE to the XACT_TYPE_CODE column in the file. The data must be copied without the column headers.
Map each Transaction type code to one EAM failure code domain value.

Use commas to separate the entries.
Save and close the file.

16.2.4.5 How to configure domainValues_Xact_Types_EAM_FailureResolution_maximo.csv

This section explains how to configure the domainValues_Xact_Types_EAM_FailureResolution_maximo.csv file.

Identify the Enterprise Asset Management Failure Resolutions in your MAXIMO source system by using the following SQL:

SELECT DISTINCT FAILURECODE.FAILURECODE,FAILURECODE.DESCRIPTION,'0' AS X_CUSTOM 
FROM FAILURECODE, FAILURELIST 
WHERE 
FAILURECODE.ORGID=FAILURELIST.ORGID 
AND FAILURELIST.TYPE IN ('REMEDY') 
AND FAILURECODE.FAILURECODE=FAILURELIST.FAILURECODE

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAM_FailureResolution_maximo.csv file in a text editor.
Copy the FAILURECODE to the XACT_TYPE_CODE column in the file. The data must be copied without the column headers.
Map each Transaction type code to one EAM Failure code domain value.

Use commas to separate the entries.
Save and close the file.

16.2.4.6 How to configure domainValues_Xact_Types_EAMCostElement_MAXIMO.csv

This section explains how to configure the domainValues_Xact_Types_EAMCostElement_MAXIMO.csv file.

Identify the Enterprise Asset Management Cost Element types in your MAXIMO source system by using the following SQL:

SELECT 'MAINTENANCE' EAM_COSTELEMENT,1 AS EAM_COSTELEMENT_ID,'Equipment' DESCRIPTION FROM SYNONYMDOMAIN 
UNION 
SELECT 'MAINTENANCE' EAM_COSTELEMENT, 2 AS EAM_COSTELEMENT_ID, 
'Labor' DESCRIPTION FROM SYNONYMDOMAIN 
UNION 
SELECT 'MAINTENANCE' EAM_COSTELEMENT,
3 AS EAM_COSTELEMENT_ID,
'Material' DESCRIPTION FROM SYNONYMDOMAIN

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_EAMCostElement_MAXIMO.csv file in a text editor.
Copy the EAM_COST_ELEMENT_ID to the XACT_TYPE_CODE column in the file. The data must be copied without the column headers.
Map each Transaction type code to one Cost Element (EAM_COST_ELEMENT) domain value.

Use commas to separate the entries.
Save and close the file.

16.2.4.7 How to configure domainValues_Status_Asset_MAXIMO.csv

This section explains how to configure the domainValues_Status_Asset_MAXIMO.csv file.

Identify the Enterprise Asset Management Asset Status in your MAXIMO source system by using the following SQL:

SELECT VALUE STATUS_CODE,DESCRIPTION STATUS_NAME,
'EAM_ASSET_STATUS' AS W_STATUS_CLASS,'0' AS X_CUSTOM 
FROM SYNONYMDOMAIN 
WHERE DOMAINID='LOCASSETSTATUS'

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Status_Asset_MAXIMO.csv file in a text editor.
Copy the VALUE to the STATUS_CODE column in the file. The data must be copied without the column headers.
Map each Status code to one Asset Status (EAM_ASSET_STATUS) domain value. Use commas to separate the entries.
Save and close the file.

16.2.4.8 How to configure domainValues_Status_MfgJob_MAXIMO.csv

This section explains how to configure the domainValues_Status_MfgJob_MAXIMO.csv file.

Identify the Manufacturing Job Status in your MAXIMO source system by using the following SQL:

SELECT 'MFG_STATUS' W_STATUS_CLASS,VALUE STATUS_CODE,
DESCRIPTION STATUS_NAME,DESCRIPTION STATUS_DESC ,'0' AS X_CUSTOM 
FROM SYNONYMDOMAIN 
WHERE DOMAINID='WOSTATUS'

From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Status_MfgJob_MAXIMO.csv file in a text editor.
Copy the VALUE to the STATUS_CODE column in the file.

The data must be copied without the column headers.
Map each Status code to one Job Status (MFG_STATUS) domain value.

Use commas to separate the entries.
Save and close the file.

16.2.4.9 How to configure file_ bucket_range_master_ebs11i.csv

This section explains how to configure the file_bucket_range_master_maximo.csv file.

From the $PMServer\SrcFiles directory (for example, INFA_HOME\server\infa_shared\SrcFiles), open file_bucket_range_master_maximo.csv file in a text editor.
Configure the value of BUCKET_RANGE_NAME,MIN_RANGE and MAX_RANGE.
Save and close the file.