Search Results icx_po_revisions_temp




Overview
Explore in AI Chat

Overview

The ICX_PO_REVISIONS_TEMP table is a core data object within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a transient repository designed to store the results of a comparison between two different revisions of a purchase order (PO). Its primary role is to support the PO revision history and comparison features in iProcurement, enabling users to view a detailed, line-item breakdown of changes made between specific versions of a PO document. The table's temporary nature suggests it is populated on-demand during a user's session to facilitate this comparison before potentially being purged.

Key Information Stored

The table's structure is designed to precisely identify the changed element within a PO's hierarchy. Its composite primary key (ICX_PO_REVISIONS_TEMP_PK1) uniquely pinpoints a specific alteration using a combination of identifiers: HEADER_ID, RELEASE_ID, LINE_ID, LOCATION_ID, DISTRIBUTION_ID, REVISION_NUM, and LINE_SEQ. The most critical functional columns are LEVEL_ALTERED and FIELD_ALTERED. LEVEL_ALTERED indicates the document level where the change occurred (e.g., Header, Line, Shipment, Distribution), while FIELD_ALTERED specifies the exact column or attribute that was modified (e.g., Quantity, Price, Need-By Date). This granular storage allows for a structured presentation of revision differences.

Common Use Cases and Queries

The principal use case is generating a side-by-side comparison report of PO revisions within the iProcurement interface. A typical query would join this table to the relevant PO_*_ARCHIVE_ALL tables to fetch the old and new values for the altered fields. For instance, to find all changes for a specific PO header between revision 2 and revision 4, a query might filter on HEADER_ID and REVISION_NUM. Reporting use cases include auditing change history, analyzing amendment patterns, and troubleshooting discrepancies. Sample SQL often involves selecting from ICX_PO_REVISIONS_TEMP joined to PO_HEADERS_ARCHIVE_ALL on HEADER_ID and REVISION_NUM, with filters on LEVEL_ALTERED and FIELD_ALTERED to categorize changes.

Related Objects

ICX_PO_REVISIONS_TEMP is intrinsically linked to the Purchase Order archival tables, as defined by its foreign key relationships. It references the following tables to pull the historical data for comparison:

These relationships confirm that the table compares data stored in the official PO revision archives, ensuring accuracy and consistency with the core Purchasing (PO) module's historical records.