Oracle Inventory Management Command Center

This chapter covers the following topics:

Inventory Management Command Center

Inventory Management Command Center Overview

Use the Inventory Management Command Center to simplify and expedite fulfillment planning and execution. The command center enables warehouse managers, outbound supervisors, inventory managers, inventory control supervisors, and product managers to streamline inventory activities and to quickly act on exceptions. Kanban planners and inventory control supervisors can use the command center to gain insights about the current inventory health at various inventory locations known as points of use, material replenishment lead time, Kanban demand, and unmoved Kanban cards to manage inventory levels and control inventory cost.

Use the command center to:

The Inventory Management Command Center includes role-based dashboards with metrics and charts that highlight critical information about the day-to-day activities of warehouse managers, outbound supervisors, inventory managers, inventory control supervisors, product managers, and Kanban planners. The dashboards provide in-depth, multidimensional analysis using transactional data so that you can take corrective actions to resolve issues proactively.

These dashboards are organized by role under the following responsibilities and menus:

Dashboard Role Responsibility and Menu
Receiving Dashboard Warehouse Manager, Inventory Manager, and Inventory Control Supervisor Logistics Manager > Command Center
Aging Inventory Dashboard Warehouse Manager, Inventory Manager, and Inventory Control Supervisor Logistics Manager > Command Center
Reservations Dashboard Warehouse Manager, Inventory Manager, and Inventory Control Supervisor Logistics Manager > Command Center
Accuracy Dashboards include: Warehouse Manager, Inventory Manager, and Inventory Control Supervisor Logistics Manager > Command Center
Shipping Dashboard Outbound Fulfillment Manager and Supervisor Logistics Manager > Command Center
Space Utilization Dashboard Warehouse Manager, Inventory Manager, and Inventory Control Supervisor Logistics Manager > Command Center
Activity Dashboard Warehouse Manager, Inventory Manager, and Inventory Control Supervisor Logistics Manager > Command Center
Move Orders Dashboard Warehouse Manager, Inventory Manager, and Inventory Control Supervisor Logistics Manager > Command Center
Supply/Demand Dashboard Warehouse Manager, Inventory Manager, Inventory Control Supervisor, and Production Supervisor Logistics Manager > Command Center
Track and Trace Dashboard Warehouse Manager, Inventory Manager, and Inventory Control Supervisor Logistics Manager > Command Center
Transaction Management Dashboard Warehouse Manager, Inventory Manager, Inventory Control Supervisor, Production Supervisor, Receiving Supervisor, and Shipping Clerk Logistics Manager > Command Center
Items Dashboard Product Manager Manufacturing and Distribution Manager > Inventory > Items
Kanban Dashboard Inventory Control Supervisor, Kanban Planner eKanban Super User > Home (OAF)

Note: You must complete the Inventory Management Command Center configuration and setup after the installation and common configurations are completed as described in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework, Release 12.2. For additional ECC overview information, see Overview of Oracle Enterprise Command Centers, Oracle E-Business Suite User's Guide

Searching in and Refining Enterprise Command Center Dashboards

Use the search box to search for and refine (filter) the data on a dashboard. You can select a value from the Available Refinements component, or you can use the Search field to find a keyword, a value, or a specific record. When you submit a search, or select an available refinement, the search term or refinement is added to the Selected Refinements list, and all of the dashboard data is refined. You can add multiple refinements and remove any of them at any time. Use Saved Search to create and save your search. You can edit, delete, or refer to this saved search. You can also use data sets to further refine your search.

Use an asterisk (*) or a percent sign (%) to perform a partial keyword or record search that matches any string of zero or more characters. You can also use a question mark (?) to perform a partial search that matches any single character.

Additional Information: For more information about searching for and refining data in enterprise command centers, see Search in Highlights of an Enterprise Command Center, Oracle E-Business Suite User's Guide.

Receiving Dashboard

See Inventory Management Command Center Overview.

The Receiving Dashboard enables you to ensure that material is received, inspected, and made available for order picking and consumption. Analyze and refine the dashboard data by clicking metrics, alerts, and graphs.

Use the dashboard to:

Access the Receiving Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Receiving Dashboard

Receiving Dashboard

the picture is described in the document text

The following table describes the dashboard:

Components Description
Receipts (summary bar) The Receipts summary bar contains the following key metrics. You can refine the dashboard data by clicking a metric value.
  • Organization Count: This metric shows how many active organizations are currently represented in the dashboard.

    Note: Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, click the value to select a single organization

  • Organization: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

  • Expected Today: This metric shows how many pending receiving order lines have an expected date earlier than or equal to today (the current system date).

Inspections and Putaways (summary bar) The Inspections and Putaways summary bar contains the following key metrics. You can refine the dashboard data by clicking a metric value.
  • Awaiting Inspection: This metric shows how many receipt lines are awaiting inspection.

  • Putaway (Lines): This metric shows how many receipt lines are pending delivery or putaway.

  • Putaway (LPNs): This metric shows how many License Plate Number (LPNs) are awaiting delivery or putaway.

Alerts (summary bar) The Alerts summary bar contains the following key metrics. You can refine the dashboard data by clicking a metric value.
  • Priority Lines: This metric shows the number of items with a priority flag set to Y indicating that the item should receive priority handling to address outbound concerns.

  • Rejected Lines: This metric shows how many receipt lines have failed inspection.

  • Dock to Stock (Min): This metric shows the average time taken from receipt to delivery or storage for all eligible delivery transactions. To calculate the dock to stock time for a delivery transaction, the dashboard uses the transaction delivery date and the transaction receipt date. Use this metric to analyze the average time (in minutes) taken to move the material from the receiving dock to storage in the past 30 days. This metric does not include direct delivery transactions.

    This metric displays a value using the following default color key:

    • Red, if the value is greater than 120 minutes (>120)

    • Yellow, if the value is greater than or equal to 30 minutes (>=30) and less than or equal to 120 minutes (<=120)

    • Green, if the value is less than 30 minutes (< 30)

  • Today's Dock to Stock (Min): This metric shows the average time taken from receipt to delivery or storage for all eligible delivery transactions that occurred today (the current system date).

    This metric displays a value using the following default color key:

    • Red, if the value is greater than 120 minutes (>120)

    • Yellow, if the value is greater than or equal to 30 minutes (>=30) and less than or equal to 120 minutes (<=120)

    • Green, if the value is less than 30 minutes (< 30)

    Note: System administrators can customize the default color key.

Expected Receipts by Date (tab) This tab contains a chart that sorts expected receiving lines by scheduled date.
Expected Receipts by Source (tab) This tab contains a chart that sorts expected receiving lines by source.
Awaiting Inspection (tab) This tab contains a chart that sorts receiving lines pending inspection by item.
Putaways (Lines) (tab) This tab contains a chart that sorts the receiving lines awaiting putaway (not LPN) to inventory.
Putaways (LPNs) (tab) This tab contains an Aggregate table that shows the LPNs awaiting putaway to inventory. This is the default tab when you select the Pending Putaway LPNs metric.
Dock to Stock (tab) This tab contains a chart that shows the average dock to stock time (in minutes) for all the eligible delivery transactions. Sorting of this chart can be done based on delivery date and item.
Expected Receipts (results table) This table shows all expected receipt lines that match the current refinements. To update the receipt details and perform the receive transaction, click the link in the Action column to navigate to the Directed Receipt page.
Awaiting Inspection (results table) This table shows all receipt lines that await inspection and that match the current refinements. To add inspection details, click the link in the Action column to navigate to the Receiving Transactions page.
Putaways (results table) This table shows all receipt lines that await putaway and that match the current refinements. To update the receipt details and perform the deliver transaction, click the link in the Action column to navigate to the Directed Deliver page.
Source Documents for Receipt, Inspect, and Deliver Transactions You can perform transactions for inbound material from the action links in the Expected Receipts, Awaiting Inspection, and Putaways tables. Identify the receiving source using the Source Document Type column. Transactions are applicable to the following documents:
  • Purchase orders (PO)

  • Return material authorizations (RMA)

  • In transit shipments (INTSHIP)

  • Internal orders (INTER ORG)

  • Advanced shipment notices (ASN)

  • Return ASN shipments (RASN): You can create RASN document types and perform transactions for the RASN documents on the Receiving HTML UI beginning with Oracle E-Business Suite release 12.2.11.

Options (table-level actions) Export: Use this action to export the search results in a comma-separated values (CSV) file.

Aging Inventory Dashboard

See Inventory Management Command Center Overview.

Use the Aging Inventory dashboard to:

The Aging Inventory dashboard provides visibility to your on-hand inventory, receipt, expiration, retest, and maturity dates. This visibility ensures that material is used as intended and does not become obsolete. Additionally, you can search for organizations, subinventories, locators, revisions, lots, items, descriptions, and other details. You can also refine data by selecting the metrics and alerts and portions of the graphs. The dashboard displays several components, that you can use to further refine your search. Use the enhanced navigation features to:

Access the Aging Inventory Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Aging Inventory Dashboard

Within the Aging Inventory dashboard, you can analyze data and review summary bars, charts, and tables. The following table describes the dashboard:

Aging Inventory Dashboard

the picture is described in the document text

Components Description
On-Hand Inventory Metrics (summary bar) The On-Hand Inventory Metrics summary bar contains the following key metrics. You can refine the data by clicking on a metric value.
  • Org Count: This metric shows how many active organizations are currently represented in the dashboard.

    Note: Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, click the value to select a single organization.

  • Organization: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

  • Total Items: This metric shows a count of distinct items in the selected organization. If the same items is in multiple organizations, then it is only counted once.

  • Total Lots: This metric shows a count of distinct lots in the selected organization. If the same lot is in multiple organizations, then it is only counted once.

  • Expired Lots: This metric shows a count of distinct lots past their expiration date. If the same expired lot is in multiple organizations, then it is only counted once. Click this metric to see the Expiration Date tab.

  • Expired Value: This metric shows the total value of all the expired on-hand quantities. For each of the Expired Lots, the calculation price is taken from the costing table.

  • Past Retest Date: This metric shows a count of distinct lots that are past the retest date. If the same lot is in multiple organizations, then it is only counted once. Click this metric to see the Retest Date tab.

  • Past Maturity Date: This metric shows a count of distinct lots that are past their maturity date. If the same lot is in multiple organizations, then it is only counted once. Click this metric to see the Maturity Date tab.

Receipt Date (tab) This tab contains the Oldest Items tag cloud, which focuses on age of material based on the receipt date for the organization.

Note: The dashboard displays the accurate age of the material only if the INV: FIFO for Original Receipt Date profile option is set to Yes.

Items and Value (chart) This chart shows items that are grouped into date ranges, and the value of those items.
Expiration Date (tab) This tab contains the Lots Closest to Expiration tag cloud, which focuses on expiration dates of lot-tracked material. Expiration date is a lot attribute. The tag cloud shows those lots closest to expiration, based on the refinements you apply.
Lots and Value (chart) This chart displays the lot count and the value of those lots.
Retest Date (tab) This tab contains the Lots Closest to Retest tag cloud, which focuses on the retest date of lot tracked material. The tag cloud shows those lots closest to their retest date, based on the refinements you apply.
Lots and Value (chart) This chart displays the lot count and the value of those lots.
Maturity Date (tab) This tab contains the Closest to Maturity Date tag cloud, which focuses on the maturity date of lot tracked material. Maturity date is a lot attribute. The tag cloud shows those lots closest to their maturity date, based on the refinements you apply.
Lots and Value (chart) This chart displays the lot count and the value of those lots.
Item Summary (results table) The table displays item summaries. The table also displays items with zero on-hand quantity. Use attribute groups to see more information about items.
Lot Summary (results table) The table displays lot summaries. Use attribute groups to see more information about lots.
Item Details (results table) The table displays item details. The table also displays items with zero on-hand. Use attribute groups to see more information about items.

Reservations Dashboard

See Inventory Management Command Center Overview.

