Search Results pn_addresses_all




Overview
Explore in AI Chat

Overview

The PN_ADDRESSES_ALL table is a core data object within the Oracle E-Business Suite (EBS) Property Manager (PN) module. It serves as the central repository for storing address information pertaining to locations and service providers managed by the application. Its role is to provide a standardized and reusable address model, ensuring consistent address data is linked to various entities across the Property Manager's functional landscape. As an "ALL" table, it is designed to support the multi-organization architecture of Oracle EBS, meaning it contains data for all operating units and is partitioned by the SET_OF_BOOKS_ID column.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary purpose is to store comprehensive address attributes. Based on its function and standard Oracle EBS patterns, it typically holds columns such as ADDRESS_ID (the primary key), ADDRESS_LINE_1 through ADDRESS_LINE_4, CITY, STATE, POSTAL_CODE, COUNTRY, and COUNTY. It also includes columns for EBS architectural standards, including CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and the critical SET_OF_BOOKS_ID for multi-org partitioning. The ADDRESS_ID column uniquely identifies each address record and is the key referenced by foreign keys from related tables.

Common Use Cases and Queries

This table is fundamental for any process requiring address information for a property location or a service provider. Common use cases include generating location reports, validating service provider addresses for billing or communication, and supporting lease management by providing the physical addresses for leased properties. A typical query would join this table to a locations or sites table to retrieve a complete address for a specific entity. For example, to find addresses for active company sites, a developer might use a pattern such as:

  • SELECT addr.address_line1, addr.city, addr.state, addr.postal_code
  • FROM pn_addresses_all addr, pn_company_sites_all cs
  • WHERE addr.address_id = cs.address_id
  • AND cs.status = 'ACTIVE';

Reporting often involves this table to list all service provider addresses or to analyze the geographical distribution of managed properties.

Related Objects

The PN_ADDRESSES_ALL table has documented foreign key relationships with several other core Property Manager tables, as per the provided metadata. These relationships define how address data is consumed within the module:

  • PN_COMPANY_SITES_ALL: References PN_ADDRESSES_ALL via the PN_COMPANY_SITES_ALL.ADDRESS_ID column. This links address records to specific company or service provider sites.
  • PN_LOCATIONS_ALL: References PN_ADDRESSES_ALL via the PN_LOCATIONS_ALL.ADDRESS_ID column. This links address records to physical property locations being managed.

These relationships indicate that the ADDRESS_ID primary key from PN_ADDRESSES_ALL is the critical join column for retrieving address details for either a location or a company site. The table is also likely referenced by other PN module tables, views, and public APIs (e.g., PN_LOCATIONS_PUB) for data validation and transaction processing.