Search Results pn_contacts_all




Overview
Explore in AI Chat

Overview

The PN_CONTACTS_ALL table is a core data object within the Oracle E-Business Suite (EBS) Property Manager (PN) module. It functions as the central repository for storing contact information associated with the site level of a service provider. In the context of Property Manager, which handles lease and property administration, a service provider is typically a lessor, lessee, vendor, or other entity involved in a property agreement. This table allows organizations to maintain detailed contact records (e.g., property managers, maintenance coordinators, billing contacts) linked directly to specific physical locations or sites of these entities, facilitating communication and management for lease-related operations.

Key Information Stored

The table's primary purpose is to store attributes that define a contact person at a given company site. While the full column list is not detailed in the provided metadata, the structure is defined by its primary and foreign keys. The CONTACT_ID column serves as the unique primary key identifier for each contact record. The critical foreign key COMPANY_SITE_ID links the contact to a specific site record in the PN_COMPANY_SITES_ALL table, establishing the contact's organizational and locational context. Other typical columns in such a table would include the contact's name (FIRST_NAME, LAST_NAME), job title (TITLE), and potentially flags for primary contact designation or contact type (e.g., billing, technical).

Common Use Cases and Queries

This table is essential for generating contact lists for lease administration, creating notification lists for critical events like lease expirations or payment reminders, and supporting operational reporting. A common reporting query involves joining to the company sites and parties tables to list all contacts for a specific lessor.

  • Sample Query: Retrieving contacts for a specific company site.

    SELECT pc.contact_id, pc.first_name, pc.last_name, pc.title
    FROM pn_contacts_all pc
    WHERE pc.company_site_id = :p_site_id
    ORDER BY pc.last_name, pc.first_name;

  • Integration Use Case: The contact data is often leveraged by other EBS components, such as Oracle Payments or Oracle Receivables, for generating correspondence or populating payment remittance addresses linked to lease invoices.

Related Objects

The PN_CONTACTS_ALL table is integral to the Property Manager data model, with documented relationships to other key tables.

  • PN_COMPANY_SITES_ALL: This is the parent table. Each contact must be associated with a valid company site via the PN_CONTACTS_ALL.COMPANY_SITE_ID foreign key column.
  • PN_PHONES_ALL: This is a child table. Multiple phone numbers can be stored for a single contact record. The relationship is maintained by the PN_PHONES_ALL.CONTACT_ID foreign key column referencing PN_CONTACTS_ALL.CONTACT_ID.

These relationships ensure data integrity, where a contact cannot exist without a site, and phone records are purged or orphaned if the parent contact is deleted, depending on the constraint configuration.