The Reservations Dashboard enables you to ensure that demand is satisfied through effective reservations management.

Use the dashboard to:

Access the Reservations Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Reservations Dashboard

Reservations Dashboard

the picture is described in the document text

The following table describes the dashboard:

Components Description
Demand (summary bar) This summary bar displays the following metrics.
  • Org Count: This metric shows how many active organizations are currently represented in the dashboard.

    Note: If this metric has a value greater than 1, click the value to select a single organization.

  • Organization: When a single organization is selected, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

  • Backordered: This metric shows the number of demand lines for demand sources such as sales order, internal order, RMA and job or schedule that are not fully reserved.

  • Unreserved Demand: This metric shows the number of demand lines that are not fully reserved.

  • Expected Supply: This metric shows the number of demand lines with reservation against supply sources that are not on-hand inventory, such as POs and work orders.

  • Value: This metric shows the total value of the demand lines.

Demand by Date (chart) This chart shows an analysis of the need-by date by the demand line count and value. Use this information to analyze your most immediate demands.
Short by Date (chart) This chart shows an analysis of demand lines that are fully reserved and those that are short. Lines that are not fully reserved are called short signifying short of the required quantity. By default, this chart shows the analysis of need-by date by demand line count, and value. Select a dimension to view reservations that are short or by the demand source.
Demand by Item (chart) This chart shows an analysis of demand by item, demand line count, and value. Select a dimension to view demand by the demand source, by reservations that are short, by customer, and by cross dock.
Demand by Customer (chart) This chart shows an analysis of demand by customer, demand line count, and value. Select a dimension to view demand by demand source, short, item, and cross dock.
Reservations by Date (chart) This chart shows an analysis of demands with reservations. The graph shows an analysis of the need-by date by the reservation count and the value. Select a dimension to view reservations by the demand source, item, by customer, by short, and by cross dock.
Demand (results table) This table displays details for the demand lines and reservations. To navigate to the Reservations Workbench window, click the link icon in the Action column.

Note: You can use the Action link icon beginning with Oracle E-Business Suite release 12.2.10.

Note: The dashboard displays the Reservations descriptive flexfield data only if the Reservations descriptive flexfield is enabled.

Options (table-level actions)
  • Compare: Select multiple rows to compare data.

  • Export: Use this action to export the search results in a comma-separated values (CSV) file.

Shipping Dashboard

See Inventory Management Command Center Overview.

Use the Shipping Dashboard to:

The Shipping Dashboard enables you to search for trips, waves, deliveries, and delivery details by entering refinement terms. You can analyze and refine the dashboard data by clicking metrics, alerts, and graphs. Use the navigation features on the dashboard to view:

Access the Shipping Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Shipping Dashboard

Shipping Dashboard

the picture is described in the document text

Important: To view shipped delivery details that were closed before the current day, your system administrator must set an appropriate value for the WSH: Days for Full Data Load of Shipped Details profile at the Site level and run the Delivery Details Data Load program with the full load option. Otherwise, the dashboard displays data for open delivery details only.

The following table describes the dashboard:

Components Description
Shipping Status (summary bar) This summary bar contains the following key metrics. You can refine the dashboard data by clicking a metric value.
  • Organizations: The metric shows how many active organizations are currently represented in the dashboard.

    Note: Many shipping dashboard components will be displayed only for a single organization. If this metric has a value greater than 1, then click the value to select a single organization.

  • Organization Name: When a single organization is selected, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

    Note: The Shipping Dashboard uses shipping grants. Security privileges through grants enable you to determine who can access each shipping entity. Setting security privileges has no effect on the data load because the application implements these permissions only after the data load. If you use security privileges, then the application displays data based on the privileges.

  • Scheduled for Today: This metric shows how many delivery details should ship today. This includes all delivery details that have not been shipped nor canceled, and that have a scheduled ship date earlier than or equal to today (the current system date).

  • Completed Today: This metric shows how many delivery details for which delivery is ship confirmed today.

  • Future: This metric shows how many delivery details have a future scheduled ship date.

  • Pending Workload (Hours): This metric shows the total number of hours of outstanding work to be completed. This work involves picking outbound sales order lines that are both booked and released to warehouse. This metric displays a value only for WMS-enabled-organizations. For organizations that are not WMS enabled, the metric shows the value of zero (0). To calculate the pending workload, this metric considers the following detail statuses:

    • Ready to Release

    • Backordered

    • Released to Warehouse

Shipping Alerts (summary bar) The Shipping Alerts summary bar contains the following key metrics. You can refine the dashboard data by clicking a metric value.
  • Late: This metric shows how many delivery details have a scheduled ship date in the past but have not been shipped nor canceled.

  • Backordered: This metric shows how many delivery details are backordered.

  • No Carrier: This metric shows how many delivery details have no carrier assigned.

  • No Delivery: This metric shows how many delivery details have no delivery assigned.

  • No Trip: This metric shows how many delivery details have no trip assigned.

  • Delivery Exceptions: This metric shows the number of open deliveries that have unresolved error exceptions and the open deliveries associated with details, which have exceptions.

Ship Date (tab) This tab contains the following charts:
  • Delivery Details by Ship Date: This chart sorts delivery details by ship date. Ship date buckets (ship date here refers to the Schedule Ship Date) are used to consolidate a large number of dates into a manageable format. You can drill down on any bucket to see specific ship dates.

  • Delivery Details by Status Group: This chart provides a high level overview of delivery details by status. Each status group contains one or more delivery detail statuses, so that you can focus on a limited number of high priority statuses.


Click a data point on a chart to refine the chart and the entire dashboard. By default, the chart displays details of different statuses using the following color key:
  • Ready to Release - Blue

  • Backordered - Red

  • Released for Warehouse - Orange

  • Staged/Pick Confirmed - Yellow

  • Completed - Green

    Note that the Completed label on the x-axis is the Shipped detail status.

Note: System administrators can customize these colors based on business requirements.

Detail Status (tab) This tab contains the Delivery Details by Status chart, which provides a detailed view of delivery details by status, stacked by carrier. This chart shows the number of delivery details in each release status, stacked by carrier. Detail Status, Released Status Bucket and Transportation Planning are the group dimensions. Carrier, Ship-To Country, Ship Method, Trip, Customer, Item Order Type and Shipment Priority are some of the available series dimensions.
Carrier (tab) This tab contains the Delivery Details by Carrier chart, which shows delivery details by carrier. A scroll bar and a zoom feature help you to view many statuses in a single chart. You can select from several series dimensions, including Trip, Ship-to-Country, Ship-to-Location, and Detail Status. By default, the chart displays details of different statuses using the following color key:
  • Ready to Release - Blue

  • Backordered - Red

  • Released for Warehouse - Orange

  • Staged/Pick Confirmed - Yellow

  • Completed - Green

Note: System administrators can customize these colors based on business requirements.

Ordered Weight and Volume (tab) This tab contains the Detail Weight (Sum), Detail Volume (Sum) by Carrier chart, which shows the product weight and volume for the lines associated with various shipping objects, like Carrier, Trip, Delivery, and Ship Method. You can use this when you tender a load and schedule a pick-up. If a carrier requires two or more appointments, then the application combines them and displays them in the graph.
Staged Weight and Volume (tab) This tab contains the Detail Weight (Sum), Detail Volume (Sum) by Subinventory chart, which shows the weight and volume for staged delivery details to help you manage dock operations. The weight and volume are always associated with a subinventory. If locator control is enabled for the organization, then weight and volume can also be viewed by locator.
Resource Requirements (tab) This tab contains the following charts that show the estimated picking time that is required for delivery details.
  • Estimated Time Required (Sum) by Carrier, Ship-To Location: This chart shows the estimated time that is required to complete picking for each carrier and ship-to location.

  • Estimated Time Required (Sum) by Carrier, Detail Status: This chart shows the estimated time that is required to complete picking for each carrier by detail status.

  • Estimated Time Required (Sum) by Customer, Detail Status: This chart shows the estimated time that is required to complete picking for each customer by detail status.

  • Estimated Time Required (Sum) by Item, Detail Status: This chart shows the estimated time that is required to complete picking for each item by detail status.

Delivery Details (results table) This table shows all delivery details that match the current refinements. Select Order, Inventory, Miscellaneous, and Additional Delivery Details from the drop-down list to view the associated data.

Note: The Additional Delivery Details option displays only if your system administrator enables the Delivery Details DFF.


The Detail Alert column shows whether there is an alert on a detail that requires attention before it can be shipped. Alerts includes any exception under the Order Hold status that prevents the delivery from moving to Ship Confirmed status. The application shows the alert for any of the following conditions:
  • No carrier

  • Delivery not assigned (unassigned)

  • Trip not assigned (unassigned)

  • Hold on the associated order header or lines

  • Exception on delivery details


To view the Estimated Time Required (Hours) column, select Miscellaneous from the drop-down list.
The Hold column shows whether there is a hold on the associated order header or lines. A red X icon indicates a hold.
The Transportation Planning column shows the following details depending on the applicable conditions:
  • Awaiting Planning: The delivery detail for the order has not yet been planned through Oracle Transportation Management.

  • Planned: The delivery details has been planned through Oracle Transportation Management.

  • Not Applicable: The delivery detail is for an organization that does not have Oracle Transportation Management enabled.

Deliveries (results table) This table shows all deliveries that match the current refinements. Select Weight Volume, Miscellaneous, or Additional Delivery Information from the drop-down list to view the associated data.

Note: The Additional Delivery Information option displays only if your system administrator enables the Deliveries DFF.


The Delivery Alert column shows an alert on a delivery that requires attention before it can be shipped. The application shows this alert in any of the following conditions:
  • No carrier

  • Trip not assigned (unassigned)

  • Hold on the associated order header or lines

  • Exception on delivery

  • Exceptions from attached delivery details which prevent them from shipping

Trips (results table) This table shows all trips that match the current refinements.
The Trip Alert column shows an alert on any trip that requires attention due to any of the following conditions:
  • No carrier

  • Hold on the associated order header or lines

  • Exception on a trip

  • Exceptions from attached delivery details or deliveries which prevent them from being shipped

Waves (results table) This table shows details of waves that match the current refinements.
Options (table-level actions)
  • Compare: Select multiple rows to compare data.

  • Export: Use this action to export the search results in a comma-separated values (CSV) file.

  • Shipping Operations: Use this action to manage shipping information such as trips, stops, deliveries, details, and requests by navigating to the Shipping Operations page.

  • Manage Tasks: This option is available from the Delivery Details and Deliveries results tables. Use this action to view all associated Oracle Warehouse Management System tasks for a delivery.

    Note: The Manage Tasks option is available only for deliveries and delivery lines that belong to WMS-enabled organizations and the status of deliveries and delivery lines must be Released to Warehouse.

Space Utilization Dashboard

See Inventory Management Command Center Overview.

Use the Space Utilization Dashboard to:

The Space Utilization Dashboard enables you to ensure that adequate storage space is available and that it is used effectively. You can analyze and refine the dashboard data by clicking metrics, alerts, and graphs.

Access the Space Utilization Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Space Utilization Dashboard

Space Utilization Dashboard

the picture is described in the document text

The following table describes the dashboard:

Components Description
Space Utilization (summary bar) The Space Utilization summary bar contains the following key metrics. You can refine the dashboard data by clicking a metric value.
  • Organization Count: This metric shows how many active organizations are currently represented in the dashboard.

    Note: Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, click the value to select a single organization

  • Organization: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

  • Empty Locators: This metric shows the number of empty locators.

  • Reslots: This metric shows the number of reslots that may be done.

  • Space Available %: This metric shows the percentage of space that is available based on capacity by units.

Empty Locators (tab) This tab contains a chart that shows the number of empty and non-empty locators by subinventory, zone, or locator velocity class.
Items per Locator (tab) This tab contains the following charts:
  • Items Count per Locator: This chart shows the number of items in each locator.

  • Items Quantity per Locator: This chart shows the quantity of each item in the locator.

