Skip Headers

Oracle Inventory Movement Statistics User's Guide
Release 12.1
Part Number B31584-02
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Movement Statistics Reports

This chapter covers the following topics:

Movement Statistics Reports

Use the Movement Statistics Reports to review all movements records during a specified period.

There are two reports available for this purpose:

These reports are not intended for making legal movement statistics declarations. Rather, the reports are a comprehensive summary of all movement statistics data for a given period. The reports should be used to check the movement statistics records before making a legal declaration.

To obtain country specific reports for the purpose of making legal declarations, you will have to design and create reports according to local rules and requirements. Alternatively, you may choose to make you movement statistics declarations electronically.

Related Topics

Movement Statistics Declarations

Movement Statistics Standard Reports

The transaction summary reports available with Oracle Movement Statistics are:

Summary Report

The Summary Report lists a single summary line for each movement statistics record. Use this report to verify that the transaction data is correct.

Please refer to the Appendix for a complete listing of the fields displayed on the reports as well as examples of the Summary and Detail Reports.

Note: Records with a status of IGNORE will not be listed on the Summary Report.

Detail Report

The Detail Report displays comprehensive information for each movement statistics record. This report may also be used verify that the transaction data is correct. Note that depending on the number of movement transactions you are reporting for the period, this report may be quite large.

Please refer to the Appendix for a complete listing of the fields displayed on the reports as well as examples of the Summary and Detail Reports.

Note: Records with a status of IGNORE will not be listed on the Detail Report.

Report ParametersReport Parameters
Parameter Possible Values Comments
Legal Entity Any valid legal entity Select the legal entity to make the declaration for.
Economic Zone Any valid economic zone Select the economic zone to make the declaration for.
Usage Type Internal
External
Internal - movement of goods within countries of the economic zone
External - movement of goods from the economic zone to / from countries outside the economic zone
Statistical Type INTRASTAT
EXTRASTAT
Intrastat - movement statistics from within the European Union
Extrastat - movement statistics from within the economic to / from countries outside the economic zone
Movement Type Arrival
Arrival Adjustment
Dispatch
Dispatch Adjustment
Arrival - report on all arrival movement statistics – receipt of goods transactions into an economic zone countries
Arrival Adjustment - report on all adjustments to prior period arrival movement statistics
Dispatch - report on all dispatch movement statistics – shipment / movement of goods from economic zone countries
Dispatch Adjustment - report on all adjustments to prior period dispatch movement statistics
Period Name Any valid period Select the period to make the declaration for.
Report Option Standard Summary
Standard Detail
Select the report to generate.
Currency Valid currency The currency defaults from the set of books currency.
Exchange Rate Valid exchange rate Select the exchange rate from the LOV.

Movement Statistics Report Submission Window

the picture is described in the document text

Create Adjustment Movement Records Error Report

This report automatically creates adjustment movement that report adjustments to previously declared records. This report creates:

Movement Statistics Exception Report

The Movement Statistics Exception Report displays exceptions resulting from user-defined validation rule sets. However, only those attributes with an attribute property of Required, Updateable, or Required, Not Updateable, can be displayed by the Movement Statistics Exception Report.

If a movement statistics record is missing one of the attributes defined in the validation set and the attribute property is Required, Updateable, or Required, Not Updateable, then the report displays one or more of the following messages:

Missing Attributes Messages
Message Description
Movement ID The Movement ID is missing.
Error Missing or incorrect value.
User Action Enter or correct the value.

Movement Statistics Report Submission Process

  1. Enter the parameters to identify the movement statistics report to run.

    Note: All movement statistics reports are submitted from the same window using different parameters.

  2. Submit the program for execution.

  3. Display and view report output.