Search Results icx_panel_summary




Overview
Explore in AI Chat

Overview

The ICX_PANEL_SUMMARY table is a core data object within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a consolidated summary table that aggregates key transactional data for customers. Its primary role is to provide a high-level, performance-optimized view of a customer's procurement activity, including orders, returns, cancellations, and service requests. This aggregated data is critical for supporting summary dashboards, reporting panels, and analytical features within the iProcurement self-service interface, enabling users and administrators to quickly assess customer engagement and transaction history without querying multiple detailed transactional tables.

Key Information Stored

The table stores aggregated metrics for a customer within a specific operating unit, as of a given point in time. The primary key uniquely identifies a summary record by the combination of ORG_ID (Operating Unit), CUSTOMER_ID, and DATA_AS_OF_DATE. Key summary columns typically include counts and totals for various transaction types, such as the total number of orders, total order value, number of returns, and number of service requests. The foreign key relationships indicate the storage of specific identifiers, such as LAST_ORDER_HEADER_ID, which links to the SO_HEADERS_ALL table to reference the most recent order, and the CUSTOMER_ID itself, which links to the RA_CUSTOMERS table to provide customer master data.

Common Use Cases and Queries

The primary use case is to populate summary panels or dashboards in the iProcurement application. A common query would retrieve the latest snapshot of a customer's activity for display. For example:

  • Retrieving a Customer Summary: SELECT * FROM icx.icx_panel_summary WHERE org_id = :p_org_id AND customer_id = :p_cust_id AND data_as_of_date = (SELECT MAX(data_as_of_date) FROM icx.icx_panel_summary WHERE org_id = :p_org_id AND customer_id = :p_cust_id);
  • Reporting on Aggregate Metrics: Generating reports on total orders or spend per customer across operating units, leveraging the pre-aggregated data for performance.
  • Data Refresh/Maintenance: The table is likely populated or refreshed via concurrent programs or database jobs that summarize data from source transactional tables like SO_HEADERS_ALL.

Related Objects

ICX_PANEL_SUMMARY has direct dependencies on several key EBS tables, as defined by its foreign keys. The most significant relationships are:

  • RA_CUSTOMERS: The source of the customer master record via the CUSTOMER_ID foreign key.
  • SO_HEADERS_ALL: The Order Management (OM) table that holds sales order headers, linked via the LAST_ORDER_HEADER_ID foreign key to provide details of the customer's most recent order.
  • While not explicitly listed in the provided metadata, the table's summary data is logically derived from various transactional sources within iProcurement, Order Management, and Service, and is intended for consumption by iProcurement application components and custom reports.