Locators per Item (tab) This tab contains the following charts:
  • Locator Count per Item: This chart shows the number of locators dedicated to an item.

  • Locator Quantity per Item: This chart shows the quantity of each item in the locator.

Velocity Overview (tab) This tab contains the following charts:
  • Item Count by Class: This chart shows the number of items by class.

  • Item Count by Locator Class: This chart shows the number of items by locator class.

Item Velocity (tab) This tab contains the following charts:
  • Item Velocity: This chart shows the velocity for each item. Velocity is the number of transactions performed for each item within a specific time and is used to determine the item's velocity class.

  • Item Velocity (Sum) by Item Class: This chart shows the number of items per item velocity class.

Results Table This table displays details such as the organization code, subinventory code, locator code, item, item velocity, item class, locator class, and so on.
Options (table-level actions) You can perform the following actions:
  • Compare: Select multiple rows to compare data.

  • Initiate Move Request: To create a move order, select a row and click this option to navigate to the Initiate Move Request page.

Accuracy Dashboards

The Accuracy Dashboards tab includes the following dashboards:

Cycle Counting Dashboard

See Inventory Management Command Center Overview and Accuracy Dashboards.

Use the Cycle Counting dashboard to:

Use predefined refinements to search for items, description, status, hit miss, count type, header name, and other details. Additionally, refine data by selecting the metrics and alerts and portions of the graphs. The dashboard displays several regions and components. Click these regions and components to further refine your search. The enhanced navigation features on the dashboard enable you to:

Access the Cycle Counting dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Accuracy Dashboards

Cycle Counting Dashboard

the picture is described in the document text

Within the Cycle Counting dashboard, you can analyze data and review summary bars, charts, and tables. The following table describes the dashboard:

Components Description
Items (summary bar) The Items summary bar contains the following key metrics. You can further refine the data by clicking on a metric value.
  • Organizations: This metric shows how many active organizations are currently represented in the dashboard.

    Note: Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, click the value to select a single organization.

  • Organization: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

  • Unscheduled Items: This metric shows the number of items that are associated with a schedule or in need of scheduling. This usually occurs when the scheduling concurrent process has not been run.

Today's Approvals (summary bar) The Today's Approvals summary bar contains the following key metrics. You can further refine the data by clicking on a metric value.
  • Pending: This metric shows the number of counts with a status of Pending Approval. Selecting this metric applies a refinement and makes Pending Approval the active tab.

  • Rejected: This metric shows the number of counts that were rejected today. Selecting this metric applies a refinement and makes Completed Counts the active tab.

  • Approved: This metric shows the number of counts that were approved today. Selecting this metric applies a refinement and makes Completed Counts the active tab.

Today's Counts (summary bar) The Today's Counts summary bar contains the following key metrics. You can further refine the data by clicking on a metric value.
  • Available: This metric shows the number of counts that are scheduled and are available for counting.

  • Delayed: This metric shows the number of scheduled counts that are still available after the specified number of late days.

  • Due: This metric shows the counts that need to be counted on the current day, else they will be delayed.

  • Recounts: This metric shows the counts that are recounts, which have been requested through the approval process.

  • Scheduled: This metric shows the counts that were scheduled on the current day through the scheduling process or manually.

  • Counted: This metric shows the counts that were counted on the current day.

  • Misses: This metric shows the counts that were completed on the current day and miss the quantity tolerance defined.

  • Value Change: This metric shows the value associated with the adjustment quantity for the counts completed on the current day.

Available Counts (tab) This tab contains graphs and a results table focused on counts with a status of Uncounted or Recount. You can look at the Available Counts tab as a work queue. The graphs and table in this tab expose count attributes that help prioritize and better manage the work load:
  • By Organization: This graph sorts counts by location specific information. The highest-level sort is organization and you can drill down to subinventory and locator (if locators are defined).

  • By Date: This graph sorts counts by various date attributes. By default, the graph is sorted by Count Due Date, and you see the counts with the highest priority from a date perspective.

  • By Schedule: This graph sorts available counts by cycle count header, which contains the scheduling attributes. The By Schedule graph sorts available counts by cycle count header, which contains the scheduling attributes. Within each schedule the graph further sorts by cost group in the series dimension.

  • By Value: This graph deals with the total value of counts rather than the number of counts. The value of the items being counted often dictates the priority of the counts. Graphs with value are shown only when a single organization is selected because functional currency can differ from organization to organization.


The table displays various count attributes.

Note: The dashboard displays Cycle Count Headers data and the Cycle Count Entries data only if the Cycle Count Headers and the Cycle Count Entries descriptive flexfields are enabled.

Pending Approval (tab) This tab contains the following graphs and results table. You can look at the Pending Approval tab as a work queue. The graphs and results table each highlight an important dimension of counts that have been executed, counted, and found to be out of tolerance. The graphs and table in this tab expose count attributes that help prioritize and better manage the work load

Note: Out of tolerance counts require approval.

  • By Organization: This graph sorts counts by location specific information.

  • By Date: This graph sorts counts by various date attributes.

  • By Schedule: This graph sorts available counts by cycle count header, which contains the scheduling attributes.

  • By Value Change: This graph deals with the value change that results from the counts.


The table displays various lot attributes. To view the approval status, click Approval Status to navigate to the Monitor Activities History page. To perform actions on your selection, click the Options icon. If you select two or more rows, then you can click Compare. To view and perform required actions on your notifications, click Approve Counts to navigate to the Worklist page.

Note: The dashboard displays Cycle Count Headers data and the Cycle Count Entries data only if the Cycle Count Headers and the Cycle Count Entries descriptive flexfields are enabled.

Completed Counts (tab) This tab contains the following graphs and results table, each highlighting an important dimension of counts that have been completed, counted, and approved, if required. This tab provides a historical context, which may be beneficial when measuring today's performance.

Note: Out of tolerance counts require approval.

  • By Organization: This graph sorts counts by location specific information. The highest-level sort is organization and you can drill down to subinventory and locator (if locators are defined).

  • By Date: This graph sorts counts by various date attributes. By default, this graph is sorted by Count Due Date, and you can see the counts with the highest priority from a date perspective.

  • By Schedule: This graph sorts available counts by cycle count header, which contains the scheduling attributes.

  • By Value Change: This graph shows the value change that results from the counts. The size of the value change often dictates the priority of the counts in the approval process. Graphs with value are shown only when a single organization is selected because functional currency could differ from organization to organization.


The table displays various item detail attributes. You can perform the following row-level actions:
  • To view the approval status, click Approval Status to navigate to the Monitor Activities History page.

  • To perform actions on your selection, click the Options icon.

  • To compare two or more rows, select the rows and click Compare.

  • To view and perform required actions on your notifications, click Approve Counts to navigate to the Worklist page.

Note: The dashboard displays Cycle Count Headers data and the Cycle Count Entries data only if the Cycle Count Headers and the Cycle Count Entries descriptive flexfields are enabled.

Unscheduled Items (tab) This tab displays a results table that provides details of unscheduled items.

Physical Inventory Dashboard

See Inventory Management Command Center Overview and Accuracy Dashboards.

The Physical Inventory dashboard enables you to gain insight into on-hand quantities to manage supply and demand, maintain high service levels, and plan production.

Use the dashboard to:

Access the Physical Inventory dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Accuracy Dashboards

Within the Physical Inventory dashboard, you can analyze data and review summary bars, charts, and tables.

Note: The Available Refinements component and results tables include the following descriptive flexfields:

Your system administrator must enable these flexfields so that you can select the refinements and view data.

Physical Inventory Dashboard

the picture is described in the document text

The following table describes the dashboard:

Components Description
Tags (summary bar) This summary bar contains the following key metrics. You can further refine the data by clicking on a metric value.
  • Org Count: This metric shows how many active organizations are currently represented in the dashboard.

    Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, click the value to select a single organization.

  • Organization: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

  • Uncounted Tags: This metric includes the number of blank and default tags for which the adjustment percent and count value are not entered after the physical inventory tag generation. Selecting this metric applies a refinement and makes the following components active:

    • Uncounted Tags tab with By Organization and By Item charts

    • Uncounted Tags table

  • Counted Tags: This metric shows the number of tags for which the count information such as the count quantity, unit of measure (UOM), and counted by information is entered after the physical inventory tag generation. Selecting this metric applies a refinement and makes the following components active:

    • Counted Tags tab with By Organization and By Item charts

    • Counted Tags table

  • Void Tags: This metric shows the number of tags that are not used at the end of the physical inventory count and marked as void. Use this information to track the status of each inventory tag that is generated.

  • Blank Tags: This metric shows the number of blank tags that are generated in the physical inventory. This metric does not consider default tags in the count. Use this information to add new stock keeping units (SKUs) that are found during the physical inventory count and the SKU information.

Adjustments (summary bar) This summary bar contains the metrics related to physical inventory adjustments created by count entries. You can further refine the data by clicking on a metric value.
  • Pending: This metric shows the number of adjustments that are pending approval. Selecting this metric applies a refinement and makes the following components active:

    • Pending Adjustments tab with By Organization and By Adjustment Value charts

    • Pending Approval Adjustments table

  • Approved: This metric shows the number of adjustments that are approved. Selecting this metric applies a refinement and makes the following components active:

    • Approved Adjustments tab with By Organization and By Adjustment Value charts

    • Approved Adjustments table

  • Rejected: This metric shows the number of adjustments that were rejected. Selecting this metric applies a refinement and makes the following components active:

    • Rejected Adjustments tab with By Organization and By Adjustment Value charts

    • Rejected Adjustments table

  • Pending Reservations: This metric displays a value only if there are negative adjustments that are not approved. Selecting this metric makes the following components active:

    • Pending Adjustments tab with By Organization and By Adjustment Value charts

    • Pending Approval Adjustments table

  • Pending Allocations: This metric displays a value only if there are negative adjustments that are not approved. Selecting this metric makes the following components active:

    • Pending Adjustments tab with By Organization and By Adjustment Value charts

    • Pending Approval Adjustments table

  • Adjustment Value: This metric shows the value of adjustments between the snapshot quantity and the actual count quantity.

    The calculation of the adjustment value is as follows:

    Adjustment quantity (difference between snapshot quantity and count quantity) multiplied by item cost

  • System Value: This metric shows the value of the snapshot quantity when a snapshot of system on-hand quantities of items in physical inventory is taken.

Important: The Adjustment Value and System Value metrics show the data only when a single organization is selected because the functional currency can differ from organization to organization.

Uncounted Tags (tab) This tab contains the following graphs and a results table.
  • By Organization: By default, this bar chart shows the number of uncounted tags by organization. The highest sort level is organization and you can drill down to subinventory, locator, and item.

  • By Items: This chart shows the number of uncounted tags for each item with the system value. Review the system value details to investigate default tags and begin the counting process for high-value items where counting is still due. Graphs with values are shown only when a single organization is selected because the functional currency can differ from organization to organization.


The table displays various attributes for uncounted tags.

Note: The dashboard displays Physical Inventory descriptive flexfield data and the Physical Inventory Tags descriptive flexfield data only if the Physical Inventory and Physical Inventory Tags descriptive flexfields are enabled.

Counted Tags (tab) This tab contains the following graphs and a results table.
  • By Organization: By default, this bar chart shows the number of counted tags with the sum of count value by organization and the employee who counted the item. The highest sort level is organization and you can drill down to subinventory, locator, and item. Select a different dimension to view the counted tags by count value or adjustment percent.

  • By Items: By default, this chart shows the number of the counted tags with the sum of count value by each item and the employee who counted the item. Select a different dimension to view by count value or adjustment percent. Graphs with values are shown only when a single organization is selected because the functional currency can differ from organization to organization.


The table displays various attributes for counted tags.

Note: The dashboard displays Physical Inventory descriptive flexfield data and the Physical Inventory Tags descriptive flexfield data only if the Physical Inventory and Physical Inventory Tags descriptive flexfields are enabled.

