17 Configuring Oracle Manufacturing Analytics

This section describes how to configure Oracle Manufacturing Analytics, and contains the following sections:

• Section 17.1, "Overview of Oracle Manufacturing Analytics"

• Section 17.2, "Configuration Required Before a Full Load for Oracle Manufacturing Analytics"

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

17.1 Overview of Oracle Manufacturing Analytics

The Oracle Manufacturing Analytics application enables you to analyze:

• Manufacturing execution including production performance, material and resource usage and work order analysis for discrete and process manufacturing.

• Production costs and cost variance analysis by cost elements.

• Production quality and quality test results.

• Production plan comparison, pegging and schedule adherence.

• Inventory held by an organization, including age of inventory.

• Inventory movements in, out, and through manufacturing plants, distribution centers, or storage locations.

• Inventory Bill of Materials.

• Lot genealogy.

• Kanban.

The Manufacturing Analytics module provides summary level performance indicators to help make timely, informed decisions, based on manufacturing execution performance across manufacturing facilities. It helps identify bottlenecks in the production process and analyze impact on overall supply chain effectiveness. It also provides granular visibility into production costs, production cost variances, inventory levels, production quality and production adherence to plan to help with in-depth review of production performance.

The Oracle Manufacturing Analytics application also requires post-load processing mappings to populate its aggregate and derived tables.

17.2 Configuration Required Before a Full Load for Oracle Manufacturing Analytics

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

• Section 17.2.1, "Configuration Steps for Oracle Manufacturing Analytics for Oracle EBS"

• Section 17.2.2, "Domain Values and CSV Worksheet Files for Oracle Manufacturing Analytics"

17.2.1 Configuration Steps for Oracle Manufacturing Analytics for Oracle EBS

This section contains configuration steps that you need to perform on Oracle Supply Chain and Order Management Analytics with Oracle EBS Source Systems.

17.2.1.1 How to Configure the DAC Parameter for Process Items

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

To configure the DAC parameter for Process Items:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Tasks tab, and query for task named SDE_ORA_ProductDimension.

3. Display the Parameters tab in the lower pane.

4. 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.

17.2.1.2 How to Configure the DAC Parameter for ASCP plan for Planning

To load the ASCP plan in W_PEGGING_DETAILS_F from MSC_PLANS, the ETL tasks get the data from Oracle EBS applications. This section applies to all versions of Oracle EBS.

To configure the DAC parameter for ASCP plan:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Source System Parameters tab, and query for parameter named $$PEGGING_SRC_TYPE.

3. Display the Edit tab in the lower pane.

4. Edit the value of the parameter $$PEGGING_SRC_TYPE is ASCP for getting ASCP plan.

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

17.2.1.3 How to Configure the DAC Parameter for MRP plan for Planning

To load the MRP plan in W_PEGGING_DETAILS_F from MRP_PLANS, the ETL tasks get the data from Oracle EBS applications. This section applies to all versions of Oracle EBS.

To configure the DAC parameter for MRP plan:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Source System Parameters tab, and query for parameter named $$PEGGING_SRC_TYPE.

3. Display the Edit tab in the lower pane.

4. Edit the value of the parameter $$PEGGING_SRC_TYPE is MRP for getting MRP plan.

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

17.2.1.4 How to Configure the DAC Parameter for ASCP plan for Discrete Manufacturing Analytics

To load the ASCP plan in W_MFG_PLANNED_PRODUCTION_F from MSC_PLANS, the ETL tasks get the data from Oracle EBS applications. This section applies to all versions of Oracle EBS.

To configure the DAC parameter for ASCP plan:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Source System Parameters tab, and query for parameter named $$PLAN_SRC_TYPE.

3. Display the Edit tab in the lower pane.

4. Edit the value of the parameter $$PLAN_SRC_TYPE is ASCP for getting ASCP plan.

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

17.2.1.5 How to Configure the DAC Parameter for MRP plan for Discrete Manufacturing Analytics

To load the MRP plan in W_MFG_PLANNED_PRODUCTION_F from MRP_PLANS, the ETL tasks get the data from Oracle EBS applications. This section applies to all versions of Oracle EBS.

