Search Results actual_compensation_amt




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PV_REFERRALS_B is the referrals base table within the Oracle EBS Partner Management (PV) module. It stores one row per referral transaction submitted by, or on behalf of, a partner organization, capturing the customer, contact, benefit, and compensation context surrounding the referral. The table is the primary transactional store for the referral lifecycle and is supported by a translation table (PV_REFERRALS_TL) and related child tables such as PV_REFERRED_PRODUCTS and PV_GE_QSNR_ELEMENTS_B. It is owned by the PV schema and is documented as a valid object in both EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined foreign-key structure indicates a satellite-leaning classification. The table carries descriptive and status attributes (customer details, compensation amounts, status codes, twenty-four descriptive flexfield columns) that behave like satellite payload, while also holding several foreign keys that function as link relationships to accounts, resources, benefits, and claims. Modeling suggest that the referral is best understood as a satellite anchored to a hub on the referral business key, with associated links to the referenced parties.

Key Information Stored

The table contains 81 documented columns. The essential columns comprise:

Common Use Cases and Queries

Typical reporting centers on referral pipeline status, partner contribution, and compensation exposure. A common pattern joins the base table to its translation table to retrieve the description in the session language:

SELECT b.referral_id, b.referral_code, t.description, b.referral_status
FROM pv_referrals_b b, pv_referrals_tl t
WHERE b.referral_id = t.referral_id AND t.language = USERENV('LANG');

Compensation analysis aggregates estimated against actual amounts by benefit and currency:

SELECT b.benefit_id, b.currency_code,
SUM(b.est_compensation_amt) est_total, SUM(b.actual_compensation_amt) act_total
FROM pv_referrals_b b GROUP BY b.benefit_id, b.currency_code;

Partner performance reporting joins the partner account to resolve partner names, and joins the customer account or resource tables to enrich contact information. Deduplication checks use DUPLICATE_CUSTOMER_FLAG, while claim reconciliation queries filter on CLAIM_ID. All operational queries should respect ORG_ID and SECURITY_GROUP_ID to preserve multi-org and security-group isolation.

Related Objects

The following objects are most significant in relation to PV_REFERRALS_B:

  • PV_REFERRALS_TL — translation table, joined on REFERRAL_ID, supplying language-specific descriptions.
  • PV_REFERRED_PRODUCTS — child table, joined on REFERRAL_ID, listing products associated with the referral.
  • PV_GE_QSNR_ELEMENTS_B — joined via USED_BY_ENTITY_ID, linking questionnaire elements to the referral.
  • HZ_CUST_ACCOUNTS — referenced through PARTNER_CUST_ACCOUNT_ID for partner account data.
  • JTF_RS_RESOURCE_EXTNS — referenced through PARTNER_CONTACT_RESOURCE_ID for the partner contact resource.
  • PV_GE_BENEFITS_B — referenced through BENEFIT_ID for the benefit program.
  • AS_LEADS_ALL / AS_SALES_LEADS — referenced through ENTITY_ID_LINKED_TO for lead linkage.
  • OZF_CLAIMS_ALL — referenced through CLAIM_ID for claim and compensation integration.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for security partitioning.