Search Results index_exclude_term_id

Overview

The PN_INDEX_EXCLUDE_TERM_ALL table is a core data structure within the Oracle E-Business Suite Property Manager (PN) module. It serves the specific business function of managing lease rent indexation. The table stores a definitive list of payment terms that must be omitted during the automated calculation of a rent increase for a lease. This exclusion mechanism is critical for ensuring that only applicable, index-linked payment streams are adjusted, preserving the financial integrity of lease agreements where certain terms, such as fixed service charges or non-indexed rent components, are contractually exempt from periodic adjustments.

Key Information Stored

The table's primary purpose is to link a specific index adjustment rule (index lease) with the individual payment terms excluded from its calculation. The key columns facilitating this are the foreign keys INDEX_LEASE_ID and PAYMENT_TERM_ID. The INDEX_EXCLUDE_TERM_ID column acts as the unique primary key for each exclusion record. While the provided metadata does not list all columns, the structure implies the presence of standard Oracle EBS columns like CREATION_DATE, LAST_UPDATE_DATE, and CREATED_BY to track data history. The table is an "ALL" table, indicating it is partitioned by the operating unit (likely via an ORG_ID column) to support multi-organization architecture in both EBS 12.1.1 and 12.2.2.

Common Use Cases and Queries

The primary use case is validating and reporting on exclusions during a rent indexation batch process. A system process would query this table to identify which payment terms for a given index lease should be skipped. Common queries include identifying all exclusions for a specific lease index rule or verifying if a particular payment term is excluded. For example:

• To list all excluded terms for an index lease: SELECT payment_term_id FROM pn_index_exclude_term_all WHERE index_lease_id = <lease_id>;
• To generate a report of excluded terms across operating units, one might join with PN_PAYMENT_TERMS_ALL to get term details and PN_INDEX_LEASES_ALL for the rule description.

This table is typically maintained via the Property Manager application interface, not via direct SQL manipulation.

Related Objects

The table maintains defined foreign key relationships with two other central Property Manager tables, as documented in the metadata:

• PN_INDEX_LEASES_ALL: The relationship is via the INDEX_LEASE_ID column. This links each exclusion record to the master definition of the rent indexation rule applied to a lease.
• PN_PAYMENT_TERMS_ALL: The relationship is via the PAYMENT_TERM_ID column. This identifies the exact lease payment term (e.g., a specific rent line item) that is excluded from the index calculation.

The primary key constraint PN_INDEX_EXCLUDE_TERM_PK on INDEX_EXCLUDE_TERM_ID ensures uniqueness. The table is integral to the rent indexation engine, and its data directly influences the financial output of the PN module's automated lease adjustment processes.