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 Declarations

This chapter covers the following topics:

Declaration Process

Once you have verified the transaction data, you are ready to transmit the movement statistics declaration to the proper government agencies. Note that Oracle's movement statistics solution does not provide for country-specific reporting. Using Oracle's movement statistic solution, you may make your legal movement statistics declaration either using paper-based reporting or by electronic (EDI, IDEP, or other third party product) based reporting.

The Declaration Process

  1. Determine Declaration Requirements.

  2. Run Movement statistics Official Summary Report.

  3. Transmit Declaration.

Determine Declaration Requirements

Every country requiring movement statistics declarations has different reporting requirements. These country specific requirements include report formats, reporting amount thresholds, level of detail, quantities, reporting periods, etc. You should familiarize yourself with the reporting and transmission requirements of your country to be in compliance with declaration regulations.

Run Official Report

Run the Movement Statistics Official Report to update the status of all movement statistics records for the period specified to FROZEN. The status of all movement statistics records that you are planning to declare must be FROZEN.

Note: All movement records you plan to declare must have a status of FROZEN, whether you are using paper based reporting or not. The only way to update a movement record status to FROZEN is by running the Official Summary Report.

Transmit Declaration

You may transmit your movement statistics declaration using any of the following methods. It is up to you to determine which transmission methods meets your needs and your country's declaration requirements.

Transmit Declaration via Paper Based Report

You may make movement statistics declarations via paper based report. Oracle's movement statistics solution supports making paper based declarations with the Movement Statistics Official Summary Report. Transmission of the declaration may be via fax or mail.

Transmit Declaration via EDI

Legal movement statistics declarations may be made via EDI. You need to determine if the government agency is capable of receiving EDI transmissions. Oracle's movement statistics solution supports making declarations via EDI with Oracle e-Commerce Gateway.

Transmit Declaration via Third Party Product

You may transmit your declaration via any third party product. You need to determine if the government agency accepts the transmission method and format of the third party product.

Paper Based Movement Statistics Declarations

You may choose to make your movement statistics declaration via paper based reporting. This section will briefly review the paper based reporting methods supported by Oracle's movement statistics solution.

Note that each country has their own format and reporting requirements. You need to familiarize yourself with the format, content of reports as well as the acceptable transmission methods for your country.

The following is a list of paper based reporting methods for movement statistics declarations:

  1. Movement Statistics Official Summary Report

  2. Create Custom Country Specific Reports

Movement Statistics Official Summary Report

The format of the Official Report is the same as the Summary report, that is one line of detail per movement record. You may, if this report satisfies country specific reporting requirements, submit this report to the proper government agency. However, if this report does not satisfy the reporting requirements of your country, you will need to create the necessary reports acceptable to your government agency.

Please refer to the Appendix for a complete listing of the fields displayed on this report.

Report Parameters

The Official Summary Report submission report parameters:

Official Summary Report Parameters
Parameter Possible Values Comments
Legal Entity Any valid legal entity Select the legal entity for which you want to make the declaration.
Economic Zone Any valid economic zone Select the economic zone for which you want to make the declaration.
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 for which you want to make the declaration.
Report Option Official Summary Select the ‘Official Summary' report option.
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 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 report concurrent program

  3. Display and view report output

Note: Refer to the Appendix for an example of the Movement Statistics Official Summary Report.

Transmission Methods

You may transmit paper based declarations via either fax or mail. Verify the transmission methods accepted your country.

Create Country Specific Reports

You may create you own country specific reports to fulfill your country's declaration requirements. To do this, you will be required to use a report generating tool.

The following is the process for creating your own country specific reports:

  1. Determine the reporting requirements for your country.

  2. Determine a reporting tool you will use to create the report.

  3. Design and create your report.

Determine Reporting Requirements

Each country may require their own specific format and reporting requirements. You will need to familiarize yourself with report format, report content requirements and transmission methods for each country.

Determine a Reporting Tool

To create a custom report, you should make use of a reporting tool. The reporting tool will enable you to select the information and format it to meet your country's declaration requirements.

Design and Create Report

Once you have selected a report generating tool, design and create your report. Oracle's movement statistics solution provides all the necessary data from which you can generate your declaration report.

Electronic Based Movement Statistics Declarations

To simplify the reporting of movement statistics declarations, many governments are making it possible to submit via electronic means. This section will briefly review the major electronic transmission methods supported by Oracle's Movement Statistics solution.

Note that each country has their own format and reporting requirements. You need to familiarize yourself with report format, content of reports as well as the acceptable transmission methods for your country.

This section will review:

Overview: Electronic Based Declarations

The following is a list of commonly used transmission methods for movement statistics declarations. Most countries require one of the following format types for movement statistics declarations. You should verify which format type is required.

EDI

Electronic Data Interchange (EDI) is the electronic exchange of routine business transactions. These transactions include such documents as purchase orders, invoices, inquiries, planning, acknowledgements, pricing, order status, scheduling, test results, shipping and receiving, payments, and financial reporting.

The subsets of EDI used to transmit movement statistics declarations include:

Note that EDI or any of its subsets including EDIFACT / CUSDEC INSTAT may be transmitted via network, diskette, tape, or as an e-mail attachment.

EDI FACT

Electronic Interchange For Administration, Commerce and Transport (EDIFACT) is a set of internationally agreed standards, directories, and guidelines for the electronic interchange of structured data, and in particular that related to trade in goods and services between independent, computerized information systems. The EDIFACT standard provides a common documentation and a single, unifying business language for communicating across borders.

CUSDEC / INSTAT

CUSDEC / INSTAT is the movement statistics subset message of CUSDEC used for intercommunity (EC) movement statistics declarations. This messages is automatically generated by the IDEP / CN8 software.

Customs Declaration Message (CUSDEC) permits the transfer of data from a declarant to a customs administration for the purpose of meeting legislative and/or operational requirements in respect of the declaration of goods for import, export, or transit. The message may also be used, for example:

Note that EDI or any of its subsets including EDIFACT / CUSDEC INSTAT may be transmitted via network, diskette, tape, or as an e-mail attachment.

IDEP / CN 8

INTRASTAT Data Entry Package / Combined Nomenclature 8 Digits (IDEP / CN8) is a software package used to create and report movement statistics declarations. In Europe, the Statistical Office of the European Communities (Eurostat) has developed this software packaged to reduce the burden and complexity of making movement statistics declarations.

The IDEP / CN 8 software package is usually available, free of charge, from the government agencies responsible for the collection of INTRASTAT data. Please refer to your local government agency for details about obtaining the software.

With this software you can enter movement statistic data (manually or importing it from external system) and validate the data. IDEP will then configure the data into the correct format as required by the government agency.

The IDEP software package generates an EDIFACT standard CUSDEC/INSTAT file. In addition, movement statistic declarations may be sent via diskette or as an e-mail attachment.

Combined Nomenclature 8 Digits (CN8) is a software package that can be installed either as a stand alone package or as part of IDEP. This software is also available free of charge. Combined Nomenclature codes are used for the identification of goods in movement statistic declarations. This software packages helps create the movement statistic declarations by making the CN8 codes corresponding to the goods imported and / or exported easily available.

Neither IDEP nor CN8 is mandatory. You may submit movement statistics declaration using an ASCII format file based on published standards.

ASCII File

You may submit movement statistics declaration using an ASCII format file based on published standards. The format of the ASCII files differs by country, you need to refer to the specific country requirements if you choose to transmit movement statistics declarations using this format.

e-Commerce Gateway

This section reviews creating Movement Statistics EDI transactions with Oracle's E-Commerce Gateway, including:

Overview of Movement Statistics and EDI

Oracle e-Commerce Gateway supports Intrastat and Extrastat requirements by providing for the automatic extraction and electronic processing of movement statistics. However, you must first create the movement statistics transactions using the Movement Statistics Processor.

Subsets of the EDIFACT Customs Declaration (CUSDEC) message are used to report material movement statistics. The CUSDEC subset known as INSTAT reports movement statistics within the European Union. The CUSDEC EXSTAT reports movement statistics between countries of the European Union and any country outside of the European Union.

Only movement statistics records with a movement status of ‘verified' or ‘frozen' are extracted by the Oracle E-Commerce Gateway. Once the movement statistic records are extracted, the movement status is set to EDI.

Pre-Requisites

It is assumed that you will be using Oracle's e-Commerce Gateway to generate and transmit movement statistic EDI transactions.

The following are required to create movement statistics EDI transactions through Oracle's e-Commerce Gateway:

Run e-Commerce Outbound Process

the picture is described in the document text

Process Flow

Transmitting Intrastat declaration via Oracle e-Commerce Gateway process:

  1. Create and Verify movement statistics records by running the Movement Statistics Processor

    Note: the status of all records to be transmitted via the e-Commerce Gateway must be either verified or frozen

  2. Log onto the Oracle e-Commerce Gateway application

  3. Enter all the required parameters to extract movement statistics records

  4. Select the Movement Statistics (MVTSO) transaction to transmit movement statistics

  5. From the e-Commerce Gateway, run the Movement Statistics Extract Concurrent Program

    Refer to the Oracle e-Commerce Gateway User Guide for detailed instructions

Related Topics

Oracle e-Commerce Gateway User's Guide

Oracle e-Commerce Gateway Implementation Guide

Creating Export Data File

This section reviews creating the data export flat file using the Movement Statistics Date Export concurrent program, including:

Data Export Overview

Oracle Movement Statistic's solution will create a data export file with all the necessary data for you to make legal declarations via electronic means including EDI and IDEP. You use the Movement Statistics Create Export Data concurrent program to create this data file.

You may create an export data file for the following movement types:

Only movement statistics records with a status of FROZEN within a given reporting period will be extracted to create the data export file. You should verify that all movement records that you want the Data Export concurrent program to extract have a status of FROZEN.

Once the Movement Statistics Create Data Export concurrent program has run, the status of all movement records that were extracted to create the data export file will be updated to EXPORT. Movement records, once their status is updated to EXPORT, can not be extracted again by the Data Export concurrent program. This prevents movement transactions from being extracted and reported more than once on legal declarations.

IDEP Support Overview

Using the Movement Statistics Data Export concurrent program, you create a flat file that can be imported into IDEP. IDEP will then generate the appropriate Intrastat arrival or dispatch declaration.

The file generated by the Data Export concurrent program contains all Intrastat mandated data for every European Community country. However, since every country that uses IDEP has different reporting requirements, you should be familiar with your country's reporting requirements to configure the IDEP Software for your country's specific regulations.

Prerequisites

  1. Run the Movement Statistics Official Summary Report to update the status to FROZEN.

    The status of all records for the specified period must be ‘frozen' before running the Data Export concurrent program.

  2. Run the Movement Statistics Data Export concurrent program.

    Enter the following parameters to submit this concurrent program:

    This concurrent program creates the data export file that can be imported into IDEP.

  3. Verify that the concurrent program completed successfully.

    Once the export flat file has been created, copy it to a local directory (on the PC that you have installed the IDEP software) to have the IDEP software import the data.

  4. Copy the data export file to your PC with the following steps:

    The process of copying the data export file to your local PC is different in every system. This process generically outlines the steps to copy the data export file to your PC.

    You need the request id for the Data Export concurrent program. The request id will be different for every run of the Data Export concurrent program.

Copy the Export file

  1. Locate the output file created by the execution of the Data Export concurrent program

    You can view all request output by using the View > Requests command from the Toolbar.

  2. Open the output file created by the Data Export concurrent program

    To view the output for a specific request, click View Output.

  3. Copy the file to your PC by using the Tools / Copy command

    The Tools drop down menu is located on the Toolbar and the Copy command is a Tools menu option.

  4. After issuing the Copy command, a new browser window will open with the contents of the Data Export output file

    A new browser window will open.

  5. Save the output file to your local PC from the browser window using the Save As command

    Use the Save As command, located on the browser's Toolbar under ‘File > Save As.

  6. On the Save As window, enter the path and file name for your data export file

    After entering the filename and location, save your file. You should save your file as a text file.

  7. Verify that the file was copied to the location you specified

    Navigate to the location of your file to verify that the save was successful on your PC.

  8. Log onto IDEP on your local PC.

    Start and run the import process from the IDEP software.

  9. Import the data export file you just copied into IDEP. Specify the path to the data export file in IDEP.

    Once imported, verify the data and create your legal declaration.

Related Topics

IDEP User's Guide

Troubleshooting

This section reviews the troubleshooting movement statistics declarations.

Error with Official Summary Report

The Official Summary Report concurrent program ends in error.

Data Export Concurrent Program does not Create a data file.

After you run the Data Export concurrent program, the data file created does not contain any data.

Cause

The most likely cause for this error is that not all the movement statistics records for the period in which the report was run are in status of VERIFIED. All records must be in status of VERIFIED and there must not be any records with the status of OPEN. You have not updated the status of your movement records to FROZEN before running the Data Export concurrent program.

Solution

Review all the records for the period in which the report was run, any records with the status of OPEN must be changed to a status of verified. The Data Export concurrent program only processes records with a status of FROZEN. Verify that you have run the Movement Statistics Official Summary Report for the specified period. The only way in which you can update the status of movement records is by running this report. All records processed by the Data Export program will have a status of EXPORT and will not be processed again by this concurrent program.