Search Results purchase orders

The PO_LINES_ALL_EXT_B_ARCHIVE table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 serves as an archival repository for extended attributes of purchase order lines that have been purged or archived from the primary transactional table PO_LINES_ALL. This table is part of the Purchasing module's data retention strategy, ensuring historical purchase order line details remain accessible for compliance, reporting, or audit purposes while maintaining optimal performance in active transactional tables.

Table Structure and Key Columns

The table inherits core columns from PO_LINES_ALL while focusing on extended attributes. Key columns include:

PO_LINE_ID: Primary key reference to the original purchase order line
PO_HEADER_ID: Links to the parent purchase order
LINE_TYPE_ID: Classification of the line item
ITEM_ID: Reference to inventory items
UNIT_PRICE: Historical pricing information
QUANTITY: Archived order quantities
NEED_BY_DATE: Original delivery requirements
EXT_ATTRIBUTE_[1-15]: Flexible fields for custom attributes
ARCHIVE_DATE: Timestamp when the record was archived

Functional Context

This table supports critical business processes:

Compliance Reporting: Maintains legally required purchase records beyond active system retention periods
Audit Trails: Preserves complete procurement history for internal/external audits
Historical Analysis: Enables trend analysis on purchasing patterns and supplier performance
Dispute Resolution: Provides immutable records for contract or delivery disagreements

Technical Implementation

The archiving process typically occurs:

Through scheduled purge processes in Purchasing module
Via custom archiving scripts for specific retention policies
During system upgrades or data migration projects

Integration points exist with:

Oracle Purchasing purge concurrent programs
Oracle Data Archive Manager
Custom archive/reporting solutions

Data Volume Considerations

In production environments:

Table growth correlates with purchase order volume and retention policies
Indexing strategy should focus on PO_HEADER_ID, PO_LINE_ID, and ARCHIVE_DATE
Partitioning may be implemented for large installations

Customization Potential

Organizations often extend functionality by:

Adding custom columns through extension tables
Developing archive-specific reports
Creating data extraction routines for external systems

Upgrade Implications

Between 12.1.1 and 12.2.2:

Table structure remains largely consistent
New extended attributes may be introduced
Online Patching (ADOP) in 12.2.2 affects maintenance procedures

The PO_LINES_ALL_EXT_B_ARCHIVE table represents a critical component of Oracle EBS's data lifecycle management for procurement operations, balancing system performance with regulatory and business intelligence requirements.

