Search Results pv_referred_products




Overview
Explore in AI Chat

Overview

The PV_REFERRED_PRODUCTS table is a core data object within the Oracle E-Business Suite Partner Management (PV) module, specifically in releases 12.1.1 and 12.2.2. It serves as a transactional repository for recording the specific products or services associated with a partner referral. Its primary role is to capture the granular details of what is being referred, enabling organizations to track, analyze, and compensate partners based on the precise product lines involved in a sales opportunity. This table is essential for managing the business logic of partner referral programs, linking high-level referral information to the concrete product catalog.

Key Information Stored

The table's structure is designed to associate a referral with one or more products. The documented primary key, REFERRED_PRODUCT_ID, uniquely identifies each product line item within a referral. The most critical foreign key relationship is through the REFERRAL_ID column, which links each record to its parent entry in the PV_REFERRALS_B table. While the specific product identifier column (e.g., INVENTORY_ITEM_ID, PRODUCT_ID) is not explicitly named in the provided metadata, it is a standard component of such a table. Additional columns typically store transactional details such as the quantity referred, the unit of measure, and potentially the referred list price or revenue amount, which are vital for calculating partner commissions or tracking pipeline value.

Common Use Cases and Queries

This table is central to operational reporting and process automation in partner channels. A common use case is generating a report of all referrals broken down by product category, which helps in analyzing partner performance and product demand. Another critical scenario is the automated calculation of referral fees or commissions payable to a partner based on the products that eventually result in a closed sale. A typical analytical query would join this table to PV_REFERRALS_B and the product master tables (like MTL_SYSTEM_ITEMS_B).

  • Sample Query (Product Detail by Referral): SELECT r.referral_number, r.partner_id, rp.inventory_item_id, msi.segment1 product_code, rp.quantity FROM pv_referrals_b r, pv_referred_products rp, mtl_system_items_b msi WHERE r.referral_id = rp.referral_id AND rp.inventory_item_id = msi.inventory_item_id AND r.creation_date > SYSDATE - 30;
  • Reporting Use Case: Aggregating the total potential revenue in the referral pipeline by product line or partner tier.

Related Objects

The PV_REFERRED_PRODUCTS table exists within a tightly integrated schema. Its primary and most direct relationship is with the PV_REFERRALS_B table, as defined by the foreign key on REFERRAL_ID. This establishes a one-to-many relationship where a single referral header can have multiple referred product lines. The table is also intrinsically linked to the product master tables, most commonly MTL_SYSTEM_ITEMS_B, to resolve product identifiers into descriptive information. For commission processing, it may interact with tables in the Incentive Compensation (CN) module. Programmatic access and validation for this table are typically governed by PL/SQL APIs within the PV partner management packages.