Search Results optimum_capacity




Overview
Explore in AI Chat

Overview

PN_LOCATIONS_ALL is the core space-definition table within the Oracle Property Manager (PN) module of Oracle E-Business Suite, owned by the PN schema. In EBS 12.1.1 and 12.2.2, it stores the master record of every physical location that a property portfolio comprises — buildings, floors, offices, suites, and other rentable or assignable spaces. It serves as the central hub for space management, tenancy tracking, lease administration, and cost allocation.

Each row defines a location's identity, hierarchy, physical attributes, capacity metrics, and its association with a property and address. Because it supports parent-child nesting via PARENT_LOCATION_ID, it functions as both a standalone entity and a self-referencing hierarchy, allowing drill-down from a building down to individual offices.

From a data-modeling perspective, the heuristic Data Vault classification for PN_LOCATIONS_ALL is hub. The LOCATION_ID (with its effective-dating attributes) behaves as a durable business key that anchors many downstream relationships, so it is best modeled as a hub with satellites for the descriptive, effective-dated attributes.

Key Information Stored

The table's surrogate identifier is LOCATION_ID, but the true business keys are captured by unique indexes:

Among the 67 documented columns, the most significant are:

Common Use Cases and Queries

Typical scenarios include space inventory reporting, occupancy analysis, lease-to-space reconciliation, and hierarchy traversal.

  • Listing all active locations for a property: 
    SELECT location_id, location_code, rentable_area
FROM   pn_locations_all
WHERE  property_id = :p_property_id
AND    SYSDATE BETWEEN active_start_date AND active_end_date;
  • Traversing the parent-child hierarchy using CONNECT BY on PARENT_LOCATION_ID.
  • Joining to tenancies and leases to compute occupancy and cost per square foot.
  • Feeding space allocation and contact-assignment reporting for facility managers.

Related Objects

PN_LOCATIONS_ALL participates in numerous FK relationships:

These relationships make PN_LOCATIONS_ALL the pivotal entity for integrated space, lease, and occupancy management in Property Manager.