Setting Up the Movement Statistics Dashboards

This chapter covers the following topics:

Setting Up Inventory Management Command Center

See Inventory Management Command Center Overview, Oracle Inventory User's Guide.

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, Oracle Inventory User's Guide.

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, Oracle Inventory User's Guide.

  3. Configure Descriptive Flexfields (DFFs) for search, Oracle Inventory User's Guide.

  4. Load Inbound Details data, Oracle Inventory User's Guide.

  5. Load Inventory On Hand data, Oracle Inventory User's Guide.

  6. Load Cycle Counting data, Oracle Inventory User's Guide.

  7. Load Physical Inventory data, Oracle Inventory User's Guide.

  8. Load Inventory Reservations data, Oracle Inventory User's Guide.

  9. Load Delivery Details data, Oracle Inventory User's Guide.

  10. Load Space Utilization data, Oracle Inventory User's Guide.

  11. Load Track and Trace data, Oracle Inventory User's Guide.

  12. Load Activity Details data, Oracle Inventory User's Guide.

  13. Load Move Orders data, Oracle Inventory User's Guide.

  14. Collect Item Supply/Demand Data, Oracle Inventory User's Guide.

  15. Load Supply/Demand data, Oracle Inventory User's Guide.

  16. Load Transaction Management data, Oracle Inventory User's Guide.

  17. Load Replenishment data, Oracle Inventory User's Guide.

  18. Load Items data, Oracle Inventory User's Guide.

  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, Oracle Inventory User's Guide

    • Movement Statistics Exception Report, Oracle Inventory User's Guide

    • Movement Statistics Report, Oracle Inventory User's Guide

Setting Up the Kanban Dashboard

To complete the Kanban Dashboard, Oracle Inventory User's Guide configuration setup, see Setup and Configuration Steps for the Kanban Dashboard, Oracle Inventory User's Guide.

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, Oracle Inventory User's Guide

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

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:

Prerequisite

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

Movement Statistics ECC Data Load

the picture is described in the document text

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.