Search Results po_line_locations_archive_uk1

Overview

The PO_LINE_LOCATIONS_ARCHIVE_ALL table is a core data retention object within Oracle E-Business Suite Purchasing (PO) module, specifically for versions 12.1.1 and 12.2.2. It serves as the definitive repository for historical, non-current versions of purchase order shipment lines. Its primary role is to maintain a complete audit trail of all changes made to purchase order shipments (line locations) throughout their lifecycle. When a shipment is revised or updated within the active PO_LINE_LOCATIONS_ALL table, a snapshot of the previous state is archived into this table. This enables comprehensive historical reporting, compliance auditing, and the ability to review the exact state of a shipment at any point in its revision history.

Key Information Stored

The table stores a complete set of shipment attributes as they existed at a specific revision point. Key identifying columns include LINE_LOCATION_ID (the unique identifier for the shipment line) and REVISION_NUM, which together form the table's primary key (PO_LINE_LOCATIONS_ARCHIVE_PK). This combination allows multiple archived records for the same physical shipment. Another unique key (PO_LINE_LOCATIONS_ARCHIVE_UK1) enforces integrity on the combination of PO_LINE_ID, SHIPMENT_NUM, and REVISION_NUM. Critical foreign key columns link each archived shipment to its parent objects, such as PO_HEADER_ID (purchase order), PO_LINE_ID (purchase order line), and SOURCE_SHIPMENT_ID (the original active record in PO_LINE_LOCATIONS_ALL). The table also archives related data like RECEIVING_ROUTING_ID and TAX_CODE_ID.

Common Use Cases and Queries

The primary use case is auditing and historical analysis of purchase order shipment changes. This is essential for understanding price, quantity, delivery date, or terms modifications over time. A common query retrieves the full revision history for a specific shipment or purchase order line. For example, to audit changes to unit price for a shipment, one might query:

• SELECT revision_num, unit_price, last_update_date FROM po_line_locations_archive_all WHERE line_location_id = <id> ORDER BY revision_num;

Another critical use case is supporting the revision history viewer within the Oracle Purchasing user interface, which relies on this archived data. Reporting on procurement trends or compliance often requires joining this table with PO_HEADERS_ARCHIVE_ALL and PO_LINES_ARCHIVE_ALL to reconstruct the complete state of an entire purchase order document at a past revision.

Related Objects

This table is centrally connected to the Purchasing schema's archival and active transaction structures. Its primary relationship is with the active transaction table PO_LINE_LOCATIONS_ALL, via the SOURCE_SHIPMENT_ID foreign key. It is a child of PO_HEADERS_ARCHIVE_ALL and PO_LINES_ARCHIVE_ALL, forming the complete document archive hierarchy. Other key foreign key dependencies include PO_RELEASES_ALL (for blanket agreement releases), AP_TAX_CODES_ALL, and RCV_ROUTING_HEADERS. It is also referenced by the temporary worktable ICX_PO_REVISIONS_TEMP, which is used in the revision comparison and approval process. For comprehensive reporting, it is often joined with corresponding archive tables for headers and lines.