Lookup Type: PURCHASE CLASSIFICATION 12.2.2
product: PO - Purchasing , meaning: Purchase Classification , description: Purchase Classification ,
Lookup Type: PURCHASE BASIS 12.1.1
product: PO - Purchasing , meaning: Purchase Basis , description: Purchase Basis of Line Type ,
Lookup Type: PURCHASE CLASSIFICATION 12.1.1
product: PO - Purchasing , meaning: Purchase Classification , description: Purchase Classification ,
Lookup Type: PURCHASE BASIS 12.2.2
product: PO - Purchasing , meaning: Purchase Basis , description: Purchase Basis of Line Type ,
Lookup Type: QUOTE APPROVAL TYPE 12.1.1
product: PO - Purchasing , meaning: Quotation Approval Types , description: Quotation Approval Types ,
Lookup Type: QUOTE APPROVAL TYPE 12.2.2
product: PO - Purchasing , meaning: Quotation Approval Types , description: Quotation Approval Types ,
Lookup Type: PRINT CHOICE 12.1.1
product: PO - Purchasing , meaning: Purchase Order print parameters , description: Purchase Order print parameters ,
Lookup Type: PRINT CHOICE 12.2.2
product: PO - Purchasing , meaning: Purchase Order print parameters , description: Purchase Order print parameters ,
Lookup Type: PO TYPE 12.1.1
product: PO - Purchasing , meaning: Types of Purchase Orders , description: Types of Purchase Orders ,
Lookup Type: PO TYPE 12.2.2
product: PO - Purchasing , meaning: Types of Purchase Orders , description: Types of Purchase Orders ,
Concurrent Program: POXPOPAA 12.1.1
execution_filename: POXPOPAA , product: PO - Purchasing , user_name: POXPOPAA , description: Open Purchase Order Report(by Buyer) , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: POXDOAPP TITLE TRANSLATE 12.2.2
product: PO - Purchasing , meaning: Used in translating title of POXDOAPP , description: Used in translating title of POXDOAPP ,
Concurrent Program: POGVPRPL 12.1.1
execution_filename: POGVPRPL , product: PO - Purchasing , user_name: POGVPRPL , description: Public Sector Printed Purchase Orders Report(Landscape) , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: POXDOAPP TITLE TRANSLATE 12.1.1
product: PO - Purchasing , meaning: Used in translating title of POXDOAPP , description: Used in translating title of POXDOAPP ,
Concurrent Program: POXPOCAN 12.2.2
execution_filename: POXPOCAN , product: PO - Purchasing , user_name: POXPOCAN , description: Cancelled Purchase Order Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: POXPPO 12.1.1
execution_filename: POXPRPOP , product: PO - Purchasing , user_name: POXPRPOP , description: Printed Purchase Order Report(Portrait) , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: POXPOCAN 12.1.1
execution_filename: POXPOCAN , product: PO - Purchasing , user_name: POXPOCAN , description: Cancelled Purchase Order Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: POXPPO 12.2.2
execution_filename: POXPRPOP , product: PO - Purchasing , user_name: POXPRPOP , description: Printed Purchase Order Report(Portrait) , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: PO PRINT SORT BY OPTION 12.1.1
product: PO - Purchasing , meaning: Option to Sort Printed Purchase Orders , description: Option to Sort Printed Purchase Orders ,
Lookup Type: PO PRINT SORT BY OPTION 12.2.2
product: PO - Purchasing , meaning: Option to Sort Printed Purchase Orders , description: Option to Sort Printed Purchase Orders ,
Concurrent Program: POGVPRPL 12.2.2
execution_filename: POGVPRPL , product: PO - Purchasing , user_name: POGVPRPL , description: Public Sector Printed Purchase Orders Report(Landscape) , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: POXPOPAA 12.2.2
execution_filename: POXPOPAA , product: PO - Purchasing , user_name: POXPOPAA , description: Open Purchase Order Report(by Buyer) , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: POXPOPAR 12.1.1
execution_filename: POXPOPAR , product: PO - Purchasing , user_name: POXPOPAR , description: Open Purchase Order Report(by Cost Center) , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: POXPOPAR 12.2.2
execution_filename: POXPOPAR , product: PO - Purchasing , user_name: POXPOPAR , description: Open Purchase Order Report(by Cost Center) , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: POXPOCAN_XML 12.2.2
product: PO - Purchasing , user_name: Cancelled Purchase Orders Report (XML) , description: Cancelled Purchase Orders Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: NOTIFICATION LIST 12.2.2
product: PO - Purchasing , meaning: Notification List Messages , description: Notification List Messages ,
Lookup Type: MASSCANCEL_DOCUMENTS 12.1.1
product: PO - Purchasing , meaning: Masscancel documents , description: Masscancel documents ,
Concurrent Program: POXPOPAA_XML 12.1.1
product: PO - Purchasing , user_name: Open Purchase Orders Report(by Buyer) (XML) , description: Open Purchase Orders Report(by Buyer) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: POXPOCAN_XML 12.1.1
product: PO - Purchasing , user_name: Cancelled Purchase Orders Report (XML) , description: Cancelled Purchase Orders Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: NOTIFICATION LIST 12.1.1
product: PO - Purchasing , meaning: Notification List Messages , description: Notification List Messages ,
Concurrent Program: POXPOPAR_XML 12.1.1
product: PO - Purchasing , user_name: Open Purchase Orders Report(by Cost Center) (XML) , description: Open Purchase Orders Report(by Cost Center) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: MASSCANCEL_DOCUMENTS 12.2.2
product: PO - Purchasing , meaning: Masscancel documents , description: Masscancel documents ,
Concurrent Program: POXPOPDOI 12.1.1
execution_filename: POXPDOI , product: PO - Purchasing , user_name: POXPDOI , description: Purchasing Documents Open Interface Program , argument_method: Standard , enabled: Yes , execution_method: SQL*Plus ,
Concurrent Program: POXPOPAA_XML 12.2.2
product: PO - Purchasing , user_name: Open Purchase Orders Report(by Buyer) (XML) , description: Open Purchase Orders Report(by Buyer) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: POXPOPAR_XML 12.2.2
product: PO - Purchasing , user_name: Open Purchase Orders Report(by Cost Center) (XML) , description: Open Purchase Orders Report(by Cost Center) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: POXPOPDOI 12.2.2
execution_filename: POXPDOI , product: PO - Purchasing , user_name: POXPDOI , description: Purchasing Documents Open Interface Program , argument_method: Standard , enabled: Yes , execution_method: SQL*Plus ,
Table: PO_LINES_ALL_EXT_B_ARCHIVE 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL_EXT_B_ARCHIVE, object_name:PO_LINES_ALL_EXT_B_ARCHIVE, status:VALID, product: PO - Purchasing , description: Archived UDA data of Purchase document lines (for purchase orders, purchase agreements) , implementation_dba_data: PO.PO_LINES_ALL_EXT_B_ARCHIVE ,
Table: PO_LINES_ALL_EXT_TL_ARCHIVE 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL_EXT_TL_ARCHIVE, object_name:PO_LINES_ALL_EXT_TL_ARCHIVE, status:VALID, product: PO - Purchasing , description: Translated Archive UDA data of Purchase document lines (for purchase orders, purchase agreements) , implementation_dba_data: PO.PO_LINES_ALL_EXT_TL_ARCHIVE ,
Table: PO_LINES_ALL_EXT_TL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL_EXT_TL, object_name:PO_LINES_ALL_EXT_TL, status:VALID, product: PO - Purchasing , description: Stores the UDA data of Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_ALL_EXT_TL ,
Table: PO_LINES_ALL_EXT_B 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL_EXT_B, object_name:PO_LINES_ALL_EXT_B, status:VALID, product: PO - Purchasing , description: Stores the UDA data of Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_ALL_EXT_B ,
Lookup Type: ENCUMBRANCE OBJECT TYPE 12.1.1
product: PO - Purchasing , meaning: Encumbrance Object Types , description: Encumbrance Object Types ,
Lookup Type: ENCUMBRANCE OBJECT TYPE 12.2.2
product: PO - Purchasing , meaning: Encumbrance Object Types , description: Encumbrance Object Types ,
Table: PO_LINE_LOCATIONS_ALL_EXT_B 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL_EXT_B, object_name:PO_LINE_LOCATIONS_ALL_EXT_B, status:VALID, product: PO - Purchasing , description: Stores the UDA data of Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL_EXT_B ,
Table: PO_HEADERS_ALL_EXT_TL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL_EXT_TL, object_name:PO_HEADERS_ALL_EXT_TL, status:VALID, product: PO - Purchasing , description: Stores the UDA data of the Document headers (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_HEADERS_ALL_EXT_TL ,
Table: PO_LINE_LOCATIONS_ALL_EXT_TL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL_EXT_TL, object_name:PO_LINE_LOCATIONS_ALL_EXT_TL, status:VALID, product: PO - Purchasing , description: Stores the UDA data of Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL_EXT_TL ,
Table: PO_HEADERS_ALL_EXT_B_ARCHIVE 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL_EXT_B_ARCHIVE, object_name:PO_HEADERS_ALL_EXT_B_ARCHIVE, status:VALID, product: PO - Purchasing , description: Archived UDA data of the Document headers (for purchase orders, purchase agreements) , implementation_dba_data: PO.PO_HEADERS_ALL_EXT_B_ARCHIVE ,
Table: PO_HEADERS_ALL_EXT_TL_ARCHIVE 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL_EXT_TL_ARCHIVE, object_name:PO_HEADERS_ALL_EXT_TL_ARCHIVE, status:VALID, product: PO - Purchasing , description: Translated archive UDA data of the Document headers (for purchase orders, purchase agreements) , implementation_dba_data: PO.PO_HEADERS_ALL_EXT_TL_ARCHIVE ,
Table: PO_LINE_LOC_ALL_EXT_B_ARCHIVE 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOC_ALL_EXT_B_ARCHIVE, object_name:PO_LINE_LOC_ALL_EXT_B_ARCHIVE, status:VALID, product: PO - Purchasing , description: Archived UDA data of Document shipment schedules (for purchase orders, purchase agreements) , implementation_dba_data: PO.PO_LINE_LOC_ALL_EXT_B_ARCHIVE ,
Table: PO_LINES_DRAFT_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_DRAFT_ALL, object_name:PO_LINES_DRAFT_ALL, status:VALID, product: PO - Purchasing , description: Draft table for purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_DRAFT_ALL ,
Table: PO_LINE_LOC_ALL_EXT_TL_ARCHIVE 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOC_ALL_EXT_TL_ARCHIVE, object_name:PO_LINE_LOC_ALL_EXT_TL_ARCHIVE, status:VALID, product: PO - Purchasing , description: Translated Archive UDA data of Document shipment schedules (for purchase orders, purchase agreements) , implementation_dba_data: PO.PO_LINE_LOC_ALL_EXT_TL_ARCHIVE ,