Pending Adjustments (tab) This tab contains the following graphs and a results table.

Note: Out of tolerance adjustments require approval. Oracle Inventory posts only those physical inventory adjustments that are approved. Adjustments must be approved or rejected before the adjustment transactions can be processed.

  • By Organization: By default, this bar chart shows the number of adjustments pending approval by organization and the employee who counted the item. The highest sort level is organization and you can drill down to subinventory, locator, and item. Select a different dimension to view the number of pending adjustments by adjustment percent.

  • By Adjustment Value: By default, this bar chart shows the adjustment value for adjustments pending approval by organization and the employee who counted the item. The highest sort level is organization and you can drill down to subinventory, locator, and item. Use the chart information to approve adjustments for items that have a high value or demand. Graphs with values are shown only when a single organization is selected because the functional currency can differ from organization to organization.


The results table shows details for adjustments that are pending approval.
You can perform the following row-level actions:
  • To act on a reservation for an item so that the pending adjustment is approved, click the link icon in the Reservations column to navigate to the Reservations Workbench. For information about the Reservations Workbench, see Creating Reservations.

    Note: You can use the Reservations Workbench beginning with Oracle E-Business Suite release 12.2.10.

  • To act on an allocation for an item so that the pending adjustment is approved, click the link icon in the Allocation column to navigate to the Pending Transactions window. See Pending Transactions Folder Window Available Fields.

Approved Adjustments (tab) This tab contains the following graphs and a results table.
  • By Organization: By default, this bar chart shows the number of approved adjustments by organization and approver. The highest sort level is organization, and you can drill down to subinventory, locator, and item. Select a different dimension to view approved adjustments by adjustment percent or counted by.

  • By Adjustment Value: This chart shows the adjustment values for approved adjustments by organization. The highest sort level is organization and you can drill down to subinventory, locator, and item. The dimensions include approver, counted by, and adjustment value. Graphs with values are shown only when a single organization is selected because the functional currency can differ from organization to organization.


The results table shows details for adjustments that are approved. Use this information to post the approved adjustment transactions to inventory. See Processing Physical Inventory Adjustments.
Rejected Adjustments (tab) This tab contains the following graphs and a results table.

Note: Oracle Inventory does not change the system on-hand quantity if an adjustment is rejected.

  • By Organization: By default, this bar chart shows the number of rejected adjustments by organization and approver. The highest sort level is organization and you can drill down to subinventory, locator, and item. Select a different dimension to view rejected adjustments by adjustment percent or counted by.

  • By Adjustment Value: This chart shows the adjustment values for rejected adjustments by organization. The highest-level sort is organization and you can drill down to subinventory, locator, and item. The dimensions include approver, counted by, and adjustment value. Graphs with values are shown only when a single organization is selected because the functional currency can differ from organization to organization.


Use the table to review details for the rejected adjustments.

Activity Dashboard

See Inventory Management Command Center Overview.

Use the Activity Dashboard to ensure that activities are completed in a timely and efficient manner. The dashboard provides visibility to evaluate resource productivity. Use this dashboard to search for activity details by entering refinement terms. You can analyze and refine the dashboard data by clicking metrics, alerts, and graphs.

Use the dashboard to:

Access the Activity Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Activity Dashboard

Activity Dashboard

the picture is described in the document text

The following table describes the various regions and components on the dashboard:

Note: Today's date indicates the current system date.

Components Description
Today's Activity (summary bar) The Today's Activity summary bar contains the following key metrics. You can refine the dashboard data by clicking a metric value The metrics show data for today's date, which is the current system date.
  • Organization Count: This metric shows how many active organizations are currently represented on the dashboard.

    Note: Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, click the value to select a single organization.

  • Organization Name: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

  • Receipts: This metric shows how many receipts took place today.

  • Putaways: This metric shows how many putaways took place today.

  • Cycle Counts: This metric shows how many cycle counts were completed today.

  • Move Order Issues: This metric shows how many move order issues were reported today.

  • Outbound Picks: This metric shows how many pick slips were issued for outbound move orders today.

  • Warehousing Picks: This metric shows how many pick slips were issued for warehousing move orders today.

  • Manufacturing Picks: This metric shows how many pick slips were issued for manufacturing move orders today.

  • Drops: This metric shows how many drops were made today.

  • Staging Moves: This metric shows how many staging move orders were created to cross dock material to staging locations today.

Activity (tab) This tab contains a graph that shows the total accumulated time spent on activities and the total number of tasks completed for each activity. The time is represented by the bars in the chart while the number of tasks is represented by the line. The first graph focuses on today's activity only. The second graph shows the same data summarized over the past 30 days.
Time Spent by User (tab) This tab contains a graph that shows the time spent by each user on each activity. The first graph shows time spent today, while the second graph shows time spent over the past 30 days.
Transactions by User (tab) This tab contains a graph that shows the number of transactions completed by each user for each activity. The first graph shows the number of transactions completed today, while the second graph shows the number of transactions completed over the past 30 days.
Average Total Time (tab) This tab contains a graph that shows the average duration for the transaction types performed over the specified time period. The first graph focuses on transactions completed today, while the second graph focuses on transactions completed over the past 30 days.
Average Total Time by User (tab) This tab contains a graph that shows the average time that each user spends to complete each transaction type. The first graph shows the average time for tasks completed today, while the second graph shows the user's average over the past 30 days. The averages here differ from the previous tab. The averages in this tab apply to a single user, whereas the averages in the previous tab were for all users.
Past 30 Days (tab) This tab contains a graph that shows the total number of transactions and total time worked for each day over the past 30 days. Use this graph for context and reference as a means of comparing today's activity with previous days.
Transactions (results table) The Transactions results table shows the details of all transactions including those transactions that are entered using the Mobile Supply Chain Applications (MSCA) page for the Warehouse Activity Tracker.
Options (table-level actions) Export: Use this action to export the search results in a comma-separated values (CSV) file.

Move Orders Dashboard

See Inventory Management Command Center Overview.

The Move Orders Dashboard enables you to track all move orders, headers, and lines. You can allocate and transact the move order lines depending on the status. Analyze and refine the dashboard data by clicking metrics, alerts, and graphs.

Use the dashboard to:

Access the Move Orders Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Move Orders Dashboard

Note: To display the descriptive flexfields (DFF) data, your system administrator must enable the following DFFs:

The dashboard displays data only for open move orders except for the Today's Activity summary bar, which shows the number of approved, canceled, and closed move orders today.

Move Orders Dashboard

the picture is described in the document text

Line Details Row-Level Actions

the picture is described in the document text

Allocation Details Row-Level Actions

the picture is described in the document text

The following table describes the dashboard:

Components Description
Line Status (summary bar) This summary bar contains the following key metrics. You can further refine the data by clicking on a metric value.
  • Org Count: This metric shows how many active organizations are currently represented in the dashboard. Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, click the value to select a single organization.

  • Organization: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.


You can review the number of move order lines that are in the following statuses:
  • Incomplete: This metric includes the number of move order lines in the Incomplete, Not Approved, and Partially Approved statuses.

  • Pending Approval: This metric includes the number of move order lines that are awaiting approval.

  • Approved: This metric includes the number of move order lines in the Preapproved and Approved statuses. You can allocate approved moved orders.

  • Allocated: This metric includes the number of move order lines with allocations in Oracle Inventory.

  • Reserved: This metric includes the number of move order lines with reserved material in Oracle Inventory.

Type (summary bar) To act on move order lines, this summary bar provides visibility into move order lines for the following types. For example, you can prioritize manufacturing picks to keep production rolling.
  • Requisition

  • Replenishment

  • Pick Wave

  • Manufacturing Pick

  • Put Away: Lines of this move order type belong to the Oracle Warehouse Management System (WMS)-enabled organizations.

  • Reservation: Lines of this move order type belong to the Oracle Process Manufacturing (OPM)-enabled organizations.

Today's Activity (summary bar) The Today's Activity summary bar contains the following key metrics. You can refine the dashboard data by clicking a metric value. The metrics show data for today's date, which is the current system date.
  • Approved: This metric includes the number of move order lines in the Pre-Approved or Approved status.

  • Canceled: This metric includes the number of move order lines in the Canceled or Canceled by Source status.

  • Closed: This metric includes the number of move order lines in the Closed status.

Alerts (summary bar) This summary displays the following alerts. Use these alert details to identify and to act on priority transactions.
  • Priority Putaway Lines: This metric includes the number of pending putaway move order lines for items that have backordered demand lines. By using this metric information, you can navigate to the Receiving Dashboard to review and perform receive transactions to address issues with outbound shipments. See Receiving Dashboard.

    Important: Before you view the data, ensure that your system administrator has run the Inbound Details Data Load program, which loads data to the Receiving Dashboard.

  • Past Due: This metric includes the number of move order lines for which the required date is past due.

Lines (tab) This tab contains the following graphs and a results table.
  • Organization Level: By default, the chart shows the number of move order lines by organization. Select a different dimension to view the number of lines by move order type, allocation, or reservation.

  • Subinventory Level: By default, the chart shows the number of move order lines by subinventory. Select a different dimension to view the number of lines by move order type, allocation, or reservation.


The Line Details results table shows the details for the move order lines. You can perform the following row-level actions. Select a row and then the action, which is enabled depending on the line status.
  • Move Orders: To view, edit, or cancel a move order line, select this action to navigate to the Move Orders HTML page.

    Note: You can use the Move Orders HTML page beginning with Oracle E-Business Suite release 12.2.7.

  • Transact: To allocate a move order or transact an allocated move order, select this action to navigate to the Transact Move Orders window. This action is available for the move order lines for which allocations are pending or allocated move order lines for which transactions are pending.

  • Reservation: To perform reservation activities for pick waves and manufacturing pick move order lines, select this action to navigate to the Reservations Workbench. To perform the reservation action, the status of the move order must be one of the following:

    • Incomplete

    • Pending Approval

    • Approved

    • Not Approved

    • Pre Approved

    • Partially Approved

    You can use the Reservations Workbench beginning with Oracle E-Business Suite release 12.2.10.

  • Receiving: To perform receipt transactions for putaway move order lines, select this action to navigate to the Receiving Dashboard. The Receiving Dashboard refines and shows data in the context of the item and organization of the selected move order line. See Receiving Dashboard.

Allocations (tab) This tab contains the following graphs and a results table.
  • Organization Level: By default, the chart shows the number of move order lines with allocations by organization. Select a different dimension to view the number of lines with allocations by move order number or item.

  • Subinventory Level: By default, the chart shows the number of move order lines by subinventory. Select a different dimension to view the number of lines with allocations move order number, locator, item, or lot number.


The Details results table shows the allocation details for the move order lines.
You can perform the following row-level actions. Select a row and then the action, which is enabled depending on the line status.
  • View: To view all allocations for a move order line, click View to navigate to the Pending Transactions window.

  • Update: To edit or update the allocation details for a move order line, click Update to navigate to the Transact Move Orders window.

Supply/Demand Dashboard

See Inventory Management Command Center Overview.

The Supply/Demand Dashboard gives you complete insight into the stock visibility across supply and demand sources to help you to identify and mitigate stockout risks.

Use the dashboard to:

Access the Supply/Demand Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Supply/Demand Dashboard

Supply/Demand Dashboard

the picture is described in the document text

Demand Tab Row-Level Actions

the picture is described in the document text

Available Tab Row-Level Actions

the picture is described in the document text

The following table describes the dashboard:

Components Description
Summary (summary bar) This summary bar contains the following key metrics. You can further refine the data by clicking on a metric value.
  • Org Count: This metric shows how many active organizations are currently represented in the dashboard.

    Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, click the value to select a single organization.

  • Organization: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.


