Search Results interactions_inf_id

Overview

The BIX_INTERACTIONS_INF table is a key data repository within the Oracle Business Intelligence for Interactions (BIX) product area of Oracle E-Business Suite (EBS) Releases 12.1.1 and 12.2.2. It functions as an informational fact table, designed to store quantitative and categorical metrics associated with customer interaction records. Its primary role is to support advanced analytics and reporting on interaction data by holding measurable values (e.g., revenue, duration, quantity) categorized by specific keys. As indicated by the documentation warning, this is an internal applications table; direct data manipulation or querying outside of standard Oracle Applications programs is not supported by Oracle.

Key Information Stored

The table structure is optimized for storing flexible, key-value paired metrics linked to a master interaction. The critical columns are:

• INTERACTIONS_INF_ID: The surrogate primary key for each record in this table.
• INTERACTIONS_ID: The foreign key linking to the BIX_INTERACTIONS table, which holds the core interaction header information.
• KEY and SUBKEY: Define the category of the metric (e.g., 'Revenue', 'Cost'). SUBKEY provides an optional secondary classification.
• VALUE: Stores the numerical fact or measurement (e.g., 55.00) for the specified KEY/SUBKEY.
• HANDLER_ID: Identifies the client application responsible for the data.
• PRODUCT_GROUP_ID and SECURITY_GROUP_ID: Support product segmentation and multi-org security contexts, respectively.

Common Use Cases and Queries

This table is central to generating analytical reports on interaction performance. A common use case is aggregating financial metrics, such as total revenue generated by different interaction types or channels. For performance troubleshooting, analysts might query for interactions with exceptionally high or low metric values. A typical reporting query involves joining to the master interactions table to provide context:

SELECT i.INTERACTION_NUMBER, inf.KEY, inf.SUBKEY, inf.VALUE
FROM BIX.BIX_INTERACTIONS_INF inf,
     BIX.BIX_INTERACTIONS i
WHERE inf.INTERACTIONS_ID = i.INTERACTION_ID
AND inf.KEY = 'Revenue'
ORDER BY inf.VALUE DESC;

Another pattern is to pivot key-value pairs into a columnar format for analysis, often performed within BI tools or using SQL analytic functions.

Related Objects

The BIX_INTERACTIONS_INF table has a direct and singular relationship with the master interactions table, as documented in the provided metadata:

• Primary Key: BIX_INTERACTIONS_INF_PK on the column INTERACTIONS_INF_ID.
• Foreign Key (References): The column INTERACTIONS_ID is a foreign key to the BIX_INTERACTIONS table. This is the fundamental join for enriching metric data with interaction header details like date, type, and customer.
• Index: A non-unique index, BIX_INTERACTIONS_INF1_N1, exists on the INTERACTIONS_ID column to optimize join performance to the parent table.