To configure the DAC parameter for MRP plan:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Source System Parameters tab, and query for parameter named $$PLAN_SRC_TYPE.

3. Display the Edit tab in the lower pane.

4. Edit the value of the parameter $$PLAN_SRC_TYPE is MRP for getting MRP plan.

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

17.2.1.6 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:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Configuration Tags tab.

3. Display the Subject Areas sub tab.

4. Query for the Configuration tag named 'Enable Project Dimensions'.

5. Select the Inactive check box for the selected Subject Area.

6. In the upper pane, display the Subject Areas tab, and Query for named 'Manufacturing%' subject areas and select the appropriate Subject Area.

7. In lower pane, display the Configuration Tags tab.

8. 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.

17.2.1.7 How to Disable Discrete Manufacturing Analytics

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

To disable Oracle Discrete Manufacturing analytics:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Configuration Tags tab.

3. Query for the Configuration tag named 'Manufacturing – Discrete'.

4. Display the Subject Areas sub tab.

5. Select the Inactive check box for the selected Subject Area.

6. In the upper pane, display the Subject Areas tab, and Query for named 'Manufacturing%' subject areas and select the appropriate Subject Area.

7. In lower pane, display the Configuration Tags tab.

8. Select the Inactive check box for the Configuration Tag named 'Manufacturing – Discrete'.

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

17.2.1.8 How to Disable Process Manufacturing Analytics

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

To disable Oracle Process Manufacturing analytics:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Configuration Tags tab.

3. Query for the Configuration tag named 'Manufacturing – Process'.

4. Display the Subject Areas sub tab.

5. Select the Inactive check box for the selected Subject Area.

6. In the upper pane, display the Subject Areas tab, and Query for named 'Manufacturing%' subject areas and select the appropriate Subject Area.

7. In lower pane, display the Configuration Tags tab.

8. 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.

17.2.1.9 How to Disable Discrete Manufacturing Quality

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

To disable Oracle Discrete Manufacturing Quality:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Configuration Tags tab.

3. Query for the Configuration tag named 'Manufacturing – Discrete'.

4. Display the Subject Areas sub tab.

5. Select the Inactive check box for the selected Subject Area.

6. In the upper pane, display the Subject Areas tab, and select the Subject Area named ' Quality – Discrete Quality '.

7. In lower pane, display the Configuration Tags tab.

8. Select the Inactive check box for the Configuration Tag named 'Manufacturing – Discrete'.

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

17.2.1.10 How to Disable Process Manufacturing Quality

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

To disable Oracle Process Manufacturing Quality:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Configuration Tags tab.

3. Query for the Configuration tag named 'Manufacturing – Process'.

4. Display the Subject Areas sub tab.

5. Select the Inactive check box for the selected Subject Area.

6. In the upper pane, display the Subject Areas tab, and select the Subject Area named 'Manufacturing – Process Quality'.

7. In lower pane, display the Configuration Tags tab.

8. 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.

17.2.1.11 How to Disable Project Dimensions for Inventory subject areas

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

To disable project dimensions:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.

2. Display the Configuration Tags tab.

3. Query for the Configuration tag named 'Enable Project Dimensions'.

4. Display the Subject Areas sub tab.

5. Select the Inactive check box for the selected Subject Area.

6. In the upper pane, display the Subject Areas tab, and Query for named 'Supply chain – Inventory%' and select the appropriate Subject Area.

7. In lower pane, display the Configuration Tags tab.

8. 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.

17.2.2 Domain Values and CSV Worksheet Files for Oracle Manufacturing Analytics

If you have modified or extended a seeded list of values, you must configure the CSV files for Oracle Manufacturing 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.

17.2.2.1 List of Domain Values and CSV Worksheet Files for Oracle Manufacturing Analytics

The Table below lists the domain values for Oracle Manufacturing 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 Manufacturing Analytics in the $PMServer\SrcFiles directory (for example, INFA_HOME\server\infa_shared\SrcFiles).

Table 17-1 Domain Values and CSV Worksheet Files for Oracle Manufacturing Analytics