Selecting the following metrics except Stock No Demand applies a refinement and makes the Stockout tab with Item Stockout and Stockout by Org charts active.
  • Stockout Today: This metric shows the number of items for which the demand exceeds today's the sum of today's supply plus the available quantity. Use this information to review whether today's supply and available quantity can fulfill the demand and act to resolve the stockout issue

  • Projected Stockout: This metric shows the number of items for which the demand exceeds the current available inventory quantity plus the incoming supply.

  • Stockout Risk Today: This metric shows the number of items for which today's available quantity is less than the demand and the incoming supply will fulfill the demand. Make sure that the incoming supply is available prior to the scheduled shipment or use of the excess demand.

  • Projected Stockout Risk: This metric shows the number of items for which the demand exceeds the future available quantity. The incoming supply can fulfill the excess demand, but you must ensure that the incoming supply is available before the scheduled shipment or use of the demand.

  • Stockout No Demand: This metric shows the number of items for with no available quantity and no demand in the next 14 days.

  • Stock No Demand: This metric shows the number of items for which there is available quantity but no demand in the next 14 days. Selecting this metric applies a refinement and makes the Available by Org tab with the Available by Date and Available by Organization charts active.

Stockout (tab) This tab includes the following charts:
  • Item Stockout Chart: This chart shows the number of out of stock items by item in the next 14 days.

  • Stockout by Org: This chart shows the number of out of stock items by item and organization.

Supply Demand (tab) This tab includes the following metrics and charts.
To view the stock, supply, and demand information, refine the data by an item.
  • Available Stock: This summary bar shows the following information:

    • The amount of material currently available.

    • Projected daily average of the available quantity

    • Projected weekly average of the available quantity

  • Supply: This summary bar shows the following information:

    • Projected daily average of the new supply that is added to the available inventory

    • Projected weekly average of the new supply that is added to the available inventory

  • Demand: This summary bar shows the following information:

    • Projected daily average of the demand that is taken out from the available inventory

    • Projected weekly average of the demand that is taken out from the available inventory

  • Available by Date: This chart tracks the total available quantity, supply, and demand by date.

  • Available/Supply/Demand by Date: This chart tracks the quantity that is available for supply or demand by date.

Supply (tab) This tab includes the following charts.
  • Supply: This chart shows the supply quantity for each demand type by the following predefined time buckets:

    • Past

    • Past 8-30 days

    • Past 1-7 days

    • Each day in the next 14 days, which includes today

  • Supply by Status: This pie chart shows the supply quantity by supply status to address stockout.

Demand(tab) This tab includes the following charts.
  • Demand: This chart shows the demand quantity for each demand type by the following predefined time buckets:

    • Past

    • Past 8-30 days

    • Past 1-7 days

    • Each day in the next 14 days, which includes today

  • Demand by Status: This pie chart shows the demand quantity by demand status to resolve the demand issues.

Available by Org (tab) This tab includes the following charts.
  • Available by Date: Use this chart to view the available quantity for an item in an organization by date. You can drill down to a specific date.

  • Available by Organization: This pie chart shows the average available quantity for an organization. Select the date refinement in the Available by Date chart to review the available quantity for that day.

Supply (results table) Use this table to view the supply details for items.
Demand (results table) This table displays details of items that are in demand.
For a reserved sales order type, you can perform the Transfer Reservation action. When you click this action, the Search Reservations page appears with the selected item in context. To transfer reservation from low priority demand to high priority demand, click the Transfer Demand icon.
Available (results table) This table displays on-hand quantity details for items.
You can perform the following row-level actions. Select a row and then the action, which is enabled depending on the line status.
  • View On-Hand: Check the on-hand quantity before you initiate the inter-organization transfer of an item. To know which subinventory and locator has on-hand quantity of an item, select this action to navigate to the Material Workbench.

  • Create Inter-Org Transfer: To transfer supply from other warehouses to mitigate risks, select this action to navigate to the Inter-organization Transfer window.

Track and Trace Dashboard

See Inventory Management Command Center Overview.

Use the Track and Trace Dashboard to get an overview of the storage and transaction history of material so that you can analyze issues in the supply chain process. The network viewer diagram on the dashboard helps you to track material and transactions to perform the trace analysis for defective and recalled material from a supply source to a destination during the investigation of vendor, distributor, or customer complaints. For example, there may be complaints from customers about shipped sales orders such as products not functioning properly or defective products. When you track and trace the defective products, these may be coming from a vendor or due to WIP.

During trace analysis, you can review details such as:

Use the dashboard to:

Access the Track and Trace Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Track and Trace Dashboard

Track and Trace Dashboard

the picture is described in the document text

The following table describes the dashboard:

Components Description
Data Sets To filter the traceability network, select refinements from the following data sets:
  • Inventory Trace Suppliers: Refinements for suppliers.

  • Inventory Trace Move: Refinements for subinventory transfers and backflush transfers between subinventories.

  • Inventory Trace Issues: Refinements for transactions that have issues.

  • Inventory Trace Inbound Onhand: Refinements for lots and items including inbound, in receiving, and on-hand quantities.

  • Work Orders: Refinements for Oracle Work in Process (WIP) orders.

  • Inventory Trace Sales Orders: Refinements for sales orders, picking activities, and packing activities for which packing is done after the pick release.

Track and Trace (network viewer) The Track and Trace Dashboard network viewer shows the material flow from inbound transactions to outbound transactions (sales orders) through the network nodes.
The network diagram displays the following nodes:
  1. Inbound Supply Sources: The viewer displays details for the following inbound supply sources:

    • Purchase Orders: The material received from Oracle Purchasing. The viewer displays purchase order and vendor information.

    • Work Orders: The material received from work orders as a part of assembly completion. The viewer displays work order information.

    • Intransit Shipments: The material supply from in transit shipment. The viewer displays shipment number and source information.

    • Requisitions: The material supply from requisitions. The viewer displays the requisition number and source information.

    • ASN: The material supply from ASN. The viewer displays ASN and vendor information.

  2. Lot/Item: The material in receiving or source inventory. The viewer displays item or lot information including source inventory organization, in receiving and on-hand quantities.

  3. Item: The material in receiving or source inventory. The viewer displays item information including source inventory organization and inbound, in receiving, and on-hand quantities.

  4. Deliver: The material putaway after receiving. The viewer displays subinventory, locator, and user information.

  5. Move: The material in transfer or in destination subinventory. The viewer displays transfer subinventory, transfer locator, and user information.

  6. Issue: The material issue such as Move order issue, Account alias issue, and Miscellaneous issue from the subinventory. The viewer displays subinventory, locator, and user information.

  7. Pick: The material taken out from the transfer subinventory. The viewer displays transfer subinventory, transfer locator, and user information.

  8. Pack: The packed material after the pick release in the staging area for WMS organizations. The viewer displays subinventory, locator, LPN, and user information.

    Note: The network diagram shows the Pack node only when the packing activity is performed after the pick release in the staging area for WMS organizations.

  9. Sales Order: The shipped material. The viewer displays sales order and customer information.

  10. Work Order: The work order information of WIP component issue transaction. This node uses the data from the Work Orders (gnt-wodetails) data set.


Right-click a node to select a behavior:
  • Make Anchor Node: Select this option to set the selected entity as the primary display node with adjacent nodes only.

  • Show Adjacent Nodes: Select this option to narrow the viewer to adjacent nodes only.

  • Show Details: Select this option to display the record Details dialog box.

  • Compare: Select this option to compare two or more records.

    Find Similar: The Find Similar option is available for Show Details and Compare. Select this option to filter the diagram by specific values and displays matching flows. For example, if there is a shipment issue with a sales order pick, then to verify whether there are other outbound sales orders with similar attributes, click the Find Similar button on the sales order pick Details dialog box.

  • Highlight Path: Select this option to highlight the complete path for a clear visual.

  • View (node) Detail: Select this option to display related information for the node.

Actions from Nodes To perform actions related to the nodes, right-click a node and select an action. See Performing Actions.

Performing Actions

Important: After you perform actions, your system administrator must run the Inventory Track and Trace Data Load program with the incremental load option so that the latest track and trace data is available.

The following table describes node related actions.

Node Action Description
Lot/Item Invoke Receiving Dashboard Use this action to update the status of an item or a specific lot after inspection. When you click the Invoke Receiving Dashboard action for an item and navigate to the Receiving Dashboard, the dashboard retains the item and organization refinements and displays the related data. In the Awaiting Inspection tab, click the link in the Action column to navigate to the Receiving Transactions page. See Receiving Dashboard.

Note: You can use the Receiving Transactions HTML feature beginning with Oracle E-Business Suite release 12.2.4.

Lot/Item
Deliver
Move
Pick
Pack
Update On-Hand Quantity Use this action to navigate to Material Workbench to view and update the receiving material, on-hand quantities, and intransit material.
The Material Workbench page displays refinements that are specific to the node from which you navigate.
  • Lot/Item node: The Material Workbench page displays Organization, Item, and Lot refinements.

  • Deliver, Move, Pick, and Pack nodes: The Material Workbench page displays location details with Subinventory and Locator refinements.

Note: You can use the Material Workbench HTML feature beginning with Oracle E-Business Suite release 12.2.10.

Network Viewer Diagram Examples

Example: Track and Trace Problem to the Pick Location

In this example, two different customers have reported problems with sales orders: 66048 and 66049. The inventory manager uses the network diagram to review the supply chain activities and traces the problem to the pick location.

The trace analysis steps that the inventory manager performs are as follows:

  1. Verifies recall details using the diagram nodes. The diagram shows different vendors from whom the inbound supplies are received and locations where the picking and shipping activities are performed. Views the network relationship from the source (purchase orders) to outbound sales orders.

    Network Relationship from Source (Purchase Orders) to Outbound Sales Orders

    the picture is described in the document text

  2. Identifies that there is a common picking location for the shipments.

  3. Right-clicks the Sales Order Pick node and selects the Show Detail action. The Details dialog box appears.

    Details Dialog Box

    the picture is described in the document text

  4. Clicks Find Similar to get details of comparable outbound sales orders from the picking location on the specific date.

    The Find Similar action fetches similar outbound sales orders to other customers that match the pick date.

    Similar Outbound Sales Orders

    the picture is described in the document text

  5. Clicks the Sales Order Pick grouping node to view details for individual shipments or picking action for other customers.

    Sales Order Pick Grouping Node

    the picture is described in the document text

  6. Traces the problem to the pick subinventory location.

  7. Right-clicks the Sales Pick node and selects Update On-Hand Quantity to act on the material.

Example: Track and Trace Problem to the Vendor

In this example, customers have raised concerns with defective items. The inventory manager uses the network diagram to perform the trace analysis and identifies that the issue is at the inbound supply stage. Reviews the material movement from the source of supply to outbound sales orders.

Material Movement from the Source to Outbound Sales Orders

the picture is described in the document text

The trace analysis steps the inventory manager performs are as follows:

  1. Reviews move and pick information.

  2. Reviews delivery details such as location, date, user, and all the receipts that are received in the location.

  3. Reviews details for inbound material.

  4. Reviews details for lots in receiving.

  5. Understands that there are no problems in all the above stages.

  6. Traces the problem to the inbound material.

  7. To prevent usage of the material, updates the status of the material to Reject on the Receiving Transaction Details page.

Transaction Management Dashboard

See Inventory Management Command Center Overview.

The Transaction Management Dashboard provides complete insight into the unprocessed transactions and transactions with errors in the following interfaces:

Use the dashboard to:

If the following descriptive flexfields are set up, then you can select the flexfield segments in the Available Refinements component:

Access the Transaction Management Dashboard using the following navigation:

(N) Logistics Manager (responsibility) > Command Center > Transaction Management Dashboard

Transaction Statuses in Interfaces

To load and display transactions from interfaces on the Transaction Management Dashboard, the Inventory Transaction Management Data Load concurrent program considers transaction statuses that are listed in the following table.

