Inventory Management Command Center Setup

This chapter covers the following topics:

• Setting Up Inventory Management Command Center
• Setup and Configuration Steps
• Setting Profile Options for Inventory Management Command Center
• Setting Up Steps for Resource Requirements Components on the Shipping Dashboard
• Configuring Descriptive Flexfields for Search
• Loading Inventory Management Data - Inbound Details Data Load
• Loading Inventory Management Data - Inventory On Hand
• Loading Inventory Management Data - Inventory Cycle Counting
• Loading Inventory Management Data - Physical Inventory
• Loading Inventory Management Data - Inventory Reservations
• Loading Inventory Management Data - Delivery Details
• Loading Inventory Management Data - Space Utilization
• Loading Inventory Management Data - Track and Trace
• Loading Inventory Management Data - Activity Details
• Loading Inventory Management Data - Move Orders
• Collecting Item Supply/Demand Data
• Loading Inventory Management Data - Supply/Demand
• Loading Inventory Management Data - Transaction Management
• Loading Inventory Management Data - Replenishment
• Loading Inventory Management Data - Items Dashboard
• Loading Inventory Management Data - Movement Statistics
• Setup and Configuration Steps for the Kanban Dashboard
• Setting Profile Options for the Kanban Dashboard
• Enabling Electronic Kanban ECC Access Roles
• Creating Kanban Replenishment Snapshot
• Loading Electronic Kanban ECC Data

Inventory Management Command Center Configuration

Setting Up Inventory Management Command Center

See Inventory Management Command Center Overview.

The Inventory Management Command Center configuration setup must be completed after the installation and common configurations are completed as described in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework.

Setup and Configuration Steps

See Inventory Management Command Center Overview.

To complete setup of the Inventory Management Command Center:

1. Set profile options.

2. Set up steps for resource requirements components on the Shipping Dashboard.

3. Configure Descriptive Flexfields (DFFs) for search.

4. Load Inbound Details data.

5. Load Inventory On Hand data.

6. Load Cycle Counting data.

7. Load Physical Inventory data.

8. Load Inventory Reservations data.

9. Load Delivery Details data.

10. Load Space Utilization data.

11. Load Track and Trace data.

12. Load Activity Details data.

13. Load Move Orders data.

14. Collect Item Supply/Demand Data.

15. Load Supply/Demand data.

16. Load Transaction Management data.

17. Load Replenishment data.

18. Load Items data.

19. Load Movement Statistics and Exceptions data.

    Note: System administrators must assign the Movement Statistics ECC Data Load concurrent program to the request group associated with a responsibility.

    Prerequisite: For the Movement Statistics and Exceptions dashboards to display accurate data, schedule the following programs to run periodically in Oracle Inventory:

    • Movement Statistics Processor

    • Movement Statistics Exception Report

    • Movement Statistics Report

Setting Up the Kanban Dashboard

To complete the Kanban Dashboard configuration setup, see Setup and Configuration Steps for the Kanban Dashboard.

Setting Profile Options for Inventory Management Command Center

See Inventory Management Command Center Overview.

Set a value for each user profile option to specify how Inventory Management Command Center controls access to and processes data:

