Search Results pn_options_all




Overview
Explore in AI Chat

Overview

The PN_OPTIONS_ALL table is a core data object within the Oracle E-Business Suite Property Manager (PN) module. It serves as the central repository for storing the detailed terms and conditions of options specified within a lease contract for a specific period. An option, in lease management, typically refers to a contractual right granted to the lessee or lessor, such as an option to renew, terminate, or purchase the leased property. This table is critical for tracking these contingent future events, enabling comprehensive lease lifecycle management, financial forecasting, and compliance reporting. As an "_ALL" table, it is designed to support multi-organization access control (MOAC) by including an ORG_ID column, allowing data partitioning by operating unit.

Key Information Stored

The table's primary key is OPTION_ID, which uniquely identifies each option record. Two critical foreign key columns establish the option's context within the lease structure: LEASE_ID links the option to its parent lease in PN_LEASES_ALL, and LEASE_CHANGE_ID links it to a specific lease amendment or change document in PN_LEASE_CHANGES_ALL, if applicable. While the full column list is not detailed in the provided metadata, typical columns in such a table would include data points like OPTION_TYPE (e.g., Renewal, Termination), OPTION_STATUS, NOTICE_REQUIRED_DATE, EXERCISE_DEADLINE_DATE, associated financial terms, and descriptive TEXT fields. The ORG_ID column is invariably present to enforce data security.

Common Use Cases and Queries

This table is central to reporting on upcoming lease decisions and obligations. Common business use cases include generating reports of options expiring within a fiscal quarter to manage notice deadlines, analyzing the potential financial impact of exercisable purchase options, and auditing lease terms during compliance reviews. A typical reporting query would join PN_OPTIONS_ALL to PN_LEASES_ALL to retrieve lease details and filter based on dates and statuses.

Sample Query Pattern:
SELECT l.LEASE_NUM, o.OPTION_TYPE, o.NOTICE_REQUIRED_DATE
FROM PN_OPTIONS_ALL o, PN_LEASES_ALL l
WHERE o.LEASE_ID = l.LEASE_ID
AND o.OPTION_STATUS = 'ACTIVE'
AND o.NOTICE_REQUIRED_DATE BETWEEN SYSDATE AND SYSDATE + 90
AND l.ORG_ID = :p_org_id;

Related Objects

The PN_OPTIONS_ALL table sits at the center of a defined relational structure within Property Manager. The documented foreign key relationships are as follows:

  • References (Outgoing Foreign Keys): This table references two parent tables.
    • PN_LEASES_ALL: Via LEASE_ID. Every option must be associated with a master lease.
    • PN_LEASE_CHANGES_ALL: Via LEASE_CHANGE_ID. An option may be created or modified by a specific lease amendment.
  • Referenced By (Incoming Foreign Keys): Two child tables reference PN_OPTIONS_ALL via its OPTION_ID.