Worksheet File Name	Description	Session
domainValues_TransactionTypeDimension_KanbanErrorCode11i.csv	Lists the Kanban Error Codes and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.2, "How to configure domainValues_TransactionTypeDimension_KanbanErrorCode11i.csv file for Kanban".	SDE_ORA_TransactionTypeDimension_KanbanErrorCode
domainValues_Xact_Types_MFG_CostElement_oraR12.csv	Lists the Process Manufacturing Cost Element types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.3, "How to configure domainValues_Xact_Types_MFG_CostElement_oraR12.csv file for Oracle Process Manufacturing".	SDE_ORA_TransactionTypeDimension_ProcessCostElement
domainValues_Xact_Types_CostElementTypes_ora11i.csv	Lists the Manufacturing Cost Element types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.4, "How to configure domainValues_Xact_Types_CostElementTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics".	SDE_ORA_TransactionTypeDimension_CST_Cost_Element
domainValues_SDE_ORA_StatusDimension_KanbanCardStatus11i.csv	Lists the Kanban Card Status and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.5, "How to configure domainValues_SDE_ORA_StatusDimension_KanbanCardStatus11i.csv file for Kanban".	SDE_ORA_StatusDimension_KanbanCardStatus
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 17.2.2.6, "How to configure domainValues_Status_MfgJob_ora11i.csv file for Oracle Discrete Manufacturing Analytics".	SDE_ORA_StatusDimension_Manufacturing_Discrete
domainValues_Status_Batch_oraR12.csv	Lists the Manufacturing Job Status-Process and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.7, "How to configure domainValues_Status_Batch_oraR12.csv file for Oracle Process Manufacturing Analytics".	SDE_ORA_StatusDimension_Manufacturing_Process
domainValues_Xact_Types_PlannedOrderTypes_ora11i.csv	Lists the Manufacturing Planned Order types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.8, "How to configure domainValues_Xact_Types_PlannedOrderTypes_ora11i.csv file for Discrete Manufacturing Analytics".	SDE_ORA_TransactionTypeDimension_PlannedOrderType
domainValues_SDE_ORA_StatusDimension_KanbanSupplyStatus11i.csv	Lists the Kanban Supply Status and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.9, "How to configure domainValues_SDE_ORA_StatusDimension_KanbanSupplyStatus11i.csv file for Kanban".	SDE_ORA_StatusDimension_KanbanSupplyStatus
domainValues_TransactionTypeDimension_KanbanSourceType11i.csv	Lists the Kanban Source Types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.10, "How to configure domainValues_TransactionTypeDimension_KanbanDocumentType11i.csv file for Kanban".	SDE_ORA_TransactionTypeDimension_KanbanSourceType
domainValues_TransactionTypeDimension_KanbanDocumentType11i.csv	Lists the Kanban Document Types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.11, "How to configure domainValues_TransactionTypeDimension_KanbanSourceType11i.csv file for Kanban".	SDE_ORA_TransactionTypeDimension_KanbanDocumentType
domainValues_SDE_ORA_TransactionTypeDimension_PlannedOrderType_Pegging11i.csv	Lists the Planned Order types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.12, "How to configure domainValues_SDE_ORA_TransactionTypeDimension_PlannedOrderType_Pegging11i.csv file for Planning".	SDE_ORA_TransactionTypeDimension_PlannedOrderType_Pegging
domainValues_Status_Disposition_Nonconformance_ora11i.csv	Lists the Disposition and Nonconformance Statuses and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.13, "How to configure domainValues_Status_Disposition_Nonconformance_ora11i.csv file for Discrete Manufacturing Quality".	SDE_ORA_StatusDimension_DispositionStatus, SDE_ORA_StatusDimension_NonconformanceStatus
domainValues_Xact_Types_QA_Char_Values_ora11i.csv	Lists the QA char types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.14, "How to configure domainValues_Xact_Types_QA_Char_Values_ora11i.csv file for Discrete Manufacturing Quality".	SDE_ORA_TransactionTypeDimension_Disp_Nonconf_Details
domainValues_Xact_Types_QA_Test_Evaluation_ora12.csv	Lists the QA Test Evaluation types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.15, "How to configure domainValues_Xact_Types_QA_Test_Evaluation_ora12.csv file for Process Manufacturing Quality".	SDE_ORA_TransactionTypeDimension_QA_Test_Evaluation
domainValues_Xact_Types_Quality_Grade_ora12.csv	Lists the QA Grades and the corresponding domain values for Oracle EBS-R12 application.For more information about how to edit this file, see Section 17.2.2.16, "How to configure domainValues_Xact_Types_Quality_Grade_ora12.csv file for Process Manufacturing Quality".	SDE_ORA_TransactionTypeDimension_Quality_Grade
domainValues_Xact_Types_Resource_Types_ora11i.csv	Lists the Resource types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.17, "How to configure domainValues_Xact_Types_Resource_Types_ora11i.csv for Oracle Discrete Manufacturing Analytics".	SDE_ORA_TransactionTypeDimension_Resource_Type
domainValues_Xact_Types_DemandClassTypes_ora11i.csv	Lists the Demand Class Types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.18, "How to configure domainValues_Xact_Types_DemandClassTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics".	SDE_ORA_TransactionTypeDimension_MfgDemandClass
domainValues_Xact_Types_MfgTypes_ora11i.csv	Lists the Mfg Types and the corresponding domain values for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.19, "How to configure domainValues_Xact_Types_MfgTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics".	SDE_ORA_TransactionTypeDimension_ManufacturingType
file_lkp_mfg_baseline_plans_ascp_ebs.csv	Lists the Plans in ASCP and set the Baseline plans for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.20, "How to configure file_lkp_mfg_baseline_plans_ascp_ebs.csv file for Oracle Discrete Manufacturing Analytics and Planning".	SDE_ORA_PeggingDetailsFact_ASCP, SDE_ORA_MfgPlannedProductionFact_ASCP, SDE_ORA_MfgPlanDimension_ASCP
file_lkp_mfg_baseline_plans_mrp_ebs.csv	Lists the Plans in MRP and set the Baseline plans for Oracle EBS application. For more information about how to edit this file, see Section 17.2.2.21, "How to configure file_lkp_mfg_baseline_plans_mrp_ebs.csv file for Oracle Discrete Manufacturing Analytics and Planning".	SDE_ORA_PeggingDetailsFact_MRP, SDE_ORA_MfgPlannedProductionFact_MRP, SDE_ORA_MfgPlanDimension_MRP
file_ bucket_range_master_ebs11i.csv	This file provides Inventory Aging (Onhand, Expiring) bucket ranges i.e, MIN_RANGE,MAX_RANGE to populate the W_SCM_BUCKET_D table. For more information about configuring bucket ranges, see Section 17.2.2.22, "How to configure file_ bucket_range_master_ebs11i.csv".	SDE_ORA_SCMBucketDimension