Profile Option Name	Description
INV: ECC Max Days for Track and Trace	This site-level profile option specifies the maximum number of days that the Inventory Track and Trace Data Load program considers to load data. The default value is 30.
INV: MVT ECC Full Load Days	This site-level profile option determines the age of movement records that the Full Load option of the Movement Statistics ECC Data Load program selects. The default value is 365 (that is 365 days past from the current system date). The full load option selects only the movement records whose transaction date is within the profile value. For example, if the profile is set to 365 days, then the full load does not select a back dated movement record created today for a transaction date in January 2021. Based on your business requirement, decide how many years of movement records data that you want to view. You can specify the number of days or else the program considers the default value of 365 days. The data load program's incremental load option works based on a record's last update date value. On 29th January, 2025, when you create a back dated record with the transaction date in January 2021, the last update value is recorded as 29/Jan/2025. The profile value is set as 365 days. Because 29/Jan/2025 is later than the last data load run date, the incremental load selects the record.
INV: Run Items Dashboard Full Load in Parallel Mode	This site-level profile option determines whether the "Items Dashboard Data Load" program with the Full Load option processes the following datasets of the Items Dashboard in a sequential or a parallel manner. Organization Items (inv-item-grain) Item Category Sets (inv-item-categories) Item Cross-Reference (inv-cross-ref) Manufactured Items (inv-item-manufactures) Item Revisions (inv-item-revisions) Related Items (inv-related-item) By default the profile is set to FALSE, which means that the Full Load option loads data from the datasets in a sequential manner (data load happens for one dataset after the other). If the profile is set to TRUE, then the data load program initiates a child concurrent program for each dataset and the data is loaded in parallel for each dataset. Important: Setting the profile to TRUE will consume resources on the server. Therefore, you must set the value to TRUE only when the server is free.
WSH: Days for Full Data Load of Shipped Details	This site-level profile option specifies the age of shipped delivery details selected by the Full Load option of the Delivery Details Data Load program. The application loads all delivery details that were ship confirmed in the specified number of days before the current day. For example, the current date is 04-Feb-2023 and there is a requirement to view delivery details that were ship confirmed on 01-Feb-2023. Set the profile option value to 3. If you set a value, then to load the shipped delivery details, you must run the Delivery Details Data Load program with the full load option. After you set the value and run the data load program with the full load option, the following dashboards show delivery details that were shipped along with open delivery details. Shipping Dashboard of the Inventory Management Command Center: You must first make sure that this dashboard displays shipped delivery details before you verify them on the 360 View dashboard. See Shipping Dashboard 360 View dashboard of Order Management Command Center See 360 View Dashboard, Oracle Order Management User's Guide By default, the profile option's setting is blank (null). The application considers null equal to zero. Open delivery details and those shipped on the current day are always loaded regardless of the profile value.
FND: ECC Disable Descriptive Flexfield Note: This an Application Object Library profile option.	This profile option excludes descriptive flexfields (DFFs) from the data load in ECC. If you do not want to load data of DFFs, then set the profile option value to internal names of the DFFs. To exclude the data load of a DFF to the Items Dashboard, enter the DFF internal name as the value. You can specify multiple values using a comma-separated list. The following is a list of the DFF internal names that you can enter to exclude their data load to the Items Dashboard. MTL_SYSTEM_ITEMS MTL_CATEGORIES MTL_CROSS_REFERENCES MTL_ITEM_REVISIONS MTL_MG_PART_NUMBERS MTL_RELATED_ITEMS Important: If you add or remove values from the profile option, then you must run the Items Dashboard Data Load program with the Load Type parameter set to Full Load. See Load Inventory Management Data - Items Dashboard.

Setting Up Steps for Resource Requirements Components on the Shipping Dashboard

See Setup and Configuration Steps for Inventory Management Command Center.

The Shipping Dashboard uses the historical data of the Labor Management module of Oracle Warehouse Management to estimate the picking time that is required to complete delivery details.

To ensure that the Pending Workload (Hours) metric and the charts in the Resource Requirements tab display data, complete the following steps in Oracle Warehouse Management:

• Define labor standards. See Labor Management Setup, Oracle Warehouse Management Implementation Guide.

• Run the Expected Resource Requirement Analysis concurrent program to calculate the outstanding work for the warehouse. See Concurrent Requests, Oracle Warehouse Management User's Guide.

Note: The Shipping Dashboard does not populate the estimated time required for delivery details if there are no changes to delivery details, deliveries, or trips and you run the Expected Resource Requirement Analysis concurrent program and the Delivery Details Data Load program with the incremental load option.

The Shipping Dashboard populates the estimated time required for delivery details only in the following cases:

• Run the Expected Resource Requirement Analysis program and the Delivery Details Data Load program with the full load option.

• Run the Expected Resource Requirement Analysis program after booking an order and then submit the Delivery Details Data Load program with the incremental load option.

• Run the Expected Resource Requirement Analysis program and then update any attribute for a delivery detail, a delivery, a trip, or other existing attributes for which the incremental load option of the Delivery Details Data Load program includes the details after the data load submission.

Populating Time Estimates on the Shipping Dashboard After Status Change

If the status of a delivery detail is updated from Ready to Release or Backordered to Released to Warehouse (also conversely from Released to Warehouse to Ready to Release or Backordered), then run the followings programs in this given sequence to populate the estimated time required on the Shipping Dashboard:

1. Expected Resource Requirement Analysis

2. Delivery Details Data Load with the incremental load option

Configuring Descriptive Flexfields for Search

See Setup and Configuration Steps for Inventory Management Command Center.

Enterprise command centers support searching on descriptive flexfield (DFFs) attributes. After you configure DFFs you must run the data load process to make the DFF attributes available in the command center.

For additional information on configuring and customizing flexfields, see the Oracle E-Business Suite Flexfields Guide and My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework, Release 12.2.