Interfaces and Transaction Statuses
Interface Transaction Status
Transaction Open Interface Ready
Not Ready
Error
Pending Transactions Ready
Not Ready
Error
Receiving Open Interface Pending
Error
Cycle Count Open Interface Successful
Processed with Errors
Marked for Recounting
Marked for Reprocessing
Reservations Interface Active
Inactive
Error
Object Genealogy Interface Pending
Successful
Error

Transaction Management Dashboard

the picture is described in the document text

The following table describes the various regions and components on the dashboard:

Components Description
Interface Records (summary bar) This summary bar contains the following key metrics. To refine the data, click a metric value.
  • Org Count: This metric shows the number of active organizations that are currently represented on the dashboard.

    Many dashboard components are displayed only for a single organization. If this metric has a value greater than 1, then click the value to select a single organization.

  • Organization: When you select a single organization, its name is shown here. When more than one organization is represented in the dashboard, this metric shows Multiple.

  • Error: This metric shows the number of transactions with error across the interfaces.

  • More Than 1 Hour*: This metric shows the number of transactions with no action on them for more than an hour.

  • More Than 1 Day*: This metric shows the number of transactions records with no action on them for more than a day.

Note: *These two metrics are not applicable to the Object Genealogy interface because the data of this interface is not based on the transaction date.


To identify the interface for transactions, click Available Refinements, and then Interface. The Interface attribute lists each interface with the count of transactions. You can further refine your search by selecting a specific interface.

Interface Attribute

the picture is described in the document text


Use the data from these metrics to prioritize and process transactions.
Status (chart) By default, this chart shows the number of transactions by status in an organization. Select a different group dimension to view the number of transactions by item in an organization.
Transaction Type (chart) This chart shows the number of transactions by transaction type in an organization.
Date, Time (chart) By default, this chart shows the number of transactions for an organization using the following predefined age in days bucket:
  • Today

  • 1-7

  • 8-14

  • 15-28

  • 29+


You can also select the age in minutes or age in seconds bucket. To view transactions on a specific date, select the Transaction Date group dimension. Use the chart information to prioritize transactions for processing.
Value (chart) This chart shows the sum of item value of transactions for items. The Value chart is specific to an organization.

Note: The Date, Time and Value charts for Object Genealogy do not display data because object genealogy is a hierarchical entity and is not based on quantity and item value.

Top 10 Errors (tag cloud) This tag cloud shows the top 10 processing errors in the following interface tables. You must select an organization to view data in this tag cloud.
  • Transaction Open Interface

  • Pending Transactions

  • Receiving Open Interface

  • Cycle Count Open Interface

  • Reservations Interface

  • Object Genealogy Interface


For each error explanation, by default, you can view the error count. To view the value of top 10 items with transaction errors, select the Item Value metric.
Click an error in the tag cloud to view error details in the relevant results table.
Transactions Interface, Pending Inventory, Receiving Interface, Cycle Count Interface, Reservations Interface, Object Genealogy Interface (results tables) These tables show data for transactions with the status of the transaction in the following interfaces:
  • Transaction Open Interface

  • Pending Transactions

  • Receiving Open Interface

  • Cycle Count Open Interface

  • Reservations Interface

  • Object Genealogy Interface


You can perform row-level and table-level actions.
See:

Using Actions to Update Interface Transaction Records

To update an interface transaction record, use the actions that are available from the results tables in the following sequence:

  1. In the required results table, select the transaction record that you want to modify and then the appropriate row-level action. This action takes you to the corresponding Oracle Inventory window. See Row-Level Actions in the Results Tables.

  2. Update the transaction record in the Oracle Inventory window.

  3. On the Transaction Management Dashboard, in the required result table, select one or more rows and click the Options icon.

  4. Select the relevant process action to submit the concurrent request. See Table-Level Actions in the Results Tables.

System Administrator Tasks

  1. Review the concurrent request using the following navigation:

    Manufacturing and Distribution Manager (responsibility), Standard > Other > Concurrent > Find Requests

  2. Run the Inventory Transaction Management Data Load with the Incremental Load option.

Example: Investigating a Transaction with an Error

The following example explains how you can use the Transaction Management Dashboard components to examine and resolve a transaction with an error.

In this example, the locator details for a transaction record in an inventory organization are incorrect. Therefore, the transaction record in the Transaction Open Interface has the "Locator is not valid" error.

To identify and resolve the error:

  1. In the Interface Records summary tab, click the Error metric.

  2. In the Inventory tab, Top 10 Errors tag cloud, click the "Locator is not valid. Please re-enter" error cloud. The Transactions Interface results table displays all the transaction records with this error.

  3. In a transaction record row, click the row-level Actions icon and then select the Transaction Open Interface action. The Transaction Interface window opens with the Item in context.

  4. Update the locator details in the Transaction Interface window.

  5. Navigate back to the Transaction Management Dashboard.

  6. Scroll to the Transactions Interface results table.

  7. Submit the Launch Process Transactions Interface table-level action for the transaction that you updated.

Row-Level Actions in the Results Tables

To perform the following actions, click the row-level Actions icon in the results tables and select an action.

Transactions Interface Row-Level Actions

the picture is described in the document text

Pending Inventory Row-Level Actions

the picture is described in the document text

Receiving Interface Row-Level Actions

the picture is described in the document text

Cycle Count Interface Row-Level Actions

the picture is described in the document text

Reservations Interface Row-Level Actions

the picture is described in the document text

Object Genealogy Interface Row-Level Actions

the picture is described in the document text

The following table describes the actions that are available from the rows of the results tables.

Row-Level Actions
Results Table Action Description
Transactions Interface Transaction Open Interface To view, edit, and correct a transaction, click Transaction Open Interface to navigate to the Transaction Open Interface window.
Transactions Interface
Pending Inventory
Receiving Interface
Cycle Count Interface
Reservations Interface
Object Genealogy Interface
Organization Items To update attributes of an organization-level item, click Organization Items to navigate to the Organization Item window.
Transactions Interface
Pending Inventory
Receiving Interface
Cycle Count Interface
Reservations Interface
Lot Numbers The Lot Numbers action is available only for the lot-controlled items.
To modify the attributes of a lot-controlled item, click Lot Numbers to navigate to the Item Lots window.
Transactions Interface
Pending Inventory
Receiving Interface
Cycle Count Interface
Reservations Interface
Object Genealogy Interface
Serial Numbers The Serial Numbers action is available only for the serial-controlled items.
When you click the Serial Numbers link for a transaction record, the Serial Number window opens with the selected transaction's Organization and Item in context.
Pending Inventory Pending Transactions To edit and correct a pending transaction, click Pending Transactions to navigate to the Pending Transactions window.
Receiving Interface Receiving Interface To view details for a receiving transaction, click Receiving Interface to navigate to the Transaction Statuses window.
Cycle Count Interface Cycle Count Interface To update cycle count entry information or correct an error, click Cycle Count Interface to navigate to the Inquiry/Update Cycle Count Entries Open Interface window.
Reservations Interface Reservations Interface To process an unprocessed reservation request or a reservation request with an error, click Reservations Interface to navigate to the Reservations Interface window.

Handling Errors in the Object Genealogy Interface: Because there is no window or page to correct transactions with errors in the Object Genealogy Interface, review these transactions in the interface table. To correct an error, search for the specific lot or serial number in Oracle Inventory.

Table-Level Actions in the Results Tables

Transactions Interface Table-Level Actions

the picture is described in the document text

Pending Inventory Table-Level Actions

the picture is described in the document text

Receiving Interface Table-Level Actions

the picture is described in the document text

Cycle Count Interface Table-Level Actions

the picture is described in the document text

Reservations Interface Table-Level Actions

the picture is described in the document text

Object Genealogy Interface Table-Level Actions

the picture is described in the document text

Important: After you update transactions in the Oracle Inventory windows, you must run the concurrent requests that are available from the Options icon in the results tables. Select one or more rows and click the Options icon to act on your selection.

Table-Level Actions
Results Table Action Description
Transactions Interface Launch Process Transactions Interface This concurrent request processes material transactions after changes to these transactions in any of the transaction windows in Oracle Inventory.
In the result table, even if you select one or more records for the action, the application submits the concurrent request for all the Transaction Open Interface transactions that you have updated in Oracle Inventory.
Pending Inventory Launch Process Transactions Interface In the result table, even if you select one or more records for the request, the application submits the concurrent request for all the Pending Transactions Interface records that you have updated in Oracle Inventory.
Receiving Interface Launch Receiving Transaction Processor This concurrent request processes pending or unprocessed receiving transactions.
In the result table, even if you select one or more records for the action, the application submits the concurrent request for all the Receiving Open Interface records that you have updated in Oracle Inventory.
Cycle Count Interface Import Cycle Count Entries from Open Interface This process allows you to import cycle count entries open interface records into the database. In the result table, when you select this action, the concurrent request processes cycle count headers of the selected records.
Reservations Interface Launch Reservations Interface Manager This request processes reservation requests. In the result table, even if you select one or more records for the action, the application submits the concurrent request for all the Reservations Interface records that you have updated in Oracle Inventory.
Object Genealogy Launch Asset Genealogy Import Program The Asset Genealogy Import process reads information within the MTL_OBJECT_GENEALOGY_INTERFACE table, and then imports that information into the production tables. Refer to the Oracle Enterprise Asset Management Implementation Guide for more information.
When you select this action, the concurrent request processes the selected records of the specific Batch ID.

Items Dashboard

See Inventory Management Command Center Overview.

Use the Items Dashboard to efficiently find items to expedite business processes. The dashboard provides visibility over the key attributes of the item master. The dashboard enables you to discover similar, alternate items across organizations and enable parts reuse. You can identify and compare alternate suppliers and manufacturers for parts, resolve item catalog attribute setups causing transaction issues, and track items with pending revision and future effective date. Search for items by entering refinement terms, and analyze and refine the dashboard data by clicking metrics, alerts, and graphs.

Use the dashboard to:

Access the Items Dashboard using the following navigation:

(N) Manufacturing and Distribution Manager (responsibility) > Inventory > Items > Items Dashboard

Items Dashboard

the picture is described in the document text

Attributes Tab Row-Level Actions

the picture is described in the document text

Note: If suppliers with an item-supplier combination are debarred, that is, the Disabled checkbox is selected in the Purchasing, Approved Supplier List window, then the Items Dashboard does not include these suppliers in the calculation of metrics and charts.

The following table describes the dashboard:

Components Description
All Items (tab) This tab contains the following key metrics. You can refine the dashboard data by clicking a metric value.
  • Master Items: This metric shows how many items are defined in the Item Master organization.

  • Organization Items: This metric shows how many items are assigned to the organizations.

  • Items with Pending Revisions: This metric shows how many items are pending a revision.

Items by Function (tab) This tab contains the following key metrics. You can refine the dashboard data by clicking a metric value.
  • Manufactured Items: This metric shows how many items are defined as manufactured items across the organization.

  • Stockable Items: This metric shows how many items are defined as stockable items across the organization.

  • Purchased Items: This metric shows how many items are defined as purchased items across the organization.

  • Customer Ordered Items: This metric shows how many items are defined as customer ordered items across the organization.

  • Shippable Items: This metric shows how many items are defined as shippable items across the organization.

  • Asset Items: This metric shows how many items are defined as asset items across the organization.

  • Service Items: This metric shows how many items are defined as service items across the organization.

Items Information (region)
Overview (tab)
This region contains the Overview tab with the following charts:
  • Item Functions: This graph shows all the items by their function.

  • Item (Count Distinct) by Catalog Group, Status: This graph shows all the items by the catalog group and status.


The record detail section displays key attributes of an item. To view further details of the item, click the Record Details icon.
Items Information (region)
Attributes (tab)
This tab contains a table that shows the item attributes. Select an item attribute group from the list to display the details of the selected item attribute group.
To update an item's specifications or other related details, click the link icon in the Update Item column to navigate to the Update Overview page.
To perform the following actions, click the row- level Actions icon and select an action:
  • To view details of where the item is used, select Item Where Used to navigate to the Indented Bills tab on the Bills of Material dashboard.

  • To view and act on the on-hand availability for an item lot, select On Hand to navigate to the Material Workbench window.

  • To add an attachment to an item, select Item Attachments to open the Attachments page.

  • To view the structure list for the item, select Item Structure to navigate to the Structure List page.

