Search Results purchase orders

The ECE_PO_INTERFACE_HEADERS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical interface table used in the Procurement module, specifically for processing purchase order (PO) data during electronic commerce integration. This table serves as a staging area for PO header information before it is validated and transferred to the core Oracle Purchasing tables, such as PO_HEADERS_ALL. Below is a detailed breakdown of its structure, purpose, and usage within Oracle EBS.

Purpose and Functionality

The ECE_PO_INTERFACE_HEADERS table is part of Oracle's E-Commerce Gateway (ECG), which facilitates electronic data interchange (EDI) between Oracle EBS and external trading partners. It temporarily stores PO header data received from external systems (e.g., supplier portals or EDI transactions) before it undergoes validation and import into the Oracle Purchasing module. This ensures data integrity and compliance with business rules before becoming official records.

Key Columns and Descriptions

The table contains several columns that map to PO header attributes, including:

TRANSACTION_ID: A unique identifier for each PO transaction in the interface.
PO_NUMBER: The purchase order number assigned by the external system.
VENDOR_ID: Identifier for the supplier, mapped to PO_VENDORS.
SHIP_TO_LOCATION_ID: References the delivery location in HR_LOCATIONS.
BILL_TO_LOCATION_ID: Billing address location ID.
CURRENCY_CODE: The currency of the PO (e.g., USD, EUR).
STATUS: Indicates the processing state (e.g., 'PENDING', 'PROCESSED', 'ERROR').
CREATION_DATE: Timestamp when the record was created in the interface.
LAST_UPDATE_DATE: Timestamp of the last modification.

Integration Workflow

The typical workflow involving ECE_PO_INTERFACE_HEADERS is as follows:

Data Reception: External systems or EDI transactions populate the table with PO header data.
Validation: Oracle's E-Commerce Gateway validates the data against business rules (e.g., valid vendor, currency).
Processing: Valid records are transferred to PO_HEADERS_ALL via concurrent programs like "Import Purchase Orders."
Error Handling: Failed records remain in the interface table with an 'ERROR' status, requiring manual correction.

Technical Considerations

Indexing: The table is indexed on TRANSACTION_ID and STATUS for efficient querying.
Purge Mechanism: Processed records should be archived or purged periodically to maintain performance.
Custom Extensions: Organizations often extend the table with custom columns for additional data requirements.

Common Use Cases

EDI Integration: Automating PO exchanges with suppliers via ANSI X12 or EDIFACT standards.
Supplier Portals: Capturing POs created by suppliers in self-service portals.
Data Migration: Bulk-loading legacy PO data during system implementations.

Conclusion

The ECE_PO_INTERFACE_HEADERS table is a pivotal component in Oracle EBS Procurement, enabling seamless electronic PO processing. Its design ensures data accuracy and provides a robust framework for integrating external systems with Oracle Purchasing. Proper configuration and monitoring of this table are essential for efficient procure-to-pay operations.

