Search Results zpstr_ras sap table details

The PO_LINE_LOCATIONS_ARCHIVE_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 serves as a critical repository for historical purchase order shipment data, ensuring compliance, auditability, and reporting capabilities. This table archives shipment-level information from PO_LINE_LOCATIONS_ALL when purchase orders are modified, canceled, or closed, preserving a complete transactional history. Below is a detailed analysis of its structure, purpose, and integration within Oracle Procurement.

Purpose and Functional Overview

The PO_LINE_LOCATIONS_ARCHIVE_ALL table captures snapshots of shipment details (e.g., quantities, prices, delivery dates) associated with purchase order lines before changes are made. Key scenarios triggering archiving include:

Order Modifications: Changes to shipment terms, quantities, or pricing.
Order Cancellation/Closure: Retains pre-closure shipment data for reference.
Audit Requirements: Supports regulatory compliance (e.g., SOX, GDPR) by maintaining immutable records.

Key Columns and Relationships

The table mirrors the structure of PO_LINE_LOCATIONS_ALL with additional archival metadata. Notable columns include:

PO_LINE_LOCATION_ID: Foreign key to the original shipment record.
ARCHIVE_DATE: Timestamp of archival (critical for historical tracking).
SHIPMENT_TYPE: Distinguishes between standard, blanket, or planned shipments.
QUANTITY/PRICE: Archived values at the time of modification.
ORG_ID: Multi-org identifier for partitioned data access.

Relationships exist with PO_HEADERS_ARCHIVE_ALL and PO_LINES_ARCHIVE_ALL, forming a complete historical purchase order hierarchy.

Integration with Oracle EBS Modules

The table interacts with several EBS components:

Procurement: Tracks changes to shipments for supplier performance analysis.
Inventory/Receiving: Links archived shipments to receipt histories via RCV_SHIPMENT_LINES.
Financials: Provides audit trails for AP invoice matching (PO_DISTRIBUTIONS_ARCHIVE_ALL).

Technical Considerations

Partitioning: In EBS 12.2.2, partitioning by ARCHIVE_DATE improves query performance for large datasets.
Indexing: Key indexes on PO_LINE_LOCATION_ID, PO_HEADER_ID, and ORG_ID optimize joins.
Purge Policies: Controlled via concurrent programs (e.g., "Purge Document Archival Records") to manage storage.

Customization and Extensions

Common enhancements include:

Custom Reports: SQL queries leveraging archived data for trend analysis.
Triggers: Additional validation during archival (e.g., capturing user comments).
APIs: PO_ARCHIVE package for programmatic access to archived records.

Conclusion

The PO_LINE_LOCATIONS_ARCHIVE_ALL table is indispensable for maintaining data integrity in Oracle Procurement. Its design ensures traceability across the procure-to-pay lifecycle while supporting advanced reporting and compliance needs. Organizations should align archival retention policies with business requirements and leverage partitioning in EBS 12.2.2 for optimal performance.

Lookup Type: ACTION DETAILS 12.2.2
product: PO - Purchasing , meaning: Action Details Option , description: Action Details Option ,
Lookup Type: EMPLOYEE DETAILS 12.2.2
product: PO - Purchasing , meaning: NODESCRIPTION81 ,
Lookup Type: EMPLOYEE DETAILS 12.1.1
product: PO - Purchasing , meaning: NODESCRIPTION81 ,
Lookup Type: ACTION DETAILS 12.1.1
product: PO - Purchasing , meaning: Action Details Option , description: Action Details Option ,
Table: PO_LINE_LOCATIONS_ARCHIVE_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ARCHIVE_ALL, object_name:PO_LINE_LOCATIONS_ARCHIVE_ALL, status:VALID, product: PO - Purchasing , description: Archived purchase order shipments , implementation_dba_data: PO.PO_LINE_LOCATIONS_ARCHIVE_ALL ,
Table: PO_NOTIFICATIONS_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_NOTIFICATIONS_ALL, object_name:PO_NOTIFICATIONS_ALL, status:VALID, product: PO - Purchasing , description: Notifications , implementation_dba_data: PO.PO_NOTIFICATIONS_ALL ,
Table: RCV_LOT_TRANSACTIONS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_LOT_TRANSACTIONS, object_name:RCV_LOT_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: Receiving lots transactions , implementation_dba_data: PO.RCV_LOT_TRANSACTIONS ,
Table: PO_ASL_ATTRIBUTES 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ASL_ATTRIBUTES, object_name:PO_ASL_ATTRIBUTES, status:VALID, product: PO - Purchasing , description: Approved supplier list attributes , implementation_dba_data: PO.PO_ASL_ATTRIBUTES ,
Table: PO_REQEXPRESS_HEADERS_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQEXPRESS_HEADERS_ALL, object_name:PO_REQEXPRESS_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Template headers for express requisitions , implementation_dba_data: PO.PO_REQEXPRESS_HEADERS_ALL ,
Table: PO_VENDORS 12.1.1
product: PO - Purchasing , description: Suppliers , implementation_dba_data: Not implemented in this database ,
Table: RCV_SERIALS_INTERFACE 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SERIALS_INTERFACE, object_name:RCV_SERIALS_INTERFACE, status:VALID, product: PO - Purchasing , description: Receiving serial interface table , implementation_dba_data: PO.RCV_SERIALS_INTERFACE ,
Table: RCV_MC_SUB_LEDGER_DETAILS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_MC_SUB_LEDGER_DETAILS, object_name:RCV_MC_SUB_LEDGER_DETAILS, status:VALID, product: PO - Purchasing , description: MRC sub-table of RCV_SUB_LEDGER_DETAILS , implementation_dba_data: PO.RCV_MC_SUB_LEDGER_DETAILS ,
Table: PO_NOTIFICATION_CONTROLS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_NOTIFICATION_CONTROLS, object_name:PO_NOTIFICATION_CONTROLS, status:VALID, product: PO - Purchasing , description: Blanket agreement and planned purchase order notification controls , implementation_dba_data: PO.PO_NOTIFICATION_CONTROLS ,
Table: RCV_MC_TRANSACTIONS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_MC_TRANSACTIONS, object_name:RCV_MC_TRANSACTIONS, status:VALID, product: PO - Purchasing , description: MRC sub-table of RCV_TRANSACTIONS , implementation_dba_data: PO.RCV_MC_TRANSACTIONS ,
Table: PO_COMMODITIES_B 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_COMMODITIES_B, object_name:PO_COMMODITIES_B, status:VALID, product: PO - Purchasing , description: Commodities , implementation_dba_data: PO.PO_COMMODITIES_B ,
Table: PO_USAGES 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_USAGES, object_name:PO_USAGES, status:VALID, product: PO - Purchasing , description: Note usages , implementation_dba_data: PO.PO_USAGES ,
Table: RCV_SUB_LEDGER_DETAILS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SUB_LEDGER_DETAILS, object_name:RCV_SUB_LEDGER_DETAILS, status:VALID, product: PO - Purchasing , description: Detailed accounting lines for the receiving transaction , implementation_dba_data: PO.RCV_SUB_LEDGER_DETAILS ,
Table: PO_DOCUMENT_TOTALS_GT 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_DOCUMENT_TOTALS_GT, object_name:PO_DOCUMENT_TOTALS_GT, status:VALID, product: PO - Purchasing , implementation_dba_data: PO.PO_DOCUMENT_TOTALS_GT ,
Table: PO_VENDOR_LIST_HEADERS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_VENDOR_LIST_HEADERS, object_name:PO_VENDOR_LIST_HEADERS, status:VALID, product: PO - Purchasing , description: RFQ supplier list headers , implementation_dba_data: PO.PO_VENDOR_LIST_HEADERS ,
Table: PO_LINE_LOCATIONS_ALL_EBS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL_EBS, object_name:PO_LINE_LOCATIONS_ALL_EBS, status:VALID, product: PO - Purchasing , description: archive for euro business support project , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL_EBS ,
Table: PO_GA_ORG_ASSIGNMENTS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_GA_ORG_ASSIGNMENTS, object_name:PO_GA_ORG_ASSIGNMENTS, status:VALID, product: PO - Purchasing , description: Global Agreements Org Assignments , implementation_dba_data: PO.PO_GA_ORG_ASSIGNMENTS ,
Table: PO_REQ_DISTRIBUTIONS_ALL_EFC 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQ_DISTRIBUTIONS_ALL_EFC, object_name:PO_REQ_DISTRIBUTIONS_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_REQ_DISTRIBUTIONS_ALL_EFC ,
Table: PO_PRICE_DIFF_INTERFACE 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_PRICE_DIFF_INTERFACE, object_name:PO_PRICE_DIFF_INTERFACE, status:VALID, product: PO - Purchasing , description: Price differentials for rate based lines , implementation_dba_data: PO.PO_PRICE_DIFF_INTERFACE ,
Table: PO_JOB_ASSOCIATIONS_B 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_JOB_ASSOCIATIONS_B, object_name:PO_JOB_ASSOCIATIONS_B, status:VALID, product: PO - Purchasing , description: Associates HR jobs with Purchasing categories. , implementation_dba_data: PO.PO_JOB_ASSOCIATIONS_B ,
Table: PO_CHANGE_REQUESTS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_CHANGE_REQUESTS, object_name:PO_CHANGE_REQUESTS, status:VALID, product: PO - Purchasing , description: PO_CHANGE_REQUEST table stores the change requests for Purchase Orders, Releases and Requisitions submitted by Suppliers or Requesters , implementation_dba_data: PO.PO_CHANGE_REQUESTS ,
Table: RCV_ROUTING_STEPS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_ROUTING_STEPS, object_name:RCV_ROUTING_STEPS, status:VALID, product: PO - Purchasing , description: Receiving routing steps , implementation_dba_data: PO.RCV_ROUTING_STEPS ,
Table: PO_RFQ_VENDORS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_RFQ_VENDORS, object_name:PO_RFQ_VENDORS, status:VALID, product: PO - Purchasing , description: Suppliers on an RFQ , implementation_dba_data: PO.PO_RFQ_VENDORS ,
Table: PO_LINE_TYPES_B 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_TYPES_B, object_name:PO_LINE_TYPES_B, status:VALID, product: PO - Purchasing , description: Line types , implementation_dba_data: PO.PO_LINE_TYPES_B ,
Table: PO_CONTROL_RULES_EFC 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_CONTROL_RULES_EFC, object_name:PO_CONTROL_RULES_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_CONTROL_RULES_EFC ,
Table: PO_PURGE_REQ_LIST 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_PURGE_REQ_LIST, object_name:PO_PURGE_REQ_LIST, status:VALID, product: PO - Purchasing , description: Requisition candidates for purging , implementation_dba_data: PO.PO_PURGE_REQ_LIST ,
Table: PO_DISTRIBUTIONS_GT 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_DISTRIBUTIONS_GT, object_name:PO_DISTRIBUTIONS_GT, status:VALID, product: PO - Purchasing , description: For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is used for internal processing of data for PO Approval Submission Checks. , implementation_dba_data: PO.PO_DISTRIBUTIONS_GT ,
Table: PO_PRICE_DIFFERENTIALS_ARCHIVE 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_PRICE_DIFFERENTIALS_ARCHIVE, object_name:PO_PRICE_DIFFERENTIALS_ARCHIVE, status:VALID, product: PO - Purchasing , description: Price differentials for rate based lines , implementation_dba_data: PO.PO_PRICE_DIFFERENTIALS_ARCHIVE ,
Table: PO_RELEASES_ALL_EBS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_RELEASES_ALL_EBS, object_name:PO_RELEASES_ALL_EBS, status:VALID, product: PO - Purchasing , description: archive for euro business support project , implementation_dba_data: PO.PO_RELEASES_ALL_EBS ,
Table: RCV_UPGRADE_STEPS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_UPGRADE_STEPS, object_name:RCV_UPGRADE_STEPS, status:VALID, product: PO - Purchasing , description: Temporary table for tracking a receiving upgrade from Release 9 to Release 10 , implementation_dba_data: PO.RCV_UPGRADE_STEPS ,
Table: RCV_ACCOUNTING_EVENT_TYPES 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_ACCOUNTING_EVENT_TYPES, object_name:RCV_ACCOUNTING_EVENT_TYPES, status:VALID, product: PO - Purchasing , description: Receiving Accounting Event Types , implementation_dba_data: PO.RCV_ACCOUNTING_EVENT_TYPES ,
Table: RCV_MC_SHIPMENT_LINES 12.1.1
product: PO - Purchasing , description: MRC sub-table of RCV_SHIPMENT_LINES , implementation_dba_data: Not implemented in this database ,
Table: PO_UN_NUMBERS_B 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_UN_NUMBERS_B, object_name:PO_UN_NUMBERS_B, status:VALID, product: PO - Purchasing , description: United Nations numbers , implementation_dba_data: PO.PO_UN_NUMBERS_B ,
Table: PO_WF_CANDIDATE_REQ_LINES_TEMP 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_WF_CANDIDATE_REQ_LINES_TEMP, object_name:PO_WF_CANDIDATE_REQ_LINES_TEMP, status:VALID, product: PO - Purchasing , description: Temporary table to store requisition lines that can be automatically created using workflow , implementation_dba_data: PO.PO_WF_CANDIDATE_REQ_LINES_TEMP ,
Table: RCV_ROUTING_HEADERS 12.1.1
product: PO - Purchasing , description: Receiving routing headers , implementation_dba_data: Not implemented in this database ,
Table: PO_NOTES 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_NOTES, object_name:PO_NOTES, status:VALID, product: PO - Purchasing , description: No longer used , implementation_dba_data: PO.PO_NOTES ,
Table: POA_BIS_SAVINGS_RPT 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.POA_BIS_SAVINGS_RPT, object_name:POA_BIS_SAVINGS_RPT, status:VALID, product: PO - Purchasing , description: Temporary table for Purchasing Intelligence reports. , implementation_dba_data: PO.POA_BIS_SAVINGS_RPT ,
Table: PO_ACCRUAL_ACCOUNTS_TEMP_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ACCRUAL_ACCOUNTS_TEMP_ALL, object_name:PO_ACCRUAL_ACCOUNTS_TEMP_ALL, status:VALID, product: PO - Purchasing , description: Accrual accounts temporary table , implementation_dba_data: PO.PO_ACCRUAL_ACCOUNTS_TEMP_ALL ,
Table: POA_CM_EVAL_SCORES 12.2.2
product: PO - Purchasing , implementation_dba_data: Not implemented in this database ,
Table: PO_ATTRIBUTE_VALUES_DRAFT 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ATTRIBUTE_VALUES_DRAFT, object_name:PO_ATTRIBUTE_VALUES_DRAFT, status:VALID, product: PO - Purchasing , description: Draft table for PO_ATTRIBUTE_VALUES , implementation_dba_data: PO.PO_ATTRIBUTE_VALUES_DRAFT ,
Table: PO_NOTIFICATIONS_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_NOTIFICATIONS_ALL, object_name:PO_NOTIFICATIONS_ALL, status:VALID, product: PO - Purchasing , description: Notifications , implementation_dba_data: PO.PO_NOTIFICATIONS_ALL ,
Table: POA_BIS_SUPPLIER_PERFORMANCE 12.2.2
product: PO - Purchasing , description: Summary information to compare suppliers for an item , implementation_dba_data: Not implemented in this database ,
Table: PO_ATTRIBUTE_VALUES_TLP 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ATTRIBUTE_VALUES_TLP, object_name:PO_ATTRIBUTE_VALUES_TLP, status:VALID, product: PO - Purchasing , description: Stores translatable descriptor values for records that are searchable in iProcurement , implementation_dba_data: PO.PO_ATTRIBUTE_VALUES_TLP ,
Table: PO_PRICE_DIFF_DRAFT 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_PRICE_DIFF_DRAFT, object_name:PO_PRICE_DIFF_DRAFT, status:VALID, product: PO - Purchasing , description: Draft Table for price differentials for rate-based lines. , implementation_dba_data: PO.PO_PRICE_DIFF_DRAFT ,
Table: PO_PRICE_ADJ_ATTRIBS_DRAFT 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_PRICE_ADJ_ATTRIBS_DRAFT, object_name:PO_PRICE_ADJ_ATTRIBS_DRAFT, status:VALID, product: PO - Purchasing , description: Draft table for Price Adjustments Attributes. , implementation_dba_data: PO.PO_PRICE_ADJ_ATTRIBS_DRAFT ,
Table: CHV_AUTHORIZATIONS_GT 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.CHV_AUTHORIZATIONS_GT, object_name:CHV_AUTHORIZATIONS_GT, status:VALID, product: PO - Purchasing , implementation_dba_data: PO.CHV_AUTHORIZATIONS_GT ,