Items Information (region)
Revisions (tab)
This tab contains a table that shows the current, past, and future revisions, organization, revision label and its effective date details, and the revision reason.
You can perform the follow row-level actions:
  • To view the Engineering Change Order (ECO) for an item, click the link icon in the ECO column to navigate to the Change Order Summary page.

  • To add an attachment to an item, click the link icon in the Item Attachments column to open the revision level Attachments page.


Select an item attribute group from the list to display the details of the selected item attribute group.
Items Information (region)
Approved Suppliers (tab)
This tab contains a tag cloud that shows the top ten suppliers. The record details section displays the approved supplier, supplier status, organization code and supplier item details for an item.
Items Information (region)
Manufacturers (tab)
This tab contains a tag cloud that shows the top ten manufacturers, and a grid that shows manufacturers. The record details section displays the organization, manufacturer, manufacturer part number, and item manufacturers additional information. To view further details of the item, click the Record Details icon.
Items Information (region)
Related Items (tab)
This tab contains a tag cloud that shows the top 10 relationship item types, and a grid that shows related items. The record details section displays the organization, related item, manufacturer part number, and item related additional information. To view further details of the item, click the Record Details icon.
Items Information (region)
Cross-References (tab)
This tab contains a tag cloud that shows the top 10 item cross-reference types, and a grid that shows cross-references. To view further details of the item, click the Record Details icon. The record details section displays the organization, cross reference, cross reference type, and item cross-reference additional information.
Items Information (region)
Classifications (tab)
This tab contains a tag cloud that shows the top 10 categories, and a grid that shows the categories. To view further details of the item, click the Record Details icon. The record details section displays the item, item description, organization, category set name, category name, category set description, and item category additional information.
Options (table-level actions)
  • Compare: Select multiple rows to compare data.

  • Export: Use this action to export the search results in a comma-separated values (CSV) file.

Kanban Dashboard

As a Kanban planner or an inventory control supervisor, use the Kanban Dashboard to:

You can search using the available refinements for Kanban pull sequences, Kanban cards, Kanban lead time, and Kanban demand. For example, you can select to refine your search using item, point of use, inventory health, source type, lead time, card number, unmoved status, current activity, source, planning, demand report, and so on.

From the eKanban Super User responsibility, navigate to the Kanban Dashboard:

(N) Home (OAF)> Kanban Dashboard (tab)

Kanban Dashboard

the picture is described in the document text

The following table describes the Kanban Dashboard components:

Component Description
Kanban Pull Sequences (summary bar) The Kanban Pull Sequences summary bar displays the following metrics:
  • Items

    This metric displays the number of unique items with pull sequence definitions.

  • Points of Use

    This metric displays the number of points of use in the pull sequence definitions.

  • Pull Sequences

    This metric displays the number of pull sequences.

  • Low Stock

    This metric displays the number of pull sequences that have low stock. Click this metric to view information in the Inventory Health tab.

  • Excess Stock

    This metric displays the number of pull sequences that have excess stock. Click this metric to view information in the Inventory Health tab.

  • Shorter Lead Time

    This metric displays the number of pull sequences with actual lead time lesser than the planned lead time. Click this metric to view information in the Replenishment Lead Time tab.

  • Longer Lead Time

    This metric displays the number of pull sequences with actual lead time greater than the planned lead time. Click this metric to view information in the Replenishment Lead Time tab.

  • Lower Demand

    This metric displays the number of pull sequences with actual demand lower than the planned demand. Click this metric to view information in the Kanban Demand tab.

  • Greater Demand

    This metric displays the number of pull sequences with actual demand greater than the planned demand. Click this metric to view information in the Kanban Demand tab.


Click a metric to refine the information in the dashboard.
Kanban Cards (summary bar) The Kanban Cards summary bar displays the following metrics:
  • Active

    This metric displays the total number of cards that are active.

  • On Hold

    This metric displays the total number of cards that are on hold.

  • Unmoved

    This metric displays the total number of cards that are in a specific status for an extended period.

  • Temporary

    This metric displays the total number of cards that are temporary.

  • Empty

    This metric displays the total number of cards that have the supply status as Empty.

  • In Process

    This metric displays the total number of cards that have the supply status as In Process.

  • Full

    This metric displays the total number of cards that have the supply status as Full.


Click any of the metrics to view card information in the Kanban Cards tab.
Inventory Health (tab) The Inventory Health tab provides charts and grids that give you insights into the inventory levels versus the safety stocks and enable you to identify the stock positions and take action to meet any demand.
For details, see Inventory Health Tab.
Replenishment Lead Time (tab) The Replenishment Lead Time tab provides charts and tables that give you insights into the calculation of the actual lead time of replenished cards for each pull sequence and compares it with the planning lead time. You can use the information in this tab to identify the items with longer lead time and plan the replenishments.
For details, see Replenishment Lead Time Tab.
Kanban Demand (tab) The Kanban Demand tab provides charts and tables that give you insights into the calculation of the actual demand for each item based on the number of card replenishments and then compares it with demand calculated from the planning logic. You can use this tab to identify the items with greater demand and plan the replenishments accordingly.
For details, see Kanban Demand Tab.
Kanban Cards (tab) The Kanban Cards tab provides charts and tables that give you insights into the cards that have been in a specific supply status for an extended length of time. You can use this tab to identify such cards and update the status.
For details, see Kanban Cards Tab.

Inventory Health Tab

The Inventory Health tab displays the inventory levels as compared to the safety stocks. Based on the percentage of the actual inventory to safety stock, inventory health can be categorized into Low Stock, Normal Stock, or Excess Stock.

Inventory Health Metrics Calculations

The following parameters are used in the calculation:

Values that are greater than or equal to the Inventory Health Threshold - Bad, or less than the Inventory Health Threshold - Good, are considered as Normal Stock (Green).

Inventory health is displayed as None (Gray) when the parameters are not set up and safety stock days, average daily demand are not defined in the pull sequence. You can define the Average Daily Demand with a specific average demand using the Update Production action in the Planning Workbench. See Viewing and Updating Pull Sequence Planning, Oracle Electronic Kanban User's Guide.

Example: Inventory Health Calculation

The following example explains the inventory health calculation.

In this example, Parameters are set as follows on the Configurations tab, Parameters page. See Configuring Kanban Parameters, Oracle Electronic Kanban User's Guide.

For inventory health threshold:

For an item pull sequence:

Inventory Health calculations is based on the parameters and pull sequence setup:

The following table shows the Inventory Health, which is displayed based on the Cards in Supply Status set to Full.

Inventory Health Indicators
Case Cards in Supply Status Full Quantity Inventory Health
1 1 100 Low Stock (Red)
2 2 200 Normal Stock (Green)
3 3 300 Excess Stock (Yellow)

Also, Custom Extension is available to define specific values at the Pull Sequence level to override the parameters that are set at the Organization level. See Configure Inventory Health Analytic, Oracle Electronic Kanban User's Guide.

Inventory Health Tab Components

Inventory Health Tab

the picture is described in the document text

Inventory Health Tab - Table-Level Actions

the picture is described in the document text

The following table describes the Inventory Health tab components:

Component Description
Pull Sequence (Count Distinct) by Point of Use, Inventory Health (chart) This chart displays the inventory health of pull sequences by point of use. Click the Options icon to select Inventory Health or Point of Use from the Dimension menu. Select Point of Use from the Group Dimensions menu.
Pull Sequence (Count Distinct) by Source Type, Inventory Health (chart) This chart displays the inventory health of pull sequences by source type. Click the Options icon to select Inventory Health or Source from the Dimension menu. Select Source Type, Source, Supplier, Source Subinventory, or Source Organization from the Group Dimensions menu.
Inventory Health Summary by Point of Use (pivot table) Use this table to analyze the inventory health of pull sequences by point of use.
Inventory Health Summary by Source Type (pivot table) Use this table to analyze the inventory health of pull sequences by source type.
Pull Sequences Results Table (tab layout) On the Inventory Health tab's Pull Sequences results table, you can select from the following attribute groups to display details by:
  • Source

  • Kanban

  • Planning

  • Card Supply Status


Click the Record Details icon for a selected item to view the Details dialog box.
You can perform the following row-level actions. Select a row, click the Actions icon and select from the following:
  • View Replenishment Chain: Click this action link to view the Replenishment Chain network diagram. The Replenishment Chain network diagram helps you to visualize the replenishment information and act when required. The diagram contains the following entity nodes:

    • Supplier

    • Organization

    • Production

    You can view the data set name, site, location, sublocation, and the item name for each of the nodes. The nodes support all the source types.

    Right-click a node to select the following options available for the node:

    • Make Anchor Node: Select this option to make a node the main node.

    • Show Adjacent Nodes: Select this option to expand a node to see its related nodes.

    • Highlight Path: Select this option to highlight the specific path of a node. You can right-click and select Unhighlight Path to remove highlighting a path.

    • Explore Node: Select this option to explore the node further.

    • Compare: Select multiple nodes and click Compare for a side-by-side comparison of the records of each selected node.

    • Show Details: Select this for a node to open the Details window to view all attribute details such as site, location, sublocation, item, description, organization, subinventory, locator, number of cards, size, and UOM.

      On the Details window, select multiple filters and then click:

      • Find Similar to apply these filters to the diagram.

      • Search Within to search for your selected filter within the diagram.

  • View Pull Sequence: Click this action link to view details in the Pull Sequence Details tab.


To perform a table-level action, select one or more rows and choose from the following actions available from the Options icon in the Inventory Health tab's results table:
  • Compare: Select multiple rows to compare information.

  • Export: Click the Export icon to export the selected search results in a comma-separated values (CSV) file format.

  • Kanban Setup: Click this link to open the Kanban Pull Sequences page on the Kanban Setup tab.

  • Cards Summary: Click this link to open the Kanban Pull Sequences page on the Cards Summary tab.

  • Kanban Planning: Click this link to open the Pull Sequence Planning page on the Kanban Planning tab.

See:

Replenishment Lead Time Tab

The Replenishment Lead Time tab shows the actual lead time of replenished cards for each pull sequence, and compares it with lead time setup in the Planning tabbed region for the pull sequence. See Planning Workbench, Oracle Electronic Kanban User's Guide.

Replenishment Lead Time Metrics Calculations

The dashboard displays the number of pull sequences, taking into account the tolerance value, for:

Note: Lead Time will be displayed as None (Gray) when the parameters are not set up and lead time is not defined in the pull sequence or if there are no replenishment cycles completed within the defined range of days.

You can define the default time period and set the value for tolerance using the Electronic Kanban parameters for lead time calculations:

The following parameter values are used in the "System Defined" report:

Note: You can also define custom reports with different range start date, range end date and equality tolerance for replenishment lead time calculations.

Example: Replenishment Lead Time Calculation

The following example explains the replenishment lead time calculation.

In this example, Parameters are set as follows on the Configurations tab, Parameters page. See Configuring Kanban Parameters, Oracle Electronic Kanban User's Guide.

For lead time:

For an item pull sequence:

The Lead Time calculations is based on the parameters and pull sequence setup.

Actual Lead Time Calculations

Assume that the number of replenishments in the last 10 days (based on the parameter setting) is 5.

The following table shows the calculation of replenishment lead time and days.

Replenishment Lead Time Calculation
Replenishment Lead Time Days
Card 1, cycle 1 2.5
Card 2, cycle 1 2.5
Card 1, cycle 2 2.5
Card 2, cycle 2 1.8
Card 1, cycle 3 2.7
Average Lead Time (2.5+2.5+2.5+1.8+2.7)/5 = 2.4 days

