Search Results ece_mvsto_headers




Overview
Explore in AI Chat

Overview

The ECE_MVSTO_HEADERS table resides in the EC (e-Commerce Gateway) schema and serves as the header-level staging and reference structure for the outbound Movement Statistics transaction. In Oracle EBS 12.1.1 and 12.2.2, it holds the summarized movement statistics data that the e-Commerce Gateway uses to generate outbound EDI or flat-file transmissions to statistical and customs authorities. Each row represents a single movement statistics document header, capturing legal entity, reporting period, movement type, statistical type, and translation-related attributes required for regulatory filing.

The table is classified heuristically as standalone within a Data Vault modeling suggestion. Although it references several parent entities through foreign keys, its own business transactions are not generalized into a shared hub or link pattern; it is best treated as a satellite or standalone reference table centered on the TRANSACTION_RECORD_ID unique key rather than as a pure hub. This classification reflects its role as a document-header store where the primary uniqueness constraint is the transaction record, not a natural business key.

Key Information Stored

The table contains 106 columns, reflecting the breadth of movement statistics metadata. The most significant columns include:

Common Use Cases and Queries

The primary use case is generating outbound Movement Statistics transactions through the e-Commerce Gateway concurrent programs. Users query this table to verify that header data was staged correctly, to reconcile aggregated totals against detail records, and to audit transmitted documents by period or legal entity.

A typical reconciliation query joins the header to the legal entity and transaction document tables:

  • SELECT h.TRANSACTION_RECORD_ID, h.PERIOD_NAME, h.MOVEMENT_TYPE, le.NAME, h.TOTAL_STATISTICAL_VALUE FROM EC.ECE_MVSTO_HEADERS h, FV_LEGAL_ENTITIES le WHERE h.LEGAL_ENTITY_ID = le.LEGAL_ENTITY_ID AND h.PERIOD_NAME = :period;
  • To trace back to the source transaction: SELECT a.TRX_NUMBER, h.EDI_TRANSACTION_REFERENCE FROM EC.ECE_MVSTO_HEADERS h, ECE_AR_TRX_HEADERS a WHERE h.TP_DOCUMENT_ID = a.TP_DOCUMENT_ID;
  • To audit by security group: filter on SECURITY_GROUP_ID in multi-org or multi-entity deployments.

Reporting use cases include period-over-period statistical value comparisons, movement type analysis, and verification of completeness using HEADER_DATA_EXIST_FLAG and TOTAL_RECORDS.

Related Objects

The following objects are the most significant related entities based on the documented foreign key relationships:

  • ECE_AR_TRX_HEADERS — Joined via TP_DOCUMENT_ID; provides the originating transaction document context.
  • FV_LEGAL_ENTITIES — Joined via LEGAL_ENTITY_ID; supplies legal entity master data.
  • MTL_MOVEMENT_PARAMETERS — Joined via ENTITY_ORG_ID; defines inventory organization movement statistics parameters.
  • FND_SECURITY_GROUPS — Joined via SECURITY_GROUP_ID; controls access partitioning.
  • Detail-level MVSTO tables and the e-Commerce Gateway concurrent programs that stage and transmit the Movement Statistics transaction are the primary consumers of this header data.