Search Results pn_system_setup_options

Overview

PN_SYSTEM_SETUP_OPTIONS is the Property Manager (PN) configuration table that stores system setup options at the operating unit level. Each row represents a distinct profile of Property Manager behavior for a given organization and ledger, driving defaults for lease numbering, currency conversion, accounting integration, space assignment, and adjustment processing. In Oracle EBS 12.1.1 and 12.2.2, this table is the central reference that Property Manager reads during lease creation, space management, and journal generation to determine how transactions should be numbered, grouped, dated, and posted to the General Ledger.

The table resides in the PN schema and is joined to operating units and sets of books, making it a configuration anchor rather than a transactional ledger. Because it controls multiple downstream processes, changes to this table should be treated as setup changes requiring careful regression testing. The heuristic Data Vault classification mined from the foreign key structure is link, suggesting the table functions primarily as an associative entity that binds an operating unit (HR_ALL_ORGANIZATION_UNITS) to a ledger (GL_SETS_OF_BOOKS_11I) while carrying descriptive configuration attributes. In a dimensional model, it behaves as a type-1 configuration dimension keyed by profile.

Key Information Stored

The table contains 39 documented columns. The most operationally significant include the following:

• PROFILE_ID — The surrogate primary key, enforced by PN_SYSTEM_SETUP_OPTIONS_PK and also captured by the unique index PN_SYSTEM_SETUP_OPTIONS_U1.
• ORG_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the operating unit whose Property Manager options are configured.
• SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS_11I, identifying the ledger used for accounting entries generated from Property Manager transactions.
• ACCOUNTING_OPTION — Controls the accounting treatment mode applied to Property Manager transactions.
• DEFAULT_CURRENCY_CONV_TYPE — Default currency conversion type used for foreign-currency lease and rent calculations.
• MULTIPLE_TENANCY_LEASE — Flag indicating whether a lease may contain multiple tenants.
• AUTO_SPACE_DISTRIBUTION — Determines whether space is automatically distributed across lease assignments.
• AUTO_COMP_NUM_GEN, AUTO_LEASE_NUM_GEN, AUTO_INDEX_NUM_GEN, AUTO_VAR_RENT_NUM_GEN — Number-generation flags for completions, leases, index adjustments, and variable rent records respectively.
• GL_TRANSFER_MODE and SUBMIT_JOURNAL_IMPORT_FLAG — Govern how Property Manager accounting entries are transferred and whether journal import is submitted automatically.
• LEGACY_DATA_CUTOFF_DATE — Boundary date distinguishing legacy data from live transactions.
• ALLOW_TENANCY_OVERLAP_FLAG and RECALC_IR_ON_ACC_CHG_FLAG — Control tenancy overlap validation and recalculation of index rent on account changes.
• DEFAULT_USER_VIEW_CODE and CALC_ANNUALIZED_BASIS_CODE — Default user interface view and annualization basis for calculations.
• SMALLEST_TERM_AMOUNT — Threshold amount used in lease term calculations.

Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN are maintained for all rows. The business-key candidate captured by PN_SYSTEM_SETUP_OPTIONS_U1 is PROFILE_ID, which is also the primary key, indicating that the table maintains a one-row-per-profile model rather than a composite business key.

Common Use Cases and Queries

Typical scenarios include retrieving setup options for a specific operating unit before creating leases, auditing automatic number-generation configuration, and verifying ledger linkage for accounting integration. A common query pattern joins the setup row to the operating unit and ledger:

• Retrieve setup options for an operating unit: SELECT * FROM PN_SYSTEM_SETUP_OPTIONS WHERE ORG_ID = :org_id;
• Report numbering and automation flags: SELECT PROFILE_ID, ORG_ID, AUTO_LEASE_NUM_GEN, AUTO_COMP_NUM_GEN, AUTO_INDEX_NUM_GEN, AUTO_VAR_RENT_NUM_GEN FROM PN_SYSTEM_SETUP_OPTIONS;
• Validate ledger linkage: SELECT s.PROFILE_ID, s.ORG_ID, s.SET_OF_BOOKS_ID, g.NAME FROM PN_SYSTEM_SETUP_OPTIONS s JOIN GL_SETS_OF_BOOKS_11I g ON s.SET_OF_BOOKS_ID = g.SET_OF_BOOKS_ID;
• Identify operating units with multiple tenancy enabled: SELECT ORG_ID FROM PN_SYSTEM_SETUP_OPTIONS WHERE MULTIPLE_TENANCY_LEASE = 'Y';
• Audit recent configuration changes: SELECT PROFILE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM PN_SYSTEM_SETUP_OPTIONS WHERE LAST_UPDATE_DATE > SYSDATE - 30;

These queries support reporting on configuration drift across operating units and are frequently embedded in custom concurrent programs that validate setup completeness before lease interfaces run.

Related Objects

The following objects reference or depend on PN_SYSTEM_SETUP_OPTIONS through documented foreign keys or functional linkage:

• HR_ALL_ORGANIZATION_UNITS — Referenced by PN_SYSTEM_SETUP_OPTIONS.ORG_ID; supplies the operating unit definition.
• GL_SETS_OF_BOOKS_11I — Referenced by PN_SYSTEM_SETUP_OPTIONS.SET_OF_BOOKS_ID; provides ledger context for accounting transfer.
• PN_LEASES_ALL — Lease records that consume numbering and tenancy flags from this setup row.
• PN_SPACE_ASSIGNMENTS — Space assignment records governed by AUTO_SPACE_DISTRIBUTION and DEFAULT_LOCN_AREA_FLAG.
• PN_ADJUSTMENTS — Adjustment transactions affected by consolidation and renormalization flags.
• PN_SYSTEM_SETUP_OPTIONS_PK — The primary key constraint enforcing uniqueness of PROFILE_ID.
• PN_SYSTEM_SETUP_OPTIONS_U1 — Unique index consistent with the PROFILE_ID business-key candidate.