In this example, the "System Defined" report shows the pull sequence with Longer Lead Time (Red).

Replenishment Lead Time Tab Components

Replenishment Lead Time Tab

the picture is described in the document text

Replenishment Lead Time Tab - Table-Level Actions

the picture is described in the document text

The following table describes the Replenishment Lead Time tab components:

Component Description
Report Count (link) Click Report Count to view and select from multiple reports.
Note that the Replenishment Lead Time tab defaults the System Defined report based on the parameters set on the Configurations tab, Parameters page. You can only create lead time reports.

Note: If your system administrator runs the Electronic Kanban ECC Data Load with the Full Load option, then after the completion of the full load, user defined reports are removed, and the dashboard displays only the system defined report.

Create New Lead Time Report (button) To define a lead time report:
  1. Click Create New Lead Time Report and provide information in the following fields:

    • Report Name: Enter a name for the report.

    • Range Start Date: The date that defaults to this field is based on the "Actual vs Planned Lead Time - Default Number of Days" parameter set on the Configurations tab, Parameters page. You can update the default value.

    • Range End Date: The current system date defaults to this field. You can update the default value.

    • Lead Time Tolerance: The value that defaults to this field is based on the "Actual vs Planned Lead Time - Equality Tolerance" parameter set on the Configurations tab, Parameters page. You can update the default value.

  2. Click Create.

    When you create a report, the Kanban Dashboard refreshes to display information based on the new report.

Pull Sequence (Count Distinct) by Point of Use, Lead Time (chart) This chart enables you to identify the number of pull sequences by point of use based on the Replenishment Lead Time classification. You can drill down on the pull sequence values. Click the Options icon to select Lead Time or Point of Use from the Dimension menu. Select Point of Use from the Group Dimensions menu.
Pull Sequence (Count Distinct) by Source Type, Lead Time (chart) This chart enables you to identify the number of pull sequences by source type based on the Replenishment Lead Time classification. You can drill down on the pull sequence values. Click the Options icon to select Lead Time, Source Type, or Source from the Dimension menu. Select Source Subinventory, Source, Supplier, Source Organization, and Source Inventory from the Group Dimensions menu.
Lead Time Summary by Point of Use (pivot table) Use this table to analyze lead time classification of pull sequences by point of use.
Lead Time Summary by Source Type (pivot table) Use this table to analyze lead time classification of pull sequences by source type.
Pull Sequences Results Table (tab layout) On the Replenishment Lead Time tab's Pull Sequences results table, you can select from the following attribute groups to display details by:
  • Source

  • Kanban

  • Planning

  • Report


Click the Record Details icon for a selected item to view the Details dialog box.
To perform a row-level action, select a row and click the View Pull Sequence icon to view details in the Pull Sequence Details tab.
Click the links in the table columns to refine the information available in the Kanban Dashboard.
To perform a table-level action, select one or more rows and choose from the following actions available from the Options icon in the Replenishment Lead Time tab's results table:
  • Compare: Select multiple rows to compare information.

  • Export: Click the Export icon to export the selected search results in a comma-separated values (CSV) file format.

  • Kanban Setup: Click this link to open the Kanban Pull Sequences page on the Kanban Setup tab.

  • Cards Summary: Click this link to open the Kanban Pull Sequences page on the Cards Summary tab.

  • Kanban Planning: Click this link to open the Pull Sequence Planning page on the Kanban Planning tab.

See:

Kanban Demand Tab

In the Actual Demand versus Planned Demand calculation, the actual demand is calculated for each pull sequence, and compared with average daily demand as calculated from the planning logic. The dashboard displays the number of pull sequences where actual demand is greater than planned, less than planned, and equal to planned, taking into account the tolerance value.

Demand Metrics Calculations

You can define the default time period and set the value for tolerance using the Electronic Kanban parameters for demand calculations:

Demand is displayed as None (Gray) when the parameters are not set up or average daily demand is not defined in the pull sequence or if there are no replenishments performed within the defined range of days. You can define the Average Daily Demand with a specific average demand using the Update Production action in the Planning Workbench. See Viewing and Updating Pull Sequence Planning, Oracle Electronic Kanban User's Guide.

The following parameter values are used in the "System Defined" report.

Note: You can also define custom reports with different range start date, range end date and equality tolerance for demand calculations.

Example: Demand Calculation

The following example explains the Demand calculation.

In this example, Parameters are set as follows on the Configurations tab, Parameters page. See Configuring Kanban Parameters, Oracle Electronic Kanban User's Guide.

For demand:

For an item pull sequence:

Demand calculations is based on the parameters and pull sequence setup.

Actual Demand Calculations:

In this example, the "System Defined" report shows the pull sequence with Greater Demand (Red).

Kanban Demand Tab Components

Kanban Demand Tab

the picture is described in the document text

Kanban Demand Tab - Table-Level Actions

the picture is described in the document text

The following table describes the Kanban Demand tab components:

Component Description
Report Count (link) Click Report Count to view and select from multiple demand reports.
Note that the Kanban Demand tab defaults the System Defined report based on the parameters set on the Configurations tab, Parameters page. You can only create reports.

Note: If your system administrator runs the Electronic Kanban ECC Data Load with the Full Load option, then after the completion of the full load, user defined reports are removed, and the dashboard displays only the system defined report.

Create New Demand Report (button) To define a demand report:
  1. Click Create New Demand Report and provide information in the following fields:

    • Report Name: Enter a name for the report.

    • Range Start Date: The date that defaults to this field is based on the "Actual vs Planned Demand - Default Number of Days" parameter set on the Parameters page of the Configurations tab. You can update the default value.

    • Range End Date: The current system date defaults to this field. You can update the default value.

    • Demand Tolerance: The value that defaults to this field is based on the "Actual vs Planned Demand - Equality Tolerance" parameter set on the Parameters page of the Configurations tab. You can update the default value.

  2. Click Create.

    When you create a report, the Kanban Dashboard refreshes to display information based on the new report.

Pull Sequence (Count Distinct) by Point of Use, Demand (chart) This chart displays the number of pull sequences by point of use based on the Demand classification. You can drill down on the pull sequence values. Click the Options icon to select Demand or Point of Use from the Dimension menu. Select Point of Use from the Group Dimensions menu.
Pull Sequence (Count Distinct) by Source Type, Demand (chart) This chart displays the number of pull sequences by source type based on the Demand classification. You can drill down on the pull sequence values. Click the Options icon to select Demand, Source Type, or Source from the Dimension menu. Select Source Type, Source, Supplier, Source Organization, or Source Subinventory from the Group Dimensions menu.
Demand Summary by Point of Use (pivot table) Use this table to analyze demand classification of pull sequences by point of use.
Demand Summary by Source Type (pivot table) Use this table to analyze demand classification of pull sequences by source type.
Pull Sequences Results Table (tab layout) On the Kanban Cards tab's Pull Sequences results table, you can select from the following attribute groups to display details by:
  • Source

  • Kanban

  • Planning

  • Report


Click the Record Details icon for a selected item to view the Details dialog box.
Click the links in the table columns to refine the information available in the Kanban Dashboard.
To perform a row-level action, select a row and click the View Pull Sequence icon to view details in the Pull Sequence Details tab.
To perform a table-level action, select one or more rows and choose from the following actions available from the Options icon in the Kanban Demand tab's results table:
  • Compare: Select multiple rows to compare information.

  • Export: Click the Export icon to export the selected search results in a comma-separated values (CSV) file format.

  • Kanban Setup: Click this link to open the Kanban Pull Sequences page on the Kanban Setup tab.

  • Cards Summary: Click this link to open the Kanban Pull Sequences page on the Cards Summary tab.

  • Kanban Planning: Click this link to open the Pull Sequence Planning page on the Kanban Planning tab.

See:

Kanban Cards Tab

The Kanban Cards tab displays cards that have been in a particular supply status for an extended period of time.

Unmoved Cards Metric Calculations

The length of time each supply status a card is considered unmoved is set in the Card Supply Statuses Electronic Kanban parameter. For this parameter, enter the percentage of lead time to show the length of time each supply status a card is considered unmoved. See Configuring Kanban Parameters, Oracle Electronic Kanban User's Guide.

The Unmoved Cards Calculation program calculates the number of cards that are in each supply status for a period of time configured by you. The program:

  1. Selects all pull sequences for an organization. For every pull sequence, all Kanban cards are selected.

  2. Finds the percentage of lead time for the valid statuses.

  3. Gets the planned lead time for the pull sequence.

  4. For every card, gets the Last Activity Date, Status, and Creation Date.

Example: Unmoved Cards Calculation

The following example explains the unmoved cards calculation.

In this example, Parameters are set as follows on the Configurations tab, Parameters page. See Configuring Kanban Parameters, Oracle Electronic Kanban User's Guide.

Unmoved cards calculation is based on the parameters setup.

Card is Unmoved when lead time in In Process supply status is greater than +10 % of 2 or 0.2 days.

Assume the card supply status is In Process for 1 day. then, this card will be displayed as Unmoved card.

Also, Custom Extension is available to define specific values at the Pull Sequence or Kanban Card level to override the parameters that are set at the Organization level. See Determine Unmoved Kanban Cards Program, Oracle Electronic Kanban User's Guide.

Kanban Cards Tab Components

Kanban Cards Tab – Row-Level Actions

the picture is described in the document text

Kanban Cards Tab – Table-Level Actions

the picture is described in the document text

The following table describes the Kanban Cards tab components:

Component Description
Unmoved Card (Count Distinct) by Unmoved Duration, Supply Status (chart) This chart shows the number of unmoved Kanban cards in each supply status and unmoved duration. The chart uses the following predefined unmoved duration days:
  • 0-1 Days

  • 1-3 Days

  • 3-6 Days

  • 6-10 Days

  • 10+ Days


Click the Options icon to select Supply Status, Source Type, or Source from the Dimension menu. Select Unmoved Duration from the Group Dimensions menu.
Unmoved Card (Count Distinct) by Source Type, Supply Status (chart) This chart shows the number of unmoved Kanban cards by source type and supply status. Click the Options icon to select Supply Status or Source from the Dimension menu. Select Source Type, Source, or Point of Use from the Group Dimensions menu.
Unmoved Cards Summary by Point of Use (pivot table) Use this table to analyze unmoved cards by point of use.
Unmoved Cards Summary by Source Type (pivot table) Use this table to analyze unmoved cards by source type.
Kanban Cards Results Table (tab layout) On the Kanban Cards results table, you can select from the following attribute groups to display details by:
  • Kanban

  • Current Activity

  • Replenishment


Click the Record Details icon for a selected item to view the Details dialog box.
Click the links in the table columns to refine the information available in the Kanban Dashboard.
To perform a row-level action, select a row and click the Change Supply Status icon to navigate to the Change Card Supply Status page on the Cards Action tab. On this page, select the target status and click Change Status to update the status of the Kanban card. To return to the dashboard, click the Kanban Dashboard breadcrumb.
To perform the following table-level actions, select one or more rows and click the Options icon in the results table:
  • Compare: Select multiple rows to compare information.

  • Export: Click the Export icon to export the selected search results in a comma-separated values (CSV) file format.

  • Cards Summary: Click this link to open the Kanban Pull Sequences page on the Cards Summary tab.

  • Change Supply Status: To change the supply status of multiple Kanban cards, click this link to navigate to the Change Card Supply Status page on the Cards Action tab. On this page, select the target status and click Change Status to update the status of the Kanban cards. To return to the dashboard, click the Kanban Dashboard breadcrumb.

    Important: The administrator must run the Electronic Kanban ECC Data Load program, to view the latest status of the Kanban cards.

    After the program runs successfully, you can view the following changed information about the Kanban cards:

    • In the Kanban Cards summary bar, the Unmoved metric shows the recalculated count of the Kanban cards.

    • In the Kanban Cards results table:

      • The Unmoved column shows the value No.

      • The Supply Status column shows the latest status.

See: