Oracle Inventory Management Command Center - Movement Statistics Dashboards

This chapter covers the following topics:

Movement Statistics Dashboard

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

The Movement Statistics dashboard provides visibility into extensive and wide-ranging statistical data associated with your trade movement. Use different combinations of key trade attributes to review movement statistics data, and analyze transactions across legal entities.

Use the dashboard to:

Access the Movement Statistics dashboard using the following navigation:

(N) Inventory (responsibility) > Transactions > Movement Statistics Dashboards

Important: The dashboard displays movement statistics data based on a legal entity (which is a business division). Your access to movement records of a legal entity depends on the MO: Security Profile option value set by your system administrator.

Movement Statistics Dashboard

the picture is described in the document text

The following table describes the Movement Statistics dashboard components:

Movement Statistics Dashboard Components
Components Description
Transaction Types (tabbed component) The Transaction Types tabbed component includes the following tabs:
Each tab presents the following components:
  • Movement Statistics Records Status summary bar with metrics

  • Charts

Movement Statistics Records Status (summary bar) The Movement Statistics Records Status summary bar is available in the All Transactions, Order Management, Purchasing, Inventory, and Internal Transactions tabs with the following key metrics. To refine the data, click a metric value.
  • Open: This metric shows the number of movement records that are still open. Your system administrator must run the Movement Statistics Exception Report to validate the records. After validation, the status of the records changes to Verified.

  • Verified: This metric shows the number of movement records that are verified.

  • Exceptions: This metric shows the number of movement records with warnings and errors. To review the exception details, in the Movement Statistics Details table, click the Exceptions link for an appropriate movement record. The Exceptions dashboard appears. The Exception Details table on the dashboard displays the exception type and the exception message. See Exceptions Dashboard.

All Transactions (tab) The All Transactions tab provides metrics and charts to review movement statistics data for Order Management, Purchasing, Inventory, and Internal Transactions. For details, see All Transactions Tab.
Order Management (tab) The Order Management tab provides metrics and charts to review movement statistics data for Oracle Order Management transactions. For details, see Order Management Tab.
Purchasing (tab) The Purchasing tab provides metrics and charts to review movement statistics data for Oracle Purchasing transactions. For details, see Purchasing Tab.
Inventory (tab) The Inventory tab provides metrics and charts to review movement statistics data for Oracle Inventory transactions. For details, see Inventory Tab.
Internal Transactions (tab) The Internal Transactions tab provides metrics and charts to review movement statistics data for inter-org transactions. For details, see Internal Transactions Tab.
Movement Statistics Details (results table) Use this table to review the movement statistics details for movement records. For details, see Movement Statistics Details Results Table.

All Transactions Tab

The All Transactions tab shows metrics and charts for the following source types:

The following table describes the All Transactions tab components:

All Transactions Tab Components
Components Description
Movement Statistics Records Status (summary bar) For details about the metrics, see Movement Statistics Records Status.
Transaction Value (Sum) by Transaction Date, Legal Entity (chart) This chart displays divisional trade statistics. By default, the chart shows the transaction value of trade across quarters for legal entities. Select Invoice from the Group Dimension menu. The metrics are Transaction Value (Sum) and Statistical Value (Sum). By default, the time grain is set to quarterly, and you can change the time grain to daily, weekly, monthly, or yearly.
Transaction Value (Sum) by Transaction Date, Source Type (chart) By default, this chart shows the transaction value for source types across quarters by transaction date. Select a different group dimension to view the transaction value for source types by invoice date. The Dimension menu includes Statistical Type, Movement Type, Item Description, Commodity Description, Dispatch Country, and Destination Country. The metrics are Transaction Value (Sum) and Statistical Value (Sum).
Transaction Value (Sum) by Item Description, Source Type (chart) By default, this chart shows the transaction value of trade by item in each source type across quarters. The Group Dimension menu includes Item Description, Commodity Description, Source Type, Statistical Type, Movement Type, Destination Country, and Dispatch Country. The Dimension menu includes Statistical Type, Movement Type, Item Description, Commodity Description, Dispatch Country, and Destination Country. The metrics are Transaction Value (Sum) and Statistical Value (Sum).

See Movement Statistics Dashboard.

Order Management Tab

The Order Management tab shows metrics and charts for the following source types:

Order Management Tab

the picture is described in the document text

The following table describes the Order Management tab components:

Order Management Tab Components
Components Description
Movement Statistics Records Status (summary bar) For details about the metrics, see Movement Statistics Records Status.
Transaction Value (Sum) by Transaction Date, Legal Entity (chart) This chart displays divisional trade statistics. By default, the chart shows the transaction value of trade across quarters for legal entities. The Dimension menu includes Legal Entity and Source Type. The metrics are Transaction Value (Sum) and Statistical Value (Sum). By default, the time grain is set to quarterly, and you can change the time grain to daily, weekly, monthly, or yearly.
Transaction Value (Sum) by Transaction Date, Source Type (chart) By default, this chart shows the transaction value for source types across quarters by transaction date. Select a different group dimension to view the transaction value for source types by invoice date. The Dimension menu includes Source Type, Statistical Type, Movement Type, Item Description, Commodity Description, Customer Name, and Customer Location. The metrics are Transaction Value (Sum) and Statistical Value (Sum).
Transaction Value (Sum) by Item Description, Source Type (chart) By default, this chart shows the transaction value of trade by item in each source type across quarters. The Group Dimension menu includes Item Description, Commodity Description, Source Type, Statistical Type, Movement Type, Destination Country, Dispatch Country, Customer Name, and Customer Location. The Dimension menu includes Statistical Type, Movement Type, Item Description, Commodity Description, Dispatch Country, and Destination Country. The metrics are Transaction Value (Sum) and Statistical Value (Sum).

See Movement Statistics Dashboard.

Purchasing Tab

The Purchasing tab shows metrics and charts for the following source types:

Purchasing Tab

the picture is described in the document text

The following table describes the Purchasing tab components:

Purchasing Tab Components
Components Description
Movement Statistics Records Status (summary bar) For details about the metrics, see Movement Statistics Records Status.
Transaction Value (Sum) by Transaction Date, Legal Entity (chart) This chart displays divisional trade statistics. By default, the chart shows the transaction value of trade across quarters for legal entities. The Dimension menu includes Legal Entity and Source Type. The metrics are Transaction Value (Sum) and Statistical Value (Sum). By default, the time grain is set to quarterly, and you can change the time grain to daily, weekly, monthly, or yearly.
Transaction Value (Sum) by Transaction Date, Source Type (chart) By default, this chart shows the transaction value for source types across quarters by transaction date. Select a different group dimension to view the transaction value for source types by invoice date. The Dimension menu includes Source Type, Statistical Type, Movement Type, Item Description, Commodity Description, Destination Country, Dispatch Country, and Vendor Name. The metrics are Transaction Value (Sum) and Statistical Value (Sum).
Transaction Value (Sum) by Item Description, Source Type (chart) By default, this chart shows the transaction value of trade by item in each source type across quarters. The Group Dimension menu includes Item Description, Commodity Description, Source Type, Statistical Type, Movement Type, Destination Country, Dispatch Country, and Vendor Name. The Dimension menu includes Source Type, Statistical Type, Movement Type, Item Description, Commodity Description, Dispatch Country, and Vendor Name. The metrics are Transaction Value (Sum) and Statistical Value (Sum).

See Movement Statistics Dashboard.

Inventory Tab

The Inventory tab shows metrics and charts for the following source types:

Inventory Tab

the picture is described in the document text

The following table describes the Inventory tab components:

Inventory Tab Components
Components Description
Movement Statistics Records Status (summary bar) For details about the metrics, see Movement Statistics Records Status.
Transaction Value (Sum) by Transaction Date, Legal Entity (chart) This chart displays divisional trade statistics. By default, the chart shows the transaction value of trade across quarters for legal entities. The Dimension menu includes Legal Entity and Source Type. The metrics are Transaction Value (Sum) and Statistical Value (Sum). By default, the time grain is set to quarterly, and you can change the time grain to daily, weekly, monthly, or yearly.
Transaction Value (Sum) by Transaction Date, Source Type (chart) By default, this chart shows the transaction value for source types across quarters by transaction date. Select a different group dimension to view the transaction value for source types by invoice date. The Dimension menu includes Source Type, Statistical Type, Movement Type, Item Description, Commodity Description, Destination Country, Dispatch Country, From Organization, and To Organization. The metrics are Transaction Value (Sum) and Statistical Value (Sum).
Transaction Value (Sum) by Item Description, Source Type (chart) By default, this chart shows the transaction value of trade by item in each source type across quarters. The Group Dimension menu includes Item Description, Commodity Description, Source Type, Statistical Type, Movement Type, Destination Country, Dispatch Country, From Organization, and To Organization. The Dimension menu includes Source Type, Statistical Type, Movement Type, Item Description, Commodity Description, Destination Country, Dispatch Country, From Organization, and To Organization. The metrics are Transaction Value (Sum) and Statistical Value (Sum).

See Movement Statistics Dashboard.

Internal Transactions Tab

The Internal Transactions tab shows metrics and charts for the following source types:

Internal Transactions Tab

the picture is described in the document text

The following table describes the Internal Transactions tab components:

