Search Results prp_email_recipients




Overview
Explore in AI Chat

Overview

The PRP_EMAIL_RECIPIENTS table is a core data object within the Oracle E-Business Suite Proposals (PRP) module, versions 12.1.1 and 12.2.2. It functions as the detailed recipient log for email communications generated by the system. Its primary role is to persistently store the target information for each email sent, linking the communication history to the specific parties or contacts within the Trading Community Architecture (TCA) model. This table is essential for auditing, tracking correspondence, and ensuring a complete record of proposal-related outreach.

Key Information Stored

The table's structure is designed to capture the relationship between an email event and its intended recipients. The primary key, EMAIL_RECIPIENT_ID, uniquely identifies each recipient record. The EMAIL_HISTORY_ID column is a critical foreign key that links the recipient to the parent email event stored in the PRP_EMAIL_HISTORY table. The PARTY_ID column stores the identifier for the HZ_PARTIES record, which is the central table for all persons and organizations in TCA. This design directly supports the documented business logic: for a party of type 'ORGANIZATION', the PARTY_ID may reference the organization, while associated contact details are managed elsewhere; for a party of type 'PERSON', it references the individual party directly.

Common Use Cases and Queries

A primary use case is generating audit reports on proposal communications. For example, to list all emails sent regarding a specific proposal and their recipients, one would join from the proposal header through the email history to this table. Another common scenario is troubleshooting failed communications by verifying recipient details. A sample query to retrieve recipient information for a given email would be:

  • SELECT per.email_recipient_id, per.party_id, hp.party_name, hp.party_type FROM prp_email_recipients per, hz_parties hp WHERE per.party_id = hp.party_id AND per.email_history_id = <EMAIL_HISTORY_ID>;

This table is also crucial for workflows that require confirmation of correspondence with specific client contacts during the proposal lifecycle.

Related Objects

The PRP_EMAIL_RECIPIENTS table maintains defined foreign key relationships with two key tables, as documented in the ETRM metadata:

  • PRP_EMAIL_HISTORY: The primary parent table. The column PRP_EMAIL_RECIPIENTS.EMAIL_HISTORY_ID references the PRP_EMAIL_HISTORY table to link each recipient record to a specific sent email.
  • HZ_PARTIES: The foundational TCA table. The column PRP_EMAIL_RECIPIENTS.PARTY_ID references HZ_PARTIES.PARTY_ID to identify the person or organization recipient.

These relationships enforce data integrity and are essential for any join query that retrieves comprehensive email history, including recipient names and types from the TCA model.