17.2.2.2 How to configure domainValues_TransactionTypeDimension_KanbanErrorCode11i.csv file for Kanban

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

1. Identify the Kanban error codes in your EBS source system by using the following SQL:

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

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_TransactionTypeDimension_KanbanErrorCode11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 4th line.

4. Map each Transaction type code to one Error code (KANBAN_ERROR_CODE) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.3 How to configure domainValues_Xact_Types_MFG_CostElement_oraR12.csv file for Oracle Process Manufacturing

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

1. Identify the Manufacturing (Process) Cost Element types in your EBS source system by using the following SQL:

   SELECT FND_LOOKUP_VALUES.LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE lookup_TYPE='COST_COMPONENT_TYPE' AND LANGUAGE='US'; 
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_MFG_CostElement_oraR12.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 7th line.

4. Map each Transaction type code to one Cost Element (CST_COST_ELEMENT_PRC) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.4 How to configure domainValues_Xact_Types_CostElementTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics

This section explains how to configure the domainValues_Xact_Types_CostElementTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics.

1. Identify the Manufacturing (Discrete) Cost Element types in your EBS source system by using the following SQL:

   SELECT CST_COST_ELEMENTS.COST_ELEMENT_ID FROM CST_COST_ELEMENTS; 
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_CostElementTypes_ora11i.csv file in a text editor.

3. Copy the COST_ELEMENT_ID to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 6th line.

4. Map each Transaction type code to one Cost Element (CST_COST_ELEMENT) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.5 How to configure domainValues_SDE_ORA_StatusDimension_KanbanCardStatus11i.csv file for Kanban

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

1. Identify the Kanban Card 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 = 'MTL_KANBAN_CARD_STATUS' AND FND_LOOKUP_VALUES.LANGUAGE = 'US';
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_SDE_ORA_StatusDimension_KanbanCardStatus11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the STATUS_CODE column in the file. The data must be copied starting from the 5th line.

4. Map each Status code to one Card Status (KANBAN_CARD_STATUS) domain value.

   Use commas to separate the entries.

5. Save and close the file.

17.2.2.6 How to configure domainValues_Status_MfgJob_ora11i.csv file for Oracle Discrete Manufacturing Analytics

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

1. Identify the Manufacturing (Discrete) 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'; 
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Status_MfgJob_ora11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the STATUS_CODE column in the file. The data must be copied starting from the 5th line.

4. Map each Status code to one Job Status (MFG_STATUS) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.7 How to configure domainValues_Status_Batch_oraR12.csv file for Oracle Process Manufacturing Analytics

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

1. Identify the Process Manufacturing Batch 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='GME_BATCH_STATUS' AND LANGUAGE ='US';
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Status_Batch_oraR12.csv file in a text editor.

3. Copy the LOOKUP_CODE to the STATUS_CODE column in the file.

   The data must be copied starting from the 7th line.

4. Map each Status code to one Batch Status (PROCESS_MFG_STATUS) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.8 How to configure domainValues_Xact_Types_PlannedOrderTypes_ora11i.csv file for Discrete Manufacturing Analytics

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

1. Identify the Manufacturing (Discrete) Planned Order types 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= 'MRP_ORDER_TYPE' AND FND_LOOKUP_VALUES.LANGUAGE = 'US';
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_PlannedOrderTypes_ora11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 48th line.

4. Map each Transaction type code to one Plan Order Type (PLAN_ORDER_TYPE) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.9 How to configure domainValues_SDE_ORA_StatusDimension_KanbanSupplyStatus11i.csv file for Kanban

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

1. Identify the Kanban Supply 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 = 'MTL_KANBAN_SUPPLY_STATUS' AND FND_LOOKUP_VALUES.LANGUAGE = 'US';
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_SDE_ORA_StatusDimension_KanbanSupplyStatus11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the STATUS_CODE column in the file. The data must be copied starting from the 9th line.

4. Map each Status code to one Kanban Supply Status domain value.

   Use commas to separate the entries.

5. Save and close the file.

17.2.2.10 How to configure domainValues_TransactionTypeDimension_KanbanDocumentType11i.csv file for Kanban

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

1. Identify the Kanban Document types in your EBS source system by using the following SQL:

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

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_TransactionTypeDimension_KanbanDocumentType11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 10th line.

4. Map each Transaction type code to one Kanban Document Type domain value.

   Use commas to separate the entries.

5. Save and close the file.

17.2.2.11 How to configure domainValues_TransactionTypeDimension_KanbanSourceType11i.csv file for Kanban

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

1. Identify the Kanban Source types in your EBS source system by using the following SQL:

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

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_TransactionTypeDimension_KanbanSourceType11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 6th line.

4. Map each Transaction type code to one Kanban Source Type domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.12 How to configure domainValues_SDE_ORA_TransactionTypeDimension_PlannedOrderType_Pegging11i.csv file for Planning

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

1. Identify the Planned Order types in your EBS source system by using the following SQL:

   SELECT ('SUPPLY'||'~'||FND_LOOKUP_VALUES.LOOKUP_CODE) AS LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE FND_LOOKUP_VALUES.LOOKUP_TYPE= 'MRP_ORDER_TYPE' AND FND_LOOKUP_VALUES.LANGUAGE = 'US' AND VIEW_APPLICATION_ID =700 AND SECURITY_GROUP_ID =0 UNION ALL SELECT ('DEMAND'||'~'||FND_LOOKUP_VALUES.LOOKUP_CODE) AS LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE FND_LOOKUP_VALUES.LOOKUP_TYPE='MSC_DEMAND_ORIGINATION' AND LANGUAGE ='US' AND VIEW_APPLICATION_ID =700 AND SECURITY_GROUP_ID =0;
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_SDE_ORA_TransactionTypeDimension_PlannedOrderType_Pegging11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 74th line.

4. Map each Transaction type code to one SUPPLY or DEMAND Plan Order Type domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.13 How to configure domainValues_Status_Disposition_Nonconformance_ora11i.csv file for Discrete Manufacturing Quality

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

1. Identify the Quality Disposition and Nonconformance status in your EBS source system by using the following SQL:

   SELECT QA_CHAR_VALUE_LOOKUPS.SHORT_CODE FROM QA_CHARS, QA_CHAR_VALUE_LOOKUPS WHERE QA_CHARS.CHAR_ID=QA_CHAR_VALUE_LOOKUPS.CHAR_ID AND QA_CHARS.NAME='Disposition Status'; SELECT QA_CHAR_VALUE_LOOKUPS.SHORT_CODE FROM QA_CHARS, QA_CHAR_VALUE_LOOKUPS WHERE QA_CHARS.CHAR_ID=QA_CHAR_VALUE_LOOKUPS.CHAR_ID AND QA_CHARS.NAME='Nonconformance Status';
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Status_Disposition_Nonconformance_ora11i.csv file in a text editor.

3. Copy the SHORT_CODE to the STATUS_CODE column in the file.

   The data must be copied starting from the 15th line.

4. Map each Status code to one Disposition or Nonconformance Status domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.14 How to configure domainValues_Xact_Types_QA_Char_Values_ora11i.csv file for Discrete Manufacturing Quality

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

1. Identify the Quality characteristic types in your EBS source system by using the following SQL:

   SELECT (QA_CHARS.CHAR_ID||'~'||QA_CHAR_VALUE_LOOKUPS.SHORT_CODE ) AS LOOKUP_CODE FROM QA_CHARS, QA_CHAR_VALUE_LOOKUPS WHERE QA_CHARS.CHAR_ID=QA_CHAR_VALUE_LOOKUPS.CHAR_ID AND NAME IN('Nonconformance Source','Nonconform Severity','Nonconform Priority','Nonconformance Type','Disposition','Disposition Action','Disposition Source') 
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_QA_Char_Values_ora11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 42nd line.

4. Map each Transaction type code to one Quality Characteristic Type domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.15 How to configure domainValues_Xact_Types_QA_Test_Evaluation_ora12.csv file for Process Manufacturing Quality

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

1. Identify the Quality test Evaluation types in your EBS source system by using the following SQL:

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

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_QA_Test_Evaluation_ora12.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 9th line.

4. Map each Transaction type code to one Evaluation Type (EVALUATION) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.16 How to configure domainValues_Xact_Types_Quality_Grade_ora12.csv file for Process Manufacturing Quality

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

1. Identify the Quality Grades in your EBS source system by using the following SQL:

   SELECT GRADE_CODE FROM MTL_GRADES; 
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_Quality_Grade_ora12.csv file in a text editor.

3. Copy the GRADE_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 14th line.

4. Map each Transaction type code to one Quality Grade (GRADE) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.17 How to configure domainValues_Xact_Types_Resource_Types_ora11i.csv for Oracle Discrete Manufacturing Analytics

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

1. Identify the Manufacturing Resource types 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= 'BOM_RESOURCE_TYPE' AND FND_LOOKUP_VALUES.LANGUAGE = 'US'; 
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_Resource_Types_ora11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 6th line.

4. Map each Transaction type code to one Resource Type (BOM_RESOURCE_TYPE) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.18 How to configure domainValues_Xact_Types_DemandClassTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics

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