Internal Transactions Tab Components
Components Description
Movement Statistics Records Status (summary bar) For details about the metrics, see Movement Statistics Records Status.
Transaction Value (Sum) by Transaction Date, Legal Entity (chart) This chart displays divisional trade statistics. By default, the chart shows the transaction value of trade across quarters for legal entities. The Dimension menu includes Legal Entity and Source Type. The metrics are Transaction Value (Sum) and Statistical Value (Sum). By default, the time grain is set to quarterly, and you can change the time grain to daily, weekly, monthly, or yearly.
Transaction Value (Sum) by Transaction Date, Source Type (chart) By default, this chart shows the transaction value for source types across quarters by transaction date. Select a different group dimension to view the transaction value for source types by invoice date. The Dimension menu includes Source Type, Statistical Type, Movement Type, Item Description, Commodity Description, Destination Country, Dispatch Country, From Organization, To Organization, Customer Name, and Customer Location. The metrics are Transaction Value (Sum) and Statistical Value (Sum).
Transaction Value (Sum) by Item Description, Source Type (chart) By default, this chart shows the transaction value of trade by item in each source type across quarters. The Group Dimension menu includes Item Description, Commodity Description, Source Type, Statistical Type, Movement Type, Destination Country, Dispatch Country, From Organization, To Organization, Customer Name, and Customer Location. The Dimension menu includes Source Type, Statistical Type, Movement Type, Item Description, Commodity Description, Destination Country, Dispatch Country, From Organization, To Organization, Customer Name, and Customer Location. The metrics are Transaction Value (Sum) and Statistical Value (Sum).

See Movement Statistics Dashboard.

Movement Statistics Details Results Table

The Movement Statistics Details table shows information for movement records based on the selection of an attribute group. For all the attribute groups, the common columns are Movement Number, Legal Entity, and Period Name.

Movement Statistics Details Table

the picture is described in the document text

Note: The movement statistics information that you view in these attributes is defined in Oracle Inventory, Movement Statistics Summary window. See: Viewing and Maintaining Movement Statistics, Oracle Inventory User's Guide.

You can select from the following attribute groups to display details by:

Performing Row-Level and Table Level Actions

The following row-level and table-level actions are available:

See Movement Statistics Dashboard.

Exceptions Dashboard

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

The Exceptions dashboard is an operational dashboard that provides exception resolution process for movement records.

Use the dashboard to:

Access the Exceptions dashboard using the following navigation:

(N) Inventory (responsibility) > Transactions > Movement Statistics Dashboards

Exceptions Dashboard

the picture is described in the document text

Exception Details - Row-Level Actions

the picture is described in the document text

The following table describes the Exceptions dashboard components:

Exceptions Dashboard
Components Description
Exceptions Summary (metrics) The Exceptions Summary bar presents the following key metrics. Click the metric link to refine the dashboard data.
  • Errors: This metric shows the number of movement records with errors that require resolution. These are the records that will not get verified unless errors are resolved. Scroll to the Exception Details table to review the error details. You can resolve a single error or multiple errors.

  • Warnings: This metric shows the number of movement records with warnings.

Exception Types (tag cloud) This tag cloud provides an overview of attributes with errors and warnings. This tag cloud shows attributes and the number of movement records with incorrect or missing values for attributes. For example, two tag clouds, Delivery Terms (2) and Commodity Code (4) mean that there are two movement records with incorrect or missing value for the Delivery Terms attribute and four movement records with missing value for the Commodity Code attribute. The tag cloud component displays the attributes in relative sizes based on the number of records with errors or warnings. Click a tag cloud to filter based on the relevant tag cloud and review the error exception type in the Exception Details table.
Movement Number (Count Distinct) By Transaction Date, Source Type (chart) By default, this chart shows the number of movement records with exceptions by source type across quarters. You can select a different dimension to plot the chart by exception type, exception name, exception message, and attribute name. You can change the time grain to daily, weekly, monthly, or yearly.
Movement Number (Count Distinct) By Attribute Name (pie chart) This pie chart shows the percentage of attributes with errors. Use this pie chart to identify the attributes that contribute to most of the exception errors. The hover text for each segment displays the attribute name and the number of records with the incorrect attribute value.
Exception Details (results table) The Exception Details table contains the following attribute groups to examine exception details:
  • Exception Details: This attribute group shows the exception type, exception message, and attribute name.

  • Movement Details

  • Miscellaneous

Important: If a movement record has multiple exceptions, then each exception appears in a separate row.


Performing Actions
  • To resolve an exception error for a single record, click the row-level Update action icon to display the Update Movement Record page. Select the attribute value and save.

  • To perform a table-level action, select one or more rows and choose from the following actions available from the Options icon in the Exception Details 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.

    • Mass Update: To resolve exception errors for multiple records at a time, select Mass Update. The Update Movement Record page appears with the selected records. Select the attribute values for the multiple records and save.


Important: After you fix errors, updates to the dashboards happen in real time.
  • The Exceptions dashboard shows the latest number for the Errors metric and the Exception Types cloud tag. The Exception Type column for the related record shows the No Error status. The Error status is cleared from the Exceptions Dashboard, and the record is removed from dashboard after the Movement Statistics ECC Data Load concurrent program is run with the incremental load option.

  • The Exceptions metric in the Movement Statistics dashboard also reflects the latest number.