Concurrent Program: ECEPOI 12.1.1
execution_filename: ECEPOI.Process_POI_Inbound , product: EC - e-Commerce Gateway , user_name: IN: Purchase Orders (850/ORDERS) , description: IN: Purchase Orders (850/ORDERS) , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOI875 12.1.1
execution_filename: ECEPOI.Process_POI_Inbound , product: EC - e-Commerce Gateway , user_name: IN: Purchase Orders (850/ORDERS) , description: IN: Purchase Orders (850/ORDERS) , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOI 12.2.2
execution_filename: ECEPOI.Process_POI_Inbound , product: EC - e-Commerce Gateway , user_name: IN: Purchase Orders (850/ORDERS) , description: IN: Purchase Orders (850/ORDERS) , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOI875 12.2.2
execution_filename: ECEPOI.Process_POI_Inbound , product: EC - e-Commerce Gateway , user_name: IN: Purchase Orders (850/ORDERS) , description: IN: Purchase Orders (850/ORDERS) , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEGPOI 12.1.1
execution_filename: GML_GPOI.PROCESS_GPOI_INBOUND , product: EC - e-Commerce Gateway , user_name: IN: OPM Purchase Order (850/ORDERS) , description: Import EDI OPM Purchase Order Inbound Datafile , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEGPOI 12.2.2
execution_filename: GML_GPOI.PROCESS_GPOI_INBOUND , product: EC - e-Commerce Gateway , user_name: IN: OPM Purchase Order (850/ORDERS) , description: Import EDI OPM Purchase Order Inbound Datafile , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: POI:DOCUMENT_TYPE 12.1.1
product: EC - e-Commerce Gateway , meaning: POI:Document Type , description: Document Type for Inbound Purchase Orders (850/ORDERS) ,
Lookup Type: POI:DOCUMENT_TYPE 12.2.2
product: EC - e-Commerce Gateway , meaning: POI:Document Type , description: Document Type for Inbound Purchase Orders (850/ORDERS) ,
Lookup Type: DOCUMENT 12.2.2
product: EC - e-Commerce Gateway , meaning: List objects that can be cancelled or masscancelled. , description: List objects that can be cancelled or masscancelled. ,
Lookup Type: DOCUMENT 12.1.1
product: EC - e-Commerce Gateway , meaning: List objects that can be cancelled or masscancelled. , description: List objects that can be cancelled or masscancelled. ,
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 ,
Table: ECE_PO_INTERFACE_LINES 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_INTERFACE_LINES, object_name:ECE_PO_INTERFACE_LINES, status:VALID, product: EC - e-Commerce Gateway , description: Contains the purchase order line data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_INTERFACE_LINES ,
Table: ECE_PO_INTERFACE_SHIPMENTS 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_INTERFACE_SHIPMENTS, object_name:ECE_PO_INTERFACE_SHIPMENTS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the purchase order shipment data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_INTERFACE_SHIPMENTS ,
Table: ECE_PO_INTERFACE_SHIPMENTS 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_INTERFACE_SHIPMENTS, object_name:ECE_PO_INTERFACE_SHIPMENTS, status:VALID, product: EC - e-Commerce Gateway , description: Contains the purchase order shipment data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_INTERFACE_SHIPMENTS ,
Table: ECE_PO_INTERFACE_LINES 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_INTERFACE_LINES, object_name:ECE_PO_INTERFACE_LINES, status:VALID, product: EC - e-Commerce Gateway , description: Contains the purchase order line data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_INTERFACE_LINES ,
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_PROJECT_INFO 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_PROJECT_INFO, object_name:ECE_PO_PROJECT_INFO, status:VALID, product: EC - e-Commerce Gateway , description: Contains temporary project data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_PROJECT_INFO ,
Table: ECE_PO_PROJECT_INFO 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_PROJECT_INFO, object_name:ECE_PO_PROJECT_INFO, status:VALID, product: EC - e-Commerce Gateway , description: Contains temporary project data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_PROJECT_INFO ,
Table: ECE_PO_DISTRIBUTIONS 12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_DISTRIBUTIONS, object_name:ECE_PO_DISTRIBUTIONS, status:VALID, product: EC - e-Commerce Gateway , description: Contains temporary project data and PO distributions to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_DISTRIBUTIONS ,
Table: ECE_PO_DISTRIBUTIONS 12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_PO_DISTRIBUTIONS, object_name:ECE_PO_DISTRIBUTIONS, status:VALID, product: EC - e-Commerce Gateway , description: Contains temporary project data and PO distributions to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. , implementation_dba_data: EC.ECE_PO_DISTRIBUTIONS ,
Concurrent Program: ECEPOO 12.1.1
execution_filename: ECE_POO_TRANSACTION.Extract_POO_Outbound , product: EC - e-Commerce Gateway , user_name: ECEPOO , description: EDI Purchase Order Outbound , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOO 12.2.2
execution_filename: ECE_POO_TRANSACTION.Extract_POO_Outbound , product: EC - e-Commerce Gateway , user_name: ECEPOO , description: EDI Purchase Order Outbound , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
View: ECE_PO_PROJECT_INFO_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_PO_PROJECT_INFO_V, object_name:ECE_PO_PROJECT_INFO_V, status:VALID, product: EC - e-Commerce Gateway , description: Contains the project level data for the the Purchase Order (850/ORDERS) and the Purchase Order Changes (860/ORDCHG) transactions. , implementation_dba_data: APPS.ECE_PO_PROJECT_INFO_V ,
View: ECE_PO_PROJECT_INFO_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_PO_PROJECT_INFO_V, object_name:ECE_PO_PROJECT_INFO_V, status:VALID, product: EC - e-Commerce Gateway , description: Contains the project level data for the the Purchase Order (850/ORDERS) and the Purchase Order Changes (860/ORDCHG) transactions. , implementation_dba_data: APPS.ECE_PO_PROJECT_INFO_V ,
View: ECE_ATTACHMENT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_ATTACHMENT_V, object_name:ECE_ATTACHMENT_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts attachment data* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) transactions.* The attachment view is used for header, line, shipment, distribution, item and master item , implementation_dba_data: APPS.ECE_ATTACHMENT_V ,
View: ECE_ATTACHMENT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_ATTACHMENT_V, object_name:ECE_ATTACHMENT_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts attachment data* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) transactions.* The attachment view is used for header, line, shipment, distribution, item and master item , implementation_dba_data: APPS.ECE_ATTACHMENT_V ,
View: ECE_PO_DISTRIBUTIONS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_PO_DISTRIBUTIONS_V, object_name:ECE_PO_DISTRIBUTIONS_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts distribution information* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) transactions.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purc , implementation_dba_data: APPS.ECE_PO_DISTRIBUTIONS_V ,
View: ECE_PO_DISTRIBUTIONS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_PO_DISTRIBUTIONS_V, object_name:ECE_PO_DISTRIBUTIONS_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts distribution information* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) transactions.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purc , implementation_dba_data: APPS.ECE_PO_DISTRIBUTIONS_V ,
View: ECE_POO_SHIPMENTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_POO_SHIPMENTS_V, object_name:ECE_POO_SHIPMENTS_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts shipment information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purchase Order Shipment View* @rep:category BUSINESS_ENTIT , implementation_dba_data: APPS.ECE_POO_SHIPMENTS_V ,
View: ECE_POO_SHIPMENTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_POO_SHIPMENTS_V, object_name:ECE_POO_SHIPMENTS_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts shipment information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purchase Order Shipment View* @rep:category BUSINESS_ENTIT , implementation_dba_data: APPS.ECE_POO_SHIPMENTS_V ,
Concurrent Program: ECEPO2I 12.1.1
execution_filename: ECEPO2I.PROCESS_PO2I_INBOUND , product: EC - e-Commerce Gateway , user_name: Purchase Order Inbound (Generic) , description: Purchase Order Inbound (Generic) , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPO2I 12.2.2
execution_filename: ECEPO2I.PROCESS_PO2I_INBOUND , product: EC - e-Commerce Gateway , user_name: Purchase Order Inbound (Generic) , description: Purchase Order Inbound (Generic) , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOCI 12.1.1
execution_filename: ECEPOCI. Process_POCI_Inbound , product: EC - e-Commerce Gateway , user_name: IN: Purchase Order Changes (860/ORDCHG) , description: IN: Purchase Order Changes (860/ORDCHG) , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOCI 12.2.2
execution_filename: ECEPOCI. Process_POCI_Inbound , product: EC - e-Commerce Gateway , user_name: IN: Purchase Order Changes (860/ORDCHG) , description: IN: Purchase Order Changes (860/ORDCHG) , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEGPOAO 12.1.1
execution_filename: GML_GPOAO.EXTRACT_GPOAO_OUTBOUND , product: EC - e-Commerce Gateway , user_name: OUT: OPM Purchase Order Acknowledgement (855/ORDRSP) , description: OPM Outbound Purchase Order Acknowledgement , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEGPOAO 12.2.2
execution_filename: GML_GPOAO.EXTRACT_GPOAO_OUTBOUND , product: EC - e-Commerce Gateway , user_name: OUT: OPM Purchase Order Acknowledgement (855/ORDRSP) , description: OPM Outbound Purchase Order Acknowledgement , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: OUTPUT_LEVEL_DSNO 12.1.1
product: EC - e-Commerce Gateway , meaning: OUTPUT_LEVEL_DSNO ,
Lookup Type: OUTPUT_LEVEL_DSNO 12.2.2
product: EC - e-Commerce Gateway , meaning: OUTPUT_LEVEL_DSNO ,
Lookup Type: POCI:DOCUMENT_TYPE 12.2.2
product: EC - e-Commerce Gateway , meaning: POCI:Document Type , description: Document Type for Purchase Order Change (860/ORDCHG) ,
Lookup Type: POCI:DOCUMENT_TYPE 12.1.1
product: EC - e-Commerce Gateway , meaning: POCI:Document Type , description: Document Type for Purchase Order Change (860/ORDCHG) ,
Lookup Type: POCAO:DOCUMENT_TYPE 12.1.1
product: EC - e-Commerce Gateway , meaning: POCAO:Document Type , description: Document Type for Outbound Purchase Order Change Acknowledgement (865/ORDRSP) ,
Lookup Type: POCAO:DOCUMENT_TYPE 12.2.2
product: EC - e-Commerce Gateway , meaning: POCAO:Document Type , description: Document Type for Outbound Purchase Order Change Acknowledgement (865/ORDRSP) ,
Concurrent Program: ECEPOAO 12.1.1
execution_filename: EC_DOCUMENT.process_outbound , product: EC - e-Commerce Gateway , user_name: Triggering Outbound , description: EC Triggering Process Outbound , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOAO 12.2.2
execution_filename: EC_DOCUMENT.process_outbound , product: EC - e-Commerce Gateway , user_name: Triggering Outbound , description: EC Triggering Process Outbound , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOCAO 12.2.2
execution_filename: EC_DOCUMENT.process_outbound , product: EC - e-Commerce Gateway , user_name: Triggering Outbound , description: EC Triggering Process Outbound , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOCAO 12.1.1
execution_filename: EC_DOCUMENT.process_outbound , product: EC - e-Commerce Gateway , user_name: Triggering Outbound , description: EC Triggering Process Outbound , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOCO 12.1.1
execution_filename: ECE_POCO_TRANSACTION.Extract_POCO_Outbound , product: EC - e-Commerce Gateway , user_name: ECEPOCO , description: EDI PO Change Outbound , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: ECEPOCO 12.2.2
execution_filename: ECE_POCO_TRANSACTION.Extract_POCO_Outbound , product: EC - e-Commerce Gateway , user_name: ECEPOCO , description: EDI PO Change Outbound , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
View: ECE_POO_LINES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_POO_LINES_V, object_name:ECE_POO_LINES_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts line information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purchase Order Line View* @rep:category BUSINESS_ENTITY PO_PUR , implementation_dba_data: APPS.ECE_POO_LINES_V ,
View: ECE_POO_LINES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_POO_LINES_V, object_name:ECE_POO_LINES_V, status:VALID, product: EC - e-Commerce Gateway , description: /*#* This view extracts line information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purchase Order Line View* @rep:category BUSINESS_ENTITY PO_PUR , implementation_dba_data: APPS.ECE_POO_LINES_V ,