Dashboard	Data Set	DFF Title	DFF Name	DFF Attribute Group Name	Displayed In
Shipping	Shipping Delivery Details (Delivery_details)	Additional Delivery Details Information	WSH_DELIVERY_DETAILS	Additional Delivery Details Information	Available Refinements and Delivery Details results table
Shipping	Shipping Delivery Details (Delivery_details)	Additional Delivery Information	WSH_NEW_DELIVERIES	Additional Delivery Information	Available Refinements and Deliveries results table
Cycle Counting	Inventory Cycle Counting (inv-cyclecounting)	Cycle Count Headers	MTL_CYCLE_COUNT_HEADERS	Cycle Count Headers	Available Refinements and Available Counts results table
Cycle Counting	Inventory Cycle Counting (inv-cyclecounting)	Cycle Count Entries	MTL_CYCLE_COUNT_ENTRIES	Cycle Count Entries	Available Refinements and Available Counts results table
Physical Inventory	Inventory Physical Counting (inv-physical-inventory)	Physical Inventory	MTL_PHYSICAL_INVENTORIES	Physical Inventory	Available Refinements and results tables
Physical Inventory	Inventory Physical Counting (inv-physical-inventory)	Inventory Physical Counting (inv-physical-inventory)	MTL_PHYSICAL_INVENTORY_TAGS	Physical Inventory Tags	Available Refinements and results tables
Reservations	Reservations (inv-reservations)	Reservations	MTL_RESERVATIONS	Reservations	Available Refinements and Demand results table
Receiving	Inbound Details (Inbound_Details)	Receiving Transactions Additional Information	RCV_TRANSACTIONS	Receiving Transactions	Available Refinements and Pending Inspection and Pending Deliver results tables
Receiving	Inbound Details (Inbound_Details)	Shipment Line Additional Information	RCV_SHIPMENT_LINES	Receiving Transactions	Available Refinements and Pending Receiving results table
Space Utilization	Inventory Space Utilization (inv-space)	Maintain Lot Number	MTL_LOT_NUMBERS	Lot Additional details	Available Refinements and results table
Space Utilization	Inventory Space Utilization (inv-space)	Stock Locators	MTL_ITEM_LOCATIONS	Locator Additional Details	Available Refinements and results table
Move Orders	Inventory Move Orders (inv-move-orders)	Transfer Order Header	MTL_TXN_REQUEST_HEADERS	Transfer Order Header	Available Refinements Line Details result table
Move Orders	Inventory Move Orders (inv-move-orders)	Transfer Order Lines	MTL_TXN_REQUEST_LINES	Transfer Order Lines	Available Refinements Line Details result table
Items	Organization Items (inv-item-grain)	Items	MTL_SYSTEM_ITEMS	Item Additional Information	Available Refinements Items results grid > Record Details Attributes tab > Item Attributes results table
Items	Item Category Sets (inv-item-categories)	Item Categories	MTL_CATEGORIES	Item Category Additional Information	Available Refinements Categories grid > Record Details
Items	Item Cross-Reference (inv-cross-ref)	Item cross-references	MTL_CROSS_REFERENCES	Item Cross-Reference Additional Information	Available Refinements Cross-References grid > Record Details
Items	Item Revisions (inv-item-revisions)	Item Revisions	MTL_ITEM_REVISIONS	Item Revisions Additional Information	Available Refinements Revisions tab results table
Items	Manufactured Items (inv-item-manufactures)	Manufacturer Part Number	MTL_MFG_PART_NUMBERS	Item Manufacturers Additional Information	Available Refinements Manufactures grid > Record Details
Items	Related Items (inv-related-item)	Item Relationships	MTL_RELATED_ITEM	Related Items Additional Information	Available Refinements Related Items grid > Record Details
Transaction Management	Inventory Transaction Management (inv-transaction-management)	Receiving Transactions Interface	RCV_TRANSACTIONS_INTERFACE_DFV	Receiving Transactions Interface	Available Refinements Receiving Interface results table
Transaction Management	Inventory Transaction Management (inv-transaction-management)	Cycle Count Entries Interface	MTL_CC_ENTRIES_INTERFACE_DFV	Cycle Count Entries Interface	Available Refinements Cycle Count Interface results table
Transaction Management	Inventory Transaction Management (inv-transaction-management)	Reservations Interface	MTL_RESERVATIONS_INTERFACE_DFV	Reservations Interface	Available Refinements Reservations Interface results table
Transaction Management	Inventory Transaction Management (inv-transaction-management)	Transaction Interface	MTL_TRANSACTIONS_INTERFACE_DFV	Transaction Interface	Available Refinements Transactions results table

Loading Inventory Management Data - Inbound Details Data Load

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Inventory Management Command Center, run the concurrent program Inbound Details Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inbound Details Data Load

To run the Inbound Details Data Load:

1. In the Name field, select Inbound Details Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all inbound data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Submit the concurrent request.

7. Review your request using the Requests page.

8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Inventory On Hand

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Inventory Management Command Center, run the concurrent program Inventory On Hand Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inventory On Hand Data Load

To run the Inventory On Hand Data Load:

1. In the Name field, select Inventory On Hand Data Load.

2. Select Full Load as the load type to load all on-hand data from EBS.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Submit the concurrent request.

7. Review your request using the Requests page..

8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Inventory Cycle Counting

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Inventory Management Command Center, run the concurrent program Inventory Cycle Counting Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inventory Cycle Counting Data Load

To run the Inventory Cycle Counting Data Load

1. In the Name field, select Inventory Cycle Counting Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all cycle count data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must first run the program using the Metadata Load option, so that the DFF changes are displayed in the command center. Note that the full data load process includes the metadata load.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Submit the concurrent request.

7. Review your request using the Requests page.

8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Physical Inventory

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Physical Inventory dashboard, run the concurrent program Inventory Physical Inventory Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inventory Physical Inventory Data Load

