Search Results purchase

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: VIEW ORDER SHIPMENT OPTIONS 12.1.1
product: PO - Purchasing , meaning: View Additional Order Shipment Information , description: View Additional Order Shipment Information ,
Lookup Type: POXMUB_DOCUMENT_TYPE 12.2.2
product: PO - Purchasing , meaning: Document Types of Purchase Order , description: Document Types of Purchase Order ,
Lookup Type: ORDER SHIPMENT INFORMATION 12.2.2
product: PO - Purchasing , meaning: Additional Order Shipment Information , description: Additional Order Shipment Information ,
Lookup Type: POXMUB_DOCUMENT_TYPE 12.1.1
product: PO - Purchasing , meaning: Document Types of Purchase Order , description: Document Types of Purchase Order ,
Lookup Type: VIEW ORDER SHIPMENT OPTIONS 12.2.2
product: PO - Purchasing , meaning: View Additional Order Shipment Information , description: View Additional Order Shipment Information ,
Lookup Type: ORDER SHIPMENT INFORMATION 12.1.1
product: PO - Purchasing , meaning: Additional Order Shipment Information , description: Additional Order Shipment Information ,
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 ,
Lookup Type: ACCEPTANCE TYPE 12.1.1
product: PO - Purchasing , meaning: Purchase order acceptance type , description: Purchase order acceptance type ,
Lookup Type: PRINT CHOICE 12.1.1
product: PO - Purchasing , meaning: Purchase Order print parameters , description: Purchase Order print parameters ,
Lookup Type: MIPR_TYPE 12.2.2
product: PO - Purchasing , meaning: MIPR Type , description: Military Interdepartmental Purchase Request Type ,
Lookup Type: ACCEPTANCE TYPE 12.2.2
product: PO - Purchasing , meaning: Purchase order acceptance type , description: Purchase order acceptance type ,
Lookup Type: PRINT CHOICE 12.2.2
product: PO - Purchasing , meaning: Purchase Order print parameters , description: Purchase Order print parameters ,
Lookup Type: ERA MORE INFO 12.1.1
product: PO - Purchasing , meaning: RCVTXERA options , description: RCVTXERA options ,
Lookup Type: ERA MORE INFO 12.2.2
product: PO - Purchasing , meaning: RCVTXERA options , description: RCVTXERA options ,
Lookup Type: ERT TRX INFO 12.1.1
product: PO - Purchasing , meaning: Enter Receiving Transactions Trx Info , description: Enter Receiving Transactions Trx Info ,
Lookup Type: ERT TRX INFO 12.2.2
product: PO - Purchasing , meaning: Enter Receiving Transactions Trx Info , description: Enter Receiving Transactions Trx Info ,
Lookup Type: NOTIFICATION TYPE 12.1.1
product: PO - Purchasing , meaning: Notification Document Types , description: Notification Document Types ,
Lookup Type: NOTIFICATION TYPE 12.2.2
product: PO - Purchasing , meaning: Notification Document Types , description: Notification Document Types ,
Lookup Type: PR_DOC_TYPE 12.2.2
product: PO - Purchasing , meaning: Purchase Requisition Document Type , description: Purchase Requisition Document Type ,
Lookup Type: SOURCE DOCUMENT TYPE 12.2.2
product: PO - Purchasing , meaning: Source Document Types from Vendors , description: Source Document Types from Vendors ,
Lookup Type: QUOTE APPROVAL TYPE 12.1.1
product: PO - Purchasing , meaning: Quotation Approval Types , description: Quotation Approval Types ,
Lookup Type: REFERENCE_DOCUMENT_TYPE 12.1.1
product: PO - Purchasing , meaning: Reference Document Type , description: Types of documents referenced on a requisition line ,
Lookup Type: REFERENCE_DOCUMENT_TYPE 12.2.2
product: PO - Purchasing , meaning: Reference Document Type , description: Types of documents referenced on a requisition line ,
Lookup Type: SOURCE DOCUMENT TYPE 12.1.1
product: PO - Purchasing , meaning: Source Document Types from Vendors , description: Source Document Types from Vendors ,
Lookup Type: DOCUMENT TYPE 12.2.2
product: PO - Purchasing , meaning: Meaning N/A for : DOCUMENT TYPE , description: Document Type ,
Lookup Type: PO_CLM_CAR_EXEMPT_REASON 12.2.2
product: PO - Purchasing , meaning: PO: CLM CAR Exempt Reason , description: CLM CAR Exempt Reason ,
Lookup Type: LEGAL REQUISITION TYPE 12.1.1
product: PO - Purchasing , meaning: Legal Requisition Types for a user in on-line requisition entry , description: Legal Requisition Types for a user in on-line requisition entry ,
Lookup Type: LEGAL REQUISITION TYPE 12.2.2
product: PO - Purchasing , meaning: Legal Requisition Types for a user in on-line requisition entry , description: Legal Requisition Types for a user in on-line requisition entry ,
Lookup Type: RQINQ PAPER REQ 12.1.1
product: PO - Purchasing , meaning: PO Information for Paper Req in RQINQ. , description: PO Information for Paper Req in RQINQ. ,
Lookup Type: RQINQ PAPER REQ 12.2.2
product: PO - Purchasing , meaning: PO Information for Paper Req in RQINQ. , description: PO Information for Paper Req in RQINQ. ,
Lookup Type: DOCUMENT TYPE 12.1.1
product: PO - Purchasing , meaning: Meaning N/A for : DOCUMENT TYPE , description: Document Type ,
Lookup Type: VIEW ORDER SHIPMENT DETAIL 12.2.2
product: PO - Purchasing , meaning: View Order shipment detail options , description: View Order shipment detail options ,
Concurrent Program: PO_HIST_FEED 12.2.2
execution_filename: POR_History_Feed_Pkg.Main , product: PO - Purchasing , user_name: Purchase Order History Feed for P-card Reconciliation , description: Purchase Order History Feed for reconciling P-card payments , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: QUOTE APPROVAL TYPE 12.2.2
product: PO - Purchasing , meaning: Quotation Approval Types , description: Quotation Approval Types ,
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 ,
Lookup Type: VIEW ORDER SHIPMENT DETAIL 12.1.1
product: PO - Purchasing , meaning: View Order shipment detail options , description: View Order shipment detail options ,
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 ,
Lookup Type: POA BIS REPORT OPTION 12.1.1
product: PO - Purchasing , meaning: PO Report Options , description: PO Report Options ,
Concurrent Program: PO_HIST_FEED 12.1.1
execution_filename: POR_History_Feed_Pkg.Main , product: PO - Purchasing , user_name: Purchase Order History Feed for P-card Reconciliation , description: Purchase Order History Feed for reconciling P-card payments , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
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 ,
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 ,
Lookup Type: POA BIS REPORT OPTION 12.2.2
product: PO - Purchasing , meaning: PO Report Options , description: PO Report Options ,
Lookup Type: PO_CLM_TYPE_OF_ORDER 12.2.2
product: PO - Purchasing , meaning: Purchasing CLM Type of Order , description: Purchasing CLM Type of Order ,
Lookup Type: REQEXPRESS SOURCE DOC TYPE 12.2.2
product: PO - Purchasing , meaning: ReqExpress Source Document Types , description: ReqExpress Source Document Types ,
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 ,