Search Results pv_pg_elig_prog_mirr_pk

Overview

The PV_PG_ELIG_PROG_MIRR table is a core data object within the Oracle E-Business Suite (EBS) Partner Management (PV) module. It functions as a repository for defining and storing eligible program records. In the context of partner channel management, this table is instrumental in managing the association between partner entities and the specific programs for which they qualify. Its role is to serve as a master reference that supports the configuration and enforcement of program eligibility rules, which is a fundamental aspect of structuring partner hierarchies, compensation plans, and access to specialized offerings within the EBS ecosystem.

Key Information Stored

The table's primary purpose is to maintain a unique list of eligible programs. The central column is ELIG_PROGRAM_ID, which serves as the table's primary key and uniquely identifies each eligible program record. A critical foreign key column is PROGRAM_ID, which establishes a direct link to the PV_PARTNER_PROGRAM_B table. This relationship ensures data integrity by tying an eligible program definition to a concrete, defined partner program within the system. While the provided metadata specifies these core columns, typical implementations would also include audit columns (e.g., CREATION_DATE, CREATED_BY) and potentially fields for effective dating or status to control the active lifecycle of the eligibility record.

Common Use Cases and Queries

This table is primarily accessed for configuration, validation, and reporting related to partner program enrollment. Common operational scenarios include validating if a partner is authorized to enroll in a specific program before creating a program membership record, and generating reports listing all available programs for which partners can be made eligible. A typical query pattern involves joining this table to the partner program master to retrieve detailed program information.

Sample SQL Pattern:
SELECT prog.program_name, prog.description
FROM pv_pg_elig_prog_mirr elig,
pv_partner_program_b prog
WHERE elig.program_id = prog.program_id
AND prog.status = 'ACTIVE';

Related Objects

The PV_PG_ELIG_PROG_MIRR table has documented relationships with other key objects in the Partner Management schema, primarily through foreign key constraints.

• Primary Key: PV_PG_ELIG_PROG_MIRR_PK on column ELIG_PROGRAM_ID.
• Foreign Key (References): The table contains a foreign key where its PROGRAM_ID column references the PV_PARTNER_PROGRAM_B table. This is the primary documented relationship, ensuring every eligible program record is linked to a valid master program definition.

Given its central role, this table is also likely referenced by other transactional or assignment tables in the PV module, such as those managing specific partner-to-program enrollments or eligibility exceptions, though these are not explicitly detailed in the provided metadata.