Search Results pv_pg_memberships




Overview
Explore in AI Chat

Overview

The PV_PG_MEMBERSHIPS table is a core data object within the Oracle E-Business Suite Partner Management (PV) module for versions 12.1.1 and 12.2.2. It serves as the central repository for storing and managing a partner's membership details within specific partner programs. This table is fundamental to the Partner Program Enrollment and Management functionality, acting as the definitive record of a partner's association with a program, its status, and its lifecycle. Each row uniquely identifies a single membership instance, linking a partner (PARTNER_ID) to a specific program (PROGRAM_ID). Its role is critical for tracking partner eligibility, program benefits, and the historical progression of a partner's engagement within the Oracle partner ecosystem.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships define the table's essential structure. The primary key, MEMBERSHIP_ID, is a unique system-generated identifier for each membership record. The table stores the foreign key references that establish its core relationships: PARTNER_ID links to the HZ_PARTIES table (Trading Community Architecture) to identify the partner organization; PROGRAM_ID links to PV_PARTNER_PROGRAM_B to define the specific partner program; and ENRL_REQUEST_ID links to PV_PG_ENRL_REQUESTS, connecting the membership to its originating enrollment application. Other typical columns in such a table would include status, start date, end date, and membership level, forming a complete record of the program engagement.

Common Use Cases and Queries

This table is central to reporting and operational processes within Partner Management. Common use cases include generating lists of all active partners in a specific program, analyzing membership duration and churn, and validating partner eligibility for discounts or leads. A typical query would join PV_PG_MEMBERSHIPS with HZ_PARTIES and PV_PARTNER_PROGRAM_B to create a comprehensive partner membership report. For example, to find all current members of a program named 'GOLD_RESELLER':

  • SELECT hp.party_name, pgm.program_name, pvm.*
  • FROM pv_pg_memberships pvm,
  • hz_parties hp,
  • pv_partner_program_b pgm
  • WHERE pvm.partner_id = hp.party_id
  • AND pvm.program_id = pgm.program_id
  • AND pgm.program_name = 'GOLD_RESELLER'
  • AND pvm.status = 'ACTIVE';

Another critical use case is tracking membership transitions, facilitated by the PV_PG_MMBR_TRANSITIONS table, which references PV_PG_MEMBERSHIPS via FROM_MEMBERSHIP_ID and TO_MEMBERSHIP_ID.

Related Objects

The PV_PG_MEMBERSHIPS table is a central hub with well-defined relationships to several other EBS objects, as documented in the foreign key metadata.

  • Referenced By This Table (Outgoing FKs):
    • PV_PG_ENRL_REQUESTS: via ENRL_REQUEST_ID. Links the membership to its source enrollment request.
    • HZ_PARTIES: via PARTNER_ID. Identifies the partner organization.
    • PV_PARTNER_PROGRAM_B: via PROGRAM_ID. Defines the associated partner program.
  • References This Table (Incoming FKs):