1. Identify the Demand classed in your EBS source system by using the following SQL:

   SELECT FND_LOOKUP_VALUES.LOOKUP_TYPE, FND_LOOKUP_VALUES.LANGUAGE,FND_LOOKUP_VALUES.LOOKUP_CODE,FND_LOOKUP_VALUES.MEANING, FND_LOOKUP_VALUES.DESCRIPTION,FND_LOOKUP_VALUES.START_DATE_ACTIVE, FND_LOOKUP_VALUES.END_DATE_ACTIVE, FND_LOOKUP_VALUES.CREATED_BY, FND_LOOKUP_VALUES.CREATION_DATE,FND_LOOKUP_VALUES.LAST_UPDATED_BY, FND_LOOKUP_VALUES.LAST_UPDATE_DATE,'0' AS X_CUSTOM FROM FND_LOOKUP_VALUESWHERE FND_LOOKUP_VALUES.LOOKUP_TYPE= 'DEMAND_CLASS' AND FND_LOOKUP_VALUES.LANGUAGE = 'US';
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_DemandClassTypes_ora11i.cs file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 17th line.

4. Map each Transaction type code to one Demand classed ('DEMAND_CLASS') domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.19 How to configure domainValues_Xact_Types_MfgTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics

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

1. Identify the Manufacturing Work order types in your EBS source system by using the following SQL:

   SELECT FND_LOOKUP_VALUES.LOOKUP_TYPE,FND_LOOKUP_VALUES.LANGUAGE,FND_LOOKUP_VALUES.LOOKUP_CODE, FND_LOOKUP_VALUES.MEANING, FND_LOOKUP_VALUES.DESCRIPTION, FND_LOOKUP_VALUES.START_DATE_ACTIVE, FND_LOOKUP_VALUES.END_DATE_ACTIVE, FND_LOOKUP_VALUES.CREATED_BY, FND_LOOKUP_VALUES.CREATION_DATE,FND_LOOKUP_VALUES.LAST_UPDATED_BY, FND_LOOKUP_VALUES.LAST_UPDATE_DATE, '0' AS X_CUSTOMFROM FND_LOOKUP_VALUESWHERE FND_LOOKUP_VALUES.LOOKUP_TYPE= 'WIP_ENTITY' AND FND_LOOKUP_VALUES.LANGUAGE = 'US' 
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open domainValues_Xact_Types_Resource_Types_ora11i.csv file in a text editor.

3. Copy the LOOKUP_CODE to the XACT_TYPE_CODE column in the file.

   The data must be copied starting from the 11th line.

4. Map each Transaction type code to one Work order type ('WIP_ENTITY) domain value. Use commas to separate the entries.

5. Save and close the file.

17.2.2.20 How to configure file_lkp_mfg_baseline_plans_ascp_ebs.csv file for Oracle Discrete Manufacturing Analytics and Planning

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

1. Identify the ASCP Plans in your EBS source system by using the following SQL:

   SELECT ORGANIZATION_ID, PLAN_ID, SR_INSTANCE_ID FROM MSC_PLANS; 
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open file_lkp_mfg_baseline_plans_ascp_ebs.csv file in a text editor.

3. Copy the ORGANIZATION_ID, PLAN_ID and SR_INSTANCE_ID columns in the file.

   The data must be copied starting from the 3rd line.

4. Set the baseline plans under BASELINE_FLG column give Y to get the Baseline ASCP Plans.

5. Save and close the file.

17.2.2.21 How to configure file_lkp_mfg_baseline_plans_mrp_ebs.csv file for Oracle Discrete Manufacturing Analytics and Planning

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

1. Identify the MRP Plans in your EBS source system by using the following SQL:

   SELECT ORGANIZATION_ID, COMPILE_DESIGNATOR FROM MRP_PLANS; 
    
   

2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles), open file_lkp_mfg_baseline_plans_mrp_ebs.csv file in a text editor.

3. Copy the ORGANIZATION_ID and COMPILE_DESIGNATOR columns in the file. The data must be copied starting from the 3rd line.

4. Set the baseline plans under BASELINE_FLG column give Y to get the Baseline MRP Plans.

5. Save and close the file.

17.2.2.22 How to configure file_ bucket_range_master_ebs11i.csv

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

1. 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.

2. Configure the value of BUCKET_RANGE_NAME, MIN_RANGE and MAX_RANGE.

3. Save and close the file.