To run the Inventory Physical Inventory Data Load:

1. In the Name field, select Inventory Physical Inventory Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all physical inventory data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must first run the program using the Metadata Load option, so that the DFF changes are displayed in the command center. Note that the full data load process includes the metadata load.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Select the organization code for which you want to load data. You can sequentially load data for each organization using this parameter. You must run a full load for the selected organization before you run the incremental load for that organization.

   The following rules apply to the Organization Code parameter:

   • If you select a value in this parameter and Reset Data is TRUE, then when you run the full load, the application removes data for all other organizations and retains data only for the selected organization.

   • If you select a value in this parameter and Reset Data is FALSE, then the application appends data of the selected organization to the existing data.

7. Select the physical inventory for which you want to load data. You can sequentially load data for each physical inventory using this parameter.

8. Use the Reset Data parameter with caution. If you run full load for the first time or want to reset the data, then set the parameter value to TRUE. If set to TRUE, this action clears all the data that was loaded earlier and loads the new data for the selected operating unit. After the completion of full load, data of only one organization will be available in the ECC data store.

   • For subsequent full loads, to append the new data to the data set, set this value to FALSE.

   • For incremental loads, this parameter is not applicable.

9. Submit the concurrent request.

10. Review your request using the Requests page.

11. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Inventory Reservations

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Inventory Management Command Center, run the concurrent program Inventory Reservations Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inventory Reservations Data Load

To run the Inventory Reservations Data Load:

1. In the Name field, select Inventory Reservations Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all inventory reservations data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must first run the program using the Metadata Load option, so that the DFF changes are displayed in the command center. Note that the full data load process includes the metadata load.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Submit the concurrent request.

7. Review your request using the Requests page.

8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Delivery Details

See Setup and Configuration Steps for Inventory Management Command Center and Set Up Steps for Resource Requirements Components on the Shipping Dashboard.

To process and load data from Oracle E-Business Suite (EBS) to the Inventory Management Command Center, run the concurrent program Delivery Details Data Load, from the Shipping Interfaces window.

Note: This data load incorporates details into the Shipping Dashboard from orders created in Order Management only.

(N) Manufacturing and Distribution Manager > Order Management > Shipping > Interfaces

Delivery Details Data Load

To run the Delivery Details Data Load:

1. In the Name field, select Delivery Details Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all inventory delivery details data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must first run the program using the Metadata Load option, so that the DFF changes are displayed in the command center. Note that the full data load process includes the metadata load.

3. To load data for a specific organization, select the appropriate Organization Code.

4. If you select an Organization Code and set Reset Dataset to True, then when you run the Full Load, the application removes data for all other organizations and retains data only for the selected organization. If you select an Organization Code and set Reset Dataset to False, then the application appends data for the selected organization to existing data in the dashboard.

   Note: You must run a Full Load for the selected organization before you run the incremental load for that organization.

   Reset Dataset has no impact on incremental loads.

   You can run the metadata load only for a full load with Reset Dataset set to True.

5. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

6. Select the log level that you want the program to report. The default value is ERROR.

7. Select TRUE to enable SQL trace. Otherwise, select FALSE.

8. Submit the concurrent request.

9. Review your request using the Requests page.

10. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Space Utilization

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Inventory Management Command Center, run the concurrent program Inventory Space Utilization Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inventory Space Utilization Data Load

To run the Inventory Space Utilization Data Load:

1. In the Name field, select Inventory Space Utilization Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all inventory space utilization data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must first run the program using the Metadata Load option, so that the DFF changes are displayed in the command center. Note that the full data load process includes the metadata load.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Submit the concurrent request.

7. Review your request using the Requests page.

8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Track and Trace

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Track and Trace dashboard of the Inventory Management Command Center, run the concurrent program Inventory Track and Trace Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

The Inventory Track and Trace Data Load program runs for INV owned data sets (Inventory Trace Suppliers, Inventory Trace Inbound Onhand, Inventory Trace Move, Inventory Trace Issues, and Inventory Trace Sales Orders) all at a time. All these data loads are run in sequence.

The following table lists the data sets that the Track and Trace Dashboard uses.

Data Sets for the Track and Trace Dashboard

Data Set Key	Display Name	Description
inv-trace-suppliers	Inventory Trace Suppliers	Stores supplier details such as purchase orders, intransit shipments, ASNs, requisitions, and work orders. This data set also stores receipt transactions that have subinventory and location details.
inv-trace-inbound-onhand	Inventory Trace Inbound Onhand	Stores items and lots information including data for inbound, in receiving, and on-hand quantities.
inv-trace-move	Inventory Trace Move	Stores data for subinventory transfer and backflush transfers between subinventories.
inv-trace-issues	Inventory Trace Issues	Stores data for transactions that have issues.
inv-trace-salesorders	Inventory Trace Sales Orders	Stores data for sales orders and picking activities. Note: This data set stores data for packing activities only if these activities are performed after the pick release in the staging area for WMS organizations.
gnt-wodetails	Work Orders	Stores data for work orders such as details for job, organization, project, and task.

Important: To load data for the Work Orders (gnt-wodetails) data set, run the WIP ECC Data Load program. See Loading WIP ECC Data, Oracle Work in Process User's Guide.

To run data load for all the data sets that the Track and Trace dashboard uses, you can create a custom request set by including the Inventory Track and Trace Data Load program and the WIP ECC Data Load program.

Inventory Track and Trace Data Load

To run the Inventory Track and Trace Data Load:

1. In the Name field, select Inventory Track and Trace Data Load.

2. Select the appropriate load type.

   • Full Load: This process loads all track and trace data and is required to be run for the first data load. If you select and run full load for subsequent requests, then this program clears all track and trace data from ECC and loads fresh data.

   • Incremental Load: This process loads the data modified and updated from the previous load only. Incremental load should be scheduled to run as often as required to keep the ECC dashboard current.

   • Metadata Load: This load type is not applicable to the Track and Trace Dashboard.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Select the organization code for which you want to load data. You can sequentially load data for each organization using this parameter.

   The following rules apply to the Organization Code parameter:

   • If this parameter is blank, then during a full load, the program loads data for the maximum number of days specified in the INV: ECC Max Days for Track and Trace profile option.

   • If you select a value in this parameter and Reset Data is TRUE, then when you run the full load, the application removes data for all other organizations and retains data only for the selected organization.

   • If you select a value in this parameter and Reset Data is FALSE, then the application appends data of the selected organization to the existing data.

7. Use the Reset Data parameter with caution. The default value is FALSE. If you run full load for the first time or want to reset the data, then set the parameter value to TRUE. If set to TRUE, this action clears all the data that was loaded earlier, and loads the new data for the selected operating unit. After the completion of full load, data of only one organization will be available in the ECC data store.

   • For subsequent full loads, to append the new data to the data set, set this value to FALSE.

   • For incremental loads, this parameter is not applicable.

8. Submit the concurrent request.

9. Review your request using the Requests page.

10. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Activity Details

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Inventory Management Command Center, run the concurrent program Activity Details Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Activity Details Data Load

To run the Activity Details Data Load:

1. In the Name field, select Activity Details Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all inventory activity details data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Submit the concurrent request.

7. Review your request using the Requests page.

8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Move Orders

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Move Orders dashboard, run the concurrent program Inventory Move Orders Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inventory Move Orders Data Load

The Inventory Move Orders Data Load program loads data to the following data sets:

• inv-move-orders

• inv-move-order-allocations

To run the Inventory Move Orders Data Load:

1. In the Name field, select Inventory Move Orders Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all move orders and allocations data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must first run the program using the Metadata Load option, so that the DFF changes are displayed in the command center. Note that the full data load process includes the metadata load.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Select the organization code for which you want to load data. You can sequentially load data for each organization using this parameter. You must run a full load for the selected organization before you run the incremental load for that organization.

   The following rules apply to the Organization Code parameter:

   • If you select a value in this parameter and Reset Data is TRUE, then when you run the full load, the application removes data for all other organizations and retains data only for the selected organization.

   • If you select a value in this parameter and Reset Data is FALSE, then the application appends data of the selected organization to the existing data.

7. Use the Reset Data parameter with caution. If you run full load for the first time or want to reset the data, then set the parameter value to TRUE. If set to TRUE, this action clears all the data that was loaded earlier and loads the new data for the selected operating unit. After the completion of full load, data of only one organization will be available in the ECC data store.

   • For subsequent full loads, to append the new data to the data set, set this value to FALSE.

   • For incremental loads, this parameter is not applicable.

8. Submit the concurrent request.

9. Review your request using the Requests page.

10. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Collecting Item Supply/Demand Data

See Setup and Configuration Steps for Inventory Management Command Center.

To collect supply, demand, and on-hand quantity data for all items across organizations, run the concurrent program Inventory Item Supply/Demand. This program collects the items supply and demand data and loads it to the Oracle E-Business Suite (EBS) "INV_ECC_SUPPLY_DEMAND" table.

Important: You must run this program before you run the Inventory Supply/Demand Data Load program.

Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inventory Item Supply/Demand

To run Inventory Item Supply/Demand:

1. In the Name field, select Inventory Item Supply/Demand.

2. Select the organization for which you want to collect data. You must run a full load for the selected organization before you run the incremental load for that organization. You can sequentially collect data for each organization using this parameter. If you leave this parameter blank, then the program collects data for all the organizations.

3. Select the category set for which you want to collect data. The default value is Inv.Items.

4. Select the category name for which you want to collect data.

5. Enter the number of days for which you want to collect data. The default value is 15.

6. Select the appropriate mode for data load.

   • Full Load: Loads all item supply and demand data. The default value is Full Load.

   • Incremental Load: Loads only the data modified since the previous load.

   • Metadata Load: This mode is not applicable.

7. Submit the concurrent request.

