Search Results orders




The ECE_PO_PROJECT_INFO table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Procurement and Projects modules, facilitating the integration of purchase orders with project-related data. This table stores essential information that links procurement transactions to specific projects, tasks, and expenditure types, ensuring accurate financial tracking and reporting. Below is a detailed breakdown of its structure, purpose, and key attributes.

Purpose and Functional Context

The ECE_PO_PROJECT_INFO table serves as a bridge between Oracle Purchasing (PO) and Oracle Projects (PA). It captures project-related details associated with purchase orders, enabling organizations to align procurement activities with project budgets, cost accounting, and financial controls. This integration is particularly vital for industries like construction, engineering, and professional services, where procurement is often project-centric.

Key Attributes

The table includes several critical columns, each serving a specific purpose:
  • PO_HEADER_ID: References the purchase order header in PO_HEADERS_ALL, establishing the link to the procurement document.
  • PO_LINE_ID: Ties the record to a specific line in PO_LINES_ALL, enabling granular project tracking at the line level.
  • PROJECT_ID: Stores the identifier from PA_PROJECTS_ALL, associating the PO with a specific project.
  • TASK_ID: References a task within the project (PA_TASKS), allowing for detailed cost allocation.
  • EXPENDITURE_TYPE: Defines the type of expenditure (e.g., labor, materials) for accounting purposes, sourced from PA_EXPENDITURE_TYPES.
  • EXPENDITURE_ORGANIZATION_ID: Identifies the organization responsible for the expenditure, linking to HR_ORGANIZATION_UNITS.
  • AWARD_ID: Used in grants or funded projects to track awards, referencing GMS_AWARDS_ALL.
  • BUDGET_VERSION_ID: Associates the PO with a specific project budget version (PA_BUDGET_VERSIONS).

Integration with Other Modules

The table interacts with multiple EBS modules:
  1. Oracle Purchasing: When a PO is created or modified, project details are validated and stored in ECE_PO_PROJECT_INFO.
  2. Oracle Projects: Ensures procurement costs are accurately reflected in project financials, including budgets, forecasts, and actuals.
  3. General Ledger (GL): Project-related PO data flows to GL via the Subledger Accounting (SLA) framework, enabling proper cost accounting.

Technical Considerations

  • Indexes: The table typically has indexes on PO_HEADER_ID, PO_LINE_ID, and PROJECT_ID to optimize query performance.
  • Data Integrity: Foreign key constraints enforce relationships with parent tables like PO_HEADERS_ALL and PA_PROJECTS_ALL.
  • API Usage Custom integrations or extensions should use Oracle's public APIs (e.g., PO_PROJECT_DETAILS_PKG) to manipulate data, avoiding direct DML.

Common Use Cases

  1. Project Budget Monitoring: Real-time tracking of PO commitments against project budgets.
  2. Cost Allocation: Distributing procurement costs across projects, tasks, and expenditure types.
  3. Audit and Compliance: Providing a traceable link between POs and project financials for regulatory reporting.

Conclusion

The ECE_PO_PROJECT_INFO table is a cornerstone of Oracle EBS's project procurement functionality. Its design ensures seamless integration between purchasing and projects, enabling organizations to maintain financial discipline, comply with accounting standards, and achieve accurate project costing. Understanding its structure and relationships is essential for consultants and implementers working on procurement or projects implementations in EBS 12.1.1 or 12.2.2.

  • 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 , 

  • 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: 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) , 

  • 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 , 

  • 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 , 

  • 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_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_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_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_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_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 , 

  • 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_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 , 

  • 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.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_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_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 , 

  • 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 , 

  • 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 ,