Oracle A75089-02 - Manual (Page 105)

Running the INTRASTAT Movement Statistics (MVSTO) Extract Program
Outbound Transactions 8-5
As data is extracted from e-Commerce Gateway, only movement statistics with the
status of Verify or Frozen are extracted. Once data is extracted, the e-Commerce
Gateway sets the transaction status to EDI.
For more information on Intrastat, see:
■
Movement Statistics, Oracle Purchasing User’s Guide
■
Defining Economic Zones and Defining Movement Statistic Parameters, Oracle
Inventory User’s Guide.
Prerequisites
❏ Create the outbound directory and update the INIT.ORA file. See: Defining
Data File Directories, Oracle e-Commerce Gateway Implementation Manual.
❏ Define the ECE: Outbound file path profile option. See: e-Commerce Gateway
Profile Options, Oracle e-Commerce Gateway Implementation Manual, Release 11i.
❏ Define trading partner relationships and enable EDI transactions for the trading
partner. See: Defining Trading Partner Data on page 3-4.
❏ Define code conversions. See:
Defining Code Conversion Categories on
page 4-8, Assigning Categories on page 4-10, and Defining Code Conversion
Values on page 4-15.
❏ Customize interface data file layout, if necessary. See: Changing the Interface
Data File Record Layout on page 5-2.
To run the INTRASTAT movement statistics (MVSTO) extract program:
1. Navigate to the Extract Program window.
2. Select Request to submit an individual request.
3. Select the Movement Statistics (MVSTO) transaction.
4. In the Parameters window, enter the following selection criteria:
■
Specify an output path and file name if not using the default.
Note: Oracle e-Commerce Gateway extracts data from Oracle
Purchasing, Oracle Inventory, and Oracle Order Management
tables. However, you only need licenses to one of these applications
to run the Movement Statistics program.