8. Review your request using the View Requests window.

Loading Inventory Management Data - Supply/Demand

See Setup and Configuration Steps for Inventory Management Command Center.

Prerequisite: Run the concurrent program Inventory Item Supply/Demand, which collects and loads data to the Oracle E-Business Suite (EBS) "INV_ECC_SUPPLY_DEMAND" table. See Collecting Item Supply/Demand Data.

To process and load data from Oracle E-Business Suite (EBS) to the ECC data store for the Supply/Demand Dashboard, run the concurrent program Inventory Supply/Demand Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

Inventory Supply/Demand Data Load

To run the Inventory Supply/Demand Data Load:

1. In the Name field, select Inventory Supply/Demand Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all supply and demand data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: This load type is not applicable.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Submit the concurrent request.

7. Review your request using the Requests page.

8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Transaction Management

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Transaction Management Dashboard of the Inventory Management Command Center, run the concurrent program Inventory Transaction Management Data Load. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

The Inventory Transaction Management Data Load program runs for the Inventory Management (INV-TRANSACTION-MANAGEMENT) data set. This data set retrieves data from the following interface tables.

Interface Tables

Interface	Interface Table
Transaction Open Interface	MTL_TRANSACTIONS_INTERFACE
Pending Transactions	MTL_MATERIAL_TRANSACTIONS_TEMP
Receiving Open Interface	RCV_TRANSACTIONS_INTERFACE
Cycle Count Open Interface	MTL_CC_ENTRIES_INTERFACE
Reservations Interface	MTL_RESERVATIONS_INTERFACE
Object Genealogy Interface	MTL_OBJECT_GENEALOGY_INTERFACE

Inventory Transaction Management Data Load

To run the Inventory Transaction Management Data Load:

1. In the Name field, select Inventory Transaction Management Data Load.

2. Select the appropriate load type.

   • Full Load: This process loads all transaction management data and is required to be run for the first data load. If you select and run full load for subsequent requests, then this program clears all transaction management data from ECC and loads fresh data.

   • Incremental Load: This process loads the data modified and updated from the previous load only. Incremental load should be scheduled to run as often as required to keep the ECC dashboard current.

   • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must run the program first with the Metadata Load option and then with the Full Load option so that the DFF changes are displayed on the dashboard. Note that the full data load process includes the metadata load.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Select the organization code for which you want to load data. You can sequentially load data for each organization using this parameter. You must run a full load for the selected organization before you run the incremental load for that organization.

   The following rules apply to the Organization Code parameter:

   • If you select a value in this parameter and Reset Data is TRUE, then when you run the full load, the application removes data for all other organizations and retains data only for the selected organization.

   • If you select a value in this parameter and Reset Data is FALSE, then the application appends data of the selected organization to the existing data.

7. Use the Reset Data parameter with caution. If you run full load for the first time or want to reset the data, then set the parameter value to TRUE. If set to TRUE, this action clears all the data that was loaded earlier and loads the new data for the selected organization. After the completion of full load, data of only one organization will be available in the ECC data store.

   • For subsequent full loads, to append the new data to the data set, set this value to FALSE.

   • For incremental loads, this parameter is not applicable.

8. Submit the concurrent request.

9. Review your request using the Requests page.

10. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Replenishment

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the ECC data store for the Replenishment Dashboard, run the concurrent program Inventory Replenishment Data Load.

Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

The data load program loads data to the Inventory Replenishment (inv-replenishment) data set.

Inventory Replenishment Data Load

To run the Inventory Replenishment Data Load:

1. In the Name field, select Inventory Replenishment Data Load.

2. Select the appropriate load type.

   • Full Load: Loads all replenishment data from EBS.

   • Incremental Load: Loads only the data that has been modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: This load type is not applicable for the Replenishment Dashboard.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Select the organization code for which you want to load data. You can sequentially load data for each organization using this parameter.

   The following rules apply to the Organization Code parameter:

   • If you select a value in this parameter and Reset Data is TRUE, then when you run the full load, the application removes data for all other organizations and retains data only for the selected organization.

   • If you select a value in this parameter and Reset Data is FALSE, then the application appends data of the selected organization to the existing data.

7. Use the Reset Data parameter with caution. The default value is FALSE. If you run full load for the first time or want to reset the data, then set the parameter value to TRUE. If set to TRUE, this action clears all the data that was loaded earlier and loads the new data for the selected operating unit. After the completion of full load, data of only one organization will be available in the ECC data store.

   For subsequent full loads, to append the new data to the data set, set this value to FALSE.

   For incremental loads, this parameter is not applicable.

8. Submit the concurrent request.

9. Review your request using the Requests page.

10. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Items Dashboard

See Setup and Configuration Steps for Inventory Management Command Center.

To process and load data from Oracle E-Business Suite (EBS) to the Inventory Management Command Center, run the concurrent program Items Dashboard Data Load.

Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Other > Requests > Run

You can also run this program using the following navigation:

1. Item Manager (responsibility) > Item Catalog > View Concurrent Requests

2. On the Requests page, click Submit Request

Adding the Items Dashboard Data Load Program to a Responsibility

By default, the Items Dashboard Data Load program is available from the Manufacturing and Distribution Manager and Item Manager responsibilities.

To add the Items Dashboard Data Load program to a different responsibility, for example, Development Manager, follow these steps:

Prerequisite Step

Find the request group that is attached to the Development Manager responsibility.

1. Navigate to System Administrator > Security > Responsibility > Define.

2. Query your responsibility (Development Manager) and the request group (Development Manager RG - EGO_DM_RG) associated with the Development Manager responsibility.

Steps to add the Items Dashboard Load program

1. Go to Security > Responsibility > Request.

2. In the Requests region, query the request group that you noted in the prerequisite step.

3. Add the Items Dashboard Data Load program to the request group.

Items Dashboard Data Load

To run the Items Dashboard Data Load:

1. In the Name field, select Items Dashboard Data Load.

2. Enter the name in the System Name field. The default value is EBS.

3. Select the appropriate load type.

   • Full Load: Loads all for the Items Dashboard data from EBS.

   • Incremental Load: Loads only the data modified since the previous load. Schedule incremental loads to run as often as required to keep the ECC dashboard current.

   • Metadata Load: Loads Descriptive Flexfield (DFF) metadata. If there are any changes to the DFF definition, then you must first run the program using the Metadata Load option, so that the DFF changes are displayed in the command center. Note that the full data load process includes the metadata load.

4. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

5. Select the log level that you want the program to report. The default value is ERROR.

6. Select TRUE to enable SQL trace. Otherwise, select FALSE.

7. Specify one or more organizations to load data. Enter organization code as the value. You can enter multiple values using a comma-separated list. For example, AB1,M1,W1.

   Important: Note that the data load program ends in an error in the following cases:

   • Organization code is invalid

   • Delimiter is other than comma

8. If you enter multiple organization codes and set Reset Dataset to True, then when you run the Full Load, the application removes data for all other organizations and retains data only for the selected organizations. For multiple organization codes if you set Reset Dataset to False, then the application appends data of the selected organizations to existing data in the dashboard.

   Note: You must run a Full Load for the selected organizations before you run the incremental load for the organizations.

   Reset Dataset has no impact on incremental loads.

   The metadata load is triggered for a full load with Reset Dataset set to True.

9. Submit the concurrent request.

10. Review your request using the Requests page.

11. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Loading Inventory Management Data - Movement Statistics

To process and load data from Oracle E-Business Suite (EBS) to the Movement Statistics and Exceptions dashboards of the Inventory Management Command Center, run the Movement Statistics ECC Data Load concurrent program. Run this program from the Submit Request window.

(N) Manufacturing and Distribution Manager > Material Planning > Others > Request

You can also use the following navigation:

Manufacturing and Distribution Manager > Inventory > Requests

The data load program loads data to the following data sets:

• Movement Statistics (inv-mgd-mvt-stats)

• Exceptions (inv-mgd-mvt-exceptions)

Prerequisite

Review the INV: MVT ECC Full Load Days profile option value before you run the data load.

Movement Statistics ECC Data Load

To run the Movement Statistics ECC Data Load:

1. In the Name field, select Movement Statistics ECC Data Load.

2. Select the appropriate load type. Only Full Load and Incremental Load are applicable to this concurrent program.

   • Full Load: This process loads all movement statistics and exceptions data and is required to be run for the first data load. If you select and run full load for subsequent requests, then this program clears the previous movement statistics and exceptions data from the dashboard and loads fresh data.

   • Incremental Load: This process loads the data modified and updated from the previous load only. Incremental load must be scheduled to run as often as required to keep the ECC dashboard current.

3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. If the field is blank, then the data will be loaded for the base language only (usually US).

4. Select the log level that you want the program to report. The default value is ERROR.

5. Select TRUE to enable SQL trace. Otherwise, select FALSE.

6. Submit the concurrent request.

7. Review your request using the Requests page.

8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.

Setup and Configuration Steps for the Kanban Dashboard

To complete setup of the Kanban Dashboard:

1. Set profile options.

2. Enable Electronic Kanban ECC access roles.

3. Create Kanban Replenishment Snapshot.

   Caution: You must run the Create Kanban Replenishment Snapshot program before you run the Electronic Kanban ECC Data Load concurrent program.

4. Load Electronic Kanban data.

Setting Profile Options for the Kanban Dashboard

See Setup and Configuration Steps for the Kanban Dashboard.

Set a value for the following profile options to use the Kanban Dashboard:

Profile Option Name	Description	Default Value
FLM: Enable E-Kanban	Set this site-level profile value to Yes to enable E-Kanban Warning: If Oracle Electronic Kanban is enabled for your organization, then the regular Kanban windows in Oracle Inventory will not be available. However, the existing Oracle Inventory Kanban data will be visible in Oracle Electronic Kanban.	Null

Enabling Electronic Kanban ECC Access Roles

See Setup and Configuration Steps for the Kanban Dashboard.

Ensure that you set up and assign the following roles to use the Kanban Dashboard:

1. Set up the eKanban Super User responsibility.

2. Assign the Electronic Kanban ECC Dashboard user role.

Creating Kanban Replenishment Snapshot

See Setup and Configuration Steps for the Kanban Dashboard.

The Create Kanban Replenishment Snapshot program generates snapshot data for On Hand, Safety Stock, and Daily Demand line graphs in the Kanban Dashboard, View Replenishment History chart. This chart is available from the following tabs:

• Inventory Health

• Kanban Demand

Important: You must schedule this program to run daily. If the snapshot program is not run regularly, then line graphs are not displayed, and sometimes broken lines are displayed. The program does not generate snapshots for past dates. If the program is run more than once in a day, then the minimum value of the respective quantities at day level will be displayed in the chart.

You can find this concurrent program using the eKanban Super User responsibility.

Run the concurrent program from the Submit Request window.

(N) eKanban Super User > View > Requests > Find Requests

Create Kanban Replenishment Snapshot Program

To create Kanban replenishment snapshot:

1. On the Find Requests window, click Submit a New Request.

2. In the Submit Request window, select Create Kanban Replenishment Snapshot from the list of values in the Name field.

3. In the Parameters window, select the organization for which you want to generate Kanban replenishment snapshot. If you leave the Organization parameter blank, then the program creates snapshots for all the organizations.

4. Click OK on the Parameters window.

5. Click Submit on the Submit Request window to submit the concurrent request.

6. Review your request using the Requests page.

Loading Electronic Kanban ECC Data

See Setup and Configuration Steps for the Kanban Dashboard.

Prerequisite

Run the Create Kanban Replenishment Snapshot program before you run the Electronic Kanban ECC Data Load program.

To load Oracle E-Business Suite data into the Kanban Dashboard, run the concurrent program Electronic Kanban ECC Data Load. You can find this concurrent program using the eKanban Super User responsibility.

The data load program loads data to the following data sets:

Data Sets for the Electronic Kanban ECC Data Load Program

Data Set Key	Data Set
flm-kanban-cards-dtls	Kanban Cards
flm-pullseq-details	Kanban Pull Sequences
flm_kb_demand_metric	Kanban Demand
flm_kb_lt_metric	Kanban Lead Time

Note: To set up profile options before running data loads, see Setting Profile Options for the Kanban Dashboard.

Run the concurrent program from the Submit Request window.

(N) eKanban Super User > View > Requests > Find Requests

Electronic Kanban ECC Data Load

To load Electronic Kanban ECC data:

1. On the Find Requests window, click Submit a New Request.

2. On the Submit Request window, select Electronic Kanban ECC Data Load from the list of values in the Name field.

3. Use the Parameters window to enter the parameters information.

4. The System Name field defaults to EBS.

5. In the Dataset field, select the specific data set for which you would like to load data from the list of values. Leave this field blank to run a data load for all the data sets.

6. In the Load Type field, select the appropriate load type:

   • Full data load: This process loads all the item pull sequences and cards data for Electronic Kanban data and is required to be run for the first data load. The full data load process also includes metadata load. If you select and run full load for subsequent requests, then this program clears the previous Electronic Kanban data from the dashboard and loads fresh data.

     Note: Running a full load removes all user defined reports and shows only the system defined report after the full load completes.

   • Incremental data load: This process loads the new and updated item pull sequences and card that are modified and updated from the previous load. Incremental load should be scheduled to run as often as required to keep the ECC dashboard current. Ensure that you run the incremental load after running a full load to avoid any data loading errors.

   • Metadata load: This process ensures the application waits for other tasks such as consolidation, data entry, or other load processes to finish before it loads the files. Note that the full data load process includes metadata load.

7. In the Language field, enter one or more language codes for the output. For multiple language codes, use the format AA,BB,NN. For example, enter US,AR,KO. If the field is blank, then the data will be loaded for the base language only (usually US).

8. In the Enable SQL Trace field, select TRUE to enable the SQL trace. Otherwise, select FALSE.

9. In the Log Level field, select the program you want to report.

10. In the Organization Code, you can select and enter the organization code for which you want to run the concurrent program.

11. In the Reset Data field, select from the following values:

    • TRUE - when you want to reset the data set completely.

    • FALSE - when you want to extend the existing data set.

      The default value is FALSE. You can only use the Reset Data option when you run a full data load.

12. Click OK on the Parameters window.

13. Click Submit on the Submit Request window to submit the concurrent request.

14. Review your request using the Requests page.

To review request details:

1. From the menu, click Requests. The Find Requests window appears.

2. Select the All My Requests radio button and click Find. The Requests window appears and displays all of your requests.

3. In the Requests window, select the row that contains your request and then click View Details. The Request Detail window appears and displays the ECC- Run Data Load information.

4. Click OK to exit and close the window.