Search Results tph_attribute1

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:

TRANSACTION_RECORD_ID — Surrogate unique identifier; enforced by the unique index ECE_MVSTO_HEADERS_U1. This is the business-key candidate for row-level identification.
TP_DOCUMENT_ID — Foreign key to ECE_AR_TRX_HEADERS, linking the movement statistics header to the originating transaction document.
LEGAL_ENTITY_ID — Foreign key to FV_LEGAL_ENTITIES, identifying the reporting legal entity.
ENTITY_ORG_ID — Foreign key to MTL_MOVEMENT_PARAMETERS, tying the header to the inventory organization movement parameters.
SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used for row-level security partitioning.
PERIOD_NAME — The reporting period for which movement statistics are being transmitted.
MOVEMENT_TYPE, STAT_TYPE, USAGE_TYPE, MOVEMENT_STATUS — Core statistical classifiers, each accompanied by up to five extension columns (_EXT1 through _EXT5) for regional or country-specific values.
ZONE_CODE and ECONOMIC_ZONE_EXT* — Economic zone identifiers used in statistical reporting.
TOTAL_STATISTICAL_VALUE, TOTAL_INVOICE_EXT_VALUE, TOTAL_TOTAL_WEIGHT, TOTAL_SUPPLEMENTARY_UNITS, TOTAL_RECORDS — Aggregated totals for the header, summarizing the associated detail lines.
LEGAL_ENTITY_NAME, LEGAL_ENTITY_VAT_CODE, LEGAL_ENTITY_ADDRESS1 through LEGAL_ENTITY_POSTAL_CODE, LEGAL_ENTITY_COUNTRY_INT, and the region columns — Denormalized address and tax registration details for the reporting entity.
RUN_ID, TRANSACTION_DATE, EDI_TRANSACTION_REFERENCE, EDI_TRANSACTION_DATE — Execution and transmission metadata.
HEADER_DATA_EXIST_FLAG — Indicates whether detail data exists for this header, controlling downstream processing.

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.

Table: ECE_MVSTO_HEADERS 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_MVSTO_HEADERS, object_name:ECE_MVSTO_HEADERS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the movement statistics header data to support the outbound Movement Statistics transaction. , implementation_dba_data: EC.ECE_MVSTO_HEADERS ,
Table: ECE_MVSTO_HEADERS 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_MVSTO_HEADERS, object_name:ECE_MVSTO_HEADERS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the movement statistics header data to support the outbound Movement Statistics transaction. , implementation_dba_data: EC.ECE_MVSTO_HEADERS ,
Table: ECE_ADVO_HEADERS_INTERFACE 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_ADVO_HEADERS_INTERFACE, object_name:ECE_ADVO_HEADERS_INTERFACE, status:VALID, product: EC - e-Commerce Gateway , description: Contains the header data to support the outbound Application Advice (824/APERAK) transaction. , implementation_dba_data: EC.ECE_ADVO_HEADERS_INTERFACE ,
Table: ECE_ADVO_HEADERS_INTERFACE 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_ADVO_HEADERS_INTERFACE, object_name:ECE_ADVO_HEADERS_INTERFACE, status:VALID, product: EC - e-Commerce Gateway , description: Contains the header data to support the outbound Application Advice (824/APERAK) transaction. , implementation_dba_data: EC.ECE_ADVO_HEADERS_INTERFACE ,
Table: ECE_AP_CHECKS_INTERFACE 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_AP_CHECKS_INTERFACE, object_name:ECE_AP_CHECKS_INTERFACE, status:VALID, product: EC - e-Commerce Gateway , description: Contains the payment data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction. , implementation_dba_data: EC.ECE_AP_CHECKS_INTERFACE ,
Table: ECE_AP_CHECKS_INTERFACE 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_AP_CHECKS_INTERFACE, object_name:ECE_AP_CHECKS_INTERFACE, status:VALID, product: EC - e-Commerce Gateway , description: Contains the payment data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction. , implementation_dba_data: EC.ECE_AP_CHECKS_INTERFACE ,
Table: ECE_SPSO_HEADERS 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_SPSO_HEADERS, object_name:ECE_SPSO_HEADERS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the supplier schedule header data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions. , implementation_dba_data: EC.ECE_SPSO_HEADERS ,
Table: ECE_SPSO_HEADERS 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_SPSO_HEADERS, object_name:ECE_SPSO_HEADERS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the supplier schedule header data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions. , implementation_dba_data: EC.ECE_SPSO_HEADERS ,
Table: ECE_AR_TRX_HEADERS 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_AR_TRX_HEADERS, object_name:ECE_AR_TRX_HEADERS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction. , implementation_dba_data: EC.ECE_AR_TRX_HEADERS ,
Table: ECE_AR_TRX_HEADERS 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_AR_TRX_HEADERS, object_name:ECE_AR_TRX_HEADERS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction. , implementation_dba_data: EC.ECE_AR_TRX_HEADERS ,
Table: ECE_PO_INTERFACE_HEADERS 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_INTERFACE_HEADERS, object_name:ECE_PO_INTERFACE_HEADERS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the purchase order header data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_INTERFACE_HEADERS ,
Table: ECE_PO_INTERFACE_HEADERS 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_INTERFACE_HEADERS, object_name:ECE_PO_INTERFACE_HEADERS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the purchase order header data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_INTERFACE_HEADERS ,
View: ECE_ADVO_HEADERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_ADVO_HEADERS_V, object_name:ECE_ADVO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Header View@rep:category BUSINESS_ENTITY EC_A , implementation_dba_data: APPS.ECE_ADVO_HEADERS_V ,
View: ECE_MVSTO_HEADERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MVSTO_HEADERS_V, object_name:ECE_MVSTO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Header View@rep:category BUSINESS_ENTITY INV_MOVEM , implementation_dba_data: APPS.ECE_MVSTO_HEADERS_V ,
View: ECE_MVSTO_HEADERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MVSTO_HEADERS_V, object_name:ECE_MVSTO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Header View@rep:category BUSINESS_ENTITY INV_MOVEM , implementation_dba_data: APPS.ECE_MVSTO_HEADERS_V ,
View: ECE_ADVO_HEADERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_ADVO_HEADERS_V, object_name:ECE_ADVO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Header View@rep:category BUSINESS_ENTITY EC_A , implementation_dba_data: APPS.ECE_ADVO_HEADERS_V ,
View: ECE_SPSO_HEADERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_SPSO_HEADERS_V, object_name:ECE_SPSO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Planning Schedule (830/DELFOR) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Planning Schedule Header View@rep:category BUSINESS_ENTITY CHV_PLANNING , implementation_dba_data: APPS.ECE_SPSO_HEADERS_V ,
View: ECE_PYO_PAYMENT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_PYO_PAYMENT_V, object_name:ECE_PYO_PAYMENT_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts payment informationfor the outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep:scope private@rep:product AP@rep:lifecycle active@rep:displayname Payment Order/Remittance Advice Payment View@rep:c , implementation_dba_data: APPS.ECE_PYO_PAYMENT_V ,
View: ECE_PYO_PAYMENT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_PYO_PAYMENT_V, object_name:ECE_PYO_PAYMENT_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts payment informationfor the outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep:scope private@rep:product AP@rep:lifecycle active@rep:displayname Payment Order/Remittance Advice Payment View@rep:c , implementation_dba_data: APPS.ECE_PYO_PAYMENT_V ,
View: ECE_SSSO_HEADERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_SSSO_HEADERS_V, object_name:ECE_SSSO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Shipping Schedule (862/DELJIT) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Shipping Schedule Header View@rep:category BUSINESS_ENTITY CHV_SHIPPING , implementation_dba_data: APPS.ECE_SSSO_HEADERS_V ,
View: ECE_SSSO_HEADERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_SSSO_HEADERS_V, object_name:ECE_SSSO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Shipping Schedule (862/DELJIT) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Shipping Schedule Header View@rep:category BUSINESS_ENTITY CHV_SHIPPING , implementation_dba_data: APPS.ECE_SSSO_HEADERS_V ,
View: ECE_SPSO_HEADERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_SPSO_HEADERS_V, object_name:ECE_SPSO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Planning Schedule (830/DELFOR) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Planning Schedule Header View@rep:category BUSINESS_ENTITY CHV_PLANNING , implementation_dba_data: APPS.ECE_SPSO_HEADERS_V ,
View: ECE_POO_HEADERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_POO_HEADERS_V, object_name:ECE_POO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts header information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO * @rep:lifecycle active* @rep:displayname Purchase Order Header View* @rep:category BUSINESS_ENTI , implementation_dba_data: APPS.ECE_POO_HEADERS_V ,
View: ECE_POO_HEADERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_POO_HEADERS_V, object_name:ECE_POO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts header information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO * @rep:lifecycle active* @rep:displayname Purchase Order Header View* @rep:category BUSINESS_ENTI , implementation_dba_data: APPS.ECE_POO_HEADERS_V ,
View: ECE_POCO_HEADERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_POCO_HEADERS_V, object_name:ECE_POCO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Header View@rep:category BUSINESS_ENTITY PO_PU , implementation_dba_data: APPS.ECE_POCO_HEADERS_V ,
View: ECE_POCO_HEADERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_POCO_HEADERS_V, object_name:ECE_POCO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Header View@rep:category BUSINESS_ENTITY PO_PU , implementation_dba_data: APPS.ECE_POCO_HEADERS_V ,
View: ECE_CDMO_HEADER_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_CDMO_HEADER_V, object_name:ECE_CDMO_HEADER_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header View@rep:category BUSINESS_ENTITY AR_CRE , implementation_dba_data: APPS.ECE_CDMO_HEADER_V ,
View: ECE_INO_HEADER_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_INO_HEADER_V, object_name:ECE_INO_HEADER_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Header View@rep:category BUSINESS_ENTITY AR_INVOICE , implementation_dba_data: APPS.ECE_INO_HEADER_V ,
View: ECE_INO_HEADER_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_INO_HEADER_V, object_name:ECE_INO_HEADER_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Header View@rep:category BUSINESS_ENTITY AR_INVOICE , implementation_dba_data: APPS.ECE_INO_HEADER_V ,
View: ECE_CDMO_HEADER_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_CDMO_HEADER_V, object_name:ECE_CDMO_HEADER_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header View@rep:category BUSINESS_ENTITY AR_CRE , implementation_dba_data: APPS.ECE_CDMO_HEADER_V ,