Search Results pv_pg_enrq_init_sources




Overview
Explore in AI Chat

Overview

The table PV.PV_PG_ENRQ_INIT_SOURCES is a core data structure within the Oracle E-Business Suite Partner Management (PV) module, specifically for versions 12.1.1 and 12.2.2. It functions as a transactional container designed to capture and persist the initiation source details associated with a partner enrollment request. Its primary role is to support the processes of upgrading or downgrading a partner's membership level or program enrollment. By storing this contextual "source" information, the table provides an audit trail and enables the system to manage the logic and rules governing enrollment changes effectively.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which indicate the critical data points it holds. The primary key, INITIATION_SOURCE_ID, uniquely identifies each initiation source record. The table's purpose is explicitly relational, linking an enrollment request to its originating context through three key foreign key columns. The ENRL_REQUEST_ID column links to the specific enrollment request (PV_PG_ENRL_REQUESTS) that triggered the upgrade or downgrade. The PREV_MEMBERSHIP_ID references the partner's membership record (PV_PG_MEMBERSHIPS) prior to the change, establishing a "before" state. Finally, the ENRL_CHANGE_RULE_ID links to the governing business rule (PV_PG_ENRL_CHANGE_RULES) that was applied to facilitate the enrollment change, connecting the action to the configured policy.

Common Use Cases and Queries

This table is central to reporting and auditing enrollment change history. A common use case involves generating a report of all enrollment upgrades performed under a specific business rule to analyze partner migration patterns. Another scenario is tracing the lineage of a specific enrollment request back to its source membership and the rule that enabled the change for compliance or troubleshooting. A typical analytical query would join PV_PG_ENRQ_INIT_SOURCES to PV_PG_ENRL_REQUESTS, PV_PG_MEMBERSHIPS, and PV_PG_ENRL_CHANGE_RULES to create a comprehensive view of the enrollment change event.

SELECT init.INITIATION_SOURCE_ID,
       req.ENRL_REQUEST_NUMBER,
       mem.MEMBERSHIP_NUMBER AS PREV_MEMBERSHIP_NUM,
       rule.RULE_NAME
FROM PV.PV_PG_ENRQ_INIT_SOURCES init,
     PV.PV_PG_ENRL_REQUESTS req,
     PV.PV_PG_MEMBERSHIPS mem,
     PV.PV_PG_ENRL_CHANGE_RULES rule
WHERE init.ENRL_REQUEST_ID = req.ENRL_REQUEST_ID
  AND init.PREV_MEMBERSHIP_ID = mem.MEMBERSHIP_ID
  AND init.ENRL_CHANGE_RULE_ID = rule.ENRL_CHANGE_RULE_ID;

Related Objects

The table PV_PG_ENRQ_INIT_SOURCES has defined foreign key relationships with several core Partner Management tables, as documented in the ETRM metadata. These relationships are fundamental to its integrity and function.

  • PV_PG_ENRL_REQUESTS: Linked via the column ENRL_REQUEST_ID. This is the primary parent table for enrollment requests.
  • PV_PG_MEMBERSHIPS: Linked via the column PREV_MEMBERSHIP_ID. This references the membership record that existed before the enrollment change.
  • PV_PG_ENRL_CHANGE_RULES: Linked via the column ENRL_CHANGE_RULE_ID. This references the business rule that defines the conditions and outcomes for the enrollment change.