Search Results contact_assignment_id




Overview
Explore in AI Chat

Overview

The PN_CONTACT_ASSIGNMENTS_ALL table is a core data object within the Oracle E-Business Suite Property Manager (PN) module. Its primary function is to establish and manage the association between a property or lease and a service provider's point of contact. As the description states, it "links locations or leases with the site of a service provider." This table is essential for tracking which external companies (e.g., maintenance vendors, utility providers, or landlords) are assigned to specific managed properties (locations) or lease agreements, and it identifies the precise company site to be contacted for service-related matters. Being an "ALL" table, it is designed to store data across multiple operating units, adhering to Oracle's multi-org architecture standards.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which reveal the critical data relationships it maintains. The primary key, CONTACT_ASSIGNMENT_ID, uniquely identifies each assignment record. The foreign keys point to the core entities involved in the relationship:

This structure allows a single location or lease to have multiple contact assignments for different services or providers.

Common Use Cases and Queries

This table is central to operational reporting and process execution in Property Manager. A common use case is generating a contact list for all service providers assigned to a particular property portfolio or lease. For troubleshooting, one might query all assignments for a specific company. A typical reporting query would join this table to its related master tables to produce a readable output:

SELECT pca.contact_assignment_id,
pl.location_code,
pc.company_name,
pcs.site_name
FROM pn_contact_assignments_all pca,
pn_locations_all pl,
pn_companies_all pc,
pn_company_sites_all pcs
WHERE pca.location_id = pl.location_id
AND pca.company_id = pc.company_id
AND pca.company_site_id = pcs.company_site_id
AND pl.location_code = 'HQ_BLDG';

Data in this table is typically created and maintained through the Property Manager application's forms and workflows for managing locations, leases, and associated contacts.

Related Objects

PN_CONTACT_ASSIGNMENTS_ALL sits at the intersection of several key Property Manager entities. As indicated by its foreign keys, it has direct relationships with:

  • PN_LOCATIONS_ALL: The table for property locations.
  • PN_LEASES_ALL and PN_LEASE_CHANGES_ALL: The core lease management tables.
  • PN_COMPANIES_ALL and PN_COMPANY_SITES_ALL: The tables defining service provider organizations and their addresses.

Furthermore, it is a parent table to PN_CONTACT_ASSIGN_HISTORY, which tracks historical changes to these contact assignments over time, ensuring a complete audit trail. Any custom reporting or integration involving property or lease contacts will invariably reference this central junction table.