Search Results icx_por_third_party_log_values




Overview
Explore in AI Chat

Overview

The ICX_POR_THIRD_PARTY_LOG_VALUES table is a core logging entity within Oracle E-Business Suite iProcurement (ICX) modules, specifically supporting the Third Party Authoring functionality. Its primary role is to provide an auditable, granular record of data changes made by suppliers or on their behalf within the procurement system. This table operates as a child detail table, storing the specific column-level values that were altered during supplier-driven authoring processes for catalog items and pricing. It is essential for maintaining data integrity, enabling troubleshooting, and fulfilling audit requirements related to supplier self-service activities in releases 12.1.1 and 12.2.2.

Key Information Stored

The table captures the detailed transactional log of changes at the attribute level. While the full column list is not provided in the metadata, the structure is defined by its primary key and foreign key relationships. The composite primary key consists of DESCRIPTOR_KEY and LOG_ID, indicating that each record is uniquely identified by a specific log entry and a descriptor for the changed data element. Typical data stored includes the old and new values for specific item or price attributes (such as description, unit price, or category), the name of the changed column, and potentially data type information. This design allows the system to reconstruct the exact state of a data change performed by a supplier.

Common Use Cases and Queries

The primary use case is auditing and diagnosing changes made through supplier portals. System administrators and support personnel query this table to trace the history of an item or price update, often joining it to the parent log header. A common reporting scenario involves identifying all changes made for a specific supplier or item within a date range. A sample SQL pattern to retrieve detailed change history would be:

  • SELECT l.supplier_id, l.change_date, v.descriptor_key, v.old_value, v.new_value FROM icx_por_third_party_logs l, icx_por_third_party_log_values v WHERE l.log_id = v.log_id AND l.supplier_id = :p_supplier_id ORDER BY l.change_date DESC;

This data is crucial for resolving disputes, validating automated price updates, and ensuring compliance with procurement policies.

Related Objects

This table has a direct, documented foreign key relationship with the ICX_POR_THIRD_PARTY_LOGS table, which serves as its parent header. The relationship is enforced via the LOG_ID column (ICX_POR_THIRD_PARTY_LOG_VALUES.LOG_ID references ICX_POR_THIRD_PARTY_LOGS). The ICX_POR_THIRD_PARTY_LOGS table typically contains high-level information about the change event, such as the supplier ID, timestamp, user, and action type. Therefore, any meaningful reporting or analysis from the LOG_VALUES table requires a join to the LOGS table to contextualize the detailed changes with the who, when, and why of the transaction. This two-table